tableSales & Receivablesofficial - Microsoftderived - from the source, no model text

Table 8007 "Overdue Subscription Line"

Subscription Billing · Microsoft.SubscriptionBilling

Across versions

  1. BC23-28not present
  2. BC29present
  3. BC30changed

Neighbourhood 6 connected objects and pages

Table 27 "Item" (relates to)ItemTable 8052 "Customer Subscription Contract" (relates to)Customer Subscription ContractTable 8053 "Subscription Contract Type" (relates to)Subscription Contract TypeTable 8057 "Subscription Header" (relates to)Subscription HeaderTable 8063 "Vendor Subscription Contract" (relates to)Vendor Subscription ContractPage 8007 "Overdue Service Commitments" (pages and codeunits on it)Overdue Service Commitments

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Pages and codeunits on this table

Recent changes

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.

Evidence 1 sources