RVL_AP_TMP1

(SQL Table)
Index Back

Temp Table for Revaluation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
8 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
9 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
10 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
12 WTHD_PYMNT_CNT Number(5,0) INTEGER NOT NULL Wthd Payment Count

Default Value: 0

13 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
14 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
15 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
16 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
17 RVL_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Amount
18 RVL_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Discount Amount