VCHR_LN_WTHD_VW

(SQL View)
 Index Back

Voucher Line Withhold Record


SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.WTHD_ENTITY , A.WTHD_TYPE , A.WTHD_JUR_CD , A.WTHD_CLASS , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , D.PYMNT_DT FROM PS_VCHR_LINE_WTHD A , PS_VOUCHER B , PS_PYMNT_VCHR_XREF C , PS_PAYMENT_TBL D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.ENTRY_STATUS <> 'X' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND C.BANK_SETID = D.BANK_SETID AND C.BANK_CD = D.BANK_CD AND C.BANK_ACCT_KEY = D.BANK_ACCT_KEY AND C.PYMNT_ID = D.PYMNT_ID

  • Parent record: VOUCHER_LINE

    • # 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
    8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    11 PYMNT_DT Date(10) DATE Payment Date