ERPRef.com

26 COLUMNS | 2 INDICIES 910 | 43 | F43121T Purchase Order Receiver Tag File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
910	F43121T	PR	26	2	Purchase Order Receiver Tag 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.

26 COLUMNS | TOP 910 | 43 | F43121T Purchase Order Receiver Tag File

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

2 INDICIES | TOP 910 | 43 | F43121T Purchase Order Receiver Tag File

1: MATC DOCO DCTO KCOO SFXO +A (Primary/Unique)

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

2: MATC DOC DCT KCO SFX SFXE

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending
4	SFX	Document Pay Item	Ascending
5	SFXE	Pay Item Extension Number	Ascending