Pagelets Used to Work with Customer Analysis

Pagelet Name Query Name Usage Product

Customer Aging Analysis Pagelet

C360_AR_DB_CUST_AGING

View the aging balance by aging category and a count of open items making up the aging balance.

The Aging ID in the query defaults from the AR Business Unit options.

Receivables

Customer Items Balance Analysis Pagelet

C360_AR_ITEM_PVG

View the customer’s items balance by month and year.

Receivables

Customer Bill By Status Analysis Pagelet

C360_BI_BILL_STATUS

View the customer’s invoice amount by status.

Billing

Customer Contract Status Analysis Pagelet

C360_CONTRACT_STATUS_PVG

View contract status and type by net amount.

Contracts

Customer Dispute Amount Analysis Pagelet

C360_DISPUTE_AMT_PVG

View the customer’s amount in dispute by month and year.

Receivables

Customer Invoice Analysis by Month Pagelet

C360_PV_RINV_QRY

View the invoice amount by month and year.

Billing

Customer Overdue Amount Analysis Pagelet

C360_OVERDUE_AMT_ANALYSIS

View a customer’s overdue amount by month and year.

Receivables

Customer Write-Off Analysis Pagelet

C360_WRITE_OFF_ANALYSIS

View customer write-off amounts by year.

Receivables