CUCONVREL FILE
Currency Conversion Interface
The Currency Rate Conversion (CUCONVREL) file stores currency exchange rate
information you are converting from a non-Lawson system to the Lawson Currency
system using CU60, CU160, and CU260.
REFERENCED BY
CU260
UPDATED BY
CU160 CU60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUR-CURRENCY-TABLE Alpha 12 CU60.1
Currency Table The currency table stores interface
information. It is similar to a run
group.
CUR-SEQ-NUMBER Numeric 6 CU60.1
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
CUR-FR-CURR-CODE Alpha 5 CU60.1
From Currency Code This is the company base currency code,
established in GL10.1 (Company).
CUR-TO-CURR-CODE Alpha 5 CU60.1
To Currency Code This is the company base currency code,
established in GL10.1 (Company).
CUR-SYSTEM Alpha 2 CU60.1
System Code A two-character code representing an
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
CUR-EFFECT-DATE Numeric 8 (yyyymmdd) CU60.1
Effective Date The effective date identifies when the
exchange rate can be used.
CUR-SELL-RATE Signed 12.6 CU60.1
Selling Rate This is the exchange rate you converted
to the Lawson system from your
non-Lawson system.
CUCONVREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CURSET1 CURRENCY-TABLE CU160 CU60.1
SEQ-NUMBER
CURSET2 CURRENCY-TABLEKeyChange CU260 CU60.1
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
EFFECT-DATE
SEQ-NUMBER
|
