---
id: object/table/8073
type: object
title: Table 8073 "Subscription Line Archive"
summary: Table 8073 "Subscription Line Archive" in Subscription Billing (Microsoft.SubscriptionBilling). 52 fields, 2 public procedures, 1 events. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - subscription billing
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 2a104e5b0c51041e7934a303b589b7d7628f9f6347c0fa23a46bf3cdd79e956e
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subscription%20Billing/app/Service%20Commitments/Tables/SubscriptionLineArchive.Table.al
    title: src/Apps/W1/Subscription Billing/app/Service Commitments/Tables/SubscriptionLineArchive.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 8073
name: Subscription Line Archive
namespace: Microsoft.SubscriptionBilling
app: Subscription Billing
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 52
  procedures: 3
  events: 1
  subscribers: 0
relations:
  out: 15
  referenced_by: 1
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 8073 "Subscription Line Archive"

> Table 8073 "Subscription Line Archive" in Subscription Billing (Microsoft.SubscriptionBilling). 52 fields, 2 public procedures, 1 events. Introduced in BC29, still in BC30.

Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subscription%20Billing/app/Service%20Commitments/Tables/SubscriptionLineArchive.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Subscription Line Archive |
| DataClassification | CustomerContent |
| LookupPageId | Service Commitment Archive |
| DrillDownPageId | Service Commitment Archive |

## 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 | — | AutoIncrement |
| 2 | Subscription Header No. | Code[20] | Subscription No. <small>caption</small> | TableRelation [Table 8057 "Subscription Header"](../table/8057.md) (Subscription Header) |
| 4 | Original Entry No. | Integer | — |  |
| 5 | Subscription Package Code | Code[20] | — | TableRelation [Table 8055 "Subscription Package"](../table/8055.md) (Subscription Package); not editable; NotBlank |
| 6 | Template | Code[20] | — | TableRelation [Table 8054 "Sub. Package Line Template"](../table/8054.md) (Sub. Package Line Template); not editable; NotBlank |
| 7 | Description | Text[100] | Specifies the description of the Subscription Line. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 8 | Subscription Line Start Date | Date | Specifies the date from which the Subscription Line is valid and will be invoiced. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 9 | Subscription Line End Date | Date | Specifies the date up to which the Subscription Line is valid. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 10 | Next Billing Date | Date | — | not editable |
| 11 | Calculation Base Amount | Decimal | Specifies the base amount from which the price will be calculated. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 12 | 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. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 13 | 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 %. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | not editable |
| 14 | Discount % | Decimal | Specifies the percent of the discount for the Subscription Line. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 15 | Discount Amount | Decimal | Specifies the amount of the discount for the Subscription Line. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 16 | Amount | Decimal | Specifies the amount for the Subscription Line including discount. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 17 | 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. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 18 | Invoicing via | Enum "Invoicing Via" | Specifies whether the Subscription Line will be invoiced using contract or sales document. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | enum [Enum 8051 "Invoicing Via"](../enum/8051.md) |
| 19 | Invoicing Item No. | Code[20] | — | TableRelation Item."No." where("Subscription Option" = filter("Invoicing Item" \| "Service Commitment Item")) |
| 20 | Partner | Enum "Service Partner" | Specifies whether the Subscription Line will will be calculated as a credit (Purchase Invoice) or as debit (Sales Invoice). <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | enum [Enum 8053 "Service Partner"](../enum/8053.md) |
| 21 | Subscription Contract No. | Code[20] | Specifies in which contract the Subscription Line will be calculated. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | TableRelation [Table 8052 "Customer Subscription Contract"](../table/8052.md), [Table 8063 "Vendor Subscription Contract"](../table/8063.md) (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") |
| 22 | Notice Period | DateFormula | — |  |
| 23 | 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. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 24 | 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". <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 25 | Billing Rhythm | DateFormula | Specifies the Date formula 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. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 26 | 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... <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 27 | 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. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 28 | Sub. Header Customer No. | Code[20] | Subscription Header Customer No. <small>caption</small> | FlowField: lookup("Subscription Header"."End-User Customer No." where("No." = field("Subscription Header No."))); not editable |
| 29 | Subscription Contract Line No. | Integer | — | TableRelation [Table 8062 "Cust. Sub. Contract Line"](../table/8062.md), [Table 8065 "Vend. Sub. Contract Line"](../table/8065.md) (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."))) |
| 30 | Customer Price Group | Code[10] | — | TableRelation [Table 6 "Customer Price Group"](../table/6.md) (Customer Price Group); not editable |
| 31 | Shortcut Dimension 1 Code | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false))) |
| 32 | Shortcut Dimension 2 Code | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false))) |
| 33 | Price (LCY) | Decimal | — | not editable |
| 34 | Discount Amount (LCY) | Decimal | — | not editable |
| 35 | Amount (LCY) | Decimal | — | not editable |
| 36 | Currency Code | Code[10] | Specifies the currency of amounts in the Subscription Line. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | TableRelation [Table 4 "Currency"](../table/4.md); not editable |
| 37 | Currency Factor | Decimal | — | not editable |
| 38 | Currency Factor Date | Date | — | not editable |
| 39 | Calculation Base Amount (LCY) | Decimal | — | not editable |
| 40 | Discount | Boolean | Specifies whether the Subscription Line is used as a basis for periodic invoicing or discounts. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | not editable |
| 41 | Serial No. (Sub. Header) | Code[50] | Specifies the serial no. of the Subscription before the change. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | not editable |
| 42 | Quantity (Sub. Header) | Decimal | Specifies the units of the Subscription before the change. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 50 | Next Price Update | Date | Specifies the date of the next price update. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 53 | Type Of Update | Enum "Type Of Price Update" | Specifies, whether the Planned Subscription Line has been created by a Price Update. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> | enum [Enum 8004 "Type Of Price Update"](../enum/8004.md) |
| 54 | Perform Update On | Date | Specifies the date, the price update will take affect if no date is specified in the contract line. If empty the "Next Price Update" of the contract line is used. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 96 | Variant Code (Sub. Header) | Code[10] | Specifies the variant code of the Subscription before the change. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 100 | Unit Cost | Decimal | — | not editable |
| 101 | Unit Cost (LCY) | Decimal | Specifies the unit cost of the item. <small>via [Page 8094 "Service Commitment Archive"](../page/8094.md)</small> |  |
| 107 | Closed | Boolean | — |  |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 8000 | Usage Based Billing | Boolean | Specifies whether usage data is used as the basis for billing via contracts. | not editable |
| 8001 | Usage Based Pricing | Enum "Usage Based Pricing" | Specifies the method for customer based pricing. | enum [Enum 8007 "Usage Based Pricing"](../enum/8007.md); 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. | not editable |

