ERPRef.com

110 COLUMNS | 7 INDICIES 812 | 31 | F3112 Work Order Routing

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F3112	WL	110	7	Work Order Routing	Transaction Files	31: Shop Floor Control	AS400 Coexistence Tables

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.

110 COLUMNS | TOP 812 | 31 | F3112 Work Order Routing

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

7 INDICIES | TOP 812 | 31 | F3112 Work Order Routing

1: OrderNo OperationSeqNo +A (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	OPSC	Type Operation Code	Ascending
4	MCU	Business Unit	Ascending

2: BusinessUnit StartDate +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	STRT	Date - Start (Julian)	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending

3: BusinessUnit RequestedDate

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	DRQJ	Date - Requested	Ascending

4: Branch BusinessUnit +A

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	MCU	Business Unit	Ascending
3	WMCU	Workcenter Branch	Ascending
4	OPSC	Type Operation Code	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending

5: AddressNo StartDate +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	STRT	Date - Start (Julian)	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	OPSQ	Sequence Number - Operations	Ascending

6: Branch ParentItemNo +A

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	OPSQ	Sequence Number - Operations	Ascending

7: OrderNo OperSeqNo +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	OPSC	Type Operation Code	Ascending