Diagrams


Table

Requisition Wksh. Name

DynamicsDocs.comRequisition Wksh. Name«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«Table 244»Req. Wksh. TemplateName [PK,NN]DescriptionPage IDRecurringPage CaptionType; [Req.,For. Labor,Planning]<Worksheet Template Name><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 Template Name><Worksheet Line No.><Worksheet Line No.><Supplied-by Line No.><Worksheet Line No.><Worksheet Line No.><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>

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

Fields

# Name Type
1 Worksheet Template Name Code10 NotBlank: Yes
2 Name Code10 NotBlank: Yes
3 Description Text50
21 Template Type Option Editable: No
FlowField
22 Recurring Boolean Editable: No
FlowField

Keys

# Fields
0 Worksheet Template Name,Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Worksheet Template Name Req. Wksh. Template Name 1..n

Table Relations From Other Tables

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