AP Bills

The AP Bills data model provides detailed line-level visibility into vendor bills and payable balances. It supports analysis of bill amounts, payments, balances, retainage, aging, GL accounts, projects, departments, locations, and vendor details in transaction, base, and reporting currencies.

Benefits of This Data Model

• Analyze bill detail: Review the individual bill lines and GL distributions behind payable balances.
• Monitor aging and retainage: Analyze current, overdue, retained, released, and outstanding amounts.
• Support multidimensional AP analysis: Review payables by vendor, project, account, company, location, department, and related attributes.

Key Performance Indicators (KPIs)

• Transaction Currency: Currency used for the document transaction.
• Transaction Amount: Document-line amount in transaction currency.
• Transaction Paid Amount: Paid amount in transaction currency.
• Transaction Due Amount: Due amount in transaction currency.
• Transaction Overdue Amount: Overdue amount in transaction currency.
• Transaction Current Amount: Current aging amount in transaction currency.
• Transaction 1-30 Days: Amount aged 1-30 days in transaction currency.
• Transaction 31-60 Days: Amount aged 31-60 days in transaction currency.
• Transaction 61-90 Days: Amount aged 61-90 days in transaction currency.
• Transaction 91+ Days: Amount aged 91 days or more in transaction currency.
• Transaction Amount Retained: Retained amount in transaction currency.
• Transaction Amount Released: Released retainage in transaction currency.
• Transaction Amount Less Retainage: Transaction amount net of retainage.
• Transaction Balance Excluding Retainage: Outstanding transaction balance excluding retainage.
• Transaction Retainage Balance: Outstanding retainage in transaction currency.
• Transaction Total Balance: Total outstanding transaction balance.
• Base Currency: Base currency used for the document.
• Base Amount: Document-line amount in base currency.
• Base Paid Amount: Paid amount in base currency.
• Base Due Amount: Due amount in base currency.
• Base Overdue Amount: Overdue amount in base currency.
• Base Current Amount: Current aging amount in base currency.
• Base 1-30 Days: Amount aged 1-30 days in base currency.
• Base 31-60 Days: Amount aged 31-60 days in base currency.
• Base 61-90 Days: Amount aged 61-90 days in base currency.
• Base 91+ Days: Amount aged 91 days or more in base currency.
• Base Amount Retained: Retained amount in base currency.
• Base Amount Released: Released retainage in base currency.
• Base Amount Less Retainage: Base amount net of retainage.
• Base Balance Excluding Retainage: Outstanding base balance excluding retainage.
• Base Retainage Balance: Outstanding retainage in base currency.
• Base Total Balance: Total outstanding balance in base currency.
• Reporting Amount: Amount in reporting currency.
• Reporting Paid Amount: Paid amount in reporting currency.
• Reporting Due Amount: Due amount in reporting currency.
• Reporting Overdue Amount: Overdue amount in reporting currency.
• Reporting Current Amount: Current aging amount in reporting currency.
• Reporting 1-30 Days: Amount aged 1-30 days in reporting currency.
• Reporting 31-60 Days: Amount aged 31-60 days in reporting currency.
• Reporting 61-90 Days: Amount aged 61-90 days in reporting currency.
• Reporting 91+ Days: Amount aged 91 days or more in reporting currency.
• Retainage Percentage: Retainage percentage applied to the document line.
• Bill Count 1-30 Days: Number of bills aged 1-30 days.
• Bill Count 31-60 Days: Number of bills aged 31-60 days.
• Bill Count 61-90 Days: Number of bills aged 61-90 days.
• Bill Count 91+ Days: Number of bills aged 91 days or more.

Available Visualizations

View Name	Description
AP Open Bills by Project	Lists open vendor bills by project and supports project-level payable balance review.