AP Voucher Header Table

AP_DB_AMT_STS_V

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_STYLE , A.INVOICE_ID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.ORIGIN , A.OPRID , A.ENTRY_STATUS , CASE A.VCHR_DRAFT_FLG WHEN 'Y' THEN 'I' ELSE (CASE A.ENTRY_STATUS WHEN 'P' THEN (CASE A.POST_STATUS_AP WHEN 'P' THEN 'P' ELSE 'U' END) ELSE A.ENTRY_STATUS END) END , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.ENTERED_DT , ' ' , A.VENDOR_SETID FROM PS_VOUCHER A , PS_VENDOR B , PS_VCHR_REG_LC C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.VOUCHER_ID = A.VOUCHER_ID AND ((A.ENTRY_STATUS = 'R') OR (A.ENTRY_STATUS IN ('P','T') AND C.REG_CMPL_FLAG IN ('N', 'C', 'U', 'P')))

  • Related Language Record: AP_DB_AMTSTS_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_BUS_AP_NONVW

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

    Default Value: NEXT

    3 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
    4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VENDOR_SHRT_VW.VENDOR_ID

    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    8 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Default Value: OPR_DEF_TBL_AP.ORIGIN

    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_AP.OPRID

    10 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

    Default Value: O

    11 AP_DB_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
    I=Incomplete
    L=Reviewed through Maintenance
    M=Modified
    O=Open
    P=Posted
    R=Recycle
    S=Scheduled for Payment
    T=Template Voucher
    U=Unposted
    X=Deleted
    12 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    13 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

    Prompt Table: CURR_TXN_VW

    14 ENTERED_DT Date(10) DATE Entered on
    15 AP_DATE_OPTION Character(1) VARCHAR2(1) NOT NULL Date Option
    C=Current Date
    E=Ending Date
    16 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID