OMPB_DEL_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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | DELETE_DTTM | DateTime(26) | TIMESTAMP | Delete DTTM |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | OMPB_BOOK_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book Definition ID |
| 7 | OMPB_BOOK_ID | Character(30) | VARCHAR2(30) NOT NULL | Customer Price Book ID |
| 8 | OMPB_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | price book instance |
| 9 | OMPB_SRC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Source instance |
| 10 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |
| 11 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 12 | OMPB_BUS_UNIT_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: = |
| 13 | OMPB_BUS_UNIT_VAL | Character(128) | VARCHAR2(128) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE |
| 14 | OMPB_BUS_UNIT_TO | Character(128) | VARCHAR2(128) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE |
| 15 | OMPB_DEFN_ID_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: BET |
| 16 | OMPB_DEFN_ID_VAL | Character(128) | VARCHAR2(128) NOT NULL |
Definition ID
Prompt Table: %EDITTABLE2 |
| 17 | OMPB_DEFN_ID_TO | Character(128) | VARCHAR2(128) NOT NULL |
Definition ID
Prompt Table: %EDITTABLE2 |
| 18 | OMPB_DAYS_OLD | Number(5,0) | INTEGER NOT NULL | Price book days old |
| 19 | OMPB_DEL_DEFN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Delete definition without price book
N=No Y=Yes |
| 20 | OMPB_DEL_BOOK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Delete book without instance
N=No Y=Yes |
| 21 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 22 | SQL_TEXT_LONG | Long Character(4000) | CLOB | Dynamic SQL string |