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
Pega Smart Investigate for Payments