APOP_VCHRDAP_VW

(SQL View)
Index Back

Voucher Approval Detail VW

Voucher Approval Detail VW

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.ENTERED_DT , A.SUBMIT_DT , A.APPROVAL_DATE , A.AP_DAYSBETWEEN , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.VENDOR_SETID , A.VENDOR_ID , V.VENDOR_NAME_SHORT , A.OPRID , OP.OPRDEFNDESC , A.BUSINESS_UNIT_PO , A.PO_ID , A.ACCOUNTING_DT , A.DISPLAY_ORDER , A.VCHR_SRC , A.VOUCHER_STYLE , A.ENTRY_STATUS , A.ORIGIN FROM %Table(APOD_APPCSUM_MV) A , %Table(VENDOR) V , %Table(OPRID_VW) OP WHERE V.SETID = A.VENDOR_SETID AND V.VENDOR_ID = A.VENDOR_ID AND OP.OPRID = A.OPRID

  • Related Language Record: APOP_VCHRDAPLVW
  • # 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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    4 INVOICE_DT Date(10) DATE Invoice Date
    5 ENTERED_DT Date(10) DATE Entered on
    6 SUBMIT_DT Date(10) DATE Date Submitted
    7 APPROVAL_DATE Date(10) DATE Approval Date
    8 AP_DAYSBETWEEN Number(12,0) DECIMAL(12) NOT NULL Used to keep the difference between 2 dates.
    9 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    13 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    15 AP_OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    16 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    18 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    19 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    20 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
    21 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
    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 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin