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.
Article ID: 1394
Created On: Mon, Jul 2, 2012 at 4:01 PM
Last Updated On: Mon, Jun 19, 2023 at 3:30 PM
Online URL: https://kb.datafile.co.uk/article/account-mandatory-database-profiles-1394.html