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

Trans Currency - Database Profiles

Datafile Software

Trans Currency - Database Profiles

Required for foreign currency operation, values mirror the same transaction items as for the base currency, except they hold the foreign currency values.

Data Item Type Alternative Notes

Curr Code X(3) Transaction currency code, taken from the account record

Curr Rate Orig M Exchange rate used when the transaction was first written

Curr Rate Now M Exchange rate now in use on this transaction. It would differ from the original rate if the transaction had been revalued at any time

Curr Fixed ? Set to Y if transaction not to be revalued

Curr Amount L K

Curr Tax Amt L K

Curr Pay Disc L K

Curr Total *-type

Curr Allocated L K

Curr Outstanding *-type

Curr Fwd Alloc L K

Curr Last Alc Amt L K Purchase Ledger only

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Account Listing
Viewed 2984 times since Mon, Jul 2, 2012
Automatic Payments – Omit Exclusive File Locks
Viewed 420 times since Tue, Oct 15, 2024
Trans Mandatory - Database Profiles
Viewed 2715 times since Mon, Jul 2, 2012
Account Invoicing (Sales Ledger) - Database Profiles
Viewed 2891 times since Mon, Jul 2, 2012
Trans Optional 2 - Database Profiles
Viewed 2519 times since Mon, Jul 2, 2012
Record Statement Dates on Account (S/L Only)
Viewed 2448 times since Wed, Jun 13, 2012
Save Aged Analysis
Viewed 2554 times since Mon, Jul 2, 2012
Include Debtor Memo on Aged Analysis Report
Viewed 3069 times since Tue, Jun 12, 2012
Additional Copy Items from Stock to Order Detail
Viewed 2056 times since Fri, Mar 11, 2016
Credit Restocking Fee (SOP Only)
Viewed 660 times since Thu, Jan 2, 2025