Table 8059 "Subscription Line"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29present
- BC30changed
Neighbourhood 31 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 8014 “Service Commitments List” (3 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Subscription Line |
| DataClassification | CustomerContent |
| LookupPageId | Service Commitments List |
| DrillDownPageId | Service Commitments List |
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 | Subscription Header No. | Code[20] | Specifies the value of the Subscription No. field. via Page 8014 “Service Commitments List” | TableRelation Table 8057 “Subscription Header” (Subscription Header) |
| 2 | Entry No. | Integer | Specifies the value of the Entry No. field. via Page 8014 “Service Commitments List” | AutoIncrement |
| 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 8014 “Service Commitments List” | 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 8014 “Service Commitments List” | 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 8014 “Service Commitments List” | |
| 6 | Subscription Line Start Date | Date | Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8014 “Service Commitments List” | |
| 7 | Subscription Line End Date | Date | Specifies the date up to which the Subscription Line is valid. via Page 8014 “Service Commitments List” | |
| 8 | Next Billing Date | Date | Specifies the date of the next billing possible. via Page 8014 “Service Commitments List” | not editable |
| 9 | Calculation Base Amount | Decimal | Specifies the base amount from which the price will be calculated. via Page 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | not editable |
| 12 | Discount % | Decimal | Specifies the percent of the discount for the Subscription Line. via Page 8014 “Service Commitments List” | |
| 13 | Discount Amount | Decimal | Specifies the amount of the discount for the Subscription Line. via Page 8014 “Service Commitments List” | |
| 14 | Amount | Decimal | Specifies the amount for the Subscription Line including discount. via Page 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 16 | Invoicing via | Enum “Invoicing Via” | Specifies whether the Subscription Line is invoiced via a contract. Subscription Lines with invoicing via sales are not charged. Only the items are billed. via Page 8014 “Service Commitments List” | enum Enum 8051 “Invoicing Via” |
| 17 | Invoicing Item No. | Code[20] | Specifies the value of the Invoicing Item No. field. via Page 8014 “Service Commitments List” | 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 8014 “Service Commitments List” | 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 8014 “Service Commitments List” | TableRelation Table 8052 “Customer Subscription Contract”, Table 8063 “Vendor Subscription Contract” (if (Partner = const(Customer)) “Customer Subscription Contract” where(“Sell-to Customer No.” = field(“Sub. Header Customer 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 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 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 8014 “Service Commitments List” | |
| 26 | Sub. Header Customer No. | Code[20] | Specifies the value of the Subscription Customer No. field. via Page 8014 “Service Commitments List” | FlowField: lookup(“Subscription Header”.“End-User Customer No.” where(“No.” = field(“Subscription Header No.”))); not editable |
| 27 | Subscription Contract Line No. | Integer | Specifies the value of the Contract Line No. field. via Page 8014 “Service Commitments List” | 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.”))) |
| 29 | Shortcut Dimension 1 Code | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 30 | Shortcut Dimension 2 Code | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 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 8014 “Service Commitments List” | not editable |
| 32 | Discount Amount (LCY) | Decimal | Specifies the discount amount in client currency that is granted on the Subscription Line. via Page 8014 “Service Commitments List” | not editable |
| 33 | Amount (LCY) | Decimal | Specifies the amount in client currency for the Subscription Line including discount. via Page 8014 “Service Commitments List” | not editable |
| 34 | Currency Code | Code[10] | Specifies the currency of amounts in the Subscription Line. via Page 8014 “Service Commitments List” | 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 8014 “Service Commitments List” | not editable |
| 36 | Currency Factor Date | Date | Specifies the date when the currency factor was last updated. via Page 8014 “Service Commitments List” | not editable |
| 37 | Calculation Base Amount (LCY) | Decimal | Specifies the basis on which the price is calculated in client currency. via Page 8014 “Service Commitments List” | not editable |
| 38 | Discount | Boolean | Specifies whether the Subscription Line is used as a basis for periodic invoicing or discounts. via Page 8014 “Service Commitments List” | |
| 39 | Quantity | Decimal | Specifies the value of the Quantity field. via Page 8014 “Service Commitments List” | FlowField: lookup(“Subscription Header”.Quantity where(“No.” = field(“Subscription Header No.”))); not editable |
| 40 | Create Contract Deferrals | Enum “Create Contract Deferrals” | Specifies whether this Subscription Line should generate contract deferrals. If it is set to No, no deferrals are generated and the invoices are posted directly to profit or loss. via Page 8014 “Service Commitments List” | enum Enum 8020 “Create Contract Deferrals” |
| 42 | Customer Price Group | Code[10] | Specifies the value of the Customer Price Group field. via Page 8014 “Service Commitments List” | TableRelation Table 6 “Customer Price Group” (Customer Price Group); not editable |
| 50 | Next Price Update | Date | Specifies the date of the next price update. via Page 8064 “Service Commitments” | |
| 51 | Exclude from Price Update | Boolean | Specifies whether this line is considered in by the Contract Price Update. Setting it to yes will exclude the line from all price updates. via Page 8064 “Service Commitments” | |
| 52 | Price Binding Period | DateFormula | Specifies the period the price will not be changed after the price update. It sets a new “Next Price Update” in the contract line after the price update has been performed. via Page 8064 “Service Commitments” | |
| 59 | Period Calculation | enum “Period Calculation” | Specifies the Period Calculation, which controls how a period is determined for billing. The calculation of a month from 28.02. can extend to 27.03. (Align to Start of Month) or 30.03. (Align to End of Month). via Page 8014 “Service Commitments List” | enum Enum 8005 “Period Calculation” |
| 60 | Variant Code | Code[10] | Specifies the Variant Code of the Subscription. | FlowField: lookup(“Subscription Header”.“Variant Code” where(“No.” = field(“Subscription Header No.”))); not editable |
| 107 | Closed | Boolean | — | |
| 100 | Unit Cost | Decimal | — | not editable |
| 101 | Unit Cost (LCY) | Decimal | Specifies the unit cost of the item. via Page 8014 “Service Commitments List” | |
| 200 | Planned Sub. Line exists | Boolean | Specifies if a planned Renewal exists for the Subscription Line. via Page 8014 “Service Commitments List” | FlowField: exist(“Planned Subscription Line” where(“Entry No.” = field(“Entry No.”))); 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 8014 “Service Commitments List” | |
| 210 | Selected | Boolean | Specifies that the Subscription Line is to be called up in the purchase invoice. via Page 8095 “Get Vendor Contract Lines” | |
| 211 | Indent | Integer | — | |
| 480 | Dimension Set ID | Integer | Specifies the value of the Dimension Set ID field. via Page 8014 “Service Commitments List” | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 8000 | Usage Based Billing | Boolean | Specifies whether usage data is used as the basis for billing via contracts. via Page 8064 “Service Commitments” | not editable |
| 8001 | Usage Based Pricing | Enum “Usage Based Pricing” | Specifies the method for customer based pricing. via Page 8064 “Service Commitments” | enum Enum 8007 “Usage Based Pricing”; not editable |
| 8002 | Pricing Unit Cost Surcharge % | Decimal | Specifies the surcharge in percent for the debit-side price calculation, if a unit cost surcharge is to be used. via Page 8064 “Service Commitments” | not editable |
| 8003 | Supplier Reference Entry No. | Integer | Specifies the sequence number of the related reference. via Page 8064 “Service Commitments” | TableRelation Table 8015 “Usage Data Supplier Reference” (“Usage Data Supplier Reference” where(Type = const(Subscription))); not editable |
| 8006 | Created in Contract line | Boolean | Specifies whether the Subscription was created by creating a Contract line manually. via Page 8014 “Service Commitments List” | not editable |
| 8007 | Source Type | Enum “Service Object Type” | Specifies the type of the Subscription. via Page 8014 “Service Commitments List” | FlowField: lookup(“Subscription Header”.Type where(“No.” = field(“Subscription Header No.”))); enum Enum 8019 “Service Object Type”; not editable |
| 8008 | Source No. | Code[20] | Specifies the No. of the Item or G/L Account of the Subscription. via Page 8014 “Service Commitments List” | FlowField: lookup(“Subscription Header”.“Source No.” where(“No.” = field(“Subscription Header No.”))); not editable |
| 8009 | Item No. | Code[20] | Specifies the value of the Item No. field. via Page 8014 “Service Commitments List” | obsolete Pending 26.0; #if not CLEANSCHEMA29; FlowField: lookup(“Subscription Header”.“Item No.” where(“No.” = field(“Subscription Header No.”))); not editable |
| 8010 | Subscription Description | Text[100] | Specifies the value of the Subscription Description field. via Page 8014 “Service Commitments List” | FlowField: lookup(“Subscription Header”.Description where(“No.” = field(“Subscription Header No.”))); not editable |
Keys
- PK: Entry No. (clustered)
- Contract: Subscription Contract No., Subscription Contract Line No.
- Key3: Subscription Header No., Partner
- Key4: Supplier Reference Entry No., Subscription Line Start Date
Events published
OnAfterUpdateNextBillingDate(var SubscriptionLine: Record "Subscription Line"; LastBillingToDate: Date)(integration)OnAfterCheckSubscriptionLineStartDateChangeAllowed(SubscriptionLine: Record "Subscription Line")(integration): Raised after the Subscription Line Start Date change has passed the billing state check. Subscribers can only tighten the rule, by raising an error of their own.OnAfterSetUsageDataBillingFilters(var UsageDataBilling: Record "Usage Data Billing"; SubscriptionLine: Record "Subscription Line"; BillingFromDate: Date; BillingToDate: Date)(integration)OnAfterCalculateServiceAmount(var SubscriptionLine: Record "Subscription Line"; CalledByFieldNo: Integer)(integration)OnAfterUpdateSubscriptionLine(var SubscriptionLine: Record "Subscription Line")(integration)OnAfterGetCombinedDimensionSetID(var SubscriptionLine: Record "Subscription Line")(integration)OnBeforeValidateShortcutDimCode(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnAfterValidateShortcutDimCode(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeValidateDimensionSetID(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line")(integration)OnAfterValidateDimensionSetID(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line")(integration)OnAfterCopyFromSalesSubscriptionLine(var SubscriptionLine: Record "Subscription Line"; SalesSubscriptionLine: Record "Sales Subscription Line")(integration)OnBeforeCheckServiceDates(ServiceStartDate: Date; ServiceEndDate: Date; NextBillingDate: Date; var IsHandled: Boolean)(integration)OnAfterUpdateServiceCommitmentFromContractPriceUpdateLine(var SubscriptionLine: Record "Subscription Line"; SubContractPriceUpdateLine: Record "Sub. Contr. Price Update Line")(integration)
Procedures
CheckServiceDates()(internal)CheckServiceDates(ServiceStartDate: Date; ServiceEndDate: Date; NextBillingDate: Date)(internal)ClearTerminationPeriodsWhenServiceEnded()(internal)CalculateSubscriptionDates()(internal)CalculateServiceEndDate()(internal)CalculateTermUntilDate()(internal)CalculateTermUntilUsingExtensionTerm(): Boolean(internal)CalculateCancellationPossibleUntil(): Boolean(internal)GetReferenceDate(): Date(internal)CalculatePrice()(internal)CalculateServiceAmount(CalledByFieldNo: Integer)(internal)SetUpdateRequiredOnBillingLines()(internal)UpdateNextBillingDate(LastBillingToDate: Date)(internal)RecalculateAmountsFromCurrencyData()(internal)ResetAmountsAndCurrencyFromLCY()(internal)SetLCYFields(IncludeUnitCost: Boolean)(internal)IsNoticePeriodEmpty(): Boolean(internal)UpdateServiceCommitment(CalledByFieldNo: Integer)(internal)EditDimensionSet()(internal)SetDefaultDimensions(UseSource: Boolean)(internal)ApplyContractDimensions(ContractDimSetID: Integer; SourceCode: Code[10]; ContractPartnerTableID: Integer)(internal)GetCombinedDimensionSetID(DimSetID1: Integer; DimSetID2: Integer)(internal)UpdateRelatedVendorServiceCommDimensions(OldDimSetID: Integer; NewDimSetID: Integer)(internal)FilterOnServiceObjectAndTemplate(ServiceObjectNo: Code[20]; ServiceTemplate: Code[20]; ServicePartner: Enum "Service Partner")(internal)FilterOnServiceObjectAndPackage(ServiceObjectNo: Code[20]; ServiceTemplate: Code[20]; PackageCode: Code[20]; ServicePartner: Enum "Service Partner")(internal)NewLineForServiceObject()(internal)InitForServiceObject(ServiceObject: Record "Subscription Header"; ServicePartner: enum "Service Partner")(internal)UpdateFromCustomerContract(CustomerContract: Record "Customer Subscription Contract")(internal)UpdateFromVendorContract(VendorContract: Record "Vendor Subscription Contract")(internal)CopyFromSalesServiceCommitment(SalesServiceCommitment: Record "Sales Subscription Line")(internal)TestServiceCommitmentsCurrencyCode(var ServiceCommitment: Record "Subscription Line" temporary)(internal)OpenExchangeSelectionPage(var NewCurrencyFactorDate: Date; var NewCurrencyFactor: Decimal; CurrencyCode: Code[10]; NewMessageTxt: Text; CalledFromServiceObject: Boolean): BooleanResetServiceCommitmentCurrencyLCYFromContract(PartnerType: Enum "Service Partner"; ContractNo: Code[20])(internal)UpdateAndRecalculateServCommCurrencyFromContract(PartnerType: Enum "Service Partner"; ContractNo: Code[20]; CurrencyFactor: Decimal; CurrencyFactorDate: Date; CurrencyCode: Code[10])(internal)UpdateCurrencyDataOnServiceCommitments(var ServiceCommitment: Record "Subscription Line"; CurrencyFactor: Decimal; CurrencyFactorDate: Date; CurrencyCode: Code[10]; UpdateCurrencyCodeOnServiceCommitment: Boolean)(internal)FilterOnContract(PartnerType: Enum "Service Partner"; ContractNo: Code[20])(internal)SetCurrencyData(CurrencyFactor: Decimal; CurrencyFactorDate: Date; CurrencyCode: Code[10])(internal)EnsureCalculationBaseAmountExcludesVAT(SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header")(internal)ErrorIfBillingLineForServiceCommitmentExist()(internal)GetPartnerNoFromContract(): Code[20](internal)ErrorIfBillingLineArchiveForServiceCommitmentExist()(internal)ArchiveServiceCommitment()(internal)ArchiveServiceCommitment(PerformUpdateOn: Date; TypeOfPriceUpdate: Enum "Type Of Price Update")(internal)ArchiveServiceCommitmentFromServiceObject(xServiceObject: Record "Subscription Header"; ServiceObject: Record "Subscription Header")(internal)CreateServiceCommitmentArchive(var ServiceCommitmentArchive: Record "Subscription Line Archive"; xServiceCommitment: Record "Subscription Line"; PerformUpdateOn: Date; TypeOfPriceUpdate: Enum "Type Of Price Update")(internal)IsPartnerCustomer(): Boolean(internal)IsPartnerVendor(): Boolean(internal)CalculateCalculationBaseAmount()(internal)RefreshRenewalTerm()(internal)IsFullyInvoiced(): Boolean(internal)SetSkipArchiving(NewSkipArchiving: Boolean)(internal)UpdateNextPriceUpdate()(internal)SetSkipTestPackageCode(NewSkipTestPackageCode: Boolean)(internal)ModifyExcludeFromPriceUpdateInAllRelatedServiceCommitments(ServicePartner: Enum "Service Partner"; ContractNo: Code[20]; NewExcludeFromPriceUpdate: Boolean)(internal)CalculateUnitCost()(internal)UpdateServiceCommitmentFromContractPriceUpdateLine(ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line")(internal)ServiceCommitmentArchiveExistsForPeriodExists(var ServiceCommitmentArchive: Record "Subscription Line Archive"; RecurringBillingFrom: Date; RecurringBillingTo: Date): Boolean(internal)UpdateServiceCommitmentFromServiceCommitmentArchive(ServiceCommitmentArchive: Record "Subscription Line Archive")(internal)SetPerformUpdateForContractPriceUpdate(var PerformUpdate: Boolean; TypeOfPriceUpdate: Enum "Type Of Price Update"; PerformUpdateOn: Date)(internal)UnpostedDocumentExists(): Boolean(internal)BillingLineExists(): Boolean(internal)DisconnectContractLine(EntryNo: Integer)(internal)DeleteOrDisconnectServiceCommitment(EntryNo: Integer)(internal)IsUsageDataBillingFound(var UsageDataBilling: Record "Usage Data Billing"; BillingFromDate: Date; BillingToDate: Date): Boolean(internal)SetUsageDataBillingFilters(var UsageDataBilling: Record "Usage Data Billing"; BillingFromDate: Date; BillingToDate: Date)(internal)IsUsageBasedBillingValid(): Boolean(internal)GetUsageDataChargeEndDateCrossingPeriodEnd(BillingFromDate: Date; BillingToDate: Date): Date(internal)GetSupplierChargeEndDateIfRebillingMetadataExist(FromDate: Date): Date(internal)GetLastSupplierChargeEndDateIfMetadataExist(): Date(internal)GetSupplierChargeStartDateIfRebillingMetadataExist(FromDate: Date): Date(internal)ShowUsageDataBillingMetadata()(internal)UnitPriceForPeriod(ChargePeriodStart: Date; ChargePeriodEnd: Date): DecimalUnitPriceAndCostForPeriod(BillingRhythm: DateFormula; ChargePeriodStart: Date; ChargePeriodEnd: Date; var UnitPrice: Decimal; var UnitCost: Decimal; var UnitCostLCY: Decimal; var BillingReferenceDateChanged: Boolean)(internal)CalculatePeriodCountAndDaysCount(PeriodFormula: DateFormula; StartDate: Date; EndDate: Date; var Periods: Integer; var FollowUpDays: Integer; var FollowUpPeriodDays: Integer)(internal)GetBillingPeriodRatio(BillingRhythm: DateFormula; BillingBaseRhytm: DateFormula): Decimal(internal)CalculateNextToDate(PeriodFormula: DateFormula; FromDate: Date): Date(internal)OpenDeferralsExist(): Boolean(internal)
Plus 28 local procedures.
Triggers
OnInsert, OnModify, OnDelete
Relations
- drill-down page Page 8014 “Service Commitments List”
- lookup page Page 8014 “Service Commitments List”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- Planned Sub. Line exists: CalcFormula Table 8002 “Planned Subscription Line”
- Supplier Reference Entry No.: TableRelation Table 8015 “Usage Data Supplier Reference”
- 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”
- Item No.: CalcFormula Table 8057 “Subscription Header”
- Quantity: CalcFormula Table 8057 “Subscription Header”
- Source No.: CalcFormula Table 8057 “Subscription Header”
- Source Type: CalcFormula Table 8057 “Subscription Header”
- Sub. Header Customer No.: CalcFormula Table 8057 “Subscription Header”
- Subscription Description: CalcFormula Table 8057 “Subscription Header”
- Variant Code: CalcFormula Table 8057 “Subscription Header”
- 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)
Referenced by
18 fields in 9 objects relate to this table (TableRelation or CalcFormula).
- Table 8001 “Sub. Contract Renewal Line”: Amount, Billing Rhythm, Currency Code, Partner, Price, Subscription Line Description, Subscription Line End Date, Subscription Line Start Date, Subscription Line Entry No.
- Table 8070 “Subscription Billing Cue”: Sub. L. wo Cust. Sub. Contract, Sub. L. wo Vend. Sub. Contract
- Table 8016 “Usage Data Supp. Subscription”: Subscription Line Entry No.
- Table 8021 “Usage Data Billing Metadata”: Subscription Line Entry No.
- Table 8022 “Contract Billing Err. Log”: Subscription Entry No.
- Table 8061 “Billing Line”: Subscription Line Entry No.
- Table 8062 “Cust. Sub. Contract Line”: Subscription Line Entry No.
- Table 8065 “Vend. Sub. Contract Line”: Subscription Line Entry No.
- Table 8068 “Sales Subscription Line”: Subscription Line Entry No.
Pages and codeunits on this table
- Page 8014 “Service Commitments List” (source table)
- Page 8018 “Service Commitments API” (source table)
- Page 8064 “Service Commitments” (source table)
- Page 8069 “Serv. Comm. WO Cust. Contract” (source table)
- Page 8076 “Serv. Comm. WO Vend. Contract” (source table)
- Page 8095 “Get Vendor Contract Lines” (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-09-22 #11679 [29.x][Subscription Billing] 1M ‘Align to End of Month’ line with end date produces a 1-day prorated stub (releases/29.x, BC29, fix)
- 2026-09-18 #11399 [master][Subscription Billing] 1M ‘Align to End of Month’ line with end date produces a 1-day prorated stub (main, BC30, fix)
- 2026-09-17 #9225 [Extensibility][SubscriptionBilling]: Make usage data billing filtering extensible in SetUsageDataBillingFilters (main, BC30, feature)
- 2026-09-11 #10970 [Master] -SubBilling BillingLine doesn’t consider entries for usage date ranges crossing periods (main, BC30, fix)
- 2026-09-10 #11218 [master] - Subscription Contract Price Update applies the lowest sales price across all Unit of Measure codes instead of respecting Unit-Specific Price List entries in Subscription Billing. (main, BC30, fix)
- 2026-08-29 #10235 [Bug][SubscriptionBilling] Enforce Subscription Line Start Date change rules on all edit paths (main, BC30, fix)
- 2026-08-27 #10675 Temporarily suppress AS0072 (ObsoleteTag 29.0) on 10 Base App elements for v30 prep (main, BC30, fix)
- 2026-08-27 #10608 [master]-Bug 647093-[Subscription Billing] Incorrect Invoice Amounts when using explicit values in Subscription Line End Date (main, BC30, fix)
- 2026-07-30 #8553 [Bug][SubscriptionBilling]: Performance: Billing document creation does not scale to large datasets (4M+ subscription lines) (main, BC30, performance)
- 2026-07-14 #8115 Subscription Billing: respect Default Dimension Priorities on Subscription Lines (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: "Subscription Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.