ERPRef.com

87 COLUMNS | 14 INDICIES 812 | 31 | F3111 Work Order Parts List

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F3111	WM	87	14	Work Order Parts List	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.

87 COLUMNS | TOP 812 | 31 | F3111 Work Order Parts List

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

14 INDICIES | TOP 812 | 31 | F3111 Work Order Parts List

1: OrderNo OperSeqNo +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	BSEQ	Sorszám - Buborék sorszám	Ascending

2: CompItemNo CompBranch +A

Element	Alias	Description	Sequence
1	CPIT	Component Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	DRQJ	Date - Requested	Ascending

3: BusinessUnit CompItemNo +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CPIT	Component Item Number - Short	Ascending
3	COBY	Co-Products/By-Products/Intermediate	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending

4: OrderNo OperSeqNo +B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	DRQJ	Date - Requested	Ascending
4	CMCU	Component Branch	Ascending
5	LOCN	Location	Ascending
6	LOTN	Lot/Serial Number	Ascending
7	CPIT	Component Item Number - Short	Ascending

5: OrderNumber CompItmNo +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	CPIT	Component Item Number - Short	Ascending
3	CMCU	Component Branch	Ascending
4	DRQJ	Date - Requested	Ascending

6: Co_ByProducts OrderNo +A

Element	Alias	Description	Sequence
1	COBY	Co-Products/By-Products/Intermediate	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	OPSQ	Sequence Number - Operations	Ascending

7: Co_ByProducts CompItem +A

Element	Alias	Description	Sequence
1	COBY	Co-Products/By-Products/Intermediate	Ascending
2	CPIT	Component Item Number - Short	Ascending
3	CMCU	Component Branch	Ascending
4	DRQJ	Date - Requested	Ascending

8: UniqueKeyID (Primary/Unique)

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

11: CompItemNo CompBranch +B

Element	Alias	Description	Sequence
1	CPIT	Component Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	LOCN	Location	Ascending
4	LOTN	Lot/Serial Number	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending

12: OrderNo OperSeqNo +C

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	CPNB	Component Line Number BOM	Ascending

13: OrderNo OrderType +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	CPNB	Component Line Number BOM	Ascending

14: OrderNo RelatedOrder +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	RKCO	Company - Key (Related Order)	Ascending
3	RORN	Related PO/SO/WO Number	Ascending
4	RCTO	Related PO/SO/WO Order Type	Ascending
5	RLLN	Related PO/SO Line Number	Ascending
6	CPIT	Component Item Number - Short	Ascending

15: Co_ByProducts OrderNo ActIng +

Element	Alias	Description	Sequence
1	COBY	Co-Products/By-Products/Intermediate	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	AING	Active Ingredient Flag	Ascending
4	OPSQ	Sequence Number - Operations	Ascending

16: CompItemNo CompBranch +C

Element	Alias	Description	Sequence
1	CPIT	Component Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	UORG	Units - Order/Transaction Quantity	Descending