Diagrams


Table

Unplanned Demand

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field