Table 8001 "Sub. Contract Renewal Line"

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

Learn documents this table through its pages: Page 8005 “Contract Renewal” (1 Learn page).

Properties

Property	Value
Caption	Subscription Contract Renewal Line
DataClassification	CustomerContent
LookupPageId	Contract Renewal Lines
DrillDownPageId	Contract Renewal 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	Subscription Header No.	Code[20]	Specifies the number of the Subscription. via Page 8003 “Contract Renewal Lines”	TableRelation Table 8057 “Subscription Header” (Subscription Header); not editable
2	Subscription Line Entry No.	Integer	—	TableRelation Table 8059 “Subscription Line” (“Subscription Line”.“Entry No.”); not editable
10	Linked to Sub. Line Entry No.	Integer	Linked to Subscription Line Entry No. caption	not editable
11	Linked to Sub. Contract No.	Code[20]	Specifies the number of the Customer Subscription Contract from which the entry originates. This also includes vendor-related Subscription Lines. via Page 8005 “Contract Renewal”	TableRelation Table 8052 “Customer Subscription Contract” (Customer Subscription Contract); not editable
12	Linked to Sub. Contr. Line No.	Integer	Linked to Subscription Contr. Line No. caption	TableRelation Table 8062 “Cust. Sub. Contract Line” (“Cust. Sub. Contract Line”.“Line No.” where(“Subscription Contract No.” = field(“Linked to Sub. Contract No.”))); not editable
13	Subscription Contract No.	Code[20]	Specifies the number of the Contract. via Page 8003 “Contract Renewal Lines”	TableRelation Table 8052 “Customer Subscription Contract”, Table 8063 “Vendor Subscription Contract” (if (Partner = const(Customer)) “Customer Subscription Contract” else if (Partner = const(Vendor)) “Vendor Subscription Contract”); not editable
14	Subscription Contract Line No.	Integer	—	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.”))); not editable
15	Error Message	Text[500]	Specifies the last error that occured when processing the line. via Page 8005 “Contract Renewal”	not editable
100	Partner	Enum “Service Partner”	Specifies whether the template applies to customer or Vendor Subscription Contracts. via Page 8005 “Contract Renewal”	FlowField: lookup(“Subscription Line”.Partner where(“Entry No.” = field(“Subscription Line Entry No.”))); enum Enum 8053 “Service Partner”; not editable
101	Subscription t Description	Text[100]	Specifies a description of the Subscription. via Page 8003 “Contract Renewal Lines”	FlowField: lookup(“Subscription Header”.Description where(“No.” = field(“Subscription Header No.”))); not editable
102	Subscription Line Description	Text[100]	Specifies the description of the Subscription Line. via Page 8003 “Contract Renewal Lines”	FlowField: lookup(“Subscription Line”.Description where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
103	Subscription Line Start Date	Date	Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8003 “Contract Renewal Lines”	FlowField: lookup(“Subscription Line”.“Subscription Line Start Date” where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
104	Subscription Line End Date	Date	Specifies the date up to which the Subscription Line is valid. via Page 8003 “Contract Renewal Lines”	FlowField: lookup(“Subscription Line”.“Subscription Line End Date” where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
105	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 8005 “Contract Renewal”	FlowField: lookup(“Subscription Line”.“Price” where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
106	Amount	Decimal	Specifies the amount for the Subscription Line including discount. via Page 8005 “Contract Renewal”	FlowField: lookup(“Subscription Line”.Amount where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
107	Billing Rhythm	DateFormula	Specifies the Dateformula for the 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 8005 “Contract Renewal”	FlowField: lookup(“Subscription Line”.“Billing Rhythm” where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
108	Planned Sub. Line exists	Boolean	Planned Subscription Line exists caption	FlowField: exist(“Planned Subscription Line” where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
109	Currency Code	Code[10]	—	FlowField: lookup(“Subscription Line”.“Currency Code” where(“Entry No.” = field(“Subscription Line Entry No.”))); not editable
201	Agreed Sub. Line Start Date	Date	Specifies the individually agreed start of the Subscription Line. via Page 8005 “Contract Renewal”
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 8005 “Contract Renewal”

Keys

PK: Subscription Line Entry No. (clustered)
PageSort: Linked to Sub. Contract No., Linked to Sub. Contr. Line No.

Events published

OnAfterInitFromSubscriptionLine(var SubContractRenewalLine: Record "Sub. Contract Renewal Line"; SubscriptionLine: Record "Subscription Line") (integration)
OnAfterRefreshContractInfo(var SubContractRenewalLine: Record "Sub. Contract Renewal Line"; SubscriptionLine: Record "Subscription Line") (integration)

Procedures

InitFromServiceCommitment(var ServiceCommitment: Record "Subscription Line"): Boolean: Initiates the Subscription Contract Renewal Line from Subscription Line

Plus 2 local procedures.

Relations

drill-down page Page 8003 “Contract Renewal Lines”
lookup page Page 8003 “Contract Renewal Lines”
Planned Sub. Line exists: CalcFormula Table 8002 “Planned Subscription Line”
Linked to Sub. Contract No.: TableRelation Table 8052 “Customer Subscription Contract”
Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract” (conditional)
Subscription t Description: CalcFormula Table 8057 “Subscription Header”
Subscription Header No.: TableRelation Table 8057 “Subscription Header”
Amount: CalcFormula Table 8059 “Subscription Line”
Billing Rhythm: CalcFormula Table 8059 “Subscription Line”
Currency Code: CalcFormula Table 8059 “Subscription Line”
Partner: CalcFormula Table 8059 “Subscription Line”
Price: CalcFormula Table 8059 “Subscription Line”
Subscription Line Description: CalcFormula Table 8059 “Subscription Line”
Subscription Line End Date: CalcFormula Table 8059 “Subscription Line”
Subscription Line Start Date: CalcFormula Table 8059 “Subscription Line”
Subscription Line Entry No.: TableRelation Table 8059 “Subscription Line”
Linked to Sub. Contr. Line No.: TableRelation Table 8062 “Cust. Sub. Contract Line”
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)

Pages and codeunits on this table

Page 8003 “Contract Renewal Lines” (source table)
Page 8005 “Contract Renewal” (source table)
Codeunit 8002 “Create Sub. Contract Renewal” (codeunit runs on it)

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