EOEP_PRICE_VAR

(SQL Table)
 Index Back

Pricing Variable Record

Pricing Variable Record by Transaction

  • Related Language Record: EOEP_PRCVAR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APPCODE_VW

    2 EOEP_VAR_NAME Character(15) VARCHAR2(15) NOT NULL Pricing Variable Name
    3 EOEP_VAR_TYPE Character(2) VARCHAR2(2) NOT NULL Pricing Variable Type
    01=Base Price
    02=Rollup Quantity
    03=Rollup Amount
    04=Rollup Weight
    05=Rollup Volume
    06=Net Price
    07=List Price
    08=Product Cost
    09=Index Start Amount
    10=Index Start Value
    11=Index End Value
    12=Order Extended Base Price
    13=Order Extended List Price
    14=Order Extended Net Price
    15=Order Extended Product Cost
    16=Alternate Product Cost
    17=Recurring List Price
    18=Recurring Net Price
    19=Extended Recurring List Price
    20=Extended Recurring Net Price
    99=User Variable
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: EOEP_NUM_FLD_VW