RVL_RQST_AR

(SQL Table)
Index Back

AR Revaluation Request

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple

Default Value: %date

5 ASOF_DT Date(10) DATE NOT NULL As of Date

Default Value: %date

6 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

7 ENTRY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency associated with the monetary amount of a pending item.

Prompt Table: RVL_CURRENCY_VW

8 RVL_TEST_FLG Character(1) VARCHAR2(1) NOT NULL Check Only
9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: AR_ACCT_CNTL_VW