EO_RATECALC_AET(SQL Table) | 
Index Back | 
|---|---|
EO Generate Rate RequestEO Generate Rate Request | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | 
A user's ID (see PSOPRDEFN).
 Prompt Table: OPRID_VW  | 
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | 
| 4 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | 
Market Rate Index
 Default Value: MODEL Prompt Table: RT_INDEX_TBL  | 
| 5 | TERM | Number(5,0) | INTEGER NOT NULL | 
Term
 Default Value: 0  | 
| 6 | FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | 
From Currency
 Prompt Table: CURRENCY_CD_TBL  | 
| 7 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | 
Currency Rate Type
 Prompt Table: RT_TYPE_TBL  | 
| 8 | AS_OF_DATE | Date(10) | DATE NOT NULL | 
As of Date
 Default Value: %DATE  | 
| 9 | OVERRIDE_CUR_RT | Character(1) | VARCHAR2(1) NOT NULL | 
Override Existing Rates
 Y/N Table Edit Default Value: N  | 
| 10 | GENERATE_REPORT | Character(1) | VARCHAR2(1) NOT NULL | 
Generate Report
 Y/N Table Edit Default Value: Y  | 
| 11 | GENERATE_RECIP | Character(1) | VARCHAR2(1) NOT NULL | 
Generate Reciprocal Rate
 Y/N Table Edit Default Value: Y  | 
| 12 | GENERATE_CROSS_RT | Character(1) | VARCHAR2(1) NOT NULL | 
Generate Cross Rates
 Y/N Table Edit Default Value: N  | 
| 13 | RATE_TRIANGULATE | Character(1) | VARCHAR2(1) NOT NULL | 
Rate Triangulate
 Y/N Table Edit Default Value: N  | 
| 14 | QUOTE_METHOD_REQ | Character(1) | VARCHAR2(1) NOT NULL | 
Quote Method Required
 Y/N Table Edit Default Value: Y  | 
| 15 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | 
From Currency Code
 Prompt Table: CURRENCY_CD_TBL  | 
| 16 | TO_CUR | Character(3) | VARCHAR2(3) NOT NULL | 
To Currency Code
 Prompt Table: CURRENCY_CD_TBL  | 
| 17 | RUNLOCATION | Character(1) | VARCHAR2(1) NOT NULL | 
Run Location
 0=Both 1=Client 2=Server  | 
| 18 | SERVERNAMERQST | Character(8) | VARCHAR2(8) NOT NULL | Server Name Request |