Lawson Insight Technical Documentation | 
  
    
  | 
  
                             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
 |