Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Account Optional 3 - Database Profiles

Datafile Software

Account Optional 3 - Database Profiles

Data Item Type Alternative Notes

Allocation letter X (1) Holds last letter used to mark transactions making up a particular allocation. It is advanced by one letter after each allocation

Alloc-in-progress ?-type A custom field, i.e. not in general use, that allows transactions to be entered against an account when allocations are in progress but block the account being allocated by more than one user at once.

First job record Y (6) N, Y (5) Sales Ledger only

Last job record Y (6) N, Y (5) Sales Ledger only. These last two prompts hold the record numbers of the first and last job records for this account in the job costing system

Autopay amount L K Purchase Ledger only. This holds the amount to be paid from the last automatic payment run.

Autopay disc amt L K Purchase Ledger only. This item holds the discount taken on the last automatic payment run.

Autopay tx no Y(6) N, Y(5–8) Purchase Ledger only. Generated payment transaction (used by cheque run)

Retain doc days N Where text copies of documents are held on file for use with the DeskTop Ledger Enquiriesfacility, you can set a limit to the number of days they are held for each account.

Delete at year-end ?-type If set to Y, then account removed by batch delete facility at year end, if no balance or outstanding orders.

Memo Reference Y(6) Holds reference number of any memo attached to an account. Add two-digit application code (SL/PL) plus company suffix for filename

Discount Group N T Used for discount matrix if present

EC Country X (2) Two-character country code as determined by EC

EC Tax Reg X (15) VAT code of customer/supplier

O/s Orders L K Value of orders outstanding on order processing system

Fwd O/S Orders L K Value of orders with a F-Forward status on order processing system.

Due-Date D of Wk N X, Y, T If present, then rounds up due date to the specified day of the week, where 1 = Sunday, 2 = Monday, and so on

Sett Disc % (2) K L Holds the second set of settlement terms for use in Order Processing. This holds the settlement rate.

Sett Days (2) X (4) N This holds the settlement days.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Transfer Outstanding Balances
Viewed 1856 times since Fri, May 27, 2016
Controls and Audit Manager
Viewed 2119 times since Mon, Jul 2, 2012
Allow 12 Statement / Remittance Advices
Viewed 2093 times since Wed, Jun 13, 2012
ADD – Adding a New Account
Viewed 2420 times since Fri, Jun 29, 2012
Set Account Group on Stop
Viewed 13447 times since Fri, Oct 26, 2012
Trans Sub Contract (Purchase Ledger) - Database Profiles
Viewed 1972 times since Mon, Jul 2, 2012
Ledger Enquiry Manager
Viewed 2312 times since Mon, Jul 2, 2012
Other Transaction Facilities
Viewed 1818 times since Mon, Jul 2, 2012
Sales/Purchase Document Facilities
Viewed 1845 times since Mon, Jul 2, 2012
Credit Control Manager Apply Colour Highlighting Rules Sales Ledger
Viewed 1962 times since Fri, May 27, 2016