EO_CURRCNV_R_VW(SQL View) |
Index Back |
|---|---|
Currency Conversion Rule View |
| SELECT PROC_GRP_ID , PROD_ID , RULE_INSTNC_NBR , RECNAME , DESCR , DESCR50 , PROCESSING_SEQ , EXECUTE_PROD_ID , BYPASS_PROD_ID , EFFDT_PROC_CD , ALIAS_DT_FLDNAME , INCRMNT_FLDNAME , BYPASS_DTL_AUDIT , RULE_SQLID , CCR_STATUS , DESCRLONG FROM PS_EO_CURRCNV_RULE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROC_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Uniquely identifies a Currency Conversion Process Group
Prompt Table: EO_PROCGRP_PROD |
| 2 | PROD_ID |
Character(2) | VARCHAR2(2) NOT NULL |
This is an XLAT field listing all PeopleSoft 7.5 Product codes.
Prompt Table: EO_PROCGRP_PROD |
| 3 | RULE_INSTNC_NBR |
Number(3,0) | SMALLINT NOT NULL | Rule Occurrence Number |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: EO_PSRECDEFN_VW |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | PROCESSING_SEQ | Number(5,0) | INTEGER NOT NULL | Processing Sequence |
| 8 | EXECUTE_PROD_ID | Character(2) | VARCHAR2(2) NOT NULL | Execution Product ID |
| 9 | BYPASS_PROD_ID | Character(2) | VARCHAR2(2) NOT NULL | Bypass Product ID |
| 10 | EFFDT_PROC_CD | Character(1) | VARCHAR2(1) NOT NULL |
Date Processing Method
1=No Effective Date Processing 3=Effective Date, No Eff Seq 4=Effective Date with Eff Seq |
| 11 | ALIAS_DT_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Effective Date Field Name
Prompt Table: EO_RECFIELD2_VW |
| 12 | INCRMNT_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Increment Field Name
Prompt Table: EO_RECFIELD1_VW |
| 13 | BYPASS_DTL_AUDIT | Character(1) | VARCHAR2(1) NOT NULL |
Used by the Currency Conversion Utility. Any exceptions process that has been coded to write before and after images to the audit table should check this flag before writing to the audit table. Note: Use this flag in conjuntion with the flag on the run control (see Run Control for the Currency Conversion Utility). This flas has been added to the state record.
Y/N Table Edit |
| 14 | RULE_SQLID | Character(23) | VARCHAR2(23) NOT NULL | Rule SQLID |
| 15 | CCR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Used by the Currency Conversion Utility when a rule is made inactive. When the status is changed from active to inactive, all other fields are grayed out and a warning message is desplayed informing the user of possible disruption to the integrity of the rule set.
A=Active I=Inactive |
| 16 | DESCRLONG | Long Character | CLOB | Long Description |