EOEP_ARB_PLAN

(SQL Table)
 Index Back

Price Arbitration Plan

Price Arbitration is used to define how Price Rules will be applied to a base (starting) price. The Price Arbitration Plan is made up of one or more Price Arbitration Sequences.

  • Related Language Record: EOEP_ARBPLN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Default Value: SO

    Prompt Table: EOEP_APPCODE_VW

    3 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL This field is a flag field to indicate default or not.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

    7 EOEP_ROUND_ID Character(15) VARCHAR2(15) NOT NULL Rounding ID

    Prompt Table: EOEP_RNDRL_HDR

    8 EOEP_ROUND_FLG Character(1) VARCHAR2(1) NOT NULL Rouding Flag
    0=None
    1=Net Price
    2=Adjustment
    3=Both
    9 EOEP_DATE_NAME Character(15) VARCHAR2(15) NOT NULL Date Name

    Prompt Table: EOEP_DATE_VAR

    10 PRC_BREAK_DATE Character(1) VARCHAR2(1) NOT NULL Price Break Date Type
    A=Requested Arrival Date
    O=Order Date
    S=Schedule Ship Date
    11 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
    12 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.
    13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.