Data Item Type Alternative Notes
Was provisional ?-type This is set to Y if this was a provisional transaction now reversed
Text-1 X (30) These three fields are used to store a longer journal memo
Text-2 X (30) The fields may be up to 64 characters in length
Text-3 X (30)
Prov Rev Date D E Date a provisional transaction was reversed
2nd Reference X (10) Allows you to add an extra reference field to nominal transactions
VAT Period Y (4) Holds the period that the transaction was reported on the VAT Form 100 (Only transactions with a non-zero cash-amount/cash-tax are updated).
Payee Name X (30) Holds the payee name entered on cashbook payments when a remittance advice is produced for a non-purchase ledger payment.
Cash Memo Bank X (16) Holds the bank account against the analysis lines entered in a cash book receipt or payment.
Article ID: 1139
Created On: Thu, Jun 28, 2012 at 10:46 AM
Last Updated On: Mon, Jun 19, 2023 at 6:35 PM
Online URL: https://kb.datafile.co.uk/article/transaction-optional-2-nominal-database-profiles-1139.html