JDE Schema (920) F34004 table definition

4 COLUMNS | 3 INDICIES 920 | 34 | F34004 Demand/Supply Inclusion Rules

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F34004	MG	4	3	Demand/Supply Inclusion Rules	Constants Files	34: Requirements Planning	Business Data

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

Select SQL

Insert SQL

Update SQL

Create SQL

4 COLUMNS | TOP 920 | 34 | F34004 Demand/Supply Inclusion Rules

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

3 INDICIES | TOP 920 | 34 | F34004 Demand/Supply Inclusion Rules

1: Version OrderType +A (Primary/Unique)

Element	Alias	Description	Sequence
4	TRTY	Status - Line	Ascending
3	LNTY	Line Type	Ascending
2	DCTO	Order Type	Ascending
1	MVER	Version	Ascending

4: Order Type Line Type Status

Element	Alias	Description	Sequence
3	TRTY	Status - Line	Ascending
2	LNTY	Line Type	Ascending
1	DCTO	Order Type	Ascending

5: Order Type Status

Element	Alias	Description	Sequence
2	TRTY	Status - Line	Ascending
1	DCTO	Order Type	Ascending