Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Transactional Optional 1 - Nominal - Database Profiles

Datafile Software

Transactional Optional 1 - Nominal - Database Profiles

Data Item Type Alternative Notes

Reference X (6) ? Often used to hold sales/purchase reference on update, or internal docket number for nominal journals

Analysis N T, C Can be used for further analysis by (e.g.) cost code, if not part of nominal coding structure; or employee number to help complete year-end P11Ds

Orig-Tx- Date D E The actual date from transactions updated from other systems

Cash Book Column N T, C For transactions which originate from the cash book, the "column” number used is stored here

Cash net amount L K The net and tax amounts for transactions entered through the cashbook

Cash tax amount L K

Cash memo account X (10) Y For cashbook transactions posted to sales and purchase ledgers, this is the associated ledger account. For other cashbook accounts it is the expense account used, to display in cashbook reports

Cash account narrative X (25) Either the sales/purchase account code or the expense account description is copied into this field as the transaction is written

Tax Code X (1) Y (1) The tax code (if appropriate) used for this transaction

Journal Source X (3) Holds a three-character description of the source of this transaction (e.g. S/L, P/L, JNL). See nominal ledger System Profile

Reconciled (Y/N) ?-type Set to Y when reconciled on bank statement

Reconciliation comment X (30) Holds optional reconciliation comment

Statement Page No N Bank statement page on which transaction occurred

Statement Date D E Date of statement when reconciled

Temp Bank Rec ? Holds Y for items flagged in the current reconciliation

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
FACTOR – Factor Period Budgets - Nominal
Viewed 920 times since Wed, Jun 27, 2012
Transaction / Detail Enquiries - Cashbook
Viewed 1451 times since Thu, Jun 28, 2012
Nom/CB Accounts File – Item Screen Design - Cashbook
Viewed 953 times since Thu, Jun 28, 2012
Easy Mode Financial Summary Definition - Nominal
Viewed 1540 times since Wed, Jun 27, 2012
Memo Facility Configuration - Cashbook
Viewed 1348 times since Thu, Jun 28, 2012
System Profiles Screen 1 - Cashbook
Viewed 1464 times since Thu, Jun 28, 2012
Post Bank Charges - Cashbook
Viewed 2083 times since Wed, Jun 27, 2012
Report Listings & Analyses - Nominal
Viewed 1544 times since Thu, Jun 28, 2012
Real Time Updates – VAT Summary Posting Copy Items
Viewed 18 times since Thu, Oct 17, 2024
Optional Account Items - Nominal - Database Profiles
Viewed 1492 times since Thu, Jun 28, 2012