VCHR_SRCH_VW

(SQL View)
Index Back

Voucher Search Component

Voucher Search Component scroll data

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VOUCHER_STYLE , A.VOUCHER_ID_RELATED , A.ENTRY_STATUS , A.VCHR_DRAFT_FLG , A.VCHR_SRC , A.INVOICE_DT , A.GROSS_AMT , A.PAY_AMT , A.TXN_CURRENCY_CD , A.VNDR_LOC , B.VENDOR_NAME_SHORT , B.NAME1 , B.VENDOR_CLASS FROM PS_VOUCHER A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

  • Related Language Record: VCH_SRCH_LG2_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_OPRVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PRIM_VW

    6 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
    7 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
    8 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
    9 VCHR_DRAFT_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Draft Flag
    N=Complete Voucher
    Y=Incomplete Voucher

    Y/N Table Edit

    Default Value: N

    10 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
    11 INVOICE_DT Date(10) DATE Invoice Date
    12 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    13 PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
    14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    16 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    17 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    18 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
    A=Attorney
    E=Employee
    H=HCM
    R=Outside Party