PROCESS_INSTANCEPrompt Table: OPR_DEF_TBL_FS
AP_VNDRSTAT_AET(SQL Table) |
Index Back |
|---|---|
Supplier Process AESCC 01/27/03 F-BSCULLIO-25: Inactivate Suppliers |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 5 | DATE_WRK | Date(10) | DATE | Date Work Field |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | LAST_ACTIVITY_DT | Date(10) | DATE | Last Activity Date |
| 8 | CREATE_LOG_SW | Character(1) | VARCHAR2(1) NOT NULL | Log Supplier Processed |
| 9 | UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Update Prior Operations |
| 10 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 11 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 12 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 13 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 14 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 15 | LAST_UPDATE_DT | Date(10) | DATE | Last Updated |