SQL query of AP230

Sort:
You are not authorized to post a reply.
Author
Messages
maharuchi
Advanced Member
Posts: 28
Advanced Member
    Can anybody share with me SQL query of AP230 ?

    Thanks a lot
    klemmyjb
    Basic Member
    Posts: 12
    Basic Member
      do you look at APINVOICE select * from APINVOICE
      klemmyjb
      Basic Member
      Posts: 12
      Basic Member
        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.