Table 8019 "Sub. Contr. Analysis Entry"
Subscription Billing
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 13 connected objects and pages
Subscription Billing · captioned “Subscription Contract Analysis Entry” · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Subscription Contract Analysis Entry |
| DataClassification | CustomerContent |
| LookupPageId | Contract Analysis Entries |
| DrillDownPageId | Contract Analysis Entries |
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 | Entry No. | Integer | Specifies the number of the entry assigned to it from the specified number series when it was created. via Page 8090 “Contract Analysis Entries” | not editable; AutoIncrement |
| 2 | Subscription Header No. | Code[20] | Specifies the contract to which the Subscription Line is to be assigned. via Page 8090 “Contract Analysis Entries” | TableRelation Table 8057 “Subscription Header” (Subscription Header) |
| 3 | Subscription Package Code | Code[20] | Specifies the code of the Subscription Package. If a Vendor Subscription Contract line has the same Subscription No. and Package Code as a Customer Subscription Contract line, the Customer Subscription Contract dimension value is copied to the Vendor Subscription Contract line. via Page 8090 “Contract Analysis Entries” | TableRelation Table 8055 “Subscription Package” (Subscription Package); not editable; NotBlank |
| 4 | Template | Code[20] | Specifies the code of the Subscription Package Line Template. via Page 8090 “Contract Analysis Entries” | TableRelation Table 8054 “Sub. Package Line Template” (Sub. Package Line Template); not editable; NotBlank |
| 5 | Description | Text[100] | Specifies the description of the Subscription Line. via Page 8090 “Contract Analysis Entries” | |
| 6 | Subscription Line Start Date | Date | Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8090 “Contract Analysis Entries” | |
| 7 | Subscription Line End Date | Date | Specifies the date up to which the Subscription Line is valid. via Page 8090 “Contract Analysis Entries” | |
| 8 | Next Billing Date | Date | Specifies the date of the next billing possible. via Page 8090 “Contract Analysis Entries” | not editable |
| 9 | Calculation Base Amount | Decimal | Specifies the base amount from which the price will be calculated. via Page 8090 “Contract Analysis Entries” | |
| 10 | Calculation Base % | Decimal | Specifies the percent at which the price of the Subscription Line will be calculated. 100% means that the price corresponds to the Base Price. via Page 8090 “Contract Analysis Entries” | |
| 11 | Price | Decimal | Specifies the price of the Subscription Line with quantity of 1 in the billing period. The price is calculated from Base Price and Base Price %. via Page 8090 “Contract Analysis Entries” | not editable |
| 12 | Discount % | Decimal | Specifies the percent of the discount for the Subscription Line. via Page 8090 “Contract Analysis Entries” | |
| 13 | Discount Amount | Decimal | Specifies the amount of the discount for the Subscription Line. via Page 8090 “Contract Analysis Entries” | |
| 14 | Amount | Decimal | Specifies the amount for the Subscription Line including discount. via Page 8090 “Contract Analysis Entries” | |
| 15 | Billing Base Period | DateFormula | Specifies for which period the Amount is valid. If you enter 1M here, a period of one month, or 12M, a period of 1 year, to which Amount refers to. via Page 8090 “Contract Analysis Entries” | |
| 17 | Invoicing Item No. | Code[20] | Specifies the value of the Invoicing Item No. field. via Page 8090 “Contract Analysis Entries” | TableRelation Item.“No.” where(“Subscription Option” = filter(“Invoicing Item” | “Service Commitment Item”)) |
| 18 | Partner | Enum “Service Partner” | Specifies whether the Subscription Line will will be calculated as a credit (Purchase Invoice) or as debit (Sales Invoice). via Page 8090 “Contract Analysis Entries” | enum Enum 8053 “Service Partner” |
| 19 | Subscription Contract No. | Code[20] | Specifies the contract to which the Subscription Line is to be assigned. via Page 8090 “Contract Analysis Entries” | TableRelation Table 8052 “Customer Subscription Contract”, Table 8063 “Vendor Subscription Contract” (if (Partner = const(Customer)) “Customer Subscription Contract” where(“Sell-to Customer No.” = field(“Partner No.”)) else if (Partner = const(Vendor)) “Vendor Subscription Contract”) |
| 20 | Notice Period | DateFormula | Specifies a date formula for the lead time that a notice must have before the Subscription Line ends. The rhythm of the update of “Notice possible to” and “Term Until” is determined using the extension term. For example, with an extension period of 1M, the notice period is repeatedly postponed by on… via Page 8090 “Contract Analysis Entries” | |
| 21 | Initial Term | DateFormula | Specifies a date formula for calculating the minimum term of the Subscription Line. If the minimum term is filled and no extension term is entered, the end of Subscription Line is automatically set to the end of the initial term. via Page 8090 “Contract Analysis Entries” | |
| 22 | Extension Term | DateFormula | Specifies a date formula for automatic renewal after initial term and the rhythm of the update of “Notice possible to” and “Term Until”. via Page 8090 “Contract Analysis Entries” | |
| 23 | 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 8090 “Contract Analysis Entries” | |
| 24 | Cancellation Possible Until | Date | Specifies the last date for a timely termination. The date is determined by the initial term, extension term and a notice period. An initial term of 12 months and a 3-month notice period means that the deadline for a notice of termination is after 9 months. An extension period of 12 months postpones… via Page 8090 “Contract Analysis Entries” | |
| 25 | Term Until | Date | Specifies the earliest regular date for the end of the Subscription Line, taking into account the initial term, extension term and a notice period. An initial term of 24 months results in a fixed term of 2 years. An extension period of 12 months postpones this date by 12 months. via Page 8090 “Contract Analysis Entries” | |
| 27 | Subscription Contract Line No. | Integer | Specifies the value of the Contract Line No. field. via Page 8090 “Contract Analysis Entries” | TableRelation Table 8062 “Cust. Sub. Contract Line”, Table 8065 “Vend. Sub. Contract Line” (if (Partner = const(Customer)) “Cust. Sub. Contract Line”.“Line No.” where(“Subscription Contract No.” = field(“Subscription Contract No.”)) else if (Partner = const(Vendor)) “Vend. Sub. Contract Line”.“Line No.” where(“Subscription Contract No.” = field(“Subscription Contract No.”))) |
| 31 | Price (LCY) | Decimal | Specifies the price of the Subscription Line in client currency related to quantity of 1 in the billing period. The price is calculated from Base Price and Base Price %. via Page 8090 “Contract Analysis Entries” | not editable |
| 32 | Discount Amount (LCY) | Decimal | Specifies the discount amount in client currency that is granted on the Subscription Line. via Page 8090 “Contract Analysis Entries” | not editable |
| 33 | Amount (LCY) | Decimal | Specifies the amount in client currency for the Subscription Line including discount. via Page 8090 “Contract Analysis Entries” | not editable |
| 34 | Currency Code | Code[10] | Specifies the currency of amounts in the Subscription Line. via Page 8090 “Contract Analysis Entries” | TableRelation Table 4 “Currency”; not editable |
| 35 | Currency Factor | Decimal | Specifies the currency factor valid for the Subscription Line, which is used to convert amounts to the client currency. via Page 8090 “Contract Analysis Entries” | not editable |
| 36 | Currency Factor Date | Date | Specifies the date when the currency factor was last updated. via Page 8090 “Contract Analysis Entries” | not editable |
| 37 | Calculation Base Amount (LCY) | Decimal | Specifies the basis on which the price is calculated in client currency. via Page 8090 “Contract Analysis Entries” | not editable |
| 38 | Discount | Boolean | Specifies whether the Subscription Line is used as a basis for periodic invoicing or discounts. via Page 8090 “Contract Analysis Entries” | not editable |
| 39 | Quantity | Decimal | Specifies the value of the Quantity field. via Page 8090 “Contract Analysis Entries” | not editable |
| 100 | Unit Cost | Decimal | — | not editable |
| 101 | Unit Cost (LCY) | Decimal | Specifies the unit cost of the item. via Page 8090 “Contract Analysis Entries” | not editable |
| 202 | Renewal Term | DateFormula | Specifies a date formula by which the Contract Line is renewed and the end of the Contract Line is extended. It is automatically preset with the initial term of the Subscription Line and can be changed manually. via Page 8090 “Contract Analysis Entries” | |
| 480 | Dimension Set ID | Integer | Specifies the value of the Dimension Set ID field. via Page 8090 “Contract Analysis Entries” | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 1000 | Analysis Date | Date | Specifies the period in which the entry is evaluated. via Page 8090 “Contract Analysis Entries” | |
| 1001 | Monthly Recurr. Revenue (LCY) | Decimal | Specifies the monthly recurring amount in local currency. via Page 8090 “Contract Analysis Entries” | |
| 1002 | Monthly Recurring Cost (LCY) | Decimal | Specifies the monthly recurring costs in local currency. via Page 8090 “Contract Analysis Entries” | |
| 1005 | Subscription Line Entry No. | Integer | Specifies the value of the Subscription Line Line No. field. via Page 8090 “Contract Analysis Entries” | |
| 1006 | Partner No. | Code[20] | Specifies the number of the partner who will receive the contract components and be billed by default. via Page 8090 “Contract Analysis Entries” | TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (Partner = const(Customer)) Customer else if (Partner = const(Vendor)) Vendor) |
| 8000 | Usage Based Billing | Boolean | Specifies whether usage data is used as the basis for billing via contracts. via Page 8090 “Contract Analysis Entries” | |
| 8007 | Sub. Header Source Type | Enum “Service Object Type” | Specifies the Source Type of the Subscription. via Page 8090 “Contract Analysis Entries” | enum Enum 8019 “Service Object Type” |
| 8008 | Sub. Header Source No. | Code[20] | Specifies the Source No. of the Subscription. via Page 8090 “Contract Analysis Entries” | |
| 8009 | Service Object Item No. | Code[20] | Specifies the Item No. of the Subscription. via Page 8090 “Contract Analysis Entries” | obsolete Pending 26.0; #if not CLEANSCHEMA29 |
| 8010 | Subscription Description | Text[100] | Specifies the value of the Subscription Description field. via Page 8090 “Contract Analysis Entries” |
Keys
- PK: Entry No. (clustered)
Events published
OnAfterInitFromServiceCommitment(var ContractAnalysisEntry: Record "Sub. Contr. Analysis Entry"; ServiceCommitment: Record "Subscription Line")(integration)
Procedures
InitFromServiceCommitment(ServiceCommitment: Record "Subscription Line")(internal)CalculateMonthlyRecurringRevenue(ServiceCommitment: Record "Subscription Line")(internal)CalculateMonthlyRecurringCost(ServiceCommitment: Record "Subscription Line")(internal)
Plus 1 local procedures.
Relations
- drill-down page Page 8090 “Contract Analysis Entries”
- lookup page Page 8090 “Contract Analysis Entries”
- Partner No.: TableRelation Table 18 “Customer” (conditional)
- Partner No.: TableRelation Table 23 “Vendor” (conditional)
- Currency Code: TableRelation Table 4 “Currency”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract” (conditional)
- Template: TableRelation Table 8054 “Sub. Package Line Template”
- Subscription Package Code: TableRelation Table 8055 “Subscription Package”
- Subscription Header No.: TableRelation Table 8057 “Subscription Header”
- Subscription Contract Line No.: TableRelation Table 8062 “Cust. Sub. Contract Line” (conditional)
- Subscription Contract No.: TableRelation Table 8063 “Vendor Subscription Contract” (conditional)
- Subscription Contract Line No.: TableRelation Table 8065 “Vend. Sub. Contract Line” (conditional)
Pages and codeunits on this table
- Page 8087 “Contr. Analysis Entries API” (source table)
- Page 8090 “Contract Analysis Entries” (source table)
Recent changes
- 2026-08-27 #10675 Temporarily suppress AS0072 (ObsoleteTag 29.0) on 10 Base App elements for v30 prep (main, BC30, fix)
Deprecations
- field Service Object Item No.: Pending 26.0 (#if not CLEANSCHEMA29), “Replaced by field Subscription 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: "Sub. Contr. Analysis Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.