BUSINESS_UNITOMPB_BOOK_DEFN_IDOMPB_BOOK_IDOMPB_INSTANCEEOEP_RULE_IDOMPB_ACTIVE_ROW1=Active Row
2=Inactive Row
EOEP_RANGE_IDP=Extended Price
Q=Quantity
V=Volume
W=Weight
OMPB_FMRNG_VW(SQL View) |
Index Back |
|---|---|
Customer Price Book Form RangeCustomer Price Book Formula Range |
| SELECT DISTINCT R.BUSINESS_UNIT , R.OMPB_BOOK_DEFN_ID , R.OMPB_BOOK_ID , R.OMPB_INSTANCE , R.EOEP_RULE_ID , R.OMPB_ACTIVE_ROW , R.EOEP_RANGE_ID , R.PRICE_TYPE , R.EOEP_MIN_AMOUNT , R.EOEP_MAX_AMOUNT FROM PS_OMPB_FORM_RANGE R |
| # | 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 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 6 | OMPB_ACTIVE_ROW |
Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if the row in the extract table is avtive/valid data. This is not really the same as effective date/status related.
1=Active Row 2=Inactive Row |
| 7 | EOEP_RANGE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Range ID |
| 8 | PRICE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Price Type
P=Extended Price Q=Quantity V=Volume W=Weight |
| 9 | EOEP_MIN_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Minimum Amount |
| 10 | EOEP_MAX_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Maximum Amount |