Smart Investigate for Payments maintains a database table of all debit and credit accounting entries that have been verified and released for posting to external accounting systems. Listed in order by posting date, each entry is written to the PAF_Entry database table. See online for instructions on how to view the schema.

The writing of entries to this table is not enabled when Smart Investigate for Payments is installed. The standard product is configured to use outgoing Fed Service and SWIFT messages and other correspondence as the posting instruments. To enable this function, select the Use Documents For Posting box on the Options tab of each Payment Type record you want to use for posting debits and credits.

When entries are written, all columns in this table, except ExtractDateTime, are populated by the system and are read only. The ExtractDateTime column exists so that processes extracting rows from the table can mark those rows with a date/time value to indicate when they were extracted. By marking records that have already been extracted, you are able to feed multiple accounting systems multiple times each day. Subsequent runs of the feed can ignore rows where ExtractDateTime is not null. Using this value with other columns such as AccountType, which is an indicator of an external accounting system like DDA or GL, an extraction process can further select and sort the appropriate rows for the accounting system you are feeding.

To implement a real-time or batch accounting feed, you must write a program or script to extract data from the database. The process you implement to extract the data from the table is your choice. See the Integrationarticles on the PDN for your connectivity options.