Diagrams

Table

Assembly Line

DynamicsDocs.comAssembly Line«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 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 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 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 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 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 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 94»Inventory Posting GroupCode [PK,NN]Description«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Document No.><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><Unit of Measure Code><Dimension Set ID><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Whse. Document No.><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Whse. Document No.><Location Code><Destination No.><To Bin Code><Item No.><From Unit of Measure Code><Unit of Measure Code><Variant Code><Whse. Document No.><Item No.><Variant Code><Inventory Posting Group><Gen. Prod. Posting Group><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Unit of Measure Code><Dimension Set ID><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><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Global Dimension 1 Code><Global Dimension 2 Code><Gen. Prod. Posting Group><Resource No.><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><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 Document Type (Document Type) Option
2 Document No. (Document No.) Code20
3 Line No. (Line No.) Integer Editable: No
10 Type (Type) Option
11 No. (No.) Code20
12 Variant Code (Variant Code) Code10
13 Description (Description) Text50
14 Description 2 (Description 2) Text50
18 Lead-Time Offset (Lead-Time Offset) DateFormula
19 Resource Usage Type (Resource Usage Type) Option
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 Bin Code (Bin Code) Code20
25 Position (Position) Code10
26 Position 2 (Position 2) Code10
27 Position 3 (Position 3) Code10
38 Appl.-to Item Entry (Appl.-to Item Entry) Integer
39 Appl.-from Item Entry (Appl.-from Item Entry) Integer
40 Quantity (Quantity) Decimal (0:5) Editable: No
41 Quantity (Base) (Quantity (Base)) Decimal (0:5) Editable: No
42 Remaining Quantity (Remaining Quantity) Decimal (0:5) Editable: No
43 Remaining Quantity (Base) (Remaining Quantity (Base)) Decimal (0:5) Editable: No
44 Consumed Quantity (Consumed Quantity) Decimal (0:5) Editable: No
45 Consumed Quantity (Base) (Consumed Quantity (Base)) Decimal (0:5) Editable: No
46 Quantity to Consume (Quantity to Consume) Decimal (0:5)
47 Quantity to Consume (Base) (Quantity to Consume (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 Avail. Warning (Avail. Warning) Boolean Editable: No
51 Substitution Available (Substitution Available) Boolean Editable: No
FlowField
52 Due Date (Due Date) Date
53 Reserve (Reserve) Option
60 Quantity per (Quantity per) Decimal (0:5)
61 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
62 Inventory Posting Group (Inventory Posting Group) Code10
63 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
65 Unit Cost (Unit Cost) Decimal
67 Cost Amount (Cost Amount) Decimal Editable: No
72 Date Filter (Date Filter) Date FlowFilter
80 Unit of Measure Code (Unit of Measure Code) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
7301 Pick Qty. (Pick Qty.) Decimal (0:5) Editable: No
FlowField
7302 Pick Qty. (Base) (Pick Qty. (Base)) Decimal (0:5) Editable: No
FlowField
7303 Qty. Picked (Qty. Picked) Decimal (0:5) Editable: No
7304 Qty. Picked (Base) (Qty. Picked (Base)) Decimal (0:5) Editable: No

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Document No. (Document No.) Assembly Header No. (No.) 1..n
Bin Code (Bin Code) Bin Code (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
No. (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
No. (No.) Resource No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Resource Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Registered Whse. Activity Line Whse. Document Line No. (Whse. Document Line No.) 1..n
Warehouse Activity Line Whse. Document Line No. (Whse. Document Line No.) 1..n
Whse. Worksheet Line Whse. Document Line No. (Whse. Document Line No.) 1..n