OMPB_BOOK_SS_VW(SQL View) |
Index Back |
|---|---|
Customer Price Book Header SSCustomer Price Book Header - Self Service |
| SELECT b.OPRID , a.BUSINESS_UNIT , a.OMPB_BOOK_DEFN_ID , %Substring(a.OMPB_BOOK_FOR_VAL,1,15) , a.OMPB_DEFN_DESCR , a.OMPB_BOOK_TYPE , a.OMPB_BOOK_FOR_FLG , a.OMPB_BOOK_FOR_OPR , ' ' , a.TMPLDEFN_ID FROM ps_ompb_book_defn a , PSOPRALIAS b , ps_contact c , ps_set_cntrl_rec d WHERE d.recname = 'CUSTOMER' AND a.OMPB_BOOK_FOR_FLG = 'C' AND a.OMPB_BOOK_FOR_OPR = '=' AND d.setcntrlvalue = a.business_unit AND %Sql(OMSS_VALID_CUST_SQL, b, c, d.setid, %Substring(a.OMPB_BOOK_FOR_VAL,1,15), sold_to_flg) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW |
| 3 | OMPB_BOOK_DEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book Definition ID |
| 4 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SSSOLD_VW
|
| 5 | OMPB_DEFN_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Defintion description |
| 6 | OMPB_BOOK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Price Book Type
A=Adjustments Only B=List Price and Adjustments L=List Price Only |
| 7 | OMPB_BOOK_FOR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Customer Price Book For Flag
C=Customer G=Customer Group Default Value: C |
| 8 | 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: = |
| 9 | OMPB_BOOK_FOR_VAL | Character(128) | VARCHAR2(128) NOT NULL | Customer/Customer Group |
| 10 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table: OM_XPRPTTMPL_VW |