Table 8069 "Sales Sub. Line Archive"

Subscription Billing · Microsoft.SubscriptionBilling · captioned “Sales Subscription Line Archive” · BC29-30 · source at ea08af5e · 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”
2	Document No.	Code[20]	—	TableRelation Table 5107 “Sales Header Archive” (“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. via Page 8083 “Sales Serv. Comm. Archive List”	TableRelation Table 27 “Item”
11	Item Description	Text[100]	Specifies a description of the product to be sold. via Page 8083 “Sales Serv. Comm. Archive List”	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). via Page 8083 “Sales Serv. Comm. Archive List”	enum Enum 8053 “Service Partner”
13	Description	Text[100]	Specifies a description of the package line. via Page 8083 “Sales Serv. Comm. Archive List”
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. via Page 8083 “Sales Serv. Comm. Archive List”	enum Enum 8052 “Calculation Base Type”
15	Calculation Base Amount	Decimal	Specifies the base amount from which the price will be calculated. via Page 8083 “Sales Serv. Comm. Archive List”
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. via Page 8083 “Sales Serv. Comm. Archive List”
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 %. via Page 8083 “Sales Serv. Comm. Archive List”	not editable
18	Discount %	Decimal	Specifies the percent of the discount for the Subscription Line. via Page 8083 “Sales Serv. Comm. Archive List”
19	Discount Amount	Decimal	Specifies the amount of the discount for the Subscription Line. via Page 8083 “Sales Serv. Comm. Archive List”
20	Amount	Decimal	Specifies the amount for the Subscription Line including discount. via Page 8083 “Sales Serv. Comm. Archive List”
21	Sub. Line Start Formula	DateFormula	Subscription Line Start Formula caption
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. via Page 8083 “Sales Serv. Comm. Archive List”
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. via Page 8083 “Sales Serv. Comm. Archive List”
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… via Page 8083 “Sales Serv. Comm. Archive List”
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”. via Page 8083 “Sales Serv. Comm. Archive List”
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. via Page 8083 “Sales Serv. Comm. Archive List”
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. via Page 8083 “Sales Serv. Comm. Archive List”
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. via Page 8083 “Sales Serv. Comm. Archive List”	enum Enum 8051 “Invoicing Via”
30	Template	Code[20]	Specifies a code to identify this Subscription Package Line Template. via Page 8083 “Sales Serv. Comm. Archive List”	TableRelation Table 8054 “Sub. Package Line Template” (Sub. Package Line Template)
31	Package Code	Code[20]	Specifies a code to identify this Subscription Package. via Page 8083 “Sales Serv. Comm. Archive List”	TableRelation Table 8055 “Subscription Package” (Subscription Package)
32	Customer Price Group	Code[10]	—	TableRelation Table 6 “Customer Price Group” (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”; not editable
100	Unit Cost	Decimal	—
101	Unit Cost (LCY)	Decimal	Specifies the unit cost of the item. via Page 8083 “Sales Serv. Comm. Archive List”
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”
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”
lookup page Page 8083 “Sales Serv. Comm. Archive List”
Item Description: CalcFormula Table 27 “Item”
Item No.: TableRelation Table 27 “Item”
Document No.: TableRelation Table 5107 “Sales Header Archive”
Customer Price Group: TableRelation Table 6 “Customer Price Group”
Template: TableRelation Table 8054 “Sub. Package Line Template”
Package Code: TableRelation Table 8055 “Subscription Package”

Referenced by

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

Table extension 8068 “Sales Line Archive”: Subscription Lines

Pages and codeunits on this table

Page 8083 “Sales Serv. Comm. Archive List” (source table)

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.