EO_CRCNVRL_LANG(SQL Table) |
Index Back |
---|---|
Currency Conversion Rule 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 Default Value: A |
8 | DESCRLONG | Long Character | CLOB | Long Description |