## Keys

- PK: Entry No.
- SK1: Subscription Header No., Original Entry No.

## Events published

- `OnAfterCopyFromSubscriptionLine(var SubscriptionLineArchive: Record "Subscription Line Archive"; SubscriptionLine: Record "Subscription Line")` (integration)

## Procedures

- `CopyFromServiceCommitment(ServiceCommitment: Record "Subscription Line")` (internal)
- `FilterOnServiceCommitment(OriginalEntryNo: Integer)` (internal)

## Relations

- drill-down page [Page 8094 "Service Commitment Archive"](../page/8094.md)
- lookup page [Page 8094 "Service Commitment Archive"](../page/8094.md)
- Shortcut Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Shortcut Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Customer Price Group: TableRelation [Table 6 "Customer Price Group"](../table/6.md)
- Subscription Contract No.: TableRelation [Table 8052 "Customer Subscription Contract"](../table/8052.md) (conditional)
- Template: TableRelation [Table 8054 "Sub. Package Line Template"](../table/8054.md)
- Subscription Package Code: TableRelation [Table 8055 "Subscription Package"](../table/8055.md)
- Sub. Header Customer No.: CalcFormula [Table 8057 "Subscription Header"](../table/8057.md)
- Subscription Header No.: TableRelation [Table 8057 "Subscription Header"](../table/8057.md)
- Subscription Contract Line No.: TableRelation [Table 8062 "Cust. Sub. Contract Line"](../table/8062.md) (conditional)
- Subscription Contract No.: TableRelation [Table 8063 "Vendor Subscription Contract"](../table/8063.md) (conditional)
- Subscription Contract Line No.: TableRelation [Table 8065 "Vend. Sub. Contract Line"](../table/8065.md) (conditional)

## Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

- [Table 8057 "Subscription Header"](../table/8057.md): Archived Sub. Lines exist

## Pages and codeunits on this table

- [Page 8094 "Service Commitment Archive"](../page/8094.md) (source table)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

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 Archive")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.