PROCESS_INSTANCER=Run Control Page
W=WorkBench Page
N=No
Y=Yes
REQ_CANCEL_AET(SQL Table) |
Index Back |
|---|---|
REQ Cancel Cache Rec698894 01/03/2007 IND - Resolved the issue such that when on line requisition is canceled budget check page is displayed and change order is tracked when requisition is canceled. |
| # | 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). |
| 3 | RUN_DT | Date(10) | DATE | Run Date |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 7 | COMMITMENT_CNTL_PO | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on PO |
| 8 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |
| 10 | BATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL | Batch Action |
| 11 | BATCH_LOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Batch Location
R=Run Control Page W=WorkBench Page |
| 12 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 13 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 14 | BUDGET_DT_SW | Character(1) | VARCHAR2(1) NOT NULL | Show Budget Date |
| 15 | TMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Field for holding temp data |
| 16 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 17 | FIELDNAME_TARGET | Character(18) | VARCHAR2(18) NOT NULL | Allocations Target amount field |
| 18 | CHNG_TMPLT_ID_REQ | Character(10) | VARCHAR2(10) NOT NULL | Change Template |
| 19 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 20 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 21 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |