VCHR_WTH_UPD_VW

(SQL View)
 Index Back

Voucher Withholding Update

Voucher Withholding Update

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.VOUCHER_LINE_NUM , C.WTHD_ENTITY , C.WTHD_TYPE , C.WTHD_JUR_CD , C.WTHD_CLASS , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.GROSS_AMT , A.TXN_CURRENCY_CD , B.MERCHANDISE_AMT , C.WTHD_RULE , C.WTHD_BASIS_AMT , C.WTHD_SW FROM PS_VOUCHER A , PS_VOUCHER_LINE B , PS_VCHR_LINE_WTHD C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND B.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM AND B.WTHD_SW = 'Y' AND A.ENTRY_STATUS <> 'X' AND A.POST_STATUS_AP = 'U' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE XREF.BUSINESS_UNIT = A.BUSINESS_UNIT AND XREF.VOUCHER_ID = A.VOUCHER_ID AND ((XREF.PYMNT_TYPE = 'W') OR (XREF.PYMNT_SELCT_STATUS <> 'N')))

# 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
5 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
6 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
7 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class

Prompt Table: VWTHD_CLASS_VW

8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PRIM_VW

10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
15 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
16 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099

Y/N Table Edit