OMPB_OUT_AET(SQL Table) |
Index Back |
|---|---|
OMEC AE CacheOMEC AE Cache Date Initials Issue Description 102301 dms D-RBADARIN-6 Add source_cd, orig_dt_timestamp, eip_dta_status |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DELETE_CONTROL | Character(1) | VARCHAR2(1) NOT NULL | DELETE_CONTROL |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EIP_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync |
| 6 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |
| 7 | OMPB_BOOK_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book Definition ID |
| 8 | OMPB_BOOK_ID | Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book ID |
| 9 | OMPB_BOOK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Price Book Type
A=Adjustments Only B=List Price and Adjustments L=List Price Only |
| 10 | OMPB_CHUNK_SQL | Character(100) | VARCHAR2(100) NOT NULL | OMEC Chunking SQL |
| 11 | OMPB_CHUNK_TBL | Character(30) | VARCHAR2(30) NOT NULL | OMEC Chunking Table |
| 12 | OMPB_CUST_FLDNAME | Character(15) | VARCHAR2(15) NOT NULL | OMEC Customer Field Name |
| 13 | OMPB_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | price book instance |
| 14 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 15 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 16 | SETID_CUST | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 17 | TOTAL_EXTRACT | Number(8,0) | INTEGER NOT NULL | Extract Total |