BUSINESS_UNITOMPB_BOOK_DEFN_IDOMPB_BOOK_IDOMPB_INSTANCELANGUAGE_CDOMPB_BOOK_LVW(SQL View) |
Index Back |
|---|---|
Customer Price Book InstanceCustomer Price Book Instance |
| SELECT I.BUSINESS_UNIT , I.OMPB_BOOK_DEFN_ID , I.OMPB_BOOK_ID , I.OMPB_INSTANCE , D.LANGUAGE_CD , D.OMPB_DEFN_DESCR , B.OMPB_BOOK_DESCR FROM PS_OMPB_BOOK_DEF_L D , PS_OMPB_BOOK_LNG B , PS_OMPB_INSTANCE I WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.OMPB_BOOK_DEFN_ID = B.OMPB_BOOK_DEFN_ID AND B.BUSINESS_UNIT = I.BUSINESS_UNIT AND B.OMPB_BOOK_DEFN_ID = I.OMPB_BOOK_DEFN_ID AND B.OMPB_BOOK_ID = I.OMPB_BOOK_ID AND D.LANGUAGE_CD = B.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | OMPB_BOOK_DEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book Definition ID |
| 3 | OMPB_BOOK_ID |
Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book ID |
| 4 | OMPB_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | price book instance |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | OMPB_DEFN_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Defintion description |
| 7 | OMPB_BOOK_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Price book description |