Diagrams

Table

Posted Assembly Header

DynamicsDocs.comPosted Assembly Header«Table 910»Posted Assembly HeaderNo. [PK]DescriptionSearch DescriptionDescription 2Order No.Item No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeItem Rcpt. Entry No.QuantityQuantity [Base]Assemble to OrderUnit CostCost AmountIndirect Cost %Overhead RateUnit of Measure CodeQty. per Unit of MeasureReversedNo. SeriesPosting No. Series...«Table 906»Assembly Comment LineDocument Type; [Quote,Assembly Order,,...Document No. [PK,NN]Document Line No. [PK]Line No. [PK]DateCodeComment«Table 914»Posted Assemble-to-Order LinkAssembly Document Type; [,Assembly] [P...Assembly Document No. [PK]Document Type; [,Sales Shipment]Document No.Document Line No.Assembled QuantityAssembled Quantity [Base]Assembly Order No.Order No.Order Line No.«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«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 230»Source CodeCode [PK,NN]Description<Item No.><Variant Code><Inventory Posting Group><Gen. Prod. Posting Group><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Unit of Measure Code><No. Series><Posting No. Series><Dimension Set ID><User ID><Source Code><Document No.><Assembly Document No.><Inventory Posting Group><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Gen. Prod. Posting Group><No. Series><Serial Nos.><Lot Nos.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Dimension Value Code>

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

Fields

# Name Type
2 No. (No.) Code20
3 Description (Description) Text50
4 Search Description (Search Description) Code50
5 Description 2 (Description 2) Text50
9 Order No. (Order No.) Code20
10 Item No. (Item No.) Code20
12 Variant Code (Variant Code) Code10
15 Inventory Posting Group (Inventory Posting Group) Code10
16 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
19 Comment (Comment) Boolean Editable: No
FlowField
20 Location Code (Location Code) Code10
21 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
22 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
23 Posting Date (Posting Date) Date
24 Due Date (Due Date) Date
25 Starting Date (Starting Date) Date
27 Ending Date (Ending Date) Date
33 Bin Code (Bin Code) Code20
39 Item Rcpt. Entry No. (Item Rcpt. Entry No.) Integer
40 Quantity (Quantity) Decimal (0:5)
41 Quantity (Base) (Quantity (Base)) Decimal (0:5)
54 Assemble to Order (Assemble to Order) Boolean Editable: No
FlowField
65 Unit Cost (Unit Cost) Decimal
67 Cost Amount (Cost Amount) Decimal Editable: No
75 Indirect Cost % (Indirect Cost %) Decimal (0:5)
76 Overhead Rate (Overhead Rate) Decimal (0:5)
80 Unit of Measure Code (Unit of Measure Code) Code10
81 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
100 Reversed (Reversed) Boolean
107 No. Series (No. Series) Code10 Editable: No
108 Posting No. Series (Posting No. Series) Code10
109 Order No. Series (Order No. Series) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
9010 User ID (User ID) Code50
9020 Source Code (Source Code) Code10

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Order No. (Order No.)

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Inventory Posting Group (Inventory Posting Group) Inventory Posting Group Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location () 1..n
Posting No. Series (Posting No. Series) No. Series Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field
Assembly Comment Line Document No. (Document No.) 1..n
Posted Assemble-to-Order Link Assembly Document No. (Assembly Document No.) 1..n