Table 8007 "Overdue Subscription Line"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29present
- BC30changed
Neighbourhood 6 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Overdue Subscription Line |
| TableType | Temporary |
| DataClassification | CustomerContent |
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 | Line No. | Integer | — | |
| 2 | Partner | Enum “Service Partner” | Specifies whether the Subscription Line will will be invoiced as credit (Purchase Invoice) or as debit (Sales Invoice). via Page 8007 “Overdue Service Commitments” | enum Enum 8053 “Service Partner” |
| 3 | Partner Name | Text[100] | Specifies the name of the partner who will receive the contract components and be billed by default. via Page 8007 “Overdue Service Commitments” | |
| 4 | Subscription Contract No. | Code[20] | Specifies in which Contract the Subscription Line will be invoiced. via Page 8007 “Overdue Service Commitments” | TableRelation Table 8052 “Customer Subscription Contract”, Table 8063 “Vendor Subscription Contract” (if (Partner = const(Customer)) “Customer Subscription Contract” else if (Partner = const(Vendor)) “Vendor Subscription Contract”) |
| 5 | Sub. Contract Description | Text[100] | Specifies the description of the Contract to which the Subscription Lines are assigned to. via Page 8007 “Overdue Service Commitments” | |
| 6 | Subscription Line Description | Text[100] | Specifies the description of the Subscription Line. via Page 8007 “Overdue Service Commitments” | |
| 7 | Next Billing Date | Date | Specifies the date of the next billing possible. via Page 8007 “Overdue Service Commitments” | not editable |
| 9 | Price | Decimal | Specifies the Unit Price for the subscription line billing period without discount. via Page 8007 “Overdue Service Commitments” | |
| 10 | Amount | Decimal | Specifies the amount for the Subscription Line including discount. via Page 8007 “Overdue Service Commitments” | |
| 11 | Item No. | Code[20] | Specifies the Item No. of the Subscription. via Page 8007 “Overdue Service Commitments” | obsolete Pending 26.0; #if not CLEANSCHEMA29; TableRelation Table 27 “Item” |
| 12 | Subscription Contract Type | Code[10] | Specifies the classification of the contract. via Page 8007 “Overdue Service Commitments” | TableRelation Table 8053 “Subscription Contract Type” (Subscription Contract Type) |
| 13 | Billing Rhythm | DateFormula | Specifies the Dateformula for rhythm in which the Subscription Line is invoiced. Using a Dateformula rhythm can be, for example, a monthly, a quarterly or a yearly invoicing. via Page 8007 “Overdue Service Commitments” | |
| 14 | Subscription Line Start Date | Date | Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8007 “Overdue Service Commitments” | |
| 15 | Subscription Line End Date | Date | Specifies the date up to which the Subscription Line is valid. via Page 8007 “Overdue Service Commitments” | |
| 16 | Subscription Header No. | Code[20] | Specifies the number of the Subscription. via Page 8007 “Overdue Service Commitments” | TableRelation Table 8057 “Subscription Header” (Subscription Header) |
| 17 | Subscription Description | Text[100] | Specifies the description of the Subscription. via Page 8007 “Overdue Service Commitments” | |
| 18 | Discount % | Decimal | Specifies the percent of the discount for the Subscription Line. via Page 8007 “Overdue Service Commitments” | |
| 19 | Quantity | Decimal | Specifies the quantity from Subscription. via Page 8007 “Overdue Service Commitments” | |
| 34 | Currency Code | Code[10] | — | |
| 8007 | Source Type | Enum “Service Object Type” | Specifies the type of the Subscription. via Page 8007 “Overdue Service Commitments” | enum Enum 8019 “Service Object Type” |
| 8008 | Source No. | Code[20] | Specifies the No. of the Item or G/L Account of the Subscription. via Page 8007 “Overdue Service Commitments” |
Keys
- PK: Line No. (clustered)
Procedures
CountOverdueServiceCommitments(): Integer(internal)FillOverdueServiceCommitments()(internal)OpenServiceObjectCard()(internal)
Plus 2 local procedures.
Relations
- Item No.: TableRelation Table 27 “Item”
- Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract” (conditional)
- Subscription Contract Type: TableRelation Table 8053 “Subscription Contract Type”
- Subscription Header No.: TableRelation Table 8057 “Subscription Header”
- Subscription Contract No.: TableRelation Table 8063 “Vendor Subscription Contract” (conditional)
Pages and codeunits on this table
- Page 8007 “Overdue Service Commitments” (source table)
Recent changes
- 2026-10-07 #10446 [Bug][Subscription Billing] “Subscription Lines - Overdue” cue counts lines of contracts that already ended (main, BC30, fix)
- 2026-08-27 #10675 Temporarily suppress AS0072 (ObsoleteTag 29.0) on 10 Base App elements for v30 prep (main, BC30, fix)
Deprecations
- field Item No.: Pending 26.0 (#if not CLEANSCHEMA29), “Replaced by field Source No.”
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: "Overdue Subscription Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.