Diagrams


Table

Requisition Line

DynamicsDocs.comRequisition Line«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 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 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 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«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 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 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 5722»Item CategoryCode [PK,NN]DescriptionDef. Gen. Prod. Posting GroupDef. Inventory Posting GroupDef. Tax Group CodeDef. Costing Method; [FIFO,LIFO,Specif...Def. VAT Prod. Posting Group«Table 5721»PurchasingCode [PK,NN]DescriptionDrop ShipmentSpecial Order«Table 5723»Product GroupItem Category Code [PK]Code [PK]DescriptionWarehouse Class Code«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«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 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 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 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«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«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<Worksheet Template Name><Journal Batch Name><No.><No.><Original Item No.><Location Code><Supply From><Transfer-from Code><Sales Order No.><Sell-to Customer No.><Ship-to Code><Order Address Code><Variant Code><Original Variant Code><Bin Code><Unit of Measure Code><Unit Of Measure Code (Demand)><Unit of Measure Code><Supply From><User ID><Item Category Code><Purchasing Code><Product Group Code><Routing No.><Operation No.><Work Center No.><Prod. Order Line No.><Gen. Prod. Posting Group><Gen. Business Posting Group><Production BOM Version Code><Routing Version Code><Production BOM No.><Worksheet Line No.><Worksheet Line No.><Supplied-by Line No.><Worksheet Line No.><Worksheet Line No.><Routing No.><No.><Work Center No.><Worksheet Template Name><Worksheet Batch Name><Worksheet Template Name><Worksheet Batch Name><Item No.><Unit of Measure Code><Variant Code><Location Code><Bin Code><Worksheet Template Name><Worksheet Batch Name><No.><Work Center No.><Worksheet Template Name><Worksheet Batch Name><Item No.><Variant Code><Location Code><Worksheet Template Name><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Bal. Account No.><Vendor No.><Alternative Item No.><Location Filter><Gen. Prod. Posting Group><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item Category Code><Product Group Code><Routing No.><Production BOM No.><Item No.><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><Location Code><Location Filter><Location Code><Location Code><Sell-to Customer No.><Bill-to Customer No.><Ship-to Code><Gen. Bus. Posting Group><Bill-to Customer No.><Gen. Bus. Posting Group><Ship-to Filter><Customer No.><Vendor No.><Variant Code><Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Pay-to Vendor No.><Gen. Bus. Posting Group><Subcontractor No.><Def. Gen. Prod. Posting Group><Item Category Code><Routing No.><Routing No.><Routing No.><No.><Work Center No.><Alternate Work Center><Gen. Prod. Posting Group><Capacity No. Filter><Production BOM No.><Production BOM Version Code><Routing Version Code><Production BOM No.>

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
2 Journal Batch Name Code10
3 Line No. Integer
4 Type Option
5 No. Code20
6 Description Text50
7 Description 2 Text50
8 Quantity Decimal (0:5)
9 Vendor No. Code20
10 Direct Unit Cost Decimal
12 Due Date Date
13 Requester ID Code50
14 Confirmed Boolean
15 Shortcut Dimension 1 Code Code20
16 Shortcut Dimension 2 Code Code20
17 Location Code Code10
18 Recurring Method Option BlankZero: Yes
19 Expiration Date Date
20 Recurring Frequency DateFormula
21 Order Date Date
22 Vendor Item No. Text20
23 Sales Order No. Code20 Editable: No
24 Sales Order Line No. Integer Editable: No
25 Sell-to Customer No. Code20 Editable: No
26 Ship-to Code Code10 Editable: No
28 Order Address Code Code10
29 Currency Code Code10
30 Currency Factor Decimal (0:15)
31 Reserved Quantity Decimal (0:5) Editable: No
FlowField
480 Dimension Set ID Integer Editable: No
5401 Prod. Order No. Code20 Editable: No
5402 Variant Code Code10
5403 Bin Code Code20
5404 Qty. per Unit of Measure Decimal (0:5) Editable: No
5407 Unit of Measure Code Code10
5408 Quantity (Base) Decimal (0:5)
5431 Reserved Qty. (Base) Decimal (0:5) Editable: No
FlowField
5520 Demand Type Integer Editable: No
5521 Demand Subtype Option Editable: No
5522 Demand Order No. Code20 Editable: No
5525 Demand Line No. Integer Editable: No
5526 Demand Ref. No. Integer Editable: No
5527 Status Option Editable: No
5530 Demand Date Date Editable: No
5532 Demand Quantity Decimal (0:5) Editable: No
5533 Demand Quantity (Base) Decimal (0:5) Editable: No
5538 Needed Quantity Decimal (0:5) BlankZero: Yes
Editable: No
5539 Needed Quantity (Base) Decimal (0:5) BlankZero: Yes
Editable: No
5540 Reserve Boolean
5541 Qty. per UOM (Demand) Decimal (0:5) Editable: No
5542 Unit Of Measure Code (Demand) Code10 Editable: No
5552 Supply From Code20
5553 Original Item No. Code20 Editable: No
5554 Original Variant Code Code10 Editable: No
5560 Level Integer Editable: No
5563 Demand Qty. Available Decimal (0:5) Editable: No
5590 User ID Code50 Editable: No
5701 Item Category Code Code10
5702 Nonstock Boolean
5703 Purchasing Code Code10
5705 Product Group Code Code10
5706 Transfer-from Code Code10 Editable: No
5707 Transfer Shipment Date Date Editable: No
7002 Line Discount % Decimal
7100 Blanket Purch. Order Exists Boolean Editable: No
FlowField
99000750 Routing No. Code20
99000751 Operation No. Code10
99000752 Work Center No. Code20
99000754 Prod. Order Line No. Integer Editable: No
99000755 MPS Order Boolean
99000756 Planning Flexibility Option
99000757 Routing Reference No. Integer
99000882 Gen. Prod. Posting Group Code10
99000883 Gen. Business Posting Group Code10
99000884 Low-Level Code Integer Editable: No
99000885 Production BOM Version Code Code20
99000886 Routing Version Code Code20
99000887 Routing Type Option
99000888 Original Quantity Decimal (0:5) BlankZero: Yes
Editable: No
99000889 Finished Quantity Decimal (0:5) Editable: No
99000890 Remaining Quantity Decimal (0:5) Editable: No
99000891 Original Due Date Date Editable: No
99000892 Scrap % Decimal (0:5)
99000894 Starting Date Date
99000895 Starting Time Time
99000896 Ending Date Date
99000897 Ending Time Time
99000898 Production BOM No. Code20
99000899 Indirect Cost % Decimal (0:5)
99000900 Overhead Rate Decimal (0:5)
99000901 Unit Cost Decimal
99000902 Cost Amount Decimal Editable: No
99000903 Replenishment System Option
99000904 Ref. Order No. Code20 Editable: No
99000905 Ref. Order Type Option Editable: No
99000906 Ref. Order Status Option BlankZero: Yes
Editable: No
99000907 Ref. Line No. Integer BlankZero: Yes
Editable: No
99000908 No. Series Code10 Editable: No
99000909 Expected Operation Cost Amt. Decimal Editable: No
FlowField
99000910 Expected Component Cost Amt. Decimal Editable: No
FlowField
99000911 Finished Qty. (Base) Decimal (0:5) Editable: No
99000912 Remaining Qty. (Base) Decimal (0:5) Editable: No
99000913 Related to Planning Line Integer Editable: No
99000914 Planning Level Integer Editable: No
99000915 Planning Line Origin Option Editable: No
99000916 Action Message Option
99000917 Accept Action Message Boolean
99000918 Net Quantity (Base) Decimal (0:5) Editable: No
99000919 Starting Date-Time DateTime
99000920 Ending Date-Time DateTime
99000921 Order Promising ID Code20
99000922 Order Promising Line No. Integer
99000923 Order Promising Line ID Integer

Keys

# Fields
0 Worksheet Template Name,Journal Batch Name,Line No. Clustered: Yes
1 Worksheet Template Name,Journal Batch Name,Vendor No.,Sell-to Customer No.,Ship-to Code,Order Address Code,Currency Code,Ref. Order Type,Ref. Order Status,Ref. Order No.,Location Code,Transfer-from Code MaintainSQLIndex: No
2 Type,No.,Variant Code,Location Code,Sales Order No.,Planning Line Origin,Due Date MaintainSIFTIndex: No
3 Type,No.,Variant Code,Location Code,Sales Order No.,Order Date MaintainSIFTIndex: No
4 Type,No.,Variant Code,Location Code,Starting Date MaintainSIFTIndex: No
5 Worksheet Template Name,Journal Batch Name,Type,No.,Due Date MaintainSQLIndex: No
6 Ref. Order Type,Ref. Order Status,Ref. Order No.,Ref. Line No.
7 Replenishment System,Type,No.,Variant Code,Transfer-from Code,Transfer Shipment Date MaintainSQLIndex: No
8 Order Promising ID,Order Promising Line ID,Order Promising Line No.
9 User ID,Demand Type,Worksheet Template Name,Journal Batch Name,Line No.
10 User ID,Demand Type,Demand Subtype,Demand Order No.,Demand Line No.,Demand Ref. No.
11 User ID,Worksheet Template Name,Journal Batch Name,Line No. MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Demand Type AllObjWithCaption Object ID 1..n
Bin Code Bin Code 1..n
Currency Code Currency Code 1..n
Sell-to Customer No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
No. G/L Account No. 1..n
Gen. Business Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Original Item No. Item No. 1..n
Item Category Code Item Category Code 1..n
Unit Of Measure Code (Demand) Item Unit of Measure Code 1..n
Original Variant Code Item Variant Code 1..n
Transfer-from Code Location 1..n
No. Series No. Series Code 1..n
Order Address Code Order Address Code 1..n
Prod. Order Line No. Prod. Order Line Line No. 1..n
Operation No. Prod. Order Routing Line Operation No. 1..n
Product Group Code Product Group Code 1..n
Production BOM No. Production BOM Header No. 1..n
Production BOM Version Code Production BOM Version Version Code 1..n
Purchasing Code Purchasing Code 1..n
Worksheet Template Name Req. Wksh. Template Name 1..n
Journal Batch Name Requisition Wksh. Name Name 1..n
Routing No. Routing Header No. 1..n
Routing Version Code Routing Version Version Code 1..n
Sales Order No. Sales Header No. 1..n
Ship-to Code Ship-to Address Code 1..n
Unit of Measure Code Unit of Measure Code 1..n
User ID User User Name 1..n
Supply From Vendor No. 1..n
Work Center No. Work Center No. 1..n

Table Relations From Other Tables

From Table From Field
Planning Component Supplied-by Line No. 1..n
Planning Routing Line Worksheet Line No. 1..n
Prod. Order Capacity Need Worksheet Line No. 1..n
Untracked Planning Element Worksheet Line No. 1..n