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

Keys

# Fields
0 Worksheet Template Name,Journal Batch Name,Line No. (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 (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 (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 (Type,No.,Variant Code,Location Code,Sales Order No.,Order Date) MaintainSIFTIndex: No
4 Type,No.,Variant Code,Location Code,Starting Date (Type,No.,Variant Code,Location Code,Starting Date) MaintainSIFTIndex: No
5 Worksheet Template Name,Journal Batch Name,Type,No.,Due Date (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. (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 (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. (Order Promising ID,Order Promising Line ID,Order Promising Line No.)
9 User ID,Demand Type,Worksheet Template Name,Journal Batch Name,Line No. (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. (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. (User ID,Worksheet Template Name,Journal Batch Name,Line No.) MaintainSQLIndex: No

Table Relations To Other Tables

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

Table Relations From Other Tables

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