Auditing Processing Programs

In addition to the base validations performed during auditing, there is the ability to define custom rules and totals. Custom rules allow you to define specific rules that are important for your business to validate for transaction. Custom totals provide the ability for you to define specific totals that you want calculated by Sales Audit during the auditing process. These totals are usually used for integrating to the General Ledger but can also be used for other integrations as well. Other programs in this section are helper programs used during the import, export, or auditing processes, or used for overall data maintenance.

Sales Audit Processing Programs

• Calculate Totals Based on Client Defined Rules (satotals) totals transactions based on calculation definitions that you create using the online Totals Calculation Definition.

• Evaluate Transactions and Totals based on Client Defined Rules (sarules) audits transactions for retailer-defined audit rules.

• Prevent Duplicate Export of Total Values from ReSA (sapreexp) tracks all changed totals for the store day since the last export by comparing the latest prioritized version of each total defined for export with the version that was previously sent to each system.

• Generate Next Sequence for Escheatment Processing (saescheat_nextesn) gets the next free sequence for use in the saescheat process.

• Pre/Post Helper Processes for ReSA Batch Programs (saprepost) facilitates multi-threading by allowing general system administration functions (such as table deletions or mass updates) to be completed after all threads of a particular Sales Audit program have been processed.

• Purge Aged Store/Day Transaction, Total Value and Error Data from Sales Audit (sapurge) removes aged data from Sales Audit.

• Purge Aged RTLOG Data (sartlogdatapurge) drops the partitions from the history and reject tables used by the Sales Service to load RTLOG files.

• Purge the Invalid In-progress Sales Bucket (sainprogresspurge) deletes records from in-progress staging tables for the Store Days which have been closed and for which all the sales data has been exported to Merchandising.

There are also some background jobs that can be run as an alternative to some of these audit processing programs. These include:

• Calculate Totals Based on Client Defined Rules (sa_totals_calc_job)

• Evaluate Transactions and Totals based on Client Defined Rules (sa_rules_eval_job)

• Purge Into History Tables (b8d_sa_purge)

Lastly, there are two programs that are used for migrating totals and rules between environments:

• Extract Totals and Rules (sa_rules_total_extract)

• Migrate Totals and Rules (sa_rules_total_upload)