EOEP_PRCLST_HDR

(SQL Table)
 Index Back

Price List header

Price List header

  • Related Language Record: EOEP_PRCLST_H_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

    Prompt Table: EOEP_PRLSTID_VW

    3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 EOEP_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of pricing data
    1=Enterprise Pricer
    2=Promotion Management

    Default Value: 1

    7 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
    8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    9 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID