PYMNT_VCHR_VW5

(SQL View)
 Index Back

Voucher Scheduled Payment View


SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VENDOR_SETID , A.VENDOR_ID , B.REMIT_SETID , B.REMIT_VENDOR , A.VOUCHER_STYLE , A.INVOICE_ID , A.GROSS_AMT , A.ENTRY_STATUS , A.POST_STATUS_AP , A.INVOICE_DT , A.TXN_CURRENCY_CD , A.BUDGET_HDR_STATUS , A.APPR_STATUS , A.GRP_AP_ID , A.DOC_TOL_HDR_STATUS , A.MATCH_STATUS_VCHR , A.UNMTCH_PAY_FLG , A.PREPAID_REF , A.PROCESS_MAN_CLOSE FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID

  • 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    6 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    7 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
    8 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    9 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    10 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
    11 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted
    12 INVOICE_DT Date(10) DATE Invoice Date
    13 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    14 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
    15 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
    16 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    17 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
    E=Error
    N=Not Checked
    R=Reset
    V=Valid
    18 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
    19 UNMTCH_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Pay UnMatched Voucher
    20 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference
    21 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
    N=No
    P=Processed
    Y=Yes