EM_1099_WTHD_VW

(SQL View)
 Index Back

Payment Voucher Withhold

Payment Voucher Withhold by supplier, voucher

SELECT B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , C.BUSINESS_UNIT , C.VOUCHER_ID , B.WTHD_ENTITY , B.WTHD_TYPE , B.WTHD_JUR_CD , B.WTHD_CLASS , E.DESCR , B.WTHD_RULE , D.WTHD_BASIS_AMT , D.TXN_CURRENCY_CD , D.WTHD_AMT , B.POST_DT , B.PROCESS_INSTANCE , B.BANK_SETID , B.BANK_CD , B.PYMNT_ID , D.WTHD_DECL_DATE FROM PS_WTHD_TRXN_TBL B , PS_PYMNT_VCHR_XREF C , PS_PYMNT_VCHR_WTHD D , PS_WTHD_CD_HDR E WHERE B.VENDOR_SETID = C.REMIT_SETID AND B.VENDOR_ID = C.REMIT_VENDOR AND B.VNDR_LOC = C.VNDR_LOC AND B.BANK_SETID = C.BANK_SETID AND B.BANK_CD = C.BANK_CD AND B.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND B.PYMNT_ID = C.PYMNT_ID AND B.WTHD_ENTITY = 'IRS' AND B.WTHD_TYPE LIKE '1099' AND B.WTHD_JUR_CD = 'FED' AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.VOUCHER_ID = D.VOUCHER_ID AND C.PYMNT_CNT = D.PYMNT_CNT AND B.WTHD_ENTITY = D.WTHD_ENTITY AND B.WTHD_TYPE = D.WTHD_TYPE AND B.WTHD_JUR_CD = D.WTHD_JUR_CD AND B.WTHD_CLASS = D.WTHD_CLASS AND B.WTHD_RULE = D.WTHD_RULE AND B.VENDOR_SETID = E.SETID AND B.WTHD_CLASS = E.WTHD_CD

  • Parent record: PYMNT_VCHR_XREF

    • # 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 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
    7 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
    8 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
    9 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
    12 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
    13 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    14 WTHD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Amount
    15 POST_DT Date(10) DATE The Date a transaction was Posted.
    16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    17 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    18 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    19 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    20 WTHD_DECL_DATE Date(10) DATE withholding declaration date