Diagrams

Table

Routing Header

DynamicsDocs.comRouting Header«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«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 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 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 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 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 5409»Prod. Order Routing LineRouting No. [PK]Routing Reference No. [PK]Operation No. [PK,NN]Next Operation No.Previous Operation No.Type; [Work Center,Machine Center]No.Work Center No.Work Center Group CodeDescriptionSetup TimeRun TimeWait TimeMove TimeFixed Scrap QuantityLot SizeScrap Factor %Setup Time Unit of Meas. CodeRun Time Unit of Meas. CodeWait Time Unit of Meas. CodeMove Time Unit of Meas. CodeMinimum Process TimeMaximum Process TimeConcurrent CapacitiesSend-Ahead QuantityRouting Link CodeStandard Task CodeUnit Cost perRecalculateSequence No. [Forward]Sequence No. [Backward]...«Table 5410»Prod. Order Capacity NeedStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Routing No. [PK]Line No. [PK]Operation No. [PK]Type; [Work Center,Machine Center]No.Work Center No.Work Center Group CodeRouting Reference No. [PK]DateStarting TimeEnding TimeAllocated TimeSend-Ahead Type; [,Input,Output,Both]Time Type; [Setup,Run]Needed TimeNeeded Time [ms]Lot SizeConcurrent CapacitiesEfficiencyStarting Date-TimeEnding Date-TimeWorksheet Template NameWorksheet Batch NameWorksheet Line No.ActiveRequested Only [PK]«Table 5411»Prod. Order Routing ToolRouting No. [PK,NN]Line No. [PK]No.DescriptionOperation No. [PK]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5412»Prod. Order Routing PersonnelRouting No. [PK,NN]Line No. [PK]No.DescriptionOperation No. [PK,NN]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5413»Prod. Order Rtng Qlty Meas.Routing No. [PK,NN]Line No. [PK]Qlty Measure CodeDescriptionMin. ValueMax. ValueMean ToleranceOperation No. [PK,NN]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5415»Prod. Order Rtng Comment LineRouting No. [PK,NN]Operation No. [PK,NN]Line No. [PK]DateCommentCodeStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«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 5870»BOM BufferEntry No. [PK]Type; [,Item,Machine Center,Work Cente...No.DescriptionUnit of Measure CodeVariant CodeLocation CodeReplenishment System; [Purchase,Prod....IndentationIs LeafBottleneckRouting No.Production BOM No.Lot SizeLow-Level CodeRounding PrecisionQty. per ParentQty. per Top ItemAble to Make Top ItemAble to Make ParentAvailable QuantityGross RequirementScheduled ReceiptsUnused QuantityLead Time CalculationLead-Time OffsetRolled-up Lead-Time OffsetNeeded by DateSafety Lead TimeUnit CostIndirect Cost %...«Table 5896»Inventory Adjmt. Entry (Order)Order Type; [,Production,Transfer,Serv...Order No. [PK]Order Line No. [PK]Item No.Routing No.Routing Reference No.Indirect Cost %Overhead RateCost is AdjustedAllow Online AdjustmentUnit CostDirect CostIndirect CostSingle-Level Material CostSingle-Level Capacity CostSingle-Level Subcontrd. CostSingle-Level Cap. Ovhd CostSingle-Level Mfg. Ovhd CostDirect Cost [ACY]Indirect Cost [ACY]Single-Lvl Material Cost [ACY]Single-Lvl Capacity Cost [ACY]Single-Lvl Subcontrd Cost[ACY]Single-Lvl Cap. Ovhd Cost[ACY]Single-Lvl Mfg. Ovhd Cost[ACY]Completely InvoicedIs Finished«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 99000764»Routing LineRouting No. [PK,NN]Version Code [PK]Operation No. [PK,NN]Next Operation No.Previous Operation No.Type; [Work Center,Machine Center,]No.Work Center No.Work Center Group CodeDescriptionSetup TimeRun TimeWait TimeMove TimeFixed Scrap QuantityLot SizeScrap Factor %Setup Time Unit of Meas. CodeRun Time Unit of Meas. CodeWait Time Unit of Meas. CodeMove Time Unit of Meas. CodeMinimum Process TimeMaximum Process TimeConcurrent CapacitiesSend-Ahead QuantityRouting Link CodeStandard Task CodeUnit Cost perRecalculateCommentSequence No. [Forward]...«Table 99000770»Manufacturing Comment LineTable Name; [Work Center,Machine Cente...No. [PK,NN]Line No. [PK]DateCodeComment«Table 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting No.«Table 99000775»Routing Comment LineRouting No. [PK,NN]Operation No. [PK,NN]Line No. [PK]Version Code [PK]DateCommentCode«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series«Table 99000802»Routing ToolRouting No. [PK,NN]Line No. [PK]No.DescriptionVersion Code [PK]Operation No. [PK,NN]«Table 99000803»Routing PersonnelRouting No. [PK,NN]Line No. [PK]No.DescriptionVersion Code [PK]Operation No. [PK,NN]«Table 99000805»Routing Quality MeasureRouting No. [PK,NN]Line No. [PK]Qlty Measure CodeDescriptionMin. ValueMax. ValueMean ToleranceVersion Code [PK]Operation No. [PK,NN]«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Version Nos.><No. Series><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><Routing No.><No.><Attached to Line No.><Blanket Order Line No.><Operation No.><Prod. Order Line No.><No.><Attached to Line No.><Blanket Order Line No.><Operation No.><Prod. Order Line No.><No.><Original Item No.><Operation No.><Prod. Order Line No.><Routing Version Code><No. Series><Worksheet Line No.><Alternative Item No.><No. Series><Serial Nos.><Lot Nos.><No.><Source No.><Item No.><Item No.><No.><Item No.><Item No.><Source No.><Originally Ordered No.><Attached to Line No.><Blanket Order Line No.><Operation No.><Prod. Order Line No.><Blanket Order Line No.><Attached to Line No.><Operation No.><Prod. Order Line No.><Source No.><No. Series><Prod. Order No.><Prod. Order No.><Prod. Order No.><Prod. Order No.><Prod. Order No.><Prod. Order No.><Order No.><Order No.><Routing Version Code><Order Line No.><Order Line No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Posting No. Series><Version Code><Operation No.><Operation No.><Operation No.><Operation No.><Version Code><No. Series><Version Code><Version Code><Version Code>

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

Fields

# Name Type
1 No. (No.) Code20
2 Description (Description) Text50
3 Description 2 (Description 2) Text50
4 Search Description (Search Description) Code50
10 Last Date Modified (Last Date Modified) Date Editable: No
12 Comment (Comment) Boolean Editable: No
FlowField
20 Status (Status) Option
21 Type (Type) Option
50 Version Nos. (Version Nos.) Code10
51 No. Series (No. Series) Code10 Editable: No

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Search Description (Search Description)
2 Description (Description)
3 Status (Status)

Table Relations To Other Tables

Field Related Table Related Field
No. Series (No. Series) No. Series Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
BOM Buffer Routing No. (Routing No.) 1..n
Capacity Ledger Entry Routing No. (Routing No.) 1..n
Family Routing No. (Routing No.) 1..n
Inventory Adjmt. Entry (Order) Routing No. (Routing No.) 1..n
Item Routing No. (Routing No.) 1..n
Item Journal Line Routing No. (Routing No.) 1..n
Manufacturing Comment Line No. (No.) 1..n
Prod. Order Capacity Need Routing No. (Routing No.) 1..n
Prod. Order Line Routing No. (Routing No.) 1..n
Prod. Order Routing Line Routing No. (Routing No.) 1..n
Prod. Order Routing Personnel Routing No. (Routing No.) 1..n
Prod. Order Routing Tool Routing No. (Routing No.) 1..n
Prod. Order Rtng Comment Line Routing No. (Routing No.) 1..n
Prod. Order Rtng Qlty Meas. Routing No. (Routing No.) 1..n
Production Order Routing No. (Routing No.) 1..n
Purch. Inv. Line Routing No. (Routing No.) 1..n
Purch. Rcpt. Line Routing No. (Routing No.) 1..n
Purchase Line Routing No. (Routing No.) 1..n
Purchase Line Archive Routing No. (Routing No.) 1..n
Requisition Line Routing No. (Routing No.) 1..n
Routing Comment Line Routing No. (Routing No.) 1..n
Routing Line Routing No. (Routing No.) 1..n
Routing Personnel Routing No. (Routing No.) 1..n
Routing Quality Measure Routing No. (Routing No.) 1..n
Routing Tool Routing No. (Routing No.) 1..n
Routing Version Routing No. (Routing No.) 1..n