VOUCHER_WTHD_VW

(SQL View)
 Index Back

Voucher Line Withhold Record


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.WTHD_ENTITY , A.WTHD_TYPE , A.WTHD_JUR_CD , A.WTHD_CLASS , SUM(B.MERCHANDISE_AMT) FROM PS_VCHR_LINE_WTHD A , PS_VOUCHER_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM GROUP BY A.BUSINESS_UNIT, A.VOUCHER_ID, A.WTHD_ENTITY, A.WTHD_TYPE, A.WTHD_JUR_CD, A.WTHD_CLASS

  • 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 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

    Prompt Table: VWTHD_ENTITY_VW

    4 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type

    Prompt Table: VWTHD_TYPE_VW

    5 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction

    Prompt Table: VWTHD_JUR_VW

    6 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class

    Prompt Table: VWTHD_CLASS_VW

    7 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount