Diagrams


Table

Planning Component

DynamicsDocs.comPlanning Component«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 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 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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 99000777»Routing LinkCode [PK,NN]Description«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Worksheet Template Name><Worksheet Batch Name><Worksheet Line No.><Supplied-by Line No.><Item No.><Unit of Measure Code><Routing Link Code><Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Dimension Set ID><Worksheet Template Name><Worksheet Template Name><Journal Batch Name><No.><Original Item No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Location Code><Supply From><Transfer-from Code><Dimension Set ID><Variant Code><Original Variant Code><Bin Code><Unit of Measure Code><Unit Of Measure Code (Demand)><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><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><Dimension Value Code>

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 Worksheet Batch Name Code10
3 Worksheet Line No. Integer
5 Line No. Integer BlankZero: Yes
11 Item No. Code20
12 Description Text50
13 Unit of Measure Code Code10
14 Quantity Decimal (0:5) Editable: No
15 Position Code10
16 Position 2 Code10
17 Position 3 Code10
18 Lead-Time Offset DateFormula
19 Routing Link Code Code10
20 Scrap % Decimal (0:5) BlankNumbers: BlankNeg
21 Variant Code Code10
25 Expected Quantity Decimal (0:5) Editable: No
28 Flushing Method Option
30 Location Code Code10
31 Shortcut Dimension 1 Code Code20
32 Shortcut Dimension 2 Code Code20
33 Bin Code Code20
35 Supplied-by Line No. Integer
36 Planning Level Code Integer Editable: No
37 Ref. Order Status Option
38 Ref. Order No. Code20
39 Ref. Order Line No. Integer
40 Length Decimal (0:5)
41 Width Decimal (0:5)
42 Weight Decimal (0:5)
43 Depth Decimal (0:5)
44 Calculation Formula Option
45 Quantity per Decimal (0:5)
46 Ref. Order Type Option Editable: No
50 Unit Cost Decimal
51 Cost Amount Decimal
52 Due Date Date
53 Due Time Time
55 Direct Unit Cost Decimal (2:5)
56 Indirect Cost % Decimal (0:5)
57 Overhead Rate Decimal (0:5)
58 Direct Cost Amount Decimal (2:2)
59 Overhead Amount Decimal (2:2)
60 Qty. per Unit of Measure Decimal (0:5) Editable: No
62 Quantity (Base) Decimal (0:5)
63 Reserved Qty. (Base) Decimal (0:5) Editable: No
FlowField
71 Reserved Quantity Decimal (0:5) Editable: No
FlowField
73 Expected Quantity (Base) Decimal (0:5) Editable: No
74 Original Expected Qty. (Base) Decimal (0:5) BlankZero: Yes
Editable: No
75 Net Quantity (Base) Decimal (0:5) Editable: No
76 Due Date-Time DateTime
480 Dimension Set ID Integer Editable: No
99000875 Critical Boolean
99000915 Planning Line Origin Option Editable: No

Keys

# Fields
0 Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Line No. Clustered: Yes
MaintainSIFTIndex: No
1 Item No.,Variant Code,Location Code,Due Date,Planning Line Origin MaintainSIFTIndex: No
2 Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Planning Line Origin,Due Date MaintainSQLIndex: No
MaintainSIFTIndex: No
3 Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Item No. MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Bin Code Bin Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Item No. Item 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location 1..n
Worksheet Template Name Req. Wksh. Template Name 1..n
Supplied-by Line No. Requisition Line Line No. 1..n
Worksheet Batch Name Requisition Wksh. Name Name 1..n
Routing Link Code Routing Link Code 1..n

Table Relations From Other Tables

From Table From Field