|
|
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
Element: Currency TableThis is the currency table, a table of
currency relationships, currency
exchange rates, and translation rates
for one or more companies.
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
Element: Currency Code This is the name of the currency code
you are converting from. It must be
defined in the Currency Codes file.
CUR-TO-CURR-CODE Alpha 5 CU60.1
Element: Currency Code The name of the currency code you are
converting to. It must be defined in the
Currency Codes file.
CUR-SYSTEM Alpha 2 CU60.1
Element: System Code A two-character code representing an
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
The exchange rate will be valid for the
specific system code you define.
If this field is blank, the rate is
valid for all system codes.
CUR-EFFECT-DATE Numeric 8 (yyyymmdd) CU60.1
Element: Date The effective date identifies when the
exchange rate can be used.
The rate becomes effective until you add
an exchange rate with a later date.
CUR-SELL-RATE Signed 12.6 CU60.1
Element: Account 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
|
