PROC_GRP_IDPrompt Table: EO_PROC_GROUP
PROD_IDPrompt Table: EO_CURRCNV_RULE
RULE_INSTNC_NBRPrompt Table: EO_CURRCNV_RULE
LANGUAGE_CDA=Active
I=Inactive
EO_CCR_LANG_VW(SQL View) |
Index Back |
|---|---|
CurrConv Rule Lang View |
| SELECT PROC_GRP_ID ,PROD_ID ,RULE_INSTNC_NBR ,LANGUAGE_CD ,DESCR ,DESCR50 ,CCR_STATUS ,DESCRLONG FROM PS_EO_CRCNVRL_LANG |
| # | 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_PROC_GROUP |
| 2 | PROD_ID |
Character(2) | VARCHAR2(2) NOT NULL |
This is an XLAT field listing all PeopleSoft 7.5 Product codes.
Prompt Table: EO_CURRCNV_RULE |
| 3 | RULE_INSTNC_NBR |
Number(3,0) | SMALLINT NOT NULL |
Rule Occurrence Number
Prompt Table: EO_CURRCNV_RULE |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | 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 |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |