BUSINESS_UNITPrompt Table: SP_BU_OM_NONVW
OMPB_BOOK_DEFN_IDOMPB_BOOK_IDOMPB_INSTANCEN=No
Y=Yes
OMPB_INSTANCE(SQL Table) |
Index Back |
|---|---|
Customer Price Book InstanceCustomer Price Book Instance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
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_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 | OMPB_DELTA_BK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Price delta book flag
N=No Y=Yes |
| 6 | OMPB_SRC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Source instance |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |