---
id: object/table/8070
type: object
title: Table 8070 "Subscription Billing Cue"
summary: Table 8070 "Subscription Billing Cue" in Subscription Billing (Microsoft.SubscriptionBilling). 18 fields. Introduced in BC29, still in BC30, changed in BC30.
tier: official
language: en
tags:
  - table
  - subscription billing
versions:
  introduced: "29"
  last_changed: "30"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: a35ec9128ae41a3450421aa43046551db52ae47e238eb89d5073492205b4ba91
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subscription%20Billing/app/Base/Tables/SubscriptionBillingCue.Table.al
    title: src/Apps/W1/Subscription Billing/app/Base/Tables/SubscriptionBillingCue.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/12053
object_type: table
object_id: 8070
name: Subscription Billing Cue
caption: Subscription Billing Activities Cue
namespace: Microsoft.SubscriptionBilling
app: Subscription Billing
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in:
  - "30"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 18
  procedures: 1
  events: 0
  subscribers: 0
relations:
  out: 9
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 8070 "Subscription Billing Cue"

> Table 8070 "Subscription Billing Cue" in Subscription Billing (Microsoft.SubscriptionBilling). 18 fields. Introduced in BC29, still in BC30, changed in BC30.

Subscription Billing · Microsoft.SubscriptionBilling · captioned "Subscription Billing Activities Cue" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subscription%20Billing/app/Base/Tables/SubscriptionBillingCue.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Subscription Billing Activities Cue |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key | Code[10] | — | DataClassification CustomerContent |
| 2 | Cust. Sub. Contr. Invoices | Integer | Specifies the Open Customer Subscription Contract Invoices. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Sales Header" where("Document Type" = filter(Invoice), "Recurring Billing" = filter(true))); not editable |
| 3 | Cust. Sub. Contr. Credit Memos | Integer | Specifies the Open Customer Subscription Contract Credit Memos. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Sales Header" where("Document Type" = filter("Credit Memo"), "Recurring Billing" = filter(true))); not editable |
| 4 | Vend. Sub. Contr. Invoices | Integer | Specifies the Open Vendor Subscription Contract Invoices. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Purchase Header" where("Document Type" = filter(Invoice), "Recurring Billing" = filter(true))); not editable |
| 5 | Vend. Contr. Credit Memos | Integer | Specifies the Open Vendor Subscription Contract Credit Memos. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Purchase Header" where("Document Type" = filter("Credit Memo"), "Recurring Billing" = filter(true))); not editable |
| 6 | Sub. L. wo Cust. Sub. Contract | Integer | Specifies the Subscription Lines without Customer Contract. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Subscription Line" where("Invoicing via" = filter(Contract), "Subscription Contract No." = filter(''), Partner = filter(Customer))); not editable |
| 7 | Sub. L. wo Vend. Sub. Contract | Integer | Specifies the Subscription Lines without Vendor Subscription Contract. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Subscription Line" where("Invoicing via" = filter(Contract), "Subscription Contract No." = filter(''), Partner = filter(Vendor))); not editable |
| 8 | Jobs Over Budget | Integer | Specifies the number of projects where the usage cost exceeds the budgeted cost. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count(Job where("Over Budget" = filter(= true))); not editable |
| 9 | Revenue current Month | Decimal | Specifies the Balance between posted Contract Invoices and Contract Credit Memos for Customer Subscription Contracts in current Month. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | DataClassification CustomerContent |
| 10 | Cost current Month | Decimal | Specifies the Balance between posted Contract Invoices and Contract Credit Memos for Vendor Subscription Contracts in current Month. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | DataClassification CustomerContent |
| 11 | Revenue previous Month | Decimal | Specifies the Balance between posted Contract Invoices and Contract Credit Memos for Customer Subscription Contracts in previous Month. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | DataClassification CustomerContent |
| 12 | Cost previous Month | Decimal | Specifies the Balance between posted Contract Invoices and Contract Credit Memos for Vendor Subscription Contracts in previous Month. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | DataClassification CustomerContent |
| 13 | Last Updated On | DateTime | — | not editable; DataClassification SystemMetadata |
| 20 | Date Filter | Date | — | FlowFilter; not editable |
| 21 | Job No. Filter | Code[20] | Date Filter <small>caption</small> | obsolete Pending 28.0; #if not CLEANSCHEMA30; FlowFilter; not editable |
| 22 | Overdue | Integer | Specifies the overdue Subscription Lines. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | not editable; DataClassification CustomerContent |
| 23 | Not Invoiced | Integer | Specifies the Billing Lines for Subscription Lines that have not been called into Posting Documents, yet. <small>via [Page 8085 "Sub. Billing Activities"](../page/8085.md)</small> | FlowField: count("Billing Line" where("Document No." = filter(''))); not editable |
| 30 | Errors Automated Billing | Integer | Specifies the number of errors that occurred during the automated contract billing process. | FlowField: count("Contract Billing Err. Log"); not editable |

## Keys

- SK1: Primary Key (clustered)

## Procedures

1 local procedures, no public ones.

## Relations

- Jobs Over Budget: CalcFormula [Table 167 "Job"](../table/167.md)
- Cust. Sub. Contr. Credit Memos: CalcFormula [Table 36 "Sales Header"](../table/36.md)
- Cust. Sub. Contr. Invoices: CalcFormula [Table 36 "Sales Header"](../table/36.md)
- Vend. Contr. Credit Memos: CalcFormula [Table 38 "Purchase Header"](../table/38.md)
- Vend. Sub. Contr. Invoices: CalcFormula [Table 38 "Purchase Header"](../table/38.md)
- Errors Automated Billing: CalcFormula [Table 8022 "Contract Billing Err. Log"](../table/8022.md)
- Sub. L. wo Cust. Sub. Contract: CalcFormula [Table 8059 "Subscription Line"](../table/8059.md)
- Sub. L. wo Vend. Sub. Contract: CalcFormula [Table 8059 "Subscription Line"](../table/8059.md)
- Not Invoiced: CalcFormula [Table 8061 "Billing Line"](../table/8061.md)

## Pages and codeunits on this table

- [Page 8085 "Sub. Billing Activities"](../page/8085.md) (source table)

## Recent changes

- 2026-09-30 [#12053 Remove-Sustainability-CLEAN27-tags-for-Wave2-2026](../../changes/bcapps/12053.md) (main, BC30, obsoletion)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: BC30

## Deprecations

- field Job No. Filter: Pending 28.0 (#if not CLEANSCHEMA30), "Removed as projects are not relevant in context of Subscription Billing"

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Subscription Billing Cue")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.
