ERPRef.com

36 COLUMNS | 5 INDICIES 812 | 43S | F4313 POFLIP

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F4313	PF	36	5	POFLIP	Files	43S: Supplier Self Service

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.

36 COLUMNS | TOP 812 | 43S | F4313 POFLIP

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

5 INDICIES | TOP 812 | 43S | F4313 POFLIP

1: UniqueKeyId (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	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

2: DOCO DCTO KCOO SFXO LNID NLIN

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

3: Supplier

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

4: VINV DI

Element	Alias	Description	Sequence
1	VINV	Supplier Invoice Number	Ascending
2	DI	Date - Invoice	Ascending

5: Status

Element	Alias	Description	Sequence
1	PXTR	Status- PO Flip	Ascending