PO_APR_RMDR_AET(SQL Table) |
Index Back |
|---|---|
PO Reconcile Cache Rec |
| # | 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_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RUN_DT | Date(10) | DATE | Run Date |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 7 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | BATCH_LOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Batch Location
R=Run Control Page W=WorkBench Page Default Value: R |
| 10 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |
| 12 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 13 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 14 | TEMPLATE_ID1 | Character(30) | VARCHAR2(30) NOT NULL | *Project Template Name |
| 15 | TEMPLATE_ID2 | Character(30) | VARCHAR2(30) NOT NULL | Fulfillment Workbench Template |
| 16 | SQLID1 | Character(30) | VARCHAR2(30) NOT NULL | SQL OBJECT WORK FIELD |
| 17 | SQLID2 | Character(30) | VARCHAR2(30) NOT NULL | SQL OBJECT WORK FIELD |
| 18 | POEOAWCHANNEL1 | Character(1) | VARCHAR2(1) NOT NULL |
Notification Chnl hdr
0=None 1=Email 2=Worklist 3=Email and Worklist 4=User Preference |
| 19 | POEOAWCHANNEL2 | Character(1) | VARCHAR2(1) NOT NULL |
Notification Chnl ln
0=None 1=Email 2=Worklist 3=Email and Worklist 4=User Preference |
| 20 | EOAW_INT_NODE | Character(30) | VARCHAR2(30) NOT NULL |
Internal Node Name
Prompt Table: PSNODEVW |
| 21 | EOAW_INT_PORTAL | Character(30) | VARCHAR2(30) NOT NULL |
Internal Portal Name
Prompt Table: PTLT_PORTAL_VW |
| 22 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |