Diagrams


Table

Unplanned Demand

Fields

# Name Type
1 Demand Type Option Editable: No
2 Demand SubType Option Editable: No
4 Demand Order No. Code20 Editable: No
5 Demand Line No. Integer
6 Demand Ref. No. Integer
7 Sell-to Customer No. Code20 Editable: No
8 Description Text50 Editable: No
9 Demand Date Date Editable: No
10 Status Option Editable: No
13 Item No. Code20
14 Variant Code Code10
15 Location Code Code10
16 Quantity (Base) Decimal
17 Level Integer
18 Bin Code Code20
19 Qty. per Unit of Measure Decimal (0:5) Editable: No
20 Unit of Measure Code Code10
21 Reserve Boolean
22 Needed Qty. (Base) Decimal
23 Special Order Boolean
24 Purchasing Code Code10

Keys

# Fields
0 Demand Type,Demand SubType,Demand Order No.,Demand Line No.,Demand Ref. No. Clustered: Yes
1 Demand Date,Level
2 Item No.,Variant Code,Location Code,Demand Date

Table Relations To Other Tables

Field Related Table Related Field
Bin Code Bin Code 1..n
Unit of Measure Code Item Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field