Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETEFCOST


                             ETEFCOST FILE

REFERENCED BY

ET540

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ET8-EFCOST-ID          Numeric 10
Element: Numeric 1

ET8-EFCOST-PRDID       Numeric 10
Element: Numeric 1

ET8-EFCOST-ETRESID     Numeric 10
Element: Numeric 1

ET8-EFCOST-PRDCOST     Signed 15.2
Element: Tran Inv Amt

ET8-EFCOST-RATE        Signed 18.7
Element: Psa Rate52

ET8-EFCOST-CURR        Numeric 10
Element: Numeric 1

ET8-EFCOST-SENT        Numeric 10
Element: Numeric 1

ET8-EFCOST-CRTDATE     Numeric 8  (yyyymmdd)
Element: Date

ET8-EFCOST-CRTID       Numeric 10
Element: Numeric 1

ET8-EFCOST-STATUS      Numeric 10
Element: Numeric 1

ET8-EFCOST-TYPE        Numeric 10
Element: Numeric 1

                         ETEFCOST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ET8SET1   EFCOST-ID

ET8SET2   EFCOST-ETRESID                                         ET540
          EFCOST-PRDID
          EFCOST-ID