HPYP_RATE_AET

(SQL Table)
Index Back

State record for market rate

State record for market rate

# 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).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 HPYP_REQUEST_DT Date(10) DATE Market rates Request Date
5 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

6 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
7 FROM_CUR_1 Character(3) VARCHAR2(3) NOT NULL From Currency

Prompt Table: CURRENCY_CD_TBL

8 FROM_CUR_2 Character(3) VARCHAR2(3) NOT NULL From Currency

Prompt Table: CURRENCY_CD_TBL

9 TO_CUR_1 Character(3) VARCHAR2(3) NOT NULL To Currency

Prompt Table: CURRENCY_CD_TBL

10 TO_CUR_2 Character(3) VARCHAR2(3) NOT NULL To Currency

Prompt Table: CURRENCY_CD_TBL