ERPRef.com

97 COLUMNS | 10 INDICIES 920 | 03B | F03B13 Receipts Header

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F03B13	RY	97	10	Receipts Header	Transaction Files	03B: Enhanced Accounts Receivable	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.

97 COLUMNS | TOP 920 | 03B | F03B13 Receipts Header

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

10 INDICIES | TOP 920 | 03B | F03B13 Receipts Header

1: Payment ID (Primary/Unique)

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	Ascending

3: Batch Type Number +

Element	Alias	Description	Sequence
4	PYID	Payment ID (Internal)	Ascending
3	POST	G/L Posted Code	Ascending
2	ICU	Batch Number	Ascending
1	ICUT	Batch Type	Ascending

4: Draft Reg Dr Status Pyid

Element	Alias	Description	Sequence
3	PYID	Payment ID (Internal)	Ascending
2	DDST	Draft Status	Ascending
1	DREG	Draft Register	Ascending

5: Payor Number GL Date +

Element	Alias	Description	Sequence
3	CKNU	Receipt Number	Ascending
2	DGJ	Date - For G/L (and Voucher) - Julian	Descending
1	PYR	Payor Address Number	Ascending

6: Receipt Number

Element	Alias	Description	Sequence
1	CKNU	Receipt Number	Ascending

7: Batch Number Receipt Number

Element	Alias	Description	Sequence
2	CKNU	Receipt Number	Ascending
1	ICU	Batch Number	Ascending

8: Address Number Company

Element	Alias	Description	Sequence
2	CO	Company	Ascending
1	AN8	Address Number	Ascending

9: AddressNumber Company +

Element	Alias	Description	Sequence
4	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
3	VDGJ	Void Date - For G/L - Julian	Ascending
2	CO	Company	Ascending
1	AN8	Address Number	Ascending

10: NetTransID NetDocNum

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

11: AN8 CO DGJ

Element	Alias	Description	Sequence
3	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
2	CO	Company	Ascending
1	AN8	Address Number	Ascending