Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETCUTABLE


                             ETCUTABLE FILE

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ET2-CURTBL-ID          Numeric 10
Element: Numeric 1

ET2-CURTBL-CODE        Alpha 12                                  ET700
Element: Currency Table

ET2-CURTBL-DESC        Alpha 30  (Lower Case)                    ET700
Element: Description

ET2-CURTBL-STATUS      Numeric 5                                 ET700
Element: Numeric

                         ETCUTABLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ET2SET1   CURTBL-ID

ET2SET2   CURTBL-CODE                                            ET700

                         ETCUTABLE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Etcuconv       ETCUCONV

                            ET2-CURTBL-ID    -> ET4-EXCH-CURTBL-ID
                                                ET4-EXCH-FROM-CURR
                                                ET4-EXCH-TO-CURR
                                                ET4-EXCH-EFEC-DATE

Etcurelat      ETCURELAT

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