Cash KPIs & Measures
Catalog of the 174 measures shipped with the Cash semantic model, grouped by their display folder. Captions are shown in English and German together with the number format. Use any measure with any dimension to build your own analysis.
Accounts Payable\Documents
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP #Documents | # Kred.-belege | #,##0 | Number of Vendor Vouchers (excl. Payments) |
| AP #Documents Open | # Kred.-belege offen | #,##0 | Number of Vendor Vouchers (excl. Payments) with status Open |
| AP #Documents Overdue | # Kred.-belege überf. | #,##0 | Number of Vendor Vouchers (excl. Payments) with an Overdue Amount |
| AP #Documents Overdue % (Historical) | # Kred.-belege überf. % (Historisch) | 0\ %;-0\ %;0\ % | Share of vouchers (excl. Payments) not payed in due time |
| AP #Documents Overdue (Historical) | # Kred.-belege überf. (Historisch) | #,##0 | Number of Vendor Vouchers (excl. Payments) payed not in due time |
Accounts Payable\Documents\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP #Documents Open PY | AP #Documents Open PY | #,##0 | |
| AP #Documents Overdue PY | AP #Documents Overdue PY | #,##0 |
Accounts Payable\Documents\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP #Documents Open YoY | AP #Documents Open YoY | #,##0 | |
| AP #Documents Overdue YoY | AP #Documents Overdue YoY | #,##0 |
Accounts Payable\Documents\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP #Documents Open YoY % | AP #Documents Open YoY % | #,##0 % | |
| AP #Documents Overdue YoY % | AP #Documents Overdue YoY % | #,##0 % |
Accounts Payable\Payable Amounts
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Amount Discountable | Verbindlichkeit skontofähig | #,##0 | |
| AP Amount Open | Verbindlichkeit offen | #,##0 | Amount with status Open excl. Payments |
| AP Amount Open Avg | Verbindlichkeit offen Ø | #,##0 | Average Amount Open |
| AP Amount Open Max | Verbindlichkeit offen Max | #,##0 | Highest Amount Open |
| AP Amount Open Min | Verbindlichkeit offen Min | #,##0 | Lowest Amount Open |
| AP Amount Overdue | Verbindlichkeit überf. | #,##0 | Outstanding Amount, overdue |
| AP Amount Overdue % | Verbindlichkeit überf. % | 0\ %;-0\ %;0\ % | Share of overdue amount related to open amount |
| AP Amount Overdue % (Historical) | Verbindlichkeit überf. (Historie) | 0\ %;-0\ %;0\ % | Share of amount not paid in due time |
| AP Amount Overdue (Historical) | Verbindlichkeit überf. % (Historie) | #,##0 | Historical Amounts not paid in due time |
| AP Amount Overdue Avg | Verbindlichkeit überf. Ø | #,##0 | Average Outstanding Amount, overdue |
| AP Amount Overdue Max | Verbindlichkeit überf. Max | #,##0 | Highest Outstanding Amount, overdue |
| AP Amount Overdue Min | Verbindlichkeit überf. Min | #,##0 | Lowest Outstanding Amount, overdue |
| AP Amount Payable | Verbindlichkeit | #,##0 | |
| AP Payment Amount Applied | Verbindlichkeitsausgleich | #,##0 | Application amount (by payment or cash discount) |
| AP Payment Amount CashDiscount | Skontobetrag (Verbindlichkeit) | #,##0 | Realized cash discount |
| AP Payment Amount CashOut | Zahlungsausgang | #,##0 | Paid amount |
| AP Payments CashDiscount (% of TTL) | Skontoanteil (Verbindlichkeit) | 0.0\ %;-0.0\ %;0.0\ % | Cash discount in relation to paid amount |
Accounts Payable\Payable Amounts Invoice Currency
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Amount Payable (FC) | Verbindlichkeit (in FW) | #,##0 | Amount Payable in foreign currency |
Accounts Payable\Payable Amounts\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Amount Open PY | AP Amount Open PY | #,##0 | |
| AP Amount Overdue % (Historical) PY | AP Amount Overdue % (Historical) PY | 0\ %;-0\ %;0\ % | |
| AP Amount Overdue % PY | AP Amount Overdue % PY | 0\ %;-0\ %;0\ % | |
| AP Amount Overdue PY | AP Amount Overdue PY | #,##0 | |
| AP Payment Amount CashDiscount PY | AP Payment Amount CashDiscount PY | #,##0 | |
| AP Payments CashDiscount (% of TTL) PY | AP Payments CashDiscount (% of TTL) PY | 0.0\ %;-0.0\ %;0.0\ % |
Accounts Payable\Payable Amounts\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Amount Open YoY | AP Amount Open YoY | #,##0 | |
| AP Amount Overdue % (Historical) YoY | AP Amount Overdue % (Historical) YoY | #,##0.0 | |
| AP Amount Overdue % YoY | AP Amount Overdue % YoY | #,##0.0 | |
| AP Amount Overdue YoY | AP Amount Overdue YoY | #,##0 | |
| AP Payment Amount CashDiscount YoY | AP Payment Amount CashDiscount YoY | #,##0 | |
| AP Payments CashDiscount (% of TTL) YoY | AP Payments CashDiscount (% of TTL) YoY | #,##0.0 |
Accounts Payable\Payable Amounts\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Amount Open YoY % | AP Amount Open YoY % | #,##0 % | |
| AP Amount Overdue % (Historical) YoY % | AP Amount Overdue % (Historical) YoY % | #,##0 % | |
| AP Amount Overdue % YoY % | AP Amount Overdue % YoY % | #,##0 % | |
| AP Amount Overdue YoY % | AP Amount Overdue YoY % | #,##0 % | |
| AP Payment Amount CashDiscount YoY % | AP Payment Amount CashDiscount YoY % | #,##0 % | |
| AP Payments CashDiscount (% of TTL) YoY % | AP Payments CashDiscount (% of TTL) YoY % | #,##0 % |
Accounts Payable\Payable Days
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Avg Days Overdue | Ø Verbindlichkeitstage überf. | #,##0 | Average Days of Overdue Documents |
| AP Avg Days Overdue (incl in Time) | Ø Verbindlichkeitstage | #,##0 | Average Days Overdue (incl. documents paid in due) |
Accounts Payable\Payable Days\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Avg Days Overdue (incl in Time) PY | AP Avg Days Overdue (incl in Time) PY | #,##0 |
Accounts Payable\Payable Days\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Avg Days Overdue (incl in Time) YoY | AP Avg Days Overdue (incl in Time) YoY | #,##0 |
Accounts Payable\Payable Days\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP Avg Days Overdue (incl in Time) YoY % | AP Avg Days Overdue (incl in Time) YoY % | #,##0 % |
Accounts Receivable\Documents
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR #Documents | # Deb.-belege | #,##0 | Number of Customer Vouchers (excl. Payments) |
| AR #Documents Open | # Debitorenbelege offen | #,##0 | Number of Customer Vouchers (excl. Payments) with status Open |
| AR #Documents Overdue | # Deb.-belege überf. | #,##0 | Number of Customer Vouchers (excl. Payments) with an Overdue Amount |
| AR #Documents Overdue % (Historical) | # Deb.-belege überf. % (Historie) | 0\ %;-0\ %;0\ % | Share of vouchers (excl. Payments) not payed in due time |
| AR #Documents Overdue (Historical) | # Deb.-belege überf. (Historie) | #,##0 | Number of Customer Vouchers (excl. Payments) payed not in due time |
Accounts Receivable\Documents\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR #Documents Open PY | AR #Documents Open PY | #,##0 | |
| AR #Documents Overdue PY | AR #Documents Overdue PY | #,##0 |
Accounts Receivable\Documents\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR #Documents Open YoY | AR #Documents Open YoY | #,##0 | |
| AR #Documents Overdue YoY | AR #Documents Overdue YoY | #,##0 |
Accounts Receivable\Documents\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR #Documents Open YoY % | AR #Documents Open YoY % | #,##0 % | |
| AR #Documents Overdue YoY % | AR #Documents Overdue YoY % | #,##0 % |
Accounts Receivable\Receivable Amounts
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Amount Discountable | Forderung skontofähig | #,##0 | |
| AR Amount Open | Forderung offen | #,##0 | Amount with status Open excl. Payments |
| AR Amount Open Avg | Forderung offen Ø | #,##0 | Average Amount Open |
| AR Amount Open Max | Forderung offen Max | #,##0 | Highest Amount Open |
| AR Amount Open Min | Forderung offen Min | #,##0 | Lowest Amount Open |
| AR Amount Open PY | Forderung offen PY | #,##0 | Amount with status Open excl. Payments Previous Year |
| AR Amount Overdue | Forderung überfällig | #,##0 | Outstanding Amount, overdue |
| AR Amount Overdue % | Forderung überf. in % | 0\ %;-0\ %;0\ % | Share of overdue amount related to open amount |
| AR Amount Overdue % (Historical) | Forderung überf. % (Historie) | 0\ %;-0\ %;0\ % | Share of amount not received in due time |
| AR Amount Overdue (Historical) | Forderung überf. (Historie) | #,##0 | Historical Amounts not received in due time |
| AR Amount Overdue Avg | Forderung überfällig Ø | #,##0 | Average Outstanding Amount, overdue |
| AR Amount Overdue Max | Forderung überfällig Max | #,##0 | Highest Outstanding Amount, overdue |
| AR Amount Overdue Min | Forderung überfällig Min | #,##0 | Lowest Outstanding Amount, overdue |
| AR Amount Receivable | Forderung | #,##0 | |
| AR Payment Amount Applied | Forderungsausgleich | #,##0 | Application amount (by payment or cash discount) |
| AR Payment Amount CashDiscount | Skontobetrag (Forderung) | #,##0 | Realized (granted) cash discount |
| AR Payment Amount CashIn | Zahlungseingang | #,##0 | Received amount |
| AR Payments (NotApplied) | Zahlungseingang (unverknüpft) | #,##0 | Received Amount, not connected to a receivable |
| AR Payments CashDiscount (% of TTL) | Skontoanteil (Forderung) | 0.0\ %;-0.0\ %;0.0\ % | Cash discount in relation to received amount |
Accounts Receivable\Receivable Amounts Invoice Currency
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Amount Receivable (FC) | Forderung (in FW) | #,##0 | Amount Receivable in foreign currency |
Accounts Receivable\Receivable Amounts\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Amount Overdue % (Historical) PY | AR Amount Overdue % (Historical) PY | 0\ %;-0\ %;0\ % | |
| AR Amount Overdue % PY | AR Amount Overdue % PY | 0\ %;-0\ %;0\ % | |
| AR Amount Overdue PY | AR Amount Overdue PY | #,##0 | |
| AR Payment Amount CashDiscount PY | AR Payment Amount CashDiscount PY | #,##0 | |
| AR Payments CashDiscount (% of TTL) PY | AR Payments CashDiscount (% of TTL) PY | 0.0\ %;-0.0\ %;0.0\ % |
Accounts Receivable\Receivable Amounts\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Amount Open YoY | AR Amount Open YoY | #,##0 | |
| AR Amount Overdue % (Historical) YoY | AR Amount Overdue % (Historical) YoY | #,##0.0 | |
| AR Amount Overdue % YoY | AR Amount Overdue % YoY | #,##0.0 | |
| AR Amount Overdue YoY | AR Amount Overdue YoY | #,##0 | |
| AR Payment Amount CashDiscount YoY | AR Payment Amount CashDiscount YoY | #,##0 | |
| AR Payments CashDiscount (% of TTL) YoY | AR Payments CashDiscount (% of TTL) YoY | #,##0.0 |
Accounts Receivable\Receivable Amounts\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Amount Open YoY % | AR Amount Open YoY % | #,##0 % | |
| AR Amount Overdue % (Historical) YoY % | AR Amount Overdue % (Historical) YoY % | #,##0 % | |
| AR Amount Overdue % YoY % | AR Amount Overdue % YoY % | #,##0 % | |
| AR Amount Overdue YoY % | AR Amount Overdue YoY % | #,##0 % | |
| AR Payment Amount CashDiscount YoY % | AR Payment Amount CashDiscount YoY % | #,##0 % | |
| AR Payments CashDiscount (% of TTL) YoY % | AR Payments CashDiscount (% of TTL) YoY % | #,##0 % |
Accounts Receivable\Receivable Days
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Avg Days Overdue | Ø Forderungstage überf. | #,##0 | Average Days of Overdue Documents |
| AR Avg Days Overdue (incl in Time) | Ø Forderungstage | #,##0 | Average Days Overdue (incl. documents paid in due) |
Accounts Receivable\Receivable Days\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Avg Days Overdue (incl in Time) PY | AR Avg Days Overdue (incl in Time) PY | #,##0 |
Accounts Receivable\Receivable Days\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Avg Days Overdue (incl in Time) YoY | AR Avg Days Overdue (incl in Time) YoY | #,##0 |
Accounts Receivable\Receivable Days\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AR Avg Days Overdue (incl in Time) YoY % | AR Avg Days Overdue (incl in Time) YoY % | #,##0 % |
General
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AppliedCashDiscount Label | AppliedCashDiscount Label | ||
| Client Label | Client Label | ||
| CustomerHistoryPage Label | CustomerHistoryPage Label | ||
| CustomerOpenPage Label | CustomerOpenPage Label | ||
| Document Type Label | Document Type Label | ||
| DocumentOverview Label | DocumentOverview Label | ||
| Last Refresh Label | Last Refresh Label | ||
| OverviewPage Label | OverviewPage Label | ||
| Period Label | Period Label | ||
| QAPage Label | QAPage Label | ||
| Report Label | Report Label | ||
| ReportPayables Label | ReportPayables Label | ||
| ReportReceivables Label | ReportReceivables Label | ||
| Statistic by Aging Label | Statistic by Aging Label | ||
| Statistic by Applied Cash Discount Label | Statistic by Applied Cash Discount Label | ||
| Statistic by AvgDaysOverdue Label | Statistic by AvgDaysOverdue Label | ||
| Statistic by Customer Label | Statistic by Customer Label | ||
| Statistic by CustomerAgingGroup Label | Statistic by CustomerAgingGroup Label | ||
| Statistic by Overdue Days and Amount by Document Label | Statistic by Overdue Days and Amount by Document Label | ||
| Statistic by Vendor Label | Statistic by Vendor Label | ||
| Statistic by VendorAgingGroup Label | Statistic by VendorAgingGroup Label | ||
| SummaryPage Label | SummaryPage Label | ||
| Today Label | Today Label | ||
| VendorHistoryPage Label | VendorHistoryPage Label | ||
| VendorOpenPage Label | VendorOpenPage Label |
Tech
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| App Version | App Version | ||
| Current User | Current User | ||
| DaysInFilter | Tage gefiltert | Days in current filter period | |
| DynMeasure | DynMeasure | ||
| EffectiveDate | Datum (effective) | ||
| Last Refresh | Letztes Update | ||
| Last Refresh Card | Last Refresh Card | ||
| Today Card | Today Card |
Tech\Formatting
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AP #Documents Open YoY CF | AP #Documents Open YoY CF | ||
| AP #Documents Open YoY Icon | AP #Documents Open YoY Icon | ||
| AP #Documents Overdue YoY CF | AP #Documents Overdue YoY CF | ||
| AP #Documents Overdue YoY Icon | AP #Documents Overdue YoY Icon | ||
| AP Amount Open YoY CF | AP Amount Open YoY CF | ||
| AP Amount Open YoY Icon | AP Amount Open YoY Icon | ||
| AP Amount Overdue % (Historical) YoY CF | AP Amount Overdue % (Historical) YoY CF | ||
| AP Amount Overdue % (Historical) YoY Icon | AP Amount Overdue % (Historical) YoY Icon | ||
| AP Amount Overdue % YoY CF | AP Amount Overdue % YoY CF | ||
| AP Amount Overdue % YoY Icon | AP Amount Overdue % YoY Icon | ||
| AP Amount Overdue YoY CF | AP Amount Overdue YoY CF | ||
| AP Amount Overdue YoY Icon | AP Amount Overdue YoY Icon | ||
| AP Avg Days Overdue (incl in Time) YoY CF | AP Avg Days Overdue (incl in Time) YoY CF | ||
| AP Avg Days Overdue (incl in Time) YoY Icon | AP Avg Days Overdue (incl in Time) YoY Icon | ||
| AP Payment Amount CashDiscount YoY CF | AP Payment Amount CashDiscount YoY CF | ||
| AP Payment Amount CashDiscount YoY Icon | AP Payment Amount CashDiscount YoY Icon | ||
| AP Payments CashDiscount (% of TTL) YoY CF | AP Payments CashDiscount (% of TTL) YoY CF | ||
| AP Payments CashDiscount (% of TTL) YoY Icon | AP Payments CashDiscount (% of TTL) YoY Icon | ||
| AR #Documents Open YoY CF | AR #Documents Open YoY CF | ||
| AR #Documents Open YoY Icon | AR #Documents Open YoY Icon | ||
| AR #Documents Overdue YoY CF | AR #Documents Overdue YoY CF | ||
| AR #Documents Overdue YoY Icon | AR #Documents Overdue YoY Icon | ||
| AR Amount Open YoY CF | AR Amount Open YoY CF | ||
| AR Amount Open YoY Icon | AR Amount Open YoY Icon | ||
| AR Amount Overdue % (Historical) YoY CF | AR Amount Overdue % (Historical) YoY CF | ||
| AR Amount Overdue % (Historical) YoY Icon | AR Amount Overdue % (Historical) YoY Icon | ||
| AR Amount Overdue % YoY CF | AR Amount Overdue % YoY CF | ||
| AR Amount Overdue % YoY Icon | AR Amount Overdue % YoY Icon | ||
| AR Amount Overdue YoY CF | AR Amount Overdue YoY CF | ||
| AR Amount Overdue YoY Icon | AR Amount Overdue YoY Icon | ||
| AR Avg Days Overdue (incl in Time) YoY CF | AR Avg Days Overdue (incl in Time) YoY CF | ||
| AR Avg Days Overdue (incl in Time) YoY Icon | AR Avg Days Overdue (incl in Time) YoY Icon | ||
| AR Payment Amount CashDiscount YoY CF | AR Payment Amount CashDiscount YoY CF | ||
| AR Payment Amount CashDiscount YoY Icon | AR Payment Amount CashDiscount YoY Icon | ||
| AR Payments CashDiscount (% of TTL) YoY CF | AR Payments CashDiscount (% of TTL) YoY CF | ||
| AR Payments CashDiscount (% of TTL) YoY Icon | AR Payments CashDiscount (% of TTL) YoY Icon |