Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETCUCONV


                             ETCUCONV FILE

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ET4-EXCH-ID            Numeric 10
Element: Numeric 1

ET4-EXCH-CURTBL-ID     Numeric 10                                ET700
Element: Numeric 1

ET4-EXCH-FROM-CURR     Numeric 10                                ET700
Element: Numeric 1

ET4-EXCH-TO-CURR       Numeric 10                                ET700
Element: Numeric 1

ET4-EXCH-EFEC-DATE     Numeric 8  (yyyymmdd)                     ET700
Element: Date

ET4-EXCH-RATE          Signed 18.7                               ET700
Element: Psa Rate52

                         ETCUCONV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ET4SET1   EXCH-ID

ET4SET2   EXCH-CURTBL-ID                                         ET700
          EXCH-FROM-CURR
          EXCH-TO-CURR
          EXCH-EFEC-DATE*

                         ETCUCONV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Etcurelat      ETCURELAT    Required

                            ET4-EXCH-CURTBL-ID    -> ET3-CURREL-CURTBL
                            ET4-EXCH-FROM-CURR    -> ET3-CURREL-FRM-CUR
                            ET4-EXCH-TO-CURR      -> ET3-CURREL-TO-CUR

Fr Etcucodes   ETCUCODES    Required

                            ET4-EXCH-FROM-CURR    -> ET1-CURRCD-ID

To Etcucodes   ETCUCODES    Required

                            ET4-EXCH-TO-CURR      -> ET1-CURRCD-ID