OPRIDRUN_CNTL_IDR=Run Control Page
W=WorkBench Page
Default Value: R
N=No
Y=Yes
0=None
1=Email
2=Worklist
3=Email and Worklist
4=User Preference
0=None
1=Email
2=Worklist
3=Email and Worklist
4=User Preference
PO_APR_RMDR_CTL(SQL Table) |
Index Back |
|---|---|
PO Reconcile Cache Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | BATCH_LOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Batch Location
R=Run Control Page W=WorkBench Page Default Value: R |
| 7 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 8 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 9 | TEMPLATE_ID1 | Character(30) | VARCHAR2(30) NOT NULL | *Project Template Name |
| 10 | TEMPLATE_ID2 | Character(30) | VARCHAR2(30) NOT NULL | Fulfillment Workbench Template |
| 11 | SQLID1 | Character(30) | VARCHAR2(30) NOT NULL | SQL OBJECT WORK FIELD |
| 12 | SQLID2 | Character(30) | VARCHAR2(30) NOT NULL | SQL OBJECT WORK FIELD |
| 13 | POEOAWCHANNEL1 | Character(1) | VARCHAR2(1) NOT NULL |
Notification Chnl hdr
0=None 1=Email 2=Worklist 3=Email and Worklist 4=User Preference |
| 14 | POEOAWCHANNEL2 | Character(1) | VARCHAR2(1) NOT NULL |
Notification Chnl ln
0=None 1=Email 2=Worklist 3=Email and Worklist 4=User Preference |