ERPRef.com

163 COLUMNS | 12 INDICIES 920 | 43 | F43121 Purchase Order Receiver File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F43121	PR	163	12	Purchase Order Receiver File	Transaction Files	43A: Purchase Order Receipt/Routing	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.

163 COLUMNS | TOP 920 | 43 | F43121 Purchase Order Receiver File

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

12 INDICIES | TOP 920 | 43 | F43121 Purchase Order Receiver File

1: Order Number Order Type + (Primary/Unique)

Element	Alias	Description	Sequence
8	DOC	Document (Voucher Invoice etc.)	Ascending
7	NLIN	Number of Lines	Ascending
6	LNID	Line Number	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	MATC	Type - Match Record Type	Ascending

2: Document OrderType +

Element	Alias	Description	Sequence
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

3: Receipt Doc Receipt Typ +

Element	Alias	Description	Sequence
3	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
1	DOC	Document (Voucher Invoice etc.)	Ascending

4: MatchType ShortItem +

Element	Alias	Description	Sequence
4	PDDJ	Date - Scheduled Pick	Ascending
3	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
1	MATC	Type - Match Record Type	Ascending

5: MatchType Address +

Element	Alias	Description	Sequence
9	NLIN	Number of Lines	Ascending
8	LNID	Line Number	Ascending
7	MCU	Business Unit	Ascending
6	SFXO	Order Suffix	Ascending
5	KCOO	Order Company (Order Number)	Ascending
4	DCTO	Order Type	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	AN8	Address Number	Ascending
1	MATC	Type - Match Record Type	Ascending

6: MatchType Order +

Element	Alias	Description	Sequence
9	DOC	Document (Voucher Invoice etc.)	Ascending
8	NLIN	Number of Lines	Ascending
7	LNID	Line Number	Ascending
6	MCU	Business Unit	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	MATC	Type - Match Record Type	Ascending

7: MatchType Order Number +

Element	Alias	Description	Sequence
6	LNID	Line Number	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	MATC	Type - Match Record Type	Ascending

8: Invoice No Receipt Type +

Element	Alias	Description	Sequence
3	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
1	VINV	Supplier Invoice Number	Ascending

9: SHPN MATC DOCO DCTO KCOO SFXO+

Element	Alias	Description	Sequence
9	DOC	Document (Voucher Invoice etc.)	Ascending
8	NLIN	Number of Lines	Ascending
7	LNID	Line Number	Ascending
6	SFXO	Order Suffix	Ascending
5	KCOO	Order Company (Order Number)	Ascending
4	DCTO	Order Type	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	MATC	Type - Match Record Type	Ascending
1	SHPN	Shipment Number	Ascending

10: MatchType RecDoc RecDocType +

Element	Alias	Description	Sequence
4	KCO	Document Company	Ascending
3	DCT	Document Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
1	MATC	Type - Match Record Type	Ascending

11: OperationID VesselClass

Element	Alias	Description	Sequence
2	WVTY	Vessel Class	Ascending
1	WOPID	Operation ID	Ascending

12: Order Number No NLIN

Element	Alias	Description	Sequence
5	SFX	Document Pay Item	Ascending
4	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
1	MATC	Type - Match Record Type	Ascending