Diagrams


Table

Assembly Header

DynamicsDocs.comAssembly Header«Table 900»Assembly HeaderDocument Type; [Quote,Order,,,Blanket...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedItem No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Assembled QuantityAssembled Quantity [Base]Quantity to AssembleQuantity to Assemble [Base]Reserved QuantityReserved Qty. [Base]Planning Flexibility; [Unlimited,None]...«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«Table 5767»Warehouse Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Shipping Agent Code...«Table 5773»Registered Whse. Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeStarting DateSerial No.Lot No....«Table 7325»Whse. Pick RequestDocument Type; [Shipment,Internal Pick...Document Subtype; [0,1,2,3,4,5,6,7,8,9...Document No. [PK,NN]Location Code [PK]Zone CodeBin CodeStatus; [Open,Released]Completely PickedShipment Method CodeShipping Agent CodeShipping Agent Service Code«Table 7326»Whse. Worksheet LineWorksheet Template Name [PK,NN]Name [PK,NN]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location Code [PK]Shelf No.From Zone CodeFrom Bin CodeTo Bin CodeTo Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]From Unit of Measure Code [NN]Qty. per From Unit of MeasureUnit of Measure Code [NN]Qty. per Unit of MeasureVariant CodeDescriptionDescription 2...«Table 7344»Registered Invt. Movement Hdr.No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Movement No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 901»Assembly LineDocument Type; [Quote,Order,,,Blanket...Document No. [PK]Line No. [PK]Type; [,Item,Resource]No.Variant CodeDescriptionDescription 2Lead-Time OffsetResource Usage Type; [,Direct,Fixed]Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodePositionPosition 2Position 3Appl.-to Item EntryAppl.-from Item EntryQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Consumed QuantityConsumed Quantity [Base]Quantity to ConsumeQuantity to Consume [Base]Reserved QuantityReserved Qty. [Base]Avail. WarningSubstitution Available...«Table 906»Assembly Comment LineDocument Type; [Quote,Assembly Order,,...Document No. [PK,NN]Document Line No. [PK]Line No. [PK]DateCodeComment«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 952»Time Sheet DetailTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Posted«Table 955»Time Sheet Line ArchiveTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 956»Time Sheet Detail ArchiveTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...PostedDocument No.Posting Date«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 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«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 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Item No.><Variant Code><Inventory Posting Group><Gen. Prod. Posting Group><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Bin Code><Unit of Measure Code><No. Series><Posting No. Series><Dimension Set ID><Assigned User ID><Source No.><Whse. Document No.><Whse. Document No.><Document No.><Whse. Document No.><Source No.><Document No.><Document No.><Assembly Order No.><Assembly Order No.><Assembly Order No.><Assembly Order No.><Location Code><Destination No.><Destination No.><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Whse. Document Line No.><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Bin Code><Whse. Document Line No.><Location Code><Bin Code><Location Code><Destination No.><To Bin Code><Item No.><From Unit of Measure Code><Unit of Measure Code><Variant Code><Whse. Document Line No.><Location Code><Destination No.><No. Series><Destination No.><No.><Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Inventory Posting Group><Gen. Prod. Posting Group><Unit of Measure Code><Dimension Set ID><Approver ID><Approved By><Approver ID><Approved By><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.><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Item No.><Variant Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Code><Dimension Value Code><Bin Code><Unit of Measure Code><Unit of Measure Filter><Approver ID><Substitute>

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

Fields

# Name Type
1 Document Type (Document Type) Option
2 No. (No.) Code20
3 Description (Description) Text50
4 Search Description (Search Description) Code50
5 Description 2 (Description 2) Text50
6 Creation Date (Creation Date) Date Editable: No
7 Last Date Modified (Last Date Modified) Date Editable: No
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
40 Quantity (Quantity) Decimal (0:5)
41 Quantity (Base) (Quantity (Base)) Decimal (0:5)
42 Remaining Quantity (Remaining Quantity) Decimal (0:5) Editable: No
43 Remaining Quantity (Base) (Remaining Quantity (Base)) Decimal (0:5) Editable: No
44 Assembled Quantity (Assembled Quantity) Decimal (0:5) Editable: No
45 Assembled Quantity (Base) (Assembled Quantity (Base)) Decimal (0:5) Editable: No
46 Quantity to Assemble (Quantity to Assemble) Decimal (0:5)
47 Quantity to Assemble (Base) (Quantity to Assemble (Base)) Decimal (0:5)
48 Reserved Quantity (Reserved Quantity) Decimal (0:5) Editable: No
FlowField
49 Reserved Qty. (Base) (Reserved Qty. (Base)) Decimal (0:5) Editable: No
FlowField
50 Planning Flexibility (Planning Flexibility) Option
51 MPS Order (MPS Order) Boolean
54 Assemble to Order (Assemble to Order) Boolean Editable: No
FlowField
63 Posting No. (Posting No.) Code20 Editable: No
65 Unit Cost (Unit Cost) Decimal
67 Cost Amount (Cost Amount) Decimal Editable: No
68 Rolled-up Assembly Cost (Rolled-up Assembly Cost) Decimal FlowField
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
107 No. Series (No. Series) Code10 Editable: No
108 Posting No. Series (Posting No. Series) Code10
120 Status (Status) Option Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
9000 Assigned User ID (Assigned User ID) Code50

Keys

# Fields
0 Document Type,No. (Document Type,No.) Clustered: Yes
1 Document Type,Item No.,Variant Code,Location Code,Due Date (Document Type,Item No.,Variant Code,Location Code,Due Date)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Bin Code (Bin Code) Bin Content Bin Code (Bin Code) 1..n
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 () 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
Assigned User ID (Assigned User ID) User Setup User ID (User ID) 1..n

Table Relations From Other Tables

From Table From Field
Assembly Comment Line Document No. (Document No.) 1..n
Assembly Line Document No. (Document No.) 1..n
Registered Invt. Movement Hdr. Source No. (Source No.) 1..n
Registered Whse. Activity Line Whse. Document No. (Whse. Document No.) 1..n
Time Sheet Detail Assembly Order No. (Assembly Order No.) 1..n
Time Sheet Detail Archive Assembly Order No. (Assembly Order No.) 1..n
Time Sheet Line Assembly Order No. (Assembly Order No.) 1..n
Time Sheet Line Archive Assembly Order No. (Assembly Order No.) 1..n
Warehouse Activity Line Whse. Document No. (Whse. Document No.) 1..n
Warehouse Request Source No. (Source No.) 1..n
Whse. Pick Request Document No. (Document No.) 1..n
Whse. Worksheet Line Whse. Document No. (Whse. Document No.) 1..n