Table 8070 "Subscription Billing Cue"

Subscription Billing · Microsoft.SubscriptionBilling · captioned “Subscription Billing Activities Cue” · BC29-30 · source at ea08af5e · 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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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. via Page 8085 “Sub. Billing Activities”	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 caption	obsolete Pending 28.0; #if not CLEANSCHEMA30; FlowFilter; not editable
22	Overdue	Integer	Specifies the overdue Subscription Lines. via Page 8085 “Sub. Billing Activities”	not editable; DataClassification CustomerContent
23	Not Invoiced	Integer	Specifies the Billing Lines for Subscription Lines that have not been called into Posting Documents, yet. via Page 8085 “Sub. Billing Activities”	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”
Cust. Sub. Contr. Credit Memos: CalcFormula Table 36 “Sales Header”
Cust. Sub. Contr. Invoices: CalcFormula Table 36 “Sales Header”
Vend. Contr. Credit Memos: CalcFormula Table 38 “Purchase Header”
Vend. Sub. Contr. Invoices: CalcFormula Table 38 “Purchase Header”
Errors Automated Billing: CalcFormula Table 8022 “Contract Billing Err. Log”
Sub. L. wo Cust. Sub. Contract: CalcFormula Table 8059 “Subscription Line”
Sub. L. wo Vend. Sub. Contract: CalcFormula Table 8059 “Subscription Line”
Not Invoiced: CalcFormula Table 8061 “Billing Line”

Pages and codeunits on this table

Page 8085 “Sub. Billing Activities” (source table)

Recent changes

2026-09-30 #12053 Remove-Sustainability-CLEAN27-tags-for-Wave2-2026 (main, BC30, obsoletion)

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.