EM_VN_VCHR_WTHD

(SQL View)
Index Back

voucher withhold

Voucher with withholdings

SELECT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , INVOICE_DT , A.GROSS_AMT , A.GROSS_AMT_BSE , A.TXN_CURRENCY_CD , 0 , 0 , 0 , 0 , 0 FROM PS_VOUCHER A WHERE EXISTS ( SELECT 'X' FROM PS_EM_1099_WTHD_VW B WHERE A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
6 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
7 INVOICE_DT Date(10) DATE Invoice Date
8 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
9 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
11 WTHD_AMT_TYPE_G Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Amount Goverment
12 WTHD_AMT_TYPE_I Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Amount Interest
13 WTHD_AMT_TYPE_M Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Amount Misc
14 WTHD_BASIS_AMT1 Signed Number(33,3) DECIMAL(31,3) NOT NULL WTHD_BASIS_AMT1
15 AMT_DIFF Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount1