PO_RLRQPRG_RC(SQL Table) |
Index Back |
|---|---|
Reqload Rqst Purge run cntl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | AE_QUOTE | Character(1) | VARCHAR2(1) NOT NULL | Quote |
| 4 | LOADER_BU | Character(5) | VARCHAR2(5) NOT NULL |
Requesting Loader Bus Unit
Prompt Table: PO_RLRQ_BU_VW |
| 5 | PURGE_ERRORS | Character(1) | VARCHAR2(1) NOT NULL |
Purge Error Rows
Y/N Table Edit Default Value: N |
| 6 | PURGE_PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Purge Processed Rows
Y/N Table Edit Default Value: Y |
| 7 | REQ_RQST_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Requisition Request ID
Prompt Table: PO_REQLOAD_SRCH |
| 8 | RLRQPRG_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Parm 1 |
| 9 | RLRQPRG_PARM2B | Character(30) | VARCHAR2(30) NOT NULL | Parm 2 B |
| 10 | RLRQPRG_PARM3B | Character(30) | VARCHAR2(30) NOT NULL | Parm 3 B |
| 11 | 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 |
| 12 | DATE_SEL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Date Selection
C=Current Date M=Current Date Minus Days N=No Selection by Date P=Current Date Plus Days S=Specified Date Default Value: N |
| 13 | 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 |
| 14 | DATE_SEL_DT | Date(10) | DATE | 03/23/2004 SFC Added PROD_COST_EFF_DT label |
| 15 | DATE_SEL_DAYS | Number(3,0) | SMALLINT NOT NULL | Date Selection Number of Days |