RVL_AP_TMPW

(SQL Table)
Index Back

Temp Table for Revaluation

cmh Bug 17339078 used in Revaualtion Options : BU & Supplier

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
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_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
13 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
14 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
15 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
16 WTHD_PYMNT_CNT Number(5,0) INTEGER NOT NULL Wthd Payment Count

Default Value: 0

17 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
18 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
19 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
20 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
21 RVL_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Amount
22 RVL_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Discount Amount
23 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number