Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUCODES


                              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

AC121     AC123     AC130     AC191     AC20.1    AC20.2
AC20.3    AC20.4    AC20.5    AC256     AC32.1    AC37.1
AC490     AP251     AR20.1    AR251     AR293     BN07.1
BN207     BN223     BN23.1    BN230     BN320     BN33.1
BN33.2    BN33.4    BR44.1    FB11.1    FB111     FB141
FB160     FB211     FB296     FB45.1    FB60.1    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     GL298     GL330     GL40.2    GL45.1    GL50.4
GL500     GL55.1    GL90.3    GL90.6    GL94.1    GL94.2
GL94.3    GL94.4    GL94.5    GL94.6    GL94.7    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
HR06.1    HR11.1    HR11.2    HR15.1    HR15.2    HR200
HR201     HR206     HR211     HR30.1    HR511     HR515
HR521     HR54.1    IC222     CU02.1    CU02.2    CU10.1
CU160     CU161     CU162     CU20.1    CU20.2    CU20.3
CU20.4    CU201     CU202     CU203     CU210     CU220
CU261     CU60.1    CU61.1    CU61.2    CU62.1    GL10.1
GL121     GL124     GL20.2    GL20.4    IFAC.1    IFCU.1
MA530     MA531     HS50.3    HS50.4    PA02.1    PA100
PA102     PA103     PA115     PA120     PA13.1    PA13.2
PA16.1    PA19.1    PA202     PA22.1    PA231     PA233
PA248     PA259     PA290     PA295     PA31.1    PA311
PA33.1    PA36.1    PA360     PA370     PA42.1    PA44.1
PA45.1    PA48.1    PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PA54.1    PA59.1    PA90.3    PA95.1
TR00.1    PBIP.1    PO150     PO25.1    PO25.6    PO25.7
PO30.1    PO30.2    PO30.3    PO33.1    PO34.1    PO35.1
PO52.1    PO536     PR110     PR113     PR116     PR120
PR13.1    PR13.5    PR13.6    PR13.8    PR131     PR132
PR16.1    PR197     PR20.4    PR24.1    PR276     PR70.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
Element: 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)                    BN207   BN223
Element: Forms ExpressiThis field defines the type of currency   CU01.1  CU01.2
                       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
Element: Number of DeciThis 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
Element: 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
Element: 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        AC121   AC123
                        currency codes in alphabetic order.      AC130   AC191
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC256
                                                                 AC32.1  AC37.1
                                                                 AC490   AP251
                                                                 AR20.1  AR251
                                                                 AR293   BN07.1
                                                                 BN207   BN223
                                                                 BN23.1  BN230
                                                                 BN320   BN33.1
                                                                 BN33.2  BN33.4
                                                                 BR44.1  FB11.1
                                                                 FB111   FB141
                                                                 ...