Diagrams


Table

Posted Assembly Line

DynamicsDocs.comPosted Assembly Line«Table 911»Posted Assembly LineDocument No. [PK]Line No. [PK]Order No.Order Line No.Type; [,Item,Resource]No.Variant CodeDescriptionDescription 2Lead-Time OffsetResource Usage Type; [,Direct,Fixed]Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodePositionPosition 2Position 3Item Shpt. Entry No.QuantityQuantity [Base]Due DateQuantity perQty. per Unit of MeasureInventory Posting GroupGen. Prod. Posting GroupUnit CostCost AmountUnit of Measure CodeDimension Set ID«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 IDIdLast Modified Date Time«Table 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«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<No.><No.><Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Inventory Posting Group><Gen. Prod. Posting Group><Unit of Measure 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><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.><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 Document No. Code20
3 Line No. Integer
8 Order No. Code20
9 Order Line No. Integer
10 Type Option
11 No. Code20
12 Variant Code Code10
13 Description Text50
14 Description 2 Text50
18 Lead-Time Offset DateFormula
19 Resource Usage Type Option
20 Location Code Code10
21 Shortcut Dimension 1 Code Code20
22 Shortcut Dimension 2 Code Code20
23 Bin Code Code20
25 Position Code10
26 Position 2 Code10
27 Position 3 Code10
39 Item Shpt. Entry No. Integer
40 Quantity Decimal (0:5)
41 Quantity (Base) Decimal (0:5)
52 Due Date Date
60 Quantity per Decimal (0:5)
61 Qty. per Unit of Measure Decimal (0:5) Editable: No
62 Inventory Posting Group Code20
63 Gen. Prod. Posting Group Code20
65 Unit Cost Decimal
67 Cost Amount Decimal Editable: No
80 Unit of Measure Code Code10
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Document No.,Line No. Clustered: Yes
1 Order No.,Order Line No.
2 Type,No.

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Inventory Posting Group Inventory Posting Group Code 1..n
No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location 1..n
No. Resource No. 1..n
Unit of Measure Code Resource Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field