UPDT_VCHR_TMP

(SQL Table)
Index Back

Vchr line wthd updates

Information required for voucher line withholding update process

# 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 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
4 NEW_WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withhold class
5 NEW_WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL New Withhold Type
6 NEW_WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL New Withholding Jurisdiction
7 NEW_WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding applicable flag
N=No
Y=Yes
8 CURRENT_WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding applicable flag
9 NEW_BU_CATEGORY Character(5) VARCHAR2(5) NOT NULL New business unit category based on the new withholding class
10 NEW_VNDR_CATEGORY Character(5) VARCHAR2(5) NOT NULL New vendor category based on the new class
11 NEW_WTHD_RULE Character(5) VARCHAR2(5) NOT NULL New withholding rule associated with the new withhold class
12 CREATE_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Create Withholding Payment
13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
16 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
17 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
18 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
20 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. "
21 ENT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Entity Currency Code
22 ENT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Rate Type for Wthd Entity
23 ENT_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL TE Rate Multiplier
24 ENT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL TE Rate Divisor
25 BU_REGIST_ID Character(20) VARCHAR2(20) NOT NULL BU Tax Identification Number
26 VNDR_REGIST_ID Character(20) VARCHAR2(20) NOT NULL Supplier Tax ID
27 START_DATE Date(10) DATE Start Date for Gen Standing PO
28 END_DATE Date(10) DATE End Date