VCHR_SRCHLG1_VW

(SQL View)
 Index Back

Voucher Search View

View of voucher table for inquiry type and simple update purposes. No peoplecode attached.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , D.LANGUAGE_CD , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.VOUCHER_STYLE , A.ACCOUNTING_DT , A.DUE_DT , A.ENTERED_DT , A.VNDR_LOC , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.APPR_STATUS , A.MATCH_STATUS_VCHR , A.VCHR_BAL_ERR_FLG , A.DUP_INVOICE_STATUS , A.ERROR_FLAG , A.ENTRY_STATUS , A.COMBO_ERROR_FLG , A.GRP_AP_ID , A.ORIGIN , A.PROCESS_INSTANCE , A.OPRID FROM PS_VOUCHER A , PS_VENDOR B , PS_VENDOR_LANG D WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ENTRY_STATUS IN ('O','P','R', 'L') AND A.VOUCHER_STYLE NOT IN ('THRD', 'TMPL') AND (A.VCHR_SRC <> 'PROC' OR A.VAT_ENTITY = ' ') AND A.POST_STATUS_AP <> 'P' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE XREF.BUSINESS_UNIT = A.BUSINESS_UNIT AND XREF.VOUCHER_ID = A.VOUCHER_ID AND XREF.PYMNT_SELCT_STATUS <> 'N' AND XREF.PYMNT_SELCT_STATUS <> 'X') AND NOT EXISTS( SELECT 'X' FROM PS_GRP_AP G WHERE G.BUSINESS_UNIT = A.BUSINESS_UNIT AND G.GRP_AP_ID = A.GRP_AP_ID AND G.PROCESS_INSTANCE = 0 AND G.GRP_AP_STATUS NOT IN ('R', 'A')) AND NOT EXISTS( SELECT 'X' FROM PS_VCHR_REG_LC C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.VOUCHER_ID = A.VOUCHER_ID AND C.REG_CMPL_FLAG = 'N') AND D.SETID = B.SETID AND D.VENDOR_ID = B.VENDOR_ID

  • Related Language Record for VCHR_SRCHCRT_VW

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

    Prompt Table: SP_BU_AP_NONVW

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

    Prompt Table: VOUCHER

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    5 INVOICE_DT Date(10) DATE NOT NULL Invoice Date
    6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PRIM_VW

    8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    10 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
    11 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    12 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.
    13 ENTERED_DT Date(10) DATE Entered on
    14 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_LOC_AP_VW

    15 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    16 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

    Prompt Table: CURR_TXN_VW

    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 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

    Default Value: N

    19 VCHR_BAL_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Balance Error

    Y/N Table Edit

    Default Value: N

    20 DUP_INVOICE_STATUS Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Status

    Y/N Table Edit

    Default Value: N

    21 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

    Y/N Table Edit

    Default Value: N

    22 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
    23 COMBO_ERROR_FLG Character(1) VARCHAR2(1) NOT NULL Vouchers with Combo Errors
    24 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    25 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    27 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).