|
|
CUCONVREL FILE
Curr Exchange Rate 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 TableThe currency table stores interface
information. It is similar to a run
group.
CUR-SEQ-NUMBER Numeric 6 CU60.1
Element: Seq Number A unique number assigned to each
transaction to be interfaced into the
Lawson system.
CUR-FR-CURR-CODE Alpha 5 CU60.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
CUR-TO-CURR-CODE Alpha 5 CU60.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
CUR-SYSTEM Alpha 2 CU60.1
Element: System 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
Element: Effect Date The effective date identifies when the
exchange rate can be used.
CUR-SELL-RATE Signed 14.7 CU60.1
Element: Curr 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
|
