Diagrams


Table

Prod. Order Line

DynamicsDocs.comProd. Order Line«Table 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...«Table 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 123»Purch. Inv. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Receipt No....«Table 246»Requisition LineWorksheet Template Name [PK]Journal Batch Name [PK]Line No. [PK]Type; [,G/L Account,Item]No.DescriptionDescription 2QuantityVendor No.Direct Unit CostDue DateRequester IDConfirmedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyOrder DateVendor Item No.Sales Order No.Sales Order Line No.Sell-to Customer No.Ship-to CodeOrder Address CodeCurrency CodeCurrency FactorReserved QuantityDimension Set IDProd. Order No....«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«Table 5110»Purchase Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5407»Prod. Order ComponentStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Prod. Order Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityRemaining QuantityAct. Consumption [Qty]Flushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeItem Low-Level CodeLengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 5416»Prod. Order Comp. Cmt LineProd. Order BOM Line No. [PK,NN]Line No. [PK]DateCommentCodeStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Prod. Order Line No. [PK,NN]«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 5832»Capacity Ledger EntryEntry No. [PK]No.Posting DateType; [Work Center,Machine Center, ,Re...Document No.DescriptionOperation No.Work Center No.QuantitySetup TimeRun TimeStop TimeInvoiced QuantityOutput QuantityScrap QuantityConcurrent CapacityCap. Unit of Measure CodeQty. per Cap. Unit of MeasureGlobal Dimension 1 CodeGlobal Dimension 2 CodeLast Output LineCompletely InvoicedStarting TimeEnding TimeRouting No.Routing Reference No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDocument Date...«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 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«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 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 99000771»Production BOM HeaderNo. [PK]DescriptionDescription 2Search NameUnit of Measure CodeLow-Level CodeCommentCreation DateLast Date ModifiedStatus; [New,Certified,Under Developme...Version Nos.No. Series«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 99000779»Production BOM VersionProduction BOM No. [PK,NN]Version Code [PK]DescriptionStarting DateUnit of Measure CodeLast Date ModifiedStatus; [New,Certified,Under Developme...No. Series«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series<Prod. Order No.><Item No.><Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Bin Code><Production BOM No.><Routing No.><Inventory Posting Group><Capacity No. Filter><Capacity No. Filter><Unit of Measure Code><Dimension Set ID><Production BOM Version Code><Routing Version Code><Prod. Order Line No.><Prod. Order Line No.><Prod. Order Line No.><Prod. Order Line No.><Prod. Order Line No.><Prod. Order Line No.><Supplied-by Line No.><Prod. Order Line No.><Whse. Document Line No.><Whse. Document Line No.><Order Line No.><Whse. Document Line No.><Order Line No.><No.><Location Code><Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><Dimension Set ID><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Routing No.><Work Center No.><No.><Location Code><Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><Dimension Set ID><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Routing No.><Work Center No.><No.><Original Item No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Location Code><Supply From><Transfer-from Code><Dimension Set ID><Variant Code><Original Variant Code><Bin Code><Unit of Measure Code><Unit Of Measure Code (Demand)><Routing No.><Work Center No.><Production BOM Version Code><Routing Version Code><Production BOM No.><No.><Location Code><Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><Dimension Set ID><Variant Code><Bin Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Routing No.><Work Center No.><Blanket Order Line No.><No.><Location Code><Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Dimension Set ID><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Routing No.><Work Center No.><Prod. Order No.><Item No.><Original Item No.><Unit of Measure Code><Variant Code><Original Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Dimension Set ID><Prod. Order BOM Line No.><Prod. Order Comp. Line No.><Prod. Order 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><Bin Code><Whse. Document No.><No.><No.><Work Center No.><Global Dimension 1 Code><Global Dimension 2 Code><Routing No.><Item No.><Variant Code><Unit of Measure Code><Order No.><Dimension Set ID><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.><Source No.><Originally Ordered No.><Location Code><New Location Code><Inventory Posting Group><Source Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><New Shortcut Dimension 1 Code><New Shortcut Dimension 2 Code><Order No.><Dimension Set ID><New Dimension Set ID><Variant Code><Originally Ordered Var. Code><Bin Code><New Bin Code><Bin Code><Unit of Measure Code><No.><No.><Work Center No.><Routing No.><Source No.><Routing No.><Inventory Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Location Code><Bin Code><Work Center Filter><Capacity No. Filter><Capacity No. Filter><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><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Routing No.><Production BOM No.><Item No.><Item Filter><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><Location Code><Location Code><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Bin Code><Unit of Measure Code><Unit of Measure Filter><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Production BOM No.><Routing No.><Alternate Work Center><Work Center No.>

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

Fields

# Name Type
1 Status Option
2 Prod. Order No. Code20
3 Line No. Integer
11 Item No. Code20
12 Variant Code Code10
13 Description Text50
14 Description 2 Text50
20 Location Code Code10
21 Shortcut Dimension 1 Code Code20
22 Shortcut Dimension 2 Code Code20
23 Bin Code Code20
40 Quantity Decimal (0:5)
41 Finished Quantity Decimal (0:5) Editable: No
42 Remaining Quantity Decimal (0:5) Editable: No
45 Scrap % Decimal (0:5)
47 Due Date Date Editable: No
48 Starting Date Date
49 Starting Time Time
50 Ending Date Date
51 Ending Time Time
52 Planning Level Code Integer Editable: No
53 Priority Integer
60 Production BOM No. Code20
61 Routing No. Code20
62 Inventory Posting Group Code10
63 Routing Reference No. Integer Editable: No
65 Unit Cost Decimal
67 Cost Amount Decimal Editable: No
68 Reserved Quantity Decimal (0:5) Editable: No
FlowField
70 Capacity Type Filter Option FlowFilter
71 Capacity No. Filter Code20 FlowFilter
72 Date Filter Date FlowFilter
80 Unit of Measure Code Code10
81 Quantity (Base) Decimal (0:5)
82 Finished Qty. (Base) Decimal (0:5) Editable: No
83 Remaining Qty. (Base) Decimal (0:5) Editable: No
84 Reserved Qty. (Base) Decimal (0:5) Editable: No
FlowField
90 Expected Operation Cost Amt. Decimal Editable: No
FlowField
91 Total Exp. Oper. Output (Qty.) Decimal (0:5) Editable: No
FlowField
94 Expected Component Cost Amt. Decimal Editable: No
FlowField
198 Starting Date-Time DateTime
199 Ending Date-Time DateTime
480 Dimension Set ID Integer Editable: No
5831 Cost Amount (ACY) Decimal Editable: No
5832 Unit Cost (ACY) Decimal Editable: No
99000750 Production BOM Version Code Code20
99000751 Routing Version Code Code20
99000752 Routing Type Option
99000753 Qty. per Unit of Measure Decimal (0:5) Editable: No
99000754 MPS Order Boolean
99000755 Planning Flexibility Option
99000764 Indirect Cost % Decimal (0:5)
99000765 Overhead Rate Decimal

Keys

# Fields
0 Status,Prod. Order No.,Line No. Clustered: Yes
1 Prod. Order No.,Line No.,Status
2 Status,Item No.,Variant Code,Location Code,Ending Date
3 Status,Item No.,Variant Code,Location Code,Starting Date MaintainSIFTIndex: No
4 Status,Item No.,Variant Code,Location Code,Due Date MaintainSIFTIndex: No
5 Status,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Due Date MaintainSIFTIndex: No
6 Status,Prod. Order No.,Item No.
7 Status,Prod. Order No.,Routing No.,Routing Reference No. MaintainSIFTIndex: No
8 Status,Prod. Order No.,Planning Level Code
9 Planning Level Code,Priority
10 Item No.,Variant Code,Location Code,Status,Ending Date MaintainSIFTIndex: No
11 Item No.,Variant Code,Location Code,Status,Due Date MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Bin Code Bin Code 1..n
Bin Code Bin Content Bin Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Inventory Posting Group Inventory Posting Group Code 1..n
Item No. Item 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
Capacity No. Filter Machine Center No. 1..n
Production BOM No. Production BOM Header No. 1..n
Production BOM Version Code Production BOM Version Version Code 1..n
Prod. Order No. Production Order No. 1..n
Routing No. Routing Header No. 1..n
Routing Version Code Routing Version Version Code 1..n
Capacity No. Filter Work Center No. 1..n

Table Relations From Other Tables

From Table From Field
Capacity Ledger Entry Order Line No. 1..n
Item Journal Line Order Line No. 1..n
Prod. Order Comp. Cmt Line Prod. Order Line No. 1..n
Prod. Order Component Supplied-by Line No. 1..n
Purch. Inv. Line Prod. Order Line No. 1..n
Purch. Rcpt. Line Prod. Order Line No. 1..n
Purchase Line Prod. Order Line No. 1..n
Purchase Line Archive Prod. Order Line No. 1..n
Registered Whse. Activity Line Whse. Document Line No. 1..n
Requisition Line Prod. Order Line No. 1..n
Warehouse Activity Line Whse. Document Line No. 1..n
Whse. Worksheet Line Whse. Document Line No. 1..n