---
id: object/table/8069
type: object
title: Table 8069 "Sales Sub. Line Archive"
summary: Table 8069 "Sales Sub. Line Archive" in Subscription Billing (Microsoft.SubscriptionBilling). 37 fields, 1 public procedures. 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: 39807978401c863912968dc87262de580c21a84fc29fc22092041ce98eed2191
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subscription%20Billing/app/Sales%20Service%20Commitments/Tables/SalesSubLineArchive.Table.al
    title: src/Apps/W1/Subscription Billing/app/Sales Service Commitments/Tables/SalesSubLineArchive.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: 8069
name: Sales Sub. Line Archive
caption: Sales 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: 37
  procedures: 1
  events: 0
  subscribers: 0
relations:
  out: 8
  referenced_by: 1
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 8069 "Sales Sub. Line Archive"

> Table 8069 "Sales Sub. Line Archive" in Subscription Billing (Microsoft.SubscriptionBilling). 37 fields, 1 public procedures. Introduced in BC29, still in BC30.

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

## Properties

| Property | Value |
|---|---|
| Caption | Sales Subscription Line Archive |
| DataClassification | CustomerContent |
| LookupPageId | Sales Serv. Comm. Archive List |
| DrillDownPageId | Sales Serv. Comm. Archive 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 | Document Type | Enum "Sales Document Type" | — | enum [Enum 36 "Sales Document Type"](../enum/36.md) |
| 2 | Document No. | Code[20] | — | TableRelation [Table 5107 "Sales Header Archive"](../table/5107.md) ("Sales Header Archive"."No." where("Document Type" = field("Document Type"))) |
| 3 | Document Line No. | Integer | — |  |
| 4 | Line No. | Integer | — | AutoIncrement |
| 5 | Version No. | Integer | — |  |
| 6 | Doc. No. Occurrence | Integer | — |  |
| 10 | Item No. | Code[20] | Specifies the number of an item. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | TableRelation [Table 27 "Item"](../table/27.md) |
| 11 | Item Description | Text[100] | Specifies a description of the product to be sold. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | FlowField: lookup(Item.Description where("No." = field("Item No."))); not editable |
| 12 | Partner | Enum "Service Partner" | Specifies whether a Subscription Line should be invoiced to a vendor (purchase invoice) or to a customer (sales invoice). <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | enum [Enum 8053 "Service Partner"](../enum/8053.md) |
| 13 | Description | Text[100] | Specifies a description of the package line. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 14 | Calculation Base Type | Enum "Calculation Base Type" | Specifies how the price for Subscription Line is calculated. "Item Price" uses the list price defined on the Item. "Document Price" uses the price from the sales document. "Document Price And Discount" uses the price and the discount from the sales document. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | enum [Enum 8052 "Calculation Base Type"](../enum/8052.md) |
| 15 | Calculation Base Amount | Decimal | Specifies the base amount from which the price will be calculated. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 16 | 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 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 17 | 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 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | not editable |
| 18 | Discount % | Decimal | Specifies the percent of the discount for the Subscription Line. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 19 | Discount Amount | Decimal | Specifies the amount of the discount for the Subscription Line. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 20 | Amount | Decimal | Specifies the amount for the Subscription Line including discount. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 21 | Sub. Line Start Formula | DateFormula | Subscription Line Start Formula <small>caption</small> |  |
| 22 | Agreed Sub. Line Start Date | Date | Specifies the individually agreed start of the Subscription Line. Enter a date here to overwrite the determination of the start of Subscription Line with the start of Subscription Line formula upon delivery. If the field remains empty, the start of the Subscription Line is determined upon delivery. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 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 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 24 | 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... <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 25 | 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 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 26 | 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 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 27 | 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. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 28 | 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. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | enum [Enum 8051 "Invoicing Via"](../enum/8051.md) |
| 30 | Template | Code[20] | Specifies a code to identify this Subscription Package Line Template. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | TableRelation [Table 8054 "Sub. Package Line Template"](../table/8054.md) (Sub. Package Line Template) |
| 31 | Package Code | Code[20] | Specifies a code to identify this Subscription Package. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> | TableRelation [Table 8055 "Subscription Package"](../table/8055.md) (Subscription Package) |
| 32 | Customer Price Group | Code[10] | — | TableRelation [Table 6 "Customer Price Group"](../table/6.md) (Customer Price Group); not editable |
| 34 | Currency Code | Code[10] | — | not editable |
| 60 | Linked to No. | Code[20] | — | not editable |
| 61 | Linked to Line No. | Integer | — | not editable |
| 62 | Process | Enum Process | — | enum [Enum 8017 "Process"](../enum/8017.md); not editable |
| 100 | Unit Cost | Decimal | — |  |
| 101 | Unit Cost (LCY) | Decimal | Specifies the unit cost of the item. <small>via [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)</small> |  |
| 8000 | Usage Based Billing | Boolean | Specifies whether usage data is used as the basis for billing via contracts. |  |
| 8001 | Usage Based Pricing | Enum "Usage Based Pricing" | Specifies the method for customer based pricing. | enum [Enum 8007 "Usage Based Pricing"](../enum/8007.md) |
| 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. |  |

## Keys

- PK: Line No. (clustered)
- SK1: Document Type, Document No., Document Line No., Doc. No. Occurrence, Version No.

## Procedures

- `FilterOnSalesLineArchive(SalesLineArchive: Record "Sales Line Archive")` (internal)

## Relations

- drill-down page [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)
- lookup page [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.md)
- Item Description: CalcFormula [Table 27 "Item"](../table/27.md)
- Item No.: TableRelation [Table 27 "Item"](../table/27.md)
- Document No.: TableRelation [Table 5107 "Sales Header Archive"](../table/5107.md)
- Customer Price Group: TableRelation [Table 6 "Customer Price Group"](../table/6.md)
- Template: TableRelation [Table 8054 "Sub. Package Line Template"](../table/8054.md)
- Package Code: TableRelation [Table 8055 "Subscription Package"](../table/8055.md)

## Referenced by

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

- [Table extension 8068 "Sales Line Archive"](../tableextension/8068.md): Subscription Lines

## Pages and codeunits on this table

- [Page 8083 "Sales Serv. Comm. Archive List"](../page/8083.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: "Sales Sub. Line Archive")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.