Diagrams


Table

Req. Wksh. Template

DynamicsDocs.comReq. Wksh. Template«Table 244»Req. Wksh. TemplateName [PK,NN]DescriptionPage IDRecurringPage CaptionType; [Req.,For. Labor,Planning]«Table 245»Requisition Wksh. NameWorksheet Template Name [PK,NN]Name [PK,NN]DescriptionTemplate Type; [Req.,For. Labor,Planni...Recurring«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 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 5430»Planning Error LogWorksheet Template Name [PK]Journal Batch Name [PK]Entry No. [PK]Item No.Error DescriptionTable IDTable Position«Table 5525»Manufacturing User TemplateUser ID [PK]Create Purchase Order; [,Make Purch. O...Create Production Order; [,Planned,Fir...Create Transfer Order; [,Make Trans. O...Create Assembly Order; [,Make Assembly...Purchase Req. Wksh. TemplatePurchase Wksh. NameProd. Req. Wksh. TemplateProd. Wksh. NameTransfer Req. Wksh. TemplateTransfer Wksh. NameMake Orders; [The Active Line,The Acti...«Table 99000829»Planning ComponentWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityFlushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeRef. Order Status; [Simulated,Planned,...Ref. Order No.Ref. Order Line No.LengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 99000830»Planning Routing LineWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line 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]...«Table 99000855»Untracked Planning ElementWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Track Line No. [PK]Item No.Variant CodeLocation CodeSource TypeSource IDParameter ValueUntracked QuantityTrack Quantity FromTrack Quantity ToSourceWarning Level; [,Emergency,Exception,A...«Table 99000875»Order Promising SetupPrimary Key [PK]Offset [Time]Order Promising Nos.Order Promising TemplateOrder Promising Worksheet<Worksheet Template Name><Worksheet Template Name><Worksheet Template Name><Worksheet Template Name><Purchase Req. Wksh. Template><Prod. Req. Wksh. Template><Transfer Req. Wksh. Template><Worksheet Template Name><Worksheet Template Name><Worksheet Template Name><Order Promising Template><Journal Batch Name><Worksheet Batch Name><Journal Batch Name><Purchase Wksh. Name><Prod. Wksh. Name><Transfer Wksh. Name><Worksheet Batch Name><Worksheet Batch Name><Worksheet Batch Name><Order Promising Worksheet><Worksheet Line No.><Worksheet Line No.><Supplied-by Line No.><Worksheet Line No.><Worksheet Line No.>

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

Fields

# Name Type
1 Name Code10 NotBlank: Yes
2 Description Text80
6 Page ID Integer
12 Recurring Boolean
16 Page Caption Text250 Editable: No
FlowField
99000750 Type Option

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Page ID AllObjWithCaption Object ID 1..n

Table Relations From Other Tables

From Table From Field
Manufacturing User Template Transfer Req. Wksh. Template 1..n
Order Promising Setup Order Promising Template 1..n
Planning Component Worksheet Template Name 1..n
Planning Error Log Worksheet Template Name 1..n
Planning Routing Line Worksheet Template Name 1..n
Prod. Order Capacity Need Worksheet Template Name 1..n
Requisition Line Worksheet Template Name 1..n
Requisition Wksh. Name Worksheet Template Name 1..n
Untracked Planning Element Worksheet Template Name 1..n