ERPRef.com

43 COLUMNS | 5 INDICIES 920 | 03B | F03B13Z1 Electronic Receipts Input

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F03B13Z1	RU	43	5	Electronic Receipts Input	Batch Input 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.

43 COLUMNS | TOP 920 | 03B | F03B13Z1 Electronic Receipts Input

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

5 INDICIES | TOP 920 | 03B | F03B13Z1 Electronic Receipts Input

1: EDI User EDI Batch +A (Primary/Unique)

Element	Alias	Description	Sequence
4	EDLN	EDI - Line Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
2	EDBT	EDI - Batch Number	Ascending
1	EDUS	EDI - User ID	Ascending

2: Payment ID

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

3: Upload Status Flag Batch Date

Element	Alias	Description	Sequence
2	DICJ	Date - Batch (Julian)	Ascending
1	EUPS	Auto-Cash Upload Status	Ascending

4: Batch Number Check Number +A

Element	Alias	Description	Sequence
4	DMTJ	Date - Matching Check or Item - Julian	Ascending
3	CKNU	Receipt Number	Ascending
2	ICU	Batch Number	Ascending
1	ICUT	Batch Type	Ascending

5: EDI User EDI Batch +A

Element	Alias	Description	Sequence
3	EUPS	Auto-Cash Upload Status	Ascending
2	EDBT	EDI - Batch Number	Ascending
1	EDUS	EDI - User ID	Ascending