Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              CUCODES FILE

                             Currency Codes

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.


REFERENCED BY

AC191     AC256     AC550     AC750     AP251     AR20.1
AR251     AR293     FB141     FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL110     GL122     GL135
GL167     GL190     GL191     GL195     GL196     GL199
GL255     GL256     GL292     GL293     GL294     GL296
GL330     GL40.2    GL45.1    GL50.4    GL500     GL55.1
GL90.3    GL95.1    GL95.2    GL95.3    GL95.4    GL95.5
GL95.6    GL95.7    GL95.8    GL95.9    GL96.1    GL96.2
GL96.3    GL96.4    GL96.5    GL97.1    GL97.2    GL97.3
GL97.4    GL97.5    GL97.6    GL97.7    GL97.8    GL97.9
GL98.1    GL98.2    GL98.3    GL98.4    GL98.5    GL99.1
GL99.2    GL99.3    GL99.4    GL99.5    GL99.6    RW00.1
RW100     RW20.1    RW20.2    RW50.1    RW70.1    HCUC.1
HR00.1    HR01.1    HR15.1    HR15.2    HR200     HR201
HR211     HR30.1    HR511     HR515     HR521     HR54.1
IC222     CU02.1    CU02.2    CU10.1    CU160     CU161
CU20.1    CU20.2    CU20.3    CU20.4    CU201     CU202
CU203     CU210     CU220     CU261     CU60.1    CU61.1
CU61.2    GL10.1    GL121     GL124     GL20.2    GL20.4
IFAC.1    IFCU.1    HS50.3    HS50.4    PA120     PA16.1
PA19.1    PA202     PA231     PA233     PA248     PA259
PA290     PA295     PA31.1    PA311     PA33.1    PA360
PA370     PA42.1    PA44.1    PA45.1    PA48.1    PA502
PA513     PA54.1    PA59.1    PA90.3    PA95.1    TR00.1
PR116     PR16.1    PR197     PR20.4    PR24.1    IN20.1

UPDATED BY

CU01.1    CU01.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CUC-CURRENCY-CODE    Alpha 5                                     CU01.1  CU01.2
Currency Code        This is the code identifying a specific
                     currency.


CUC-DESCRIPTION      Alpha 30  (Lower Case)                      CU01.1  CU01.2
Currency Code        This is the currency code description.      RW100
Description

CUC-FORMS-EXP        Alpha 10  (Lower Case)                      CU01.1  CU01.2
Forms Expression     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.


CUC-NBR-DECIMALS     Numeric 1                                   CU01.1  CU01.2
Number of Decimals   This 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

CUC-ISO-CODE         Alpha 3                                     CU01.1  CU01.2
ISO Code             This is the ISO code for the country of
                     origin of the currency.


CUC-ISO-CTRY-NBR     Numeric 3                                   CU01.1  CU01.2
Iso Ctry Nbr         The ISO country number.

                         CUCODES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CUCSET1   CURRENCY-CODE This path is used to retrieve the        AC191   AC256
                        currency codes in alphabetic order.      AC550   AC750
                                                                 AP251   AR20.1
                                                                 AR251   AR293
                                                                 FB141   FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 FB95.6  GL110
                                                                 GL122   GL135
                                                                 GL167   GL190
                                                                 GL191   GL195
                                                                 GL196   GL199
                                                                 GL255   GL256
                                                                 GL292   GL293
                                                                 GL294   GL296
                                                                 ...