---
title: "Table 8059 Subscription Line"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/table/8059-subscription-line/
type: table
id: 8059
name: "Subscription Line"
app: "Subscription Billing"
namespace: Microsoft.SubscriptionBilling
versions: "26-29"
build: 29.0.54011.55644
countries: "W1, DE, US"
source: "https://jonas-paprotka.de/ref/table/8059-subscription-line/source/?v=28 https://jonas-paprotka.de/ref/table/8059-subscription-line/source/"
checked: 2026-11-20
changed: 2026-11-17
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Table 8059 Subscription Line

JOP-AL, https://jonas-paprotka.de/ref/table/8059-subscription-line/

| | |
| --- | --- |
| App | Subscription Billing |
| Namespace | Microsoft.SubscriptionBilling |
| Versions | 26-29 |
| Minors | W1 26.0-29.0; DE 26.0-29.0; US 26.0-29.0, [every minor](https://jonas-paprotka.de/ref/table/8059-subscription-line/editions.json) |
| Source file | Service Commitments/Tables/SubscriptionLine.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Subscription Header No. | Code[20] | 26-29 | - | - |
| 2 | Entry No. | Integer | 26-29 | - | - |
| 3 | Subscription Package Code | Code[20] | 26-29 | - | - |
| 4 | Template | Code[20] | 26-29 | - | - |
| 5 | Description | Text[100] | 26-29 | - | - |
| 6 | Subscription Line Start Date | Date | 26-29 | - | - |
| 7 | Subscription Line End Date | Date | 26-29 | - | - |
| 8 | Next Billing Date | Date | 26-29 | - | - |
| 9 | Calculation Base Amount | Decimal | 26-29 | - | - |
| 10 | Calculation Base % | Decimal | 26-29 | - | - |
| 11 | Price | Decimal | 26-29 | - | - |
| 12 | Discount % | Decimal | 26-29 | - | - |
| 13 | Discount Amount | Decimal | 26-29 | - | - |
| 14 | Amount | Decimal | 26-29 | - | - |
| 15 | Billing Base Period | DateFormula | 26-29 | - | - |
| 16 | Invoicing via | Enum Invoicing Via | 26-29 | - | - |
| 17 | Invoicing Item No. | Code[20] | 26-29 | - | - |
| 18 | Partner | Enum Service Partner | 26-29 | - | - |
| 19 | Subscription Contract No. | Code[20] | 26-29 | - | - |
| 20 | Notice Period | DateFormula | 26-29 | - | - |
| 21 | Initial Term | DateFormula | 26-29 | - | - |
| 22 | Extension Term | DateFormula | 26-29 | - | - |
| 23 | Billing Rhythm | DateFormula | 26-29 | - | - |
| 24 | Cancellation Possible Until | Date | 26-29 | - | - |
| 25 | Term Until | Date | 26-29 | - | - |
| 26 | Sub. Header Customer No. | Code[20] | 26-29 | - | - |
| 27 | Subscription Contract Line No. | Integer | 26-29 | - | - |
| 29 | Shortcut Dimension 1 Code | Code[20] | 26-29 | - | - |
| 30 | Shortcut Dimension 2 Code | Code[20] | 26-29 | - | - |
| 31 | Price (LCY) | Decimal | 26-29 | - | - |
| 32 | Discount Amount (LCY) | Decimal | 26-29 | - | - |
| 33 | Amount (LCY) | Decimal | 26-29 | - | - |
| 34 | Currency Code | Code[10] | 26-29 | - | - |
| 35 | Currency Factor | Decimal | 26-29 | - | - |
| 36 | Currency Factor Date | Date | 26-29 | - | - |
| 37 | Calculation Base Amount (LCY) | Decimal | 26-29 | - | - |
| 38 | Discount | Boolean | 26-29 | - | - |
| 39 | Quantity | Decimal | 26-29 | - | - |
| 40 | Create Contract Deferrals | Enum Create Contract Deferrals | 26-29 | - | - |
| 42 | Customer Price Group | Code[10] | 26-29 | - | - |
| 50 | Next Price Update | Date | 26-29 | - | - |
| 51 | Exclude from Price Update | Boolean | 26-29 | - | - |
| 52 | Price Binding Period | DateFormula | 26-29 | - | - |
| 59 | Period Calculation | Enum Period Calculation | 26-29 | - | - |
| 60 | Variant Code | Code[10] | 28-29 | - | - |
| 100 | Unit Cost | Decimal | 26-29 | - | - |
| 101 | Unit Cost (LCY) | Decimal | 26-29 | - | - |
| 107 | Closed | Boolean | 26-29 | - | - |
| 200 | Planned Sub. Line exists | Boolean | 26-29 | - | - |
| 202 | Renewal Term | DateFormula | 26-29 | - | - |
| 210 | Selected | Boolean | 26-29 | - | - |
| 211 | Indent | Integer | 26-29 | - | - |
| 480 | Dimension Set ID | Integer | 26-29 | - | - |
| 8000 | Usage Based Billing | Boolean | 26-29 | - | - |
| 8001 | Usage Based Pricing | Enum Usage Based Pricing | 26-29 | - | - |
| 8002 | Pricing Unit Cost Surcharge % | Decimal | 26-29 | - | - |
| 8003 | Supplier Reference Entry No. | Integer | 26-29 | - | - |
| 8006 | Created in Contract line | Boolean | 26-29 | - | - |
| 8007 | Source Type | Enum Service Object Type | 26-29 | - | - |
| 8008 | Source No. | Code[20] | 26-29 | - | - |
| 8009 | Item No. | Code[20] | 26-29 | Pending 26.0 | Replaced by field Source No. |
| 8010 | Subscription Description | Text[100] | 26-29 | - | - |

## Keys

| Name | Fields | Sum fields | Versions |
| --- | --- | --- | --- |
| PK, clustered | Entry No. | - | 26-29 |
| Contract | Subscription Contract No., Subscription Contract Line No. | - | 26-29 |
| Key3 | Subscription Header No., Partner | - | 27-29 |
| Key4 | Supplier Reference Entry No., Subscription Line Start Date | - | 28-29 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| CheckServiceDates | () | - | internal | 26-29 | - | - |
| CheckServiceDates | (ServiceStartDate: Date; ServiceEndDate: Date; NextBillingDate: Date) | - | internal | 26-29 | - | - |
| ClearTerminationPeriodsWhenServiceEnded | () | - | internal | 26-29 | - | - |
| CalculateInitialServiceEndDate | () | - | internal | 26 | - | - |
| CalculateInitialCancellationPossibleUntilDate | () | - | internal | 26 | - | - |
| CalculateInitialTermUntilDate | () | - | internal | 26 | - | - |
| GetReferenceDate | () | Date | internal | 26-29 | - | - |
| UpdateTermUntilUsingExtensionTerm | () | Boolean | internal | 26 | - | - |
| UpdateCancellationPossibleUntil | () | Boolean | internal | 26 | - | - |
| CalculatePrice | () | - | internal | 26-29 | - | - |
| CalculateServiceAmount | (CalledByFieldNo: Integer) | - | internal | 26-29 | - | - |
| UpdateNextBillingDate | (LastBillingToDate: Date) | - | internal | 26-29 | - | - |
| RecalculateAmountsFromCurrencyData | () | - | internal | 26-29 | - | - |
| ResetAmountsAndCurrencyFromLCY | () | - | internal | 26-29 | - | - |
| SetLCYFields | (IncludeUnitCost: Boolean) | - | internal | 26-29 | - | - |
| IsNoticePeriodEmpty | () | Boolean | internal | 26-29 | - | - |
| UpdateServiceCommitment | (CalledByFieldNo: Integer) | - | internal | 26-29 | - | - |
| EditDimensionSet | () | - | internal | 26-29 | - | - |
| SetDefaultDimensions | (UseSource: Boolean) | - | internal | 26-29 | - | - |
| GetCombinedDimensionSetID | (DimSetID1: Integer; DimSetID2: Integer) | - | internal | 26-29 | - | - |
| UpdateRelatedVendorServiceCommDimensions | (OldDimSetID: Integer; NewDimSetID: Integer) | - | internal | 26-29 | - | - |
| FilterOnServiceObjectAndTemplate | (ServiceObjectNo: Code[20]; ServiceTemplate: Code[20]; ServicePartner: Enum "Service Partner") | - | internal | 26-29 | - | - |
| FilterOnServiceObjectAndPackage | (ServiceObjectNo: Code[20]; ServiceTemplate: Code[20]; PackageCode: Code[20]; ServicePartner: Enum "Service Partner") | - | internal | 26-29 | - | - |
| NewLineForServiceObject | () | - | internal | 26-29 | - | - |
| InitForServiceObject | (ServiceObject: Record "Subscription Header"; ServicePartner: Enum "Service Partner") | - | internal | 26-29 | - | - |
| UpdateFromCustomerContract | (CustomerContract: Record "Customer Subscription Contract") | - | internal | 26-29 | - | - |
| UpdateFromVendorContract | (VendorContract: Record "Vendor Subscription Contract") | - | internal | 26-29 | - | - |
| CopyFromSalesServiceCommitment | (SalesServiceCommitment: Record "Sales Subscription Line") | - | internal | 26-29 | - | - |
| TestServiceCommitmentsCurrencyCode | (var ServiceCommitment: Record "Subscription Line" temporary) | - | internal | 26-29 | - | - |
| OpenExchangeSelectionPage | (var NewCurrencyFactorDate: Date; var NewCurrencyFactor: Decimal; CurrencyCode: Code[10]; NewMessageTxt: Text; CalledFromServiceObject: Boolean) | Boolean | public | 26-29 | - | - |
| ResetServiceCommitmentCurrencyLCYFromContract | (PartnerType: Enum "Service Partner"; ContractNo: Code[20]) | - | internal | 26-29 | - | - |
| UpdateAndRecalculateServCommCurrencyFromContract | (PartnerType: Enum "Service Partner"; ContractNo: Code[20]; CurrencyFactor: Decimal; CurrencyFactorDate: Date; CurrencyCode: Code[10]) | - | internal | 26-29 | - | - |
| UpdateCurrencyDataOnServiceCommitments | (var ServiceCommitment: Record "Subscription Line"; CurrencyFactor: Decimal; CurrencyFactorDate: Date; CurrencyCode: Code[10]; UpdateCurrencyCodeOnServiceCommitment: Boolean) | - | internal | 26-29 | - | - |
| FilterOnContract | (PartnerType: Enum "Service Partner"; ContractNo: Code[20]) | - | internal | 26-29 | - | - |
| SetCurrencyData | (CurrencyFactor: Decimal; CurrencyFactorDate: Date; CurrencyCode: Code[10]) | - | internal | 26-29 | - | - |
| ErrorIfBillingLineForServiceCommitmentExist | () | - | internal | 26-29 | - | - |
| GetPartnerNoFromContract | () | Code[20] | internal | 26-29 | - | - |
| ErrorIfBillingLineArchiveForServiceCommitmentExist | () | - | internal | 26-29 | - | - |
| ArchiveServiceCommitment | () | - | internal | 26-29 | - | - |
| ArchiveServiceCommitment | (PerformUpdateOn: Date; TypeOfPriceUpdate: Enum "Type Of Price Update") | - | internal | 26-29 | - | - |
| ArchiveServiceCommitmentFromServiceObject | (xServiceObject: Record "Subscription Header"; ServiceObject: Record "Subscription Header") | - | internal | 26-29 | - | - |
| CreateServiceCommitmentArchive | (var ServiceCommitmentArchive: Record "Subscription Line Archive"; xServiceCommitment: Record "Subscription Line"; PerformUpdateOn: Date; TypeOfPriceUpdate: Enum "Type Of Price Update") | - | internal | 26-29 | - | - |
| IsPartnerCustomer | () | Boolean | internal | 26-29 | - | - |
| IsPartnerVendor | () | Boolean | internal | 26-29 | - | - |
| CalculateCalculationBaseAmount | () | - | internal | 26-29 | - | - |
| IsFullyInvoiced | () | Boolean | internal | 26-29 | - | - |
| SetSkipArchiving | (NewSkipArchiving: Boolean) | - | internal | 26-29 | - | - |
| UpdateNextPriceUpdate | () | - | internal | 26-29 | - | - |
| SetSkipTestPackageCode | (NewSkipTestPackageCode: Boolean) | - | internal | 26-29 | - | - |
| ModifyExcludeFromPriceUpdateInAllRelatedServiceCommitments | (ServicePartner: Enum "Service Partner"; ContractNo: Code[20]; NewExcludeFromPriceUpdate: Boolean) | - | internal | 26-29 | - | - |
| CalculateUnitCost | () | - | internal | 26-29 | - | - |
| UpdateServiceCommitmentFromContractPriceUpdateLine | (ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line") | - | internal | 26-29 | - | - |
| ServiceCommitmentArchiveExistsForPeriodExists | (var ServiceCommitmentArchive: Record "Subscription Line Archive"; RecurringBillingFrom: Date; RecurringBillingTo: Date) | Boolean | internal | 26-29 | - | - |
| UpdateServiceCommitmentFromServiceCommitmentArchive | (ServiceCommitmentArchive: Record "Subscription Line Archive") | - | internal | 26-29 | - | - |
| SetPerformUpdateForContractPriceUpdate | (var PerformUpdate: Boolean; TypeOfPriceUpdate: Enum "Type Of Price Update"; PerformUpdateOn: Date) | - | internal | 26-29 | - | - |
| UnpostedDocumentExists | () | Boolean | internal | 26-29 | - | - |
| BillingLineExists | () | Boolean | internal | 26-29 | - | - |
| DisconnectContractLine | (EntryNo: Integer) | - | internal | 26-29 | - | - |
| DeleteOrDisconnectServiceCommitment | (EntryNo: Integer) | - | internal | 26-29 | - | - |
| IsUsageDataBillingFound | (var UsageDataBilling: Record "Usage Data Billing"; BillingFromDate: Date; BillingToDate: Date) | Boolean | internal | 26-29 | - | - |
| IsUsageBasedBillingValid | () | Boolean | internal | 26-29 | - | - |
| GetSupplierChargeEndDateIfRebillingMetadataExist | (FromDate: Date) | Date | internal | 26-29 | - | - |
| GetLastSupplierChargeEndDateIfMetadataExist | () | Date | internal | 26-29 | - | - |
| GetSupplierChargeStartDateIfRebillingMetadataExist | (FromDate: Date) | Date | internal | 26-29 | - | - |
| ShowUsageDataBillingMetadata | () | - | internal | 26-29 | - | - |
| UnitPriceForPeriod | (ChargePeriodStart: Date; ChargePeriodEnd: Date) | Decimal | public | 26-29 | - | - |
| UnitPriceAndCostForPeriod | (BillingRhythm: DateFormula; ChargePeriodStart: Date; ChargePeriodEnd: Date; var UnitPrice: Decimal; var UnitCost: Decimal; var UnitCostLCY: Decimal) | - | internal | 26 | - | - |
| CalculatePeriodCountAndDaysCount | (PeriodFormula: DateFormula; StartDate: Date; EndDate: Date; var Periods: Integer; var FollowUpDays: Integer; var FollowUpPeriodDays: Integer) | - | internal | 26-29 | - | - |
| GetBillingPeriodRatio | (BillingRhythm: DateFormula; BillingBaseRhytm: DateFormula) | Decimal | internal | 26-29 | - | - |
| CalculateNextToDate | (PeriodFormula: DateFormula; FromDate: Date) | Date | internal | 26-29 | - | - |
| OpenDeferralsExist | () | Boolean | internal | 26-29 | - | - |
| CalculateSubscriptionDates | () | - | internal | 27-29 | - | - |
| CalculateServiceEndDate | () | - | internal | 27-29 | - | - |
| CalculateTermUntilDate | () | - | internal | 27-29 | - | - |
| CalculateTermUntilUsingExtensionTerm | () | Boolean | internal | 27-29 | - | - |
| CalculateCancellationPossibleUntil | () | Boolean | internal | 27-29 | - | - |
| RefreshRenewalTerm | () | - | internal | 27-29 | - | - |
| UnitPriceAndCostForPeriod | (BillingRhythm: DateFormula; ChargePeriodStart: Date; ChargePeriodEnd: Date; var UnitPrice: Decimal; var UnitCost: Decimal; var UnitCostLCY: Decimal; var BillingReferenceDateChanged: Boolean) | - | internal | 27-29 | - | - |
| SetUpdateRequiredOnBillingLines | () | - | internal | 28-29 | - | - |
| SetUsageDataBillingFilters | (var UsageDataBilling: Record "Usage Data Billing"; BillingFromDate: Date; BillingToDate: Date) | - | internal | 28-29 | - | - |
| ApplyContractDimensions | (ContractDimSetID: Integer; SourceCode: Code[10]; ContractPartnerTableID: Integer) | - | internal | 29 | - | - |
| EnsureCalculationBaseAmountExcludesVAT | (SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header") | - | internal | 29 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterUpdateNextBillingDate | (var SubscriptionLine: Record "Subscription Line"; LastBillingToDate: Date) | 26-29 | - | - |
| Integration event | OnAfterCalculateServiceAmount | (var SubscriptionLine: Record "Subscription Line"; CalledByFieldNo: Integer) | 26-29 | - | - |
| Integration event | OnAfterUpdateSubscriptionLine | (var SubscriptionLine: Record "Subscription Line") | 26-29 | - | - |
| Integration event | OnAfterGetCombinedDimensionSetID | (var SubscriptionLine: Record "Subscription Line") | 26-29 | - | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) | 26-29 | - | - |
| Integration event | OnAfterValidateShortcutDimCode | (var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) | 26-29 | - | - |
| Integration event | OnBeforeValidateDimensionSetID | (var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line") | 26-29 | - | - |
| Integration event | OnAfterValidateDimensionSetID | (var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line") | 26-29 | - | - |
| Integration event | OnAfterCopyFromSalesSubscriptionLine | (var SubscriptionLine: Record "Subscription Line"; SalesSubscriptionLine: Record "Sales Subscription Line") | 26-29 | - | - |
| Integration event | OnBeforeCheckServiceDates | (ServiceStartDate: Date; ServiceEndDate: Date; NextBillingDate: Date; var IsHandled: Boolean) | 26-29 | - | - |
| Integration event | OnAfterUpdateServiceCommitmentFromContractPriceUpdateLine | (var SubscriptionLine: Record "Subscription Line"; SubContractPriceUpdateLine: Record "Sub. Contr. Price Update Line") | 27-29 | - | - |
| Integration event | OnAfterCheckSubscriptionLineStartDateChangeAllowed | (SubscriptionLine: Record "Subscription Line") | 29 | - | - |
| Integration event | OnAfterSetUsageDataBillingFilters | (var UsageDataBilling: Record "Usage Data Billing"; SubscriptionLine: Record "Subscription Line"; BillingFromDate: Date; BillingToDate: Date) | 29 | - | - |

## Trigger events

| Name | Parameters | ElementName | Docs |
| --- | --- | --- | --- |
| OnBeforeInsertEvent | (var Rec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforeinsertevent-table-trigger/ |
| OnAfterInsertEvent | (var Rec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterinsertevent-table-trigger/ |
| OnBeforeModifyEvent | (var Rec: Record "Subscription Line"; var xRec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforemodifyevent-table-trigger/ |
| OnAfterModifyEvent | (var Rec: Record "Subscription Line"; var xRec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onaftermodifyevent-table-trigger/ |
| OnBeforeDeleteEvent | (var Rec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforedeleteevent-table-trigger/ |
| OnAfterDeleteEvent | (var Rec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterdeleteevent-table-trigger/ |
| OnBeforeRenameEvent | (var Rec: Record "Subscription Line"; var xRec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforerenameevent-table-trigger/ |
| OnAfterRenameEvent | (var Rec: Record "Subscription Line"; var xRec: Record "Subscription Line"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterrenameevent-table-trigger/ |
| OnBeforeValidateEvent | (var Rec: Record "Subscription Line"; var xRec: Record "Subscription Line"; CurrFieldNo: Integer) | per field, ElementName: field name | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforevalidateevent-table-trigger/ |
| OnAfterValidateEvent | (var Rec: Record "Subscription Line"; var xRec: Record "Subscription Line"; CurrFieldNo: Integer) | per field, ElementName: field name | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onaftervalidateevent-table-trigger/ |

## Source

Symbols: Microsoft.SubscriptionBilling.symbols.3099ffc7-4cf7-4df6-9b96-7e4bc2bb587c, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-11-20.
AL source 28: https://github.com/microsoft/BCApps, MIT, releases/28.x at 408a4cc8d3a4c54b60464cc14c964479facb9ba0.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
