RVL_AP_CALC

(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 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
6 WTHD_PYMNT_CNT Number(5,0) INTEGER NOT NULL Wthd Payment Count

Default Value: 0

7 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
10 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
12 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.
13 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. "
14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
15 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
16 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
17 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
18 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
19 RVL_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Amount
20 RVL_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Discount Amount