WTHD_MISMCH2_VW

(SQL View)
 Index Back

SELECT DISTINCT VCHR.BUSINESS_UNIT , VCHR.VENDOR_SETID , VNDR.VENDOR_ID , VNDR.NAME1 , VCHR.VNDR_LOC , VCHR.VOUCHER_ID , LINE.VOUCHER_LINE_NUM , VCHR.INVOICE_ID , VCHR.INVOICE_DT , VCHR.ACCOUNTING_DT , VCHR.GROSS_AMT , LINE.MERCHANDISE_AMT , LINE.WTHD_SW FROM PS_VENDOR VNDR , PS_VOUCHER VCHR , PS_VOUCHER_LINE LINE WHERE VNDR.SETID = VCHR.VENDOR_SETID AND VNDR.VENDOR_ID = VCHR.VENDOR_ID AND VCHR.BUSINESS_UNIT = LINE.BUSINESS_UNIT AND VCHR.VOUCHER_ID = LINE.VOUCHER_ID AND LINE.MERCHANDISE_AMT <> 0 AND VCHR.ENTRY_STATUS <> 'X' AND VNDR.WTHD_SW <> LINE.WTHD_SW AND VCHR.PROCESS_MAN_CLOSE = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE XREF.BUSINESS_UNIT = VCHR.BUSINESS_UNIT AND XREF.VOUCHER_ID = VCHR.VOUCHER_ID AND XREF.PYMNT_SELCT_STATUS = 'P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
8 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
9 INVOICE_DT Date(10) DATE Invoice Date
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
12 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
13 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099