PROC_GRP_IDA=Any Date
C=Current Date Only
F=Current and Future
P=Current and Past
Default Value: C
Y/N Table Edit
Default Value: N
EO_PROC_GROUP(SQL Table) |
Index Back |
|---|---|
Conversion Process Group |
| # | 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 |
| 2 | PROC_GRP_NAME | Character(20) | VARCHAR2(20) NOT NULL | Process Group Name |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | DATES_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL |
As Of Dates Allowed
A=Any Date C=Current Date Only F=Current and Future P=Current and Past Default Value: C |
| 6 | SINGLE_CURR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used in the Currency Conversion Utility. This should be checked on process groups containing records with currency code as a key, where the currency code is being converted. This flag will be looked at when a run control is being entered. If it is on, you will only be allowed to enter one "from" currency on the run control.
Y/N Table Edit Default Value: N |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |