AP_WC_APAM_VW

(SQL View)
 Index Back

Vchr Prompt for AP/AM Interfc


SELECT B.BUSINESS_UNIT , B.VOUCHER_ID , B.VENDOR_SETID , B.VENDOR_ID , C.VENDOR_NAME_SHORT , C.NAME1 , B.INVOICE_ID , B.INVOICE_DT , B.ORIGIN , B.GRP_AP_ID , B.OPRID , B.OPRID_LAST_UPDT , B.ENTERED_DT FROM PS_VOUCHER B , PS_VENDOR C WHERE B.VENDOR_SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND ((B.MATCH_ACTION='N') OR (B.MATCH_ACTION='Y' AND B.MATCH_STATUS_VCHR IN ('M','O')) OR (B.MATCH_ACTION = 'Y' AND B.MATCH_STATUS_VCHR = 'T' AND B.CLOSE_STATUS = 'C')) AND EXISTS ( SELECT 'X' FROM PS_VCHR_ACCTG_LINE A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.ASSET_FLG = 'Y' AND A.AM_DISTRIB_STATUS IN ('M', 'N'))

  • Related Language Record: AP_WC_APAM_LVW

    • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    8 INVOICE_DT Date(10) DATE Invoice Date
    9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    10 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    12 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    13 ENTERED_DT Date(10) DATE Entered on