Account Mandatory - Database Profiles

Data Item Type Alternative Notes

Account code X (10) X, Y Maximum size of 10 characters

Account name X (30) X, & Up to 64 characters. You could specify separate data items for title, initials and surname, grouped to give full name

Balance b/forward L K Holds the balance brought forward (whether open-item or balance-forward account) as at the end of the previous period

Current balance L K Holds the current balance of the account, including forward transaction values (a separate field holds the value of forward transactions, see later)

Unallocated total L K Holds the total value of credits (whether payments, credit notes, or invoice adjustments) which have yet to be allocated to debit transactions. It is not used in balance-forward accounts. It also includes any unallocated credit amounts in forward transactions

Open item ?-type Set to Y if account is open-item, N or blank indicating balance-forward. If application system profile (see appendix B) specifies all accounts to be open-item, then is set to Y automatically

Analysis code T N, X, Y Used by Customer Analysis Report to analyse customer turnover (for example) by county, salesman, TV region or other characteristic assigned to the analysis code

First transaction Y (6) N, Y (5–8) If transaction file likely to exceed 1M, then make Y (8)

Last transaction Y (6) N, Y (5–8) If transaction file likely to exceed 1M, then make Y (8). Pointers used internally to access transaction chain in transaction file.Record numbers of the first and last transactions are held here.