Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

SQL query of AP230

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
maharuchi
Advanced Member
Posts: 28
Advanced Member
1/13/2016 6:59 PM
    Can anybody share with me SQL query of AP230 ?

    Thanks a lot
    klemmyjb
    Basic Member
    Posts: 14
    Basic Member
    1/14/2016 6:37 PM
      do you look at APINVOICE select * from APINVOICE
      klemmyjb
      Basic Member
      Posts: 14
      Basic Member
      1/14/2016 6: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