CUCODES – Currency Codes

System
General Ledger Setup (IF)
Prefix
CUC
Primary key
CURRENCY-CODE
Fields
6
Updated by
2 programs
Referenced by
678 programs

CUCODES is the Currency Codes table in Lawson General Ledger Setup (prefix CUC). It is indexed by CURRENCY-CODE (CUCSET1). It is updated by CU01.1 and CU01.2 and referenced by AC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 and 670 more. The table has 6 fields, 1 index and 0 documented relations.

About CUCODES

This file contains information about currency codes. CU01.1 (Currency Codes) is the only program that updates this file; all codes are added, changed, or deleted in CU01.1 (Currency Codes). A currency code must be defined in this file to be used in the Currency system.

Fields (6)

Column = COBOL field name without the CUC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CUC-CURRENCY-CODE PK
CURRENCY_CODE
Alpha 5This is the code identifying a specific currency.CU01.1, CU01.2
CUC-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the currency code description.CU01.1, CU01.2, RW100
CUC-FORMS-EXP
FORMS_EXP
Alpha 10 (Lower Case)This field defines the type of currency used by a country. Form expression is an additional description of the currency code. If you leave this field blank, the value in the Currency Code field defaults.BN207, BN223, CU01.1, CU01.2
CUC-NBR-DECIMALS
NBR_DECIMALS
Numeric 1This field determines the number of decimals used by the conversion programs to calculate rounded or decimal amounts. Use 0 if the amount is a whole value. Use 2 for the normal two-decimal position.
  • 0 No Decimals
  • 2 Two Decimals
CU01.1, CU01.2
CUC-ISO-CODE
ISO_CODE
Alpha 3This is the ISO code for the country of origin of the currency.CU01.1, CU01.2
CUC-ISO-CTRY-NBR
ISO_CTRY_NBR
Numeric 3The ISO country number.CU01.1, CU01.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CUCSET1CURRENCY-CODEPrimaryAC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (678)