Data Item Type Alternative Notes
Nominal code X (10) Y Only used in type 6–9 analysis records, plus types2 and 5 payments
Nominal updated ?-type Nominal ledger changes this to Y as it posts each transaction into its own files. The next time nominal ledger is updated from the ledger, marked transactions are ignored and cannot be posted again
General code N T, X May be used only if the ledger is not linked to the nominal ledger.
Analysis code T N Used as the basis of the transactions analysis report. You can use it for (say) a product group code or a salesperson’s number
Credit days X (4) N, T The number of days’ credit allowed on this transaction, may be varied from invoice to invoice. Used to calculate the next item . . .
Due date D E The date payment is due, calculated as invoice date plus credit days
Old transaction ?-type If transactions are retained at period end, then fully allocated ones are marked as "old”. Available for lookup therefore
Sett disc amount L K Settlement discount amount which may be taken if paid in time
Sett disc days N X, T Number of days from invoice date for which settlement discount may be taken.
Sett disc date D E Date by which payment to be made to qualify for settlement discount
Batch number N Internally-generated batch number
User item 1 X (15) Any (Except table and calculated fields)
User item 2 L Any (Except table and calculated fields)
User item 3 N Any (Except table and calculated fields)
Date allocated D E (on Trans Optional 3 for purchase ledger)Holds the date the transaction was fully allocated.
Cost Value L K, M Sales Ledger only. Holds total cost entered for transaction, if you’re using costs
Article ID: 1407
Created On: Mon, Jul 2, 2012 at 4:22 PM
Last Updated On: Mon, Jun 19, 2023 at 3:26 PM
Online URL: https://kb.datafile.co.uk/article/trans-optional-1-database-profiles-1407.html