Trans Optional 1 - Database Profiles

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