EO_RATECALC_AET

(SQL Table)
Index Back

EO Generate Rate Request

EO Generate Rate Request

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE 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