Prev
Next
Forums Financial Management Lawson S3 Financials

SQL Tables for AC90.1 form

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
mxg119
Basic Member
Posts: 8
Basic Member
12/18/2009 2:43 PM

    I want to create a sql dataset based on the results from the AC90.1 Activity Anyalysis form. Can someone tell me what database tables are used for this?

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    12/18/2009 7:24 PM
      According to dbdoc, and apptxt:

      AP90.1 - Invoice Search by Vendor, Invoice

      Use Invoice Search by Vendor, Invoice (AP90.1) to view invoice information for a vendor. **More Information To define optional criteria used to select invoices for display, choose the Filter button to open the Selection Criteria subform. An asterisk displays next to the button if the filter is enabled. To select an invoice for transfer to another form, select the "X" (Select) line action and transfer to another form.

      Updated Files

      APAPPROVAL - No Description Available.
      APAUDIT - No Description Available.
      APCOMMENTS - No Description Available.
      APCONTACT - No Description Available.
      APCPYVND - No Description Available.
      APHLDINV - No Description Available.
      APVENADDR - No Description Available.
      APVENBAL - No Description Available.
      APVENCERT - No Description Available.
      APVENGROUP - No Description Available.
      APVENLOC - No Description Available.
      APVENMAST - No Description Available.
      APVENPAY - No Description Available.
      CBBANKINST - No Description Available.
      CBCASHCODE - No Description Available.
      CUSTDESC - No Description Available.
      MXLISTHDR - No Description Available.
      MXLISTMBR - No Description Available.
      POVENDLOC - No Description Available.
      POVENDOR - No Description Available.
      TXCODEMAST - No Description Available.
      TXCOMPANY - No Description Available.
      TXTAXCODE - No Description Available.
      TXTAXTABLE - No Description Available.



      Referenced Files

      APACCRCODE - No Description Available.
      APAPPROVAL - No Description Available.
      APAUTHOR - No Description Available.
      APCOMMENTS - No Description Available.
      APCOMPANY - No Description Available.
      APCONTACT - No Description Available.
      APCPYVND - No Description Available.
      APDISCCODE - No Description Available.
      APDISTHDR - No Description Available.
      APHLDINV - No Description Available.
      APHOLDCODE - No Description Available.
      APINCCODE - No Description Available.
      APINVOICE - No Description Available.
      APPAYMENT - No Description Available.
      APPROCGRP - No Description Available.
      APPROCLEV - No Description Available.
      APUSRFLDEF - No Description Available.
      APVENBAL - No Description Available.
      APVENCERT - No Description Available.
      APVENCLASS - No Description Available.
      APVENLOC - No Description Available.
      APVNMXVAL - No Description Available.
      ARCUSTGRP - No Description Available.
      CBCHECK - No Description Available.
      CBUSER - No Description Available.
      CBUSRCLASS - No Description Available.
      CUCONV - No Description Available.
      CURELAT - No Description Available.
      EEADVANCE - No Description Available.
      EEAPPROVAL - No Description Available.
      EEEXPENSE - No Description Available.
      GLSYSTEM - No Description Available.
      INSTCTRYCD - No Description Available.
      INSTREGN - No Description Available.
      MAINVHAND - No Description Available.
      MAMATCHTBL - No Description Available.
      MAMSGTOL - No Description Available.
      MAMTCHRULE - No Description Available.
      MAPOOLCNT - No Description Available.
      MXCATDEF - No Description Available.
      MXELEMENT - No Description Available.
      MXLISTDTL - No Description Available.
      MXOBJCAT - No Description Available.
      POAOCDTL - No Description Available.
      POITEMVEN - No Description Available.
      POVAGRMTHD - No Description Available.
      POVENDLOC - No Description Available.
      PROCUREGRP - No Description Available.
      PURCHORDER - No Description Available.
      TXTAXRATE - No Description Available.



      INVOKED Programs

      ACAC
      ACTA
      API4
      IFAC
      IFCU
      IFOB
      IFSG
      SLSE
      SLSU
      IFLU
      IFUP
      APCP
      EEI1
      Kevin Hagan
      Advanced Member
      Posts: 30
      Advanced Member
      12/21/2009 12:27 PM

        I think Greg’s list of tables was based on AP90 not the AC90. AC90 uses two basic tables for inquiry information. Actual’s can be found in the ACTRANS table while commitments can be found in ACCOMMITX. The issue that you need to be aware of though is that future dated released transactions are recorded in ACTRANS so from an accounting perspective you need to pull those out and move to the commitment column. If you just looking for actual balance rather than transaction level detail you can also find that in ACACTIVITY. Now if you want to add AP and PO detail you will also need to link in APPAYMENT and APDISTRIP as well as most likely POLINE.