ERPRef.com

53 COLUMNS | 8 INDICIES 920 | 04 | F0414 Accounts Payable Matching Document Detail

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F0414	RN	53	8	Accounts Payable Matching Document Detail	Transaction Files	04: Accounts Payable	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.

53 COLUMNS | TOP 920 | 04 | F0414 Accounts Payable Matching Document Detail

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

8 INDICIES | TOP 920 | 04 | F0414 Accounts Payable Matching Document Detail

1: Payment ID Line (Primary/Unique)

Element	Alias	Description	Sequence
2	RC5	File Line Identifier 5.0	Ascending
1	PYID	Payment ID (Internal)	Ascending

2: Payment ID Post Code

Element	Alias	Description	Sequence
2	POST	G/L Posted Code	Ascending
1	PYID	Payment ID (Internal)	Ascending

3: Document Type +A

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

5: Payment ID Doc Type +A

Element	Alias	Description	Sequence
7	SFXE	Pay Item Extension Number	Ascending
6	SFX	Document Pay Item	Ascending
5	KCO	Document Company	Ascending
4	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCTM	Document Type - Matching	Ascending
1	PYID	Payment ID (Internal)	Ascending

6: Address Num Doc Type +A

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

7: Doc DocTy Co +A

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

8: NetTID NetDoc +A

Element	Alias	Description	Sequence
3	NETRC5	Netting Line ID	Ascending
2	NETDOC	Netting Document Number	Ascending
1	NETTCID	Netting Transaction ID	Ascending

9: PYID SFX

Element	Alias	Description	Sequence
3	RC5	File Line Identifier 5.0	Ascending
2	SFX	Document Pay Item	Ascending
1	PYID	Payment ID (Internal)	Ascending