ERPRef.com

77 COLUMNS | 11 INDICIES 812 | 40 | F3003 Routing Master File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F3003	IR	77	11	Routing Master File	Master Files	30: Product Data Management	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.

77 COLUMNS | TOP 812 | 40 | F3003 Routing Master File

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

11 INDICIES | TOP 812 | 40 | F3003 Routing Master File

1: P Branch P Item +A (Primary/Unique)

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	OPSQ	Sequence Number - Operations	Ascending
6	OPSC	Type Operation Code	Ascending
7	LINE	Line/Cell Identifier	Ascending
8	EFFF	Effective - From Date	Ascending

2: P Branch P Item +B

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	OPSQ	Sequence Number - Operations	Ascending
6	OPSC	Type Operation Code	Ascending

3: C Branch P Branch +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	MMCU	Branch	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
4	KIT	Parent (short) Item Number	Ascending

4: P Branch P Item +C

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	LINE	Line/Cell Identifier	Ascending
6	OPSQ	Sequence Number - Operations	Ascending
7	OPSC	Type Operation Code	Ascending
8	MCU	Business Unit	Ascending

5: P Item P Branch +

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	MCU	Business Unit	Ascending
6	LINE	Line/Cell Identifier	Ascending
7	OPSC	Type Operation Code	Ascending

6: P Branch Routing Type +

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	TRT	Type of Routing	Ascending
3	BQTY	Units - Batch Quantity	Ascending
4	MCU	Business Unit	Ascending
5	LINE	Line/Cell Identifier	Ascending
6	KIT	Parent (short) Item Number	Ascending

7: P Branch P Item +D

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	OPSQ	Sequence Number - Operations	Ascending
6	OPSC	Type Operation Code	Ascending
7	MCU	Business Unit	Ascending

8: P Branch P Item +E

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	OPSQ	Sequence Number - Operations	Descending

9: P Branch P Item +F

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	LINE	Line/Cell Identifier	Ascending
6	OPSQ	Sequence Number - Operations	Descending

10: P Item P Branch +G

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	BQTY	Units - Batch Quantity	Ascending
4	OPSC	Type Operation Code	Ascending

11: P Branch P Item +H

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	DFOPC	DFM Operation On Critical Path	Ascending
6	OPSQ	Sequence Number - Operations	Ascending