ERPRef.com

27 COLUMNS | 7 INDICIES 920 | 40 | F4209 Held Orders

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F4209	HO	27	7	Held Orders	Transaction Files	40: Inventory/OP Base	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.

27 COLUMNS | TOP 920 | 40 | F4209 Held Orders

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

7 INDICIES | TOP 920 | 40 | F4209 Held Orders

1: Hold Code Order Type + A (Primary/Unique)

Element	Alias	Description	Sequence
11	RPER	Person Responsible	Ascending
10	ASTS	Status - Approval	Ascending
9	RDT	Time - Released	Ascending
8	RDJ	Date - Released (Julian)	Ascending
7	DLNID	DistributionLine Number	Ascending
6	LNID	Line Number	Ascending
5	SFXO	Order Suffix	Ascending
4	KCOO	Order Company (Order Number)	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
1	HCOD	Hold Code	Ascending

2: HoldCode OrderType + B

Element	Alias	Description	Sequence
9	RDT	Time - Released	Ascending
8	RDJ	Date - Released (Julian)	Ascending
7	ARTG	Code - Approval Routing	Ascending
6	MCU	Business Unit	Ascending
5	SFXO	Order Suffix	Ascending
4	KCOO	Order Company (Order Number)	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
1	HCOD	Hold Code	Ascending

3: Approval Status Person + C

Element	Alias	Description	Sequence
4	ARTG	Code - Approval Routing	Ascending
3	DCTO	Order Type	Ascending
2	RPER	Person Responsible	Ascending
1	ASTS	Status - Approval	Ascending

4: Status Originator +

Element	Alias	Description	Sequence
7	MCU	Business Unit	Ascending
6	SFXO	Order Suffix	Ascending
5	KCOO	Order Company (Order Number)	Ascending
4	DCTO	Order Type	Ascending
3	AN8	Address Number	Ascending
2	ASTS	Status - Approval	Ascending
1	DOCO	Document (Order No Invoice etc.)	Ascending

5: OrderNumber OrderType +

Element	Alias	Description	Sequence
6	DLNID	DistributionLine Number	Ascending
5	LNID	Line Number	Ascending
4	SFXO	Order Suffix	Ascending
3	KCOO	Order Company (Order Number)	Ascending
2	DCTO	Order Type	Ascending
1	DOCO	Document (Order No Invoice etc.)	Ascending

6: HoldCode OrderNumber +A

Element	Alias	Description	Sequence
6	ASTS	Status - Approval	Ascending
5	SFXO	Order Suffix	Ascending
4	KCOO	Order Company (Order Number)	Ascending
3	DCTO	Order Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
1	HCOD	Hold Code	Ascending

7: HoldCode DocumentType +

Element	Alias	Description	Sequence
9	DLNID	DistributionLine Number	Ascending
8	LNID	Line Number	Ascending
7	TRDJ	Date - Order/Transaction	Ascending
6	MCU	Business Unit	Ascending
5	SFXO	Order Suffix	Ascending
4	KCOO	Order Company (Order Number)	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
1	HCOD	Hold Code	Ascending