MARKET_RT_RNCTL

(SQL Table)
Index Back

Import Market Rt Run Control

Import Market Rate Run Control record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_DT Date(10) DATE NOT NULL Request Date

Default Value: %date

4 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

5 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

Default Value: MODEL

Prompt Table: RT_INDEX_TBL

6 FROM_CUR_1 Character(3) VARCHAR2(3) NOT NULL From Currency

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

10 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

Prompt Table: PSMSGNODEDEFN