Diagrams


Table

Item Budget Entry

DynamicsDocs.comItem Budget Entry«Table 7134»Item Budget EntryEntry No. [PK]Analysis Area; [Sales,Purchase] [NN]Budget NameDateItem No.Source Type; [,Customer,Vendor,Item]Source No.DescriptionQuantityCost AmountSales AmountUser IDLocation CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeDimension Set ID«Table 7132»Item Budget NameAnalysis Area; [Sales,Purchase] [PK]Name [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 Code«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Budget Name><Item No.><Source No.><Source No.><Source No.><User ID><Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><Vendor No.><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bill-to Customer No.><Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Pay-to Vendor No.><Location Code><Dimension Value Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Analysis Area (Analysis Area) Option NotBlank: Yes
3 Budget Name (Budget Name) Code10
4 Date (Date) Date [ClosingDates:Yes]
5 Item No. (Item No.) Code20
6 Source Type (Source Type) Option
7 Source No. (Source No.) Code20
8 Description (Description) Text50
9 Quantity (Quantity) Decimal (0:5)
10 Cost Amount (Cost Amount) Decimal
11 Sales Amount (Sales Amount) Decimal
13 User ID (User ID) Code50 Editable: No
14 Location Code (Location Code) Code10
15 Global Dimension 1 Code (Global Dimension 1 Code) Code20
16 Global Dimension 2 Code (Global Dimension 2 Code) Code20
17 Budget Dimension 1 Code (Budget Dimension 1 Code) Code20
18 Budget Dimension 2 Code (Budget Dimension 2 Code) Code20
19 Budget Dimension 3 Code (Budget Dimension 3 Code) Code20
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Analysis Area,Budget Name,Item No.,Source Type,Source No.,Date,Location Code,Global Dimension 1 Code,Global Dimension 2 Code,Budget Dimension 1 Code,Budget Dimension 2 Code,Budget Dimension 3 Code (Analysis Area,Budget Name,Item No.,Source Type,Source No.,Date,Location Code,Global Dimension 1 Code,Global Dimension 2 Code,Budget Dimension 1 Code,Budget Dimension 2 Code,Budget Dimension 3 Code)
2 Analysis Area,Budget Name,Source Type,Source No.,Item No.,Date,Location Code,Global Dimension 1 Code,Global Dimension 2 Code,Budget Dimension 1 Code,Budget Dimension 2 Code,Budget Dimension 3 Code (Analysis Area,Budget Name,Source Type,Source No.,Item No.,Date,Location Code,Global Dimension 1 Code,Global Dimension 2 Code,Budget Dimension 1 Code,Budget Dimension 2 Code,Budget Dimension 3 Code)
3 Analysis Area,Budget Name,Item No.,Date (Analysis Area,Budget Name,Item No.,Date)

Table Relations To Other Tables

Field Related Table Related Field
Source No. (Source No.) Customer No. (No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Source No. (Source No.) Item No. (No.) 1..n
Budget Name (Budget Name) Item Budget Name Name (Name) 1..n
Location Code (Location Code) Location Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
Source No. (Source No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field