ERPRef.com

33 COLUMNS | 10 INDICIES 920 | 34 | F3411 MPS/MRP/DRP Message File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F3411	MM	33	10	MPS/MRP/DRP Message File	Transaction 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.

33 COLUMNS | TOP 920 | 34 | F3411 MPS/MRP/DRP Message File

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

10 INDICIES | TOP 920 | 34 | F3411 MPS/MRP/DRP Message File

1: Unique Id (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

2: Short Item Branch + A

Element	Alias	Description	Sequence
5	RRQJ	Date - Recommended Complete	Ascending
4	MSGT	Message Type	Ascending
3	HCLD	Hold Code	Ascending
2	MCU	Business Unit	Ascending
1	ITM	Item Number - Short	Ascending

3: Order No Order Type Company

Element	Alias	Description	Sequence
3	KCOO	Order Company (Order Number)	Ascending
2	DCTO	Order Type	Ascending
1	DOCO	Document (Order No Invoice etc.)	Ascending

4: Branch Short Item + A

Element	Alias	Description	Sequence
4	DRQJ	Date - Requested	Ascending
3	MMCU	Branch	Ascending
2	ITM	Item Number - Short	Ascending
1	MCU	Business Unit	Ascending

5: Short Item Branch +B

Element	Alias	Description	Sequence
3	DRQJ	Date - Requested	Ascending
2	MCU	Business Unit	Ascending
1	ITM	Item Number - Short	Ascending

6: Short Item Sup Branch +A

Element	Alias	Description	Sequence
5	RRQJ	Date - Recommended Complete	Ascending
4	MSGT	Message Type	Ascending
3	HCLD	Hold Code	Ascending
2	MMCU	Branch	Ascending
1	ITM	Item Number - Short	Ascending

7: Supp Branch Short Item +A

Element	Alias	Description	Sequence
3	DRQJ	Date - Requested	Ascending
2	ITM	Item Number - Short	Ascending
1	MMCU	Branch	Ascending

8: Short Item Branch +

Element	Alias	Description	Sequence
5	MSGT	Message Type	Ascending
4	RRQJ	Date - Recommended Complete	Ascending
3	MSGA	Action - Message Control	Ascending
2	MCU	Business Unit	Ascending
1	ITM	Item Number - Short	Ascending

9: Branch

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

10: Short Item Branch Order Type

Element	Alias	Description	Sequence
3	DCTO	Order Type	Ascending
2	MCU	Business Unit	Ascending
1	ITM	Item Number - Short	Ascending