PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/14/2016 1:41 PM by  klemmyjb
SQL query of AP230
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
maharuchi
Advanced Member
(52 points)
Advanced Member
Posts:28


Send Message:

--
01/13/2016 1:59 PM
    Can anybody share with me SQL query of AP230 ?

    Thanks a lot
    klemmyjb
    Systems Specialist II
    Private
    Basic Member
    (36 points)
    Basic Member
    Posts:12


    Send Message:

    --
    01/14/2016 1:37 PM
    do you look at APINVOICE select * from APINVOICE
    klemmyjb
    Systems Specialist II
    Private
    Basic Member
    (36 points)
    Basic Member
    Posts:12


    Send Message:

    --
    01/14/2016 1:41 PM
    SELECT
    APINVOICE.COMPANY,
    APINVOICE.VENDOR,
    APINVOICE.INVOICE,
    APINVOICE.CANCEL_DATE,
    APINVOICE.INVOICE_TYPE,
    APINVOICE.PAY_CURRENCY,
    APINVOICE.INVOICE_DTE,
    APINVOICE.CHARGEBACK_FL,
    APINVOICE.BASE_INV_AMT,
    APINVOICE.BASE_ACT_AMT,
    APINVOICE.BASE_TOT_PMT,
    APINVOICE.TRAN_TOT_PMT,
    APINVOICE.BASE_TOT_DIST,
    APINVOICE.TRAN_TOT_DIST,
    APINVOICE.REC_STATUS,
    APINVOICE.CREATE_DATE,
    APINVOICE.CREATION_TIME,
    APINVOICE.INVOICE_GROUP,
    APINVOICE.HANDLING_CODE
    FROM APINVOICE
    You are not authorized to post a reply.