PO_RLRQPRG_AET(SQL Table) |
Index Back |
|---|---|
Reqload Rqst Purge AE Tran |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPL_ABORT | Character(1) | VARCHAR2(1) NOT NULL | AE Application Abort Indicator |
| 3 | AE_CNV_IN_FLD_NM | Character(18) | VARCHAR2(18) NOT NULL | AE input convert field |
| 4 | AE_CNV_OUT_FLD_NM | Character(18) | VARCHAR2(18) NOT NULL | AE output converion field |
| 5 | AE_QUOTE | Character(1) | VARCHAR2(1) NOT NULL | Quote |
| 6 | AE_SPACE | Character(1) | VARCHAR2(1) NOT NULL | Blank field literal |
| 7 | AE_RUN_OK | Character(1) | VARCHAR2(1) NOT NULL | AE Run OK Indicator |
| 8 | DATE_SEL_DT | Date(10) | DATE | 03/23/2004 SFC Added PROD_COST_EFF_DT label |
| 9 | DATE_SEL_OPR | Character(2) | VARCHAR2(2) NOT NULL |
Date Selection Oper
<=Less Than Select Date <==Less Than or Equal To Sel Date <>=Not Equal to Selection Date ==Equal to Selection Date >=Greater Than Selection Date >==Greater Than or Eq to Sel Date |
| 10 | LOADER_BU | Character(5) | VARCHAR2(5) NOT NULL |
Requesting Loader Bus Unit
Prompt Table: PO_RLRQ_BU_VW |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
| 12 | REQ_RQST_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Requisition Request ID
Prompt Table: PO_REQLOAD_SRCH |
| 13 | REQ_RQST_ID_X | Character(10) | VARCHAR2(10) NOT NULL | Req Reqest ID |
| 14 | RLRQPRG_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Parm 1 |
| 15 | RLRQPRG_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Parm 2 |
| 16 | RLRQPRG_PARM2B | Character(30) | VARCHAR2(30) NOT NULL | Parm 2 B |
| 17 | RLRQPRG_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Parm 3 |
| 18 | RLRQPRG_PARM3B | Character(30) | VARCHAR2(30) NOT NULL | Parm 3 B |
| 19 | RLRQPRG_PARM4 | Character(30) | VARCHAR2(30) NOT NULL | Parm 4 |
| 20 | RLRQPRG_PARM5 | Character(30) | VARCHAR2(30) NOT NULL | Parm 5 |
| 21 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 22 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Prompt Table: PO_RLRQ_SRC_VW |