Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETCURELAT


                             ETCURELAT FILE

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ET3-CURREL-ID          Numeric 10
Element: Numeric 1

ET3-CURREL-CURTBL      Numeric 10                                ET700
Element: Numeric 1

ET3-CURREL-FRM-CUR     Numeric 10                                ET700
Element: Numeric 1

ET3-CURREL-TO-CUR      Numeric 10                                ET700
Element: Numeric 1

ET3-CURREL-MULTDIV     Numeric 5                                 ET700
Element: Numeric

ET3-CURREL-FRM-DEC     Numeric 1                                 ET700
Element: Nbr Decimals

ET3-CURREL-TO-DEC      Numeric 1                                 ET700
Element: Nbr Decimals

ET3-CURREL-TRN-IND     Numeric 5                                 ET700
Element: Numeric

ET3-CURREL-TRN-CUR     Numeric 10                                ET700
Element: Numeric 1

ET3-CURREL-OVRRIDE     Numeric 5                                 ET700
Element: Numeric

ET3-CURREL-TOLLER      Numeric 3                                 ET700
Element: Ovd Tolerance

ET3-CURREL-STATUS      Numeric 5                                 ET700
Element: Numeric

                         ETCURELAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ET3SET1   CURREL-ID

ET3SET2   CURREL-CURTBL                                          ET700
          CURREL-FRM-CUR
          CURREL-TO-CUR

                         ETCURELAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Etcuconv       ETCUCONV

                            ET3-CURREL-CURTBL    -> ET4-EXCH-CURTBL-ID
                                                    ET4-EXCH-FROM-CURR
                                                    ET4-EXCH-TO-CURR
                                                    ET4-EXCH-EFEC-DATE

Etcurelat      ETCURELAT

                            ET3-CURREL-CURTBL    -> ET3-CURREL-CURTBL
                                                    ET3-CURREL-FRM-CUR
                                                    ET3-CURREL-TO-CUR