Name	Type	Length	Precision	Notes	Example
ACCOUNT_REF	VARCHAR	8	8	Bank Account Reference
STATEMENT_REF	VARCHAR	30	30	Statement Reference
CLOSING_BALANCE	DOUBLE	8	15	Closing Balance
OPENING_BALANCE	DOUBLE	8	15	Opening Balance
AMOUNT_IN	DOUBLE	8	15	Total paid in during this statement
AMOUNT_OUT	DOUBLE	8	15	Total paid out during this statement
INTEREST	DOUBLE	8	15	Interest Amount
INTEREST_ID	INTEGER	4	10	Interest Row ID
INTEREST_NOM_CODE	VARCHAR	8	8	Nominal Code for Interest
CHARGES	DOUBLE	8	15	Charges Amount
CHARGES_ID	INTEGER	4	10	Charges Row ID
CHARGES_NOM_CODE	VARCHAR	8	8	Nominal Code for Charges
STATEMENT_DATE	DATE	2	10	Statement Date
INTEREST_DATE	DATE	2	10	Interest Date
CHARGES_DATE	DATE	2	10	Charges Date
RECONCILIATION_DATE	DATE	2	10	Reconciliation Date
RECORD_CREATE_DATE		16	0	Date and time when the record was created.
RECORD_MODIFY_DATE		16	0	Date and time when the record was modified.
RECORD_DELETED	TINYINT	2	3	Flag denoting if the record has been deleted or not.

---

Back | Edit on Github