PYMNT_VCHR_VW4

(SQL View)
 Index Back

Voucher Scheduled Payment View


SELECT a.business_unit ,a.voucher_id ,a.pymnt_cnt ,a.pymnt_gross_amt ,a.dscnt_pay_amt ,a.pymnt_selct_status ,a.bank_setid ,a.bank_cd ,a.bank_acct_key ,C.VENDOR_SETID ,C.VENDOR_ID ,a.remit_setid ,a.remit_vendor ,a.pymnt_type ,A.PREPAID_STATUS ,B.VENDOR_NAME_SHORT ,a.TXN_CURRENCY_CD , a.paid_amt , a.currency_pymnt , a.vndr_loc , a.rate_mult , a.rate_div , a.cur_rt_type_pymnt , a.cur_rt_type_paid , a.pymnt_handling_cd , c.invoice_id , c.invoice_dt , c.voucher_style , c.APPR_STATUS , c.BUDGET_HDR_STATUS , c.entry_status , c.DOC_TOL_HDR_STATUS , c.PROCESS_MAN_CLOSE , c.grp_ap_id , c.MATCH_STATUS_VCHR , c.UNMTCH_PAY_FLG , c.VCHR_SRC , c.PREPAID_REF FROM ps_pymnt_vchr_xref a , PS_VENDOR B , PS_VOUCHER C , %Table(vendor_pay) v WHERE A.REMIT_SETID = B.SETID AND A.REMIT_VENDOR = B.VENDOR_ID AND a.business_unit = c.business_unit AND a.voucher_id = c.voucher_id AND v.setid = a.remit_setid AND v.vendor_id = a.remit_vendor AND v.vndr_loc = a.vndr_loc AND v.seq_num = 1 AND v.eff_status = 'A' AND %EffdtCheck(vendor_pay v1, v, %CurrentDateIn) AND (v.pymnt_hold = 'N' Or v.pymnt_hold = 'Y') AND c.voucher_style <> 'PPAY' AND a.prepaid_status = 'U' AND a.pymnt_hold = 'N' AND a.pymnt_hold_wthd = 'N' AND a.pymnt_selct_status = 'N' AND a.prepaid_status = 'U' AND a.net_selct_status = 'N' AND a.pymnt_action = 'S' AND ((A.pymnt_gross_amt > 0 AND C.VCHR_SRC <> 'PROC') OR (C.VCHR_SRC = 'PROC')) AND NOT EXISTS ( SELECT 'x' FROM ps_int_unit_pmt_vw d WHERE a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND a.pymnt_cnt = d.pymnt_cnt)

  • Parent record: VOUCHER

    • # 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 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
    4 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    5 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
    6 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
    C=Closed
    D=Negative Voucher Sum
    E=Externally Paid
    F=Federal Sanctions Error
    I=In Process - EFT
    N=Not Selected for Payment
    O=Financial Sanctions Review
    P=Paid
    R=Requested for Payment
    S=Settlement Payment
    V=Convert Error
    X=Canceled
    Y=Prepaid
    7 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    8 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    9 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    12 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    13 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    14 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
    15 PREPAID_STATUS Character(1) VARCHAR2(1) NOT NULL Prepaid Status
    A=Applied
    B=Pending Application
    C=Pending Unapply
    D=Pending Change
    F=Fully Applied
    I=Inactive
    P=Available Prepayment
    R=Restricted
    U=Unapplied
    X=Cancelled
    16 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    17 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    18 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    19 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    20 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    21 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    22 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    23 CUR_RT_TYPE_PYMNT Character(5) VARCHAR2(5) NOT NULL Payment Currency Rate Type
    24 CUR_RT_TYPE_PAID Character(5) VARCHAR2(5) NOT NULL Payment Rate Type
    25 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
    26 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    27 INVOICE_DT Date(10) DATE Invoice Date
    28 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
    ADJ=Adjustments
    AMR=Amortization Voucher
    CLBK=Claim Voucher
    CORR=Reversal Voucher
    JRNL=Journal Voucher
    PPAY=Prepaid Voucher
    REG=Regular Voucher
    RGTR=Register Voucher
    SGLP=Single Payment Voucher
    THRD=Third Party Voucher
    TMPL=Template Voucher
    29 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
    A=Approved
    D=Denied
    P=Pending
    30 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid
    31 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
    C=Complete
    D=Through batch defaults
    E=Edited by Batch Voucher Module
    L=Reviewed through Maintenance
    M=Modified
    O=Open
    P=Postable
    R=Recycle
    S=Scheduled for Payment
    T=Template Voucher
    X=Deleted
    32 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
    E=Error
    N=Not Checked
    R=Reset
    V=Valid
    33 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
    N=No
    P=Processed
    Y=Yes
    34 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    35 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
    C=Overridden - Credit Note
    D=Match Dispute
    E=Match Exceptions Exist
    M=Matched
    N=Not Applicable
    O=Manually Overridden
    T=To Be Matched
    36 UNMTCH_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Pay UnMatched Voucher
    37 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
    38 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference