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?
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.