Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EPCUSTINFO


                            EPCUSTINFO FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ECI-GROUP-ID           Alpha 15  (Lower Case)
Element: Group Id

ECI-CUST-ID            Alpha 15
Element: Cust Id

ECI-EP-TYPE            Alpha 5
Element: Ep Type

ECI-EP-ACCOUNT         Alpha 32
Element: Ep Account

ECI-EP-EXP-DATE        Numeric 8  (yyyymmdd)
Element: Ep Exp Date

ECI-EP-CUST-NAME       Alpha 30
Element: Ep Cust Name

ECI-EP-ADDR1           Alpha 30  (Lower Case)
Element: Ep Addr1

ECI-EP-ADDR2           Alpha 30  (Lower Case)
Element: Ep Addr2

ECI-EP-ADDR3           Alpha 30  (Lower Case)
Element: Ep Addr3

ECI-EP-ADDR4           Alpha 30  (Lower Case)
Element: Ep Addr4

ECI-EP-CITY            Alpha 18  (Lower Case)
Element: Ep City

ECI-EP-STATE           Alpha 2
Element: Ep State

ECI-EP-COUNTRY         Alpha 30  (Lower Case)
Element: Ep Country

ECI-EP-COUNTY          Alpha 25
Element: Ep County

ECI-EP-POSTAL-CODE     Alpha 12
Element: Ep Postal Code

ECI-DEFAULT-PMT        Alpha 1
Element: Default Pmt

                         EPCUSTINFO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ECISET1   GROUP-ID      KeyChange
          CUST-ID
          EP-ACCOUNT
          EP-TYPE