Table 8064 "Billing Line Archive"

Subscription Billing · Microsoft.SubscriptionBilling · captioned “Archived Billing Line” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Archived Billing Line
DataClassification	CustomerContent
LookupPageId	Archived Billing Lines
DrillDownPageId	Archived Billing Lines

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	Specifies the value of the Entry No. field. via Page 8017 “Archived Billing Lines List”	AutoIncrement
2	User ID	Code[50]	Specifies the user who created the line. via Page 8017 “Archived Billing Lines List”	TableRelation Table 91 “User Setup” (User Setup); not editable; DataClassification EndUserIdentifiableInformation
10	Partner No.	Code[20]	Specifies the number of the partner who will receive the contract components and be billed by default. via Page 8017 “Archived Billing Lines List”	TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (Partner = const(Customer)) Customer else if (Partner = const(Vendor)) Vendor)
20	Subscription Contract No.	Code[20]	Specifies the number of the Subscription Contract. via Page 8017 “Archived Billing Lines List”	TableRelation Table 8052 “Customer Subscription Contract” (if (Partner = const(Customer)) “Customer Subscription Contract”)
21	Subscription Contract Line No.	Integer	Specifies the value of the Contract Line No. field. via Page 8017 “Archived Billing Lines 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.”)))
30	Subscription Header No.	Code[20]	Specifies the number of the Subscription. via Page 8017 “Archived Billing Lines List”	TableRelation Table 8057 “Subscription Header” (Subscription Header)
31	Subscription Line Entry No.	Integer	Specifies the value of the Subscription Line Entry No. field. via Page 8017 “Archived Billing Lines List”
32	Subscription Description	Text[100]	Specifies a description of the Subscription. via Page 8017 “Archived Billing Lines List”	FlowField: lookup(“Subscription Header”.Description where(“No.” = field(“Subscription Header No.”))); not editable
33	Subscription Line Description	Text[100]	Specifies the description of the Subscription Line. via Page 8017 “Archived Billing Lines List”
34	Subscription Line Start Date	Date	Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8017 “Archived Billing Lines List”
35	Subscription Line End Date	Date	Specifies the date up to which the Subscription Line is valid. via Page 8017 “Archived Billing Lines List”
36	Partner	Enum “Service Partner”	Specifies the value of the Partner field. via Page 8017 “Archived Billing Lines List”	enum Enum 8053 “Service Partner”
38	Discount	Boolean	Specifies whether the Subscription Line is used as a basis for periodic invoicing or discounts. via Page 8017 “Archived Billing Lines List”
39	Service Object Quantity	Decimal	Specifies the quantity from the Subscription. via Page 8017 “Archived Billing Lines List”
50	Billing from	Date	Specifies the date from which the Subscription Line is billed. via Page 8017 “Archived Billing Lines List”
51	Billing to	Date	Specifies the date to which the Subscription Line is billed. via Page 8017 “Archived Billing Lines List”
52	Amount	Decimal	Specifies the amount for the Subscription Line including discount. via Page 8017 “Archived Billing Lines List”
53	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 8017 “Archived Billing Lines List”
55	Document Type	Enum “Rec. Billing Document Type”	Specifies the document type of the document created for posting. via Page 8017 “Archived Billing Lines List”	enum Enum 8054 “Rec. Billing Document Type”
56	Document No.	Code[20]	Specifies the document number of the document created for posting. via Page 8017 “Archived Billing Lines List”	TableRelation Table 112 “Sales Invoice Header”, Table 114 “Sales Cr.Memo Header”, Table 122 “Purch. Inv. Header” (if (“Document Type” = const(Invoice), Partner = const(Customer)) “Sales Invoice Header” else if (“Document Type” = const(“Credit Memo”), Partner = const(Customer)) “Sales Cr.Memo Header” else if (“Document Type” = const(“Invoice”), Partner = const(Vendor)) “Purch. Inv. Header” else if (“Document Typ…)
57	Unit Price	Decimal	Specifies the Unit Price for the subscription line billing period without discount. via Page 8017 “Archived Billing Lines List”
58	Discount %	Decimal	Specifies the Discount % for the subscription line billing period. via Page 8017 “Archived Billing Lines List”
60	Correction Document Type	Enum “Rec. Billing Document Type”	Specifies the value of the Correction Document Type field. via Page 8017 “Archived Billing Lines List”	enum Enum 8054 “Rec. Billing Document Type”
61	Correction Document No.	Code[20]	Specifies the value of the Correction Document No. field. via Page 8017 “Archived Billing Lines List”	TableRelation Table 112 “Sales Invoice Header”, Table 114 “Sales Cr.Memo Header” (if (“Correction Document Type” = const(Invoice), Partner = const(Customer)) “Sales Invoice Header”.“No.” else if (“Correction Document Type” = const(“Credit Memo”), Partner = const(Customer)) “Sales Cr.Memo Header”.“No.” else if (“Correction Document Type” = const(Invoice), Partner = const(Vendor)) …)
62	Document Line No.	Integer	Specifies the document line number of the document, it was posted in. via Page 8017 “Archived Billing Lines List”	TableRelation Table 37 “Sales Line” (if (Partner = const(Customer), “Document Type” = const(Invoice)) “Sales Line”.“Line No.” where(“Document Type” = const(Invoice), “Document No.” = field(“Document No.”)) else if (Partner = const(Customer), “Document Type” = const(“Credit Memo”)) “Sales Line”.“Line No.” where(“Document Type” = const(“…)
63	Billing Reference Date Changed	Boolean	Specifies whether the billing period has been adjusted manually. This is taken into account by the period calculation and may have an effect on the creation of future billing proposals.
100	Billing Template Code	Code[20]	Specifies the template code. via Page 8017 “Archived Billing Lines List”	TableRelation Table 8060 “Billing Template” (Billing Template)
101	Currency Code	Code[20]	Code caption	TableRelation Currency.Code
102	Unit Cost	Decimal	—	not editable
103	Unit Cost (LCY)	Decimal	Specifies the unit cost for the billing period. via Page 8073 “Archived Billing Lines”

Keys

PK: Entry No. (clustered)
SK1: Subscription Contract No., Subscription Contract Line No., Billing from
SK2: Subscription Line Entry No.

Procedures

PostedDocumentExist(): Boolean (internal)
ShowDocumentCard() (internal)
PostedPurchaseDocumentExist(): Boolean (internal)
FilterBillingLineArchiveOnContract(ServicePartner: Enum "Service Partner"; ContractNo: Code[20]) (internal)
FilterBillingLineArchiveOnContractLine(ServicePartner: Enum "Service Partner"; ContractNo: Code[20]; ContractLineNo: Integer) (internal)
FilterBillingLineArchiveOnDocument(RecurringBillingDocumentType: Enum "Rec. Billing Document Type"; DocumentNo: Code[20]) (internal)
FilterBillingLineArchiveOnServiceCommitment(ServiceCommitmentEntryNo: Integer) (internal)
IsInvoiceCredited(ServicePartner: Enum "Service Partner"; DocumentNo: Code[20]): Boolean (internal)

Plus 2 local procedures.

Relations

drill-down page Page 8073 “Archived Billing Lines”
lookup page Page 8073 “Archived Billing Lines”
Correction Document No.: TableRelation Table 112 “Sales Invoice Header” (conditional)
Document No.: TableRelation Table 112 “Sales Invoice Header” (conditional)
Correction Document No.: TableRelation Table 114 “Sales Cr.Memo Header” (conditional)
Document No.: TableRelation Table 114 “Sales Cr.Memo Header” (conditional)
Document No.: TableRelation Table 122 “Purch. Inv. Header” (conditional)
Partner No.: TableRelation Table 18 “Customer” (conditional)
Partner No.: TableRelation Table 23 “Vendor” (conditional)
Document Line No.: TableRelation Table 37 “Sales Line” (conditional)
Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract”
Subscription Description: CalcFormula Table 8057 “Subscription Header”
Subscription Header No.: TableRelation Table 8057 “Subscription Header”
Billing Template Code: TableRelation Table 8060 “Billing Template”
Subscription Contract Line No.: TableRelation Table 8062 “Cust. Sub. Contract Line” (conditional)
Subscription Contract Line No.: TableRelation Table 8065 “Vend. Sub. Contract Line” (conditional)
User ID: TableRelation Table 91 “User Setup”

Pages and codeunits on this table

Page 8017 “Archived Billing Lines List” (source table)
Page 8022 “Archived Billing Lines API” (source table)
Page 8073 “Archived Billing Lines” (source table)

Recent changes

2026-08-29 #10235 [Bug][SubscriptionBilling] Enforce Subscription Line Start Date change rules on all edit paths (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)

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