Fluid Pagelets Used to Work with Customer Analysis

Pagelet Name Query Name Usage Product

Customer Sales Pagelet

N/A

View Sales amounts for a customer.

Receivables

Customer Past Due Pagelet

N/A

View past due amounts for a customer.

Receivables

Customer Prepayments Pagelet

N/A

View prepayments for a customer.

Receivables

Customer Collections Pagelet

N/A

View collections information for a customer.

Receivables

Customer Deductions Pagelet

N/A

View deduction amounts for a customer.

Receivables

Customer Dispute Balance Pagelet

N/A

View the amount in dispute for a customer.

Receivables

Customer Doubtful Balance Pagelet

N/A

View the total amount and number of payments that you transferred to a doubtful receivables account for a customer.

Receivables

Customer Contact Information Pagelet

N/A

View information for the primary contact, including phone, fax, email, and preferred contact method for a customer.

Receivables

Customer Credit Information Pagelet

N/A

View the credit class, risk, limit, and risk score for a customer.

Receivables

Customer Information Pagelet

N/A

View basic information for a customer, such as name, status, and customer type.

Receivables

Customer Support Operations Pagelet

N/A

View information related to key members of your customer support operations, such as AR Specialist, Collector, and Analyst.

Receivables

Customer Address Pagelet

N/A

View bill to and ship to address information for a customer.

Receivables

Customer History Summary Pagelet

C360_CUST_HISTORY

View customer history amounts and details.

Receivables

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

Contract Status Analysis Pagelet

C360_CONTRACT_STATUS_PVG

View contract status and type by net amount.

Contracts

Dispute Analysis Pagelet

C360_DISPUTE_AMT_PVG

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

Receivables

Invoice Status Analysis Pagelet

C360_BI_BILL_STATUS

View the customer’s invoice amount by status.

Billing

Invoices by Month Analysis Pagelet

C360_PV_RINV_QRY

View the invoice amount by month and year.

Billing

Items by Month Analysis Pagelet

C360_AR_ITEM_PVG

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

Receivables

Overdue Analysis Pagelet

C360_OVERDUE_AMT_ANALYSIS

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

Receivables

Write Off Analysis Pagelet

C360_WRITE_OFF_ANALYSIS

View customer write-off amounts by year.

Receivables

Customer Top Contracts Pagelet

C360_TOP_N_CNTR

View the top 10 contracts by a contract’s total bill amount.

Contracts

Customer Top Payments Pagelet

C360_TOP_N_PAYMNT

View the top 10 payments by payment amount base.

Receivables

Customer Top Items Pagelet

C360_TOP_N_ITEM

View the top 10 items by item balance amount base.

Receivables

Customer Top Invoices Pagelet

C360_TOP_N_INVOIC

View the top 10 invoices by invoice amount.

Billing