AP_WC_VCHUNP_VW

(SQL View)
 Index Back

AP Workcenter Unpaid Vouchers

AP Workcenter Unpaid Vouchers

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.PYMNT_CNT , A.INVOICE_ID , B.REMIT_SETID , B.REMIT_VENDOR , B.REMIT_SETID , B.REMIT_VENDOR , ' ' , ' ' , B.SCHEDULED_PAY_DT , B.PYMNT_GROSS_AMT , B.CURRENCY_PYMNT , A.ENTRY_STATUS , A.POST_STATUS_AP , B.PYMNT_SELCT_STATUS , A.APPR_STATUS , ' ' , A.DOC_TOL_HDR_STATUS , A.BUDGET_HDR_STATUS , A.BUDGET_MISC_STATUS , A.MATCH_STATUS_VCHR , A.VCHR_DRAFT_FLG , B.VNDR_LOC , B.REMIT_ADDR_SEQ_NUM , B.BANK_SETID , B.BANK_CD , B.BANK_ACCT_KEY , B.PYMNT_METHOD , A.OPRID , A.OPRID_LAST_UPDT , A.ORIGIN , A.VOUCHER_STYLE , A.VCHR_SRC , A.ENTERED_DT , ' ' , ' ' , A.BUSINESS_UNIT_GL FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.ENTRY_STATUS <> 'X' AND B.PYMNT_SELCT_STATUS IN ('F','N','O')

  • Related Language Record: AP_WC_VCHUNP_LV

    • # 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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    7 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    8 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    9 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    11 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    12 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    13 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    14 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
    15 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted
    16 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
    17 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
    18 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
    B=Blocked
    C=Cleared
    R=Review
    V=Valid
    19 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
    E=Error
    N=Not Checked
    R=Reset
    V=Valid
    20 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
    21 BUDGET_MISC_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Misc Status
    E=Error in Budget Check
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid Budget Check
    22 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
    23 VCHR_DRAFT_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Draft Flag
    N=Complete Voucher
    Y=Incomplete Voucher
    24 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    25 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
    26 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    27 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    28 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
    29 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer
    30 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    31 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    32 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    33 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
    34 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
    35 ENTERED_DT Date(10) DATE Entered on
    36 COMMITMENT_CNTL Character(1) VARCHAR2(1) NOT NULL Enable Commitment Control
    37 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
    N=Not Selected
    Y=Seleted

    Y/N Table Edit

    38 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit