How You Maintain the Summary Tables for Data Points

AR_TRX_BAL_SUMMARY

The AR_TRX_BAL_SUMMARY table maintains summary data related to customers and customer accounts.

The table includes summary data in these data point categories:

Aging: All open counts and amounts; and past due, adjustment, and at risk amounts.
Billing and Payments: Payment-related data.
Business Information and Credit: Current receivables balance.

The lowest level of granularity for a data point value stored in this table is at the level of a customer bill-to site of a given customer account in a specified currency.

A data point value from the AR_TRX_BAL_SUMMARY table displayed in the case folder for a customer or customer account is derived in this way:

Add up all values across all bill-to sites (for customer account case folders) or all customer accounts (for customer case folders).
Convert the values to the credit currency using the values defined for currency and conversion rate type in the customer or customer account profile.
If the credit currency defined in the customer or customer account profile isn't the same as the scoring model currency, the data point values used for scoring are converted to the scoring model currency.

AR_TRX_SUMMARY

The AR_TRX_SUMMARY table maintains summary data related to customer and customer account transactions.

The table includes summary data in these data point categories:

Billing and Payments: Transaction counts, amounts, and percentages.
Business Information and Credit: Credit amounts and dates.

The data in the AR_TRX_SUMMARY table is over a 12-month time period. The display of summarized order, invoice, and payment data over this period of time can provide you with an overall picture of your relationship with the customer or customer account, and can help you predict future performance.

The lowest level of granularity for a data point value stored in this table is at the level of a customer bill-to site of a given customer account in a specified currency in the given 12-month period.

A data point value from the AR_TRX_SUMMARY table displayed in the case folder for a customer or customer account is derived in this way:

Add up all values with the most recent As-of date across all bill-to sites (for customer account case folders) or all customer accounts (for customer case folders).
Convert the values to the credit currency using the values defined for currency and conversion rate type in the customer or customer account profile.
If the credit currency defined in the customer or customer account profile isn't the same as the scoring model currency, the data point values used for scoring are converted to the scoring model currency.

Run the Process Receivables Transactions for Customer Account Summaries Process

During the life of a case folder, customer data is likely to change with new transactions, adjustments, payments, disputes, and other transaction and balance updates.

You can update the data in the AR_TRX_BAL_SUMMARY and AR_TRX_SUMMARY tables to reflect all of these change by using the Process Receivables Transactions for Customer Account Summaries process.

Schedule a regular run of the Process Receivables Transactions for Customer Account Summaries process to refresh the applicable customer account summary data for all related data points.

After the AR_TRX_BAL_SUMMARY and AR_TRX_SUMMARY tables are refreshed, you can open any applicable case folder and select Refresh Data from the Actions menu to refresh the data points in the case folder.