PRCR_DS_VCHR_VW

(SQL View)
 Index Back

Vchr Search Rec for DocStatus

Used by Document Status Inquiry as the Voucher search record.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.VENDOR_NAME_SHORT , A.APPR_STATUS , A.BUDGET_HDR_STATUS , A.BUDGET_MISC_STATUS , A.DOC_TOL_HDR_STATUS , A.MATCH_STATUS_VCHR , A.AP_MATCH_TYPE , A.POST_STATUS_AP FROM PS_VOUCHER A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ENTRY_STATUS <> 'X'

  • Related Language Record: PRCR_DS_VCHR_LV

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

    Prompt Table: INVOICE_ID_VW2

    4 INVOICE_DT Date(10) DATE Invoice Date
    5 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    6 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Default Value: VENDOR.SETID

    8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_ACTIVE_VW

    9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    10 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

    Prompt Table: VENDOR_SHRT_VW

    11 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
    12 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
    13 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
    14 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
    E=Error
    N=Not Checked
    R=Reset
    V=Valid
    15 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
    16 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
    17 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted