ERPRef.com

25 COLUMNS | 3 INDICIES 920 | 09 | F09611 Electronic Bank Statement Staging Detail

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F09611	BG	25	3	Electronic Bank Statement Staging Detail	Files	09: General Accounting

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.

25 COLUMNS | TOP 920 | 09 | F09611 Electronic Bank Statement Staging Detail

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

3 INDICIES | TOP 920 | 09 | F09611 Electronic Bank Statement Staging Detail

1: BankStatementNo Date (Primary/Unique)

Element	Alias	Description	Sequence
5	STLIN	Staging Line Number	Ascending
4	BSSEQ	Bank Statement Sequence	Ascending
3	BAN	Electronic Bank Account Number	Ascending
2	STMD	Statement Date	Ascending
1	BSTN	Auto Bank Statement Number	Ascending

2: BankStatementID LineNo

Element	Alias	Description	Sequence
3	STLIN	Staging Line Number	Ascending
2	BSSEQ	Bank Statement Sequence	Ascending
1	BKSTID	Bank Statement ID	Ascending

3: BankStatementNo Date Ban

Element	Alias	Description	Sequence
5	TRANT	External Transaction Type	Ascending
4	STLIN	Staging Line Number	Ascending
3	BAN	Electronic Bank Account Number	Ascending
2	STMD	Statement Date	Ascending
1	BSTN	Auto Bank Statement Number	Ascending