AP_WC_WB_VW

(SQL View)
 Index Back

Match Workbench for WorkCenter

Used to retrieve summary information of vouchers that require matching in AP WorkCenter.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.GRP_AP_ID , A.ORIGIN , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.VENDOR_NAME_SHORT , A.INVOICE_ID , A.INVOICE_DT , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.DUE_DT , A.DSCNT_DUE_DT , A.DSCNT_AMT , A.POST_STATUS_AP , A.CLOSE_STATUS , A.BUDGET_HDR_STATUS , A.MATCH_STATUS_VCHR , A.ACCOUNTING_DT , A.APPR_STATUS , A.DOC_TOL_HDR_STATUS , A.ENTERED_DT , A.ENTRY_STATUS , A.LC_EXTRCT_STATUS , A.MATCH_ACTION , A.PROCESS_INSTANCE , A.VOUCHER_STYLE , A.MATCH_DUE_DT , A.OPRID , A.VCHR_SRC , A.AP_MATCH_TYPE , A.OPRID_LAST_UPDT , A.PACKSLIP_NO , B.OFAC_STATUS FROM PS_VOUCHER A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.MATCH_ACTION = 'Y' AND A.ENTRY_STATUS ='P' AND A.CLOSE_STATUS <> 'C' AND A.IN_PROCESS_FLG = 'N'

  • Related Language Record: AP_WC_WB_LVW

    • # 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 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    4 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    10 INVOICE_DT Date(10) DATE Invoice Date
    11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    13 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    14 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    15 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
    16 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted
    17 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
    C=Closed
    O=Open
    18 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
    19 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
    20 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    21 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
    22 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
    E=Error
    N=Not Checked
    R=Reset
    V=Valid
    23 ENTERED_DT Date(10) DATE Entered on
    24 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
    25 LC_EXTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Landed Cost Extract Status
    26 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
    N=No Match
    Y=Standard
    27 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    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 MATCH_DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    30 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    31 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
    32 AP_MATCH_TYPE Character(1) VARCHAR2(1) NOT NULL Match Type
    C=Matched with Credit Note
    D=Matched with Debit Memo
    O=Matched with Override
    P=Auto - Matched
    33 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    34 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
    35 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
    B=Blocked
    C=Cleared
    R=Review
    V=Valid