Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETVENDOR


                             ETVENDOR FILE

REFERENCED BY

ET530     ET540

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EVN-VNDR-ID            Numeric 10
Element: Numeric 1

EVN-VNDR-CODE          Alpha 15                                  ET700
Element: Alpha 15

EVN-VNDR-DESC          Alpha 80
Element: Alpha 80

EVN-VNDR-ADDRESS1      Alpha 50                                  ET700
Element: Alpha 50

EVN-VNDR-ADDRESS2      Alpha 50                                  ET700
Element: Alpha 50

EVN-VNDR-ADDRESS3      Alpha 50                                  ET700
Element: Alpha 50

EVN-VNDR-ADDRESS4      Alpha 50                                  ET700
Element: Alpha 50

EVN-VNDR-TAXCODE       Alpha 20
Element: Alpha 20

EVN-VNDR-ENTTYPE       Numeric 10                                ET700
Element: Numeric 1

EVN-VNDR-STATUS        Numeric 10
Element: Numeric 1

EVN-VNDR-MGRID         Numeric 10
Element: Numeric 1

EVN-VNDR-RATING        Numeric 10
Element: Numeric 1

EVN-VNDR-AGE           Numeric 10
Element: Numeric 1

EVN-VNDR-REVSIZE       Signed 12.2
Element: Signed 9

EVN-VNDR-CURR          Numeric 10
Element: Numeric 1

EVN-VNDR-ISCSTMR       Numeric 10
Element: Numeric 1

EVN-VNDR-LEVEL         Numeric 10                                ET700
Element: Numeric 1

EVN-VNDR-PAR1          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR2          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR3          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR4          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR5          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR6          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR7          Numeric 10
Element: Numeric 1

EVN-VNDR-PAR8          Numeric 10
Element: Numeric 1

EVN-VNDR-ACCT          Numeric 6
Element: Account

EVN-VNDR-SUBACCT       Numeric 4
Element: Sub Acct

EVN-VNDR-BILLACCT      Numeric 6
Element: Account

EVN-VNDR-BLSUBACCT     Numeric 4
Element: Sub Acct

EVN-VNDR-COSTCNTR      Numeric 10
Element: Numeric 1

EVN-VNDR-COMMENT       Alpha 200
Element: Alpha 200

EVN-VNDR-APGROUP       Alpha 4                                   ET700
Element: Vendor Group

EVN-VNDR-SOURCE        Numeric 10                                ET700
Element: Numeric 1

EVN-VNDR-TEMPID        Alpha 40
Element: Alpha 40

                         ETVENDOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EVNSET1   VNDR-ID

EVNSET2   VNDR-APGROUP                                           ET530   ET540
          VNDR-CODE                                              ET700
          VNDR-ID