UPDT_BU_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 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
3 NEW_WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withhold class
4 NEW_WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL New Withhold Type
5 NEW_WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL New Withholding Jurisdiction
6 NEW_WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding applicable flag
N=No
Y=Yes
7 CURRENT_WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding applicable flag
8 NEW_BU_CATEGORY Character(5) VARCHAR2(5) NOT NULL New business unit category based on the new withholding class
9 NEW_VNDR_CATEGORY Character(5) VARCHAR2(5) NOT NULL New vendor category based on the new class
10 NEW_WTHD_RULE Character(5) VARCHAR2(5) NOT NULL New withholding rule associated with the new withhold class
11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
13 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
14 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
15 BU_REGIST_ID Character(20) VARCHAR2(20) NOT NULL BU Tax Identification Number
16 VNDR_REGIST_ID Character(20) VARCHAR2(20) NOT NULL Supplier Tax ID
17 ENT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Entity Currency Code
18 ENT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Rate Type for Wthd Entity
19 START_DATE Date(10) DATE Start Date for Gen Standing PO
20 END_DATE Date(10) DATE End Date