NET_XREF_VW

(SQL View)
 Index Back

Netting XREF View


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID ,A.PYMNT_CNT ,B.VENDOR_ID ,A.PYMNT_ID ,A.PYMNT_TYPE ,A.PAID_AMT ,A.SCHEDULED_PAY_DT ,A.TXN_CURRENCY_CD FROM PS_PYMNT_VCHR_XREF A , PS_VOUCHER B , PS_VOUCHER_LINE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND (B.VCHR_APPRVL_FLG = 'P' OR B.APPR_STATUS='A') AND A.PYMNT_HOLD IN ('N', ' ') AND A.PYMNT_SELCT_STATUS = 'N' AND A.NET_SELCT_STATUS = 'H' AND C.WTHD_SW IN ('N', ' ')

  • Parent record: VOUCHER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Default Value: NEXT

    3 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

    Default Value: 1

    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    6 PYMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Document Type
    E=Express Payment
    M=Manual Payment
    R=Regular payment
    W=Withholding Payment
    Z=Zero Payment Check
    7 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    8 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    9 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency