OMPB_BK_DFN_PVW

(SQL View)
 Index Back

Customer Price Book Header

Customer Price Book Header

SELECT BUSINESS_UNIT , OMPB_BOOK_DEFN_ID , OMPB_DEFN_DESCR , OMPB_BOOK_TYPE , OMPB_BOOK_FOR_FLG , OMPB_BOOK_FOR_OPR , OMPB_BOOK_FOR_VAL , OMPB_BOOK_FOR_TO , TMPLDEFN_ID FROM PS_OMPB_BOOK_DEFN

  • Related Language Record: OMPB_BKDFN_PLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OMPB_BUS_UNIT_VAL Character(128) VARCHAR2(128) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

    Prompt Table: SP_BU_OM_NONVW

    2 OMPB_BOOK_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book Definition ID
    3 OMPB_DEFN_DESCR Character(100) VARCHAR2(100) NOT NULL Defintion description
    4 OMPB_BOOK_TYPE Character(1) VARCHAR2(1) NOT NULL Price Book Type
    A=Adjustments Only
    B=List Price and Adjustments
    L=List Price Only

    Default Value: L

    5 OMPB_BOOK_FOR_FLG Character(1) VARCHAR2(1) NOT NULL Customer Price Book For Flag
    C=Customer
    G=Customer Group

    Default Value: C

    6 OMPB_BOOK_FOR_OPR Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
    <=<
    <==<=
    <>=not =
    ===
    >=>
    >==>=
    BEG=begins with
    BET=between
    CON=contains
    IN=in

    Default Value: =

    7 OMPB_BOOK_FOR_VAL Character(128) VARCHAR2(128) NOT NULL Customer/Customer Group

    Prompt Table: %EDITTABLE

    8 OMPB_BOOK_FOR_TO Character(128) VARCHAR2(128) NOT NULL Customer/Customer Group

    Prompt Table: %EDITTABLE

    9 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

    Prompt Table: OM_XPRPTTMPL_VW