Table 8009 "Imported Subscription Line"

Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 8009 “Imported Service Commitments” (1 Learn page).

Properties

Property	Value
Caption	Imported Subscription Line
DataClassification	CustomerContent

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	—	NotBlank; AutoIncrement
2	Subscription Header No.	Code[20]	Specifies the Subscription, the Subscription Line will be created for. via Page 8009 “Imported Service Commitments”	TableRelation Table 8057 “Subscription Header” (Subscription Header)
3	Subscription Line Entry No.	Integer	Specifies the line number of the Subscription Line. If empty, a Line No. will be assigned automatically. via Page 8009 “Imported Service Commitments”
4	Partner	Enum “Service Partner”	Specifies whether the Subscription Line will will be calculated as a credit (Purchase Invoice) or as debit (Sales Invoice). via Page 8009 “Imported Service Commitments”	enum Enum 8053 “Service Partner”
5	Subscription Contract No.	Code[20]	Specifies the number of the contract in which Subscription Lines will be created as contract lines. Subscription Lines with Invoicing via = Sales cannot be called into a Contract. via Page 8009 “Imported Service Commitments”	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”)
6	Subscription Contract Line No.	Integer	Specifies the Line No. of the contract line. If empty a Line No. will be assigned automatically. via Page 8009 “Imported Service Commitments”	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.”)))
7	Sub. Contract Line Type	Enum “Contract Line Type”	Specifies the contract line type. via Page 8009 “Imported Service Commitments”	enum Enum 8055 “Contract Line Type”
8	Subscription Package Code	Code[20]	Specifies the code of the Subscription Package. If a Vendor Subscription Contract line has the same Subscription No. and Package Code as a Customer Subscription Contract line, the Customer Subscription Contract dimension value is copied to the Vendor Subscription Contract line. via Page 8009 “Imported Service Commitments”	TableRelation Table 8055 “Subscription Package” (Subscription Package); NotBlank
9	Template Code	Code[20]	Specifies the code of the Subscription Package Line Template. via Page 8009 “Imported Service Commitments”	TableRelation Table 8054 “Sub. Package Line Template” (Sub. Package Line Template)
10	Description	Text[100]	Specifies the description of the Subscription Line. via Page 8009 “Imported Service Commitments”
11	Subscription Line Start Date	Date	Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8009 “Imported Service Commitments”
12	Subscription Line End Date	Date	Specifies the date up to which the Subscription Line is valid. via Page 8009 “Imported Service Commitments”
13	Next Billing Date	Date	Specifies the date of the next billing possible. via Page 8009 “Imported Service Commitments”
15	Calculation Base Amount	Decimal	Specifies the base amount from which the price will be calculated. via Page 8009 “Imported Service Commitments”
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 8009 “Imported Service Commitments”
17	Discount %	Decimal	Specifies the percent of the discount for the Subscription Line. via Page 8009 “Imported Service Commitments”
18	Discount Amount	Decimal	Specifies the amount of the discount for the Subscription Line. via Page 8009 “Imported Service Commitments”
19	Amount	Decimal	Specifies the amount for the Subscription Line including discount. via Page 8009 “Imported Service Commitments”
20	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 8009 “Imported Service Commitments”
21	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 8009 “Imported Service Commitments”	enum Enum 8051 “Invoicing Via”
22	Invoicing Item No.	Code[20]	Specifies which item will be used in contract invoice for invoicing of the periodic Subscription Line. via Page 8009 “Imported Service Commitments”	TableRelation Item.“No.” where(“Subscription Option” = const(“Invoicing Item”))
23	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 8009 “Imported Service Commitments”
24	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 8009 “Imported Service Commitments”
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 8009 “Imported Service Commitments”
26	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. via Page 8009 “Imported Service Commitments”
27	Discount Amount (LCY)	Decimal	Specifies the discount amount in client currency that is granted on the Subscription Line. via Page 8009 “Imported Service Commitments”	not editable
28	Amount (LCY)	Decimal	Specifies the amount in client currency for the Subscription Line including discount. via Page 8009 “Imported Service Commitments”	not editable
29	Currency Code	Code[10]	Specifies the currency of amounts in the Subscription Line. via Page 8009 “Imported Service Commitments”	TableRelation Table 4 “Currency”
30	Currency Factor	Decimal	Specifies the currency factor valid for the Subscription Line, which is used to convert amounts to the client currency. via Page 8009 “Imported Service Commitments”
31	Currency Factor Date	Date	Specifies the date when the currency factor was last updated. via Page 8009 “Imported Service Commitments”
32	Calculation Base Amount (LCY)	Decimal	Specifies the basis on which the price is calculated in client currency. via Page 8009 “Imported Service Commitments”
37	Quantity	Decimal	Specifies the number of units of Subscription. via Page 8009 “Imported Service Commitments”	FlowField: lookup(“Subscription Header”.Quantity where(“No.” = field(“Subscription Header No.”))); not editable
39	Next Price Update	Date	Specifies the date of the next price update. via Page 8009 “Imported Service Commitments”
40	Exclude from Price Update	Boolean	Specifies whether this line is considered in by the Contract Price Update. Setting it to yes will exclude the line from all price updates. via Page 8009 “Imported Service Commitments”
41	Create Contract Deferrals	Enum “Create Contract Deferrals”	Specifies whether this Subscription Line should generate contract deferrals. If it is set to No, no deferrals are generated and the invoices are posted directly to profit or loss. via Page 8009 “Imported Service Commitments”	enum Enum 8020 “Create Contract Deferrals”
100	Subscription Line created	Boolean	Specifies whether the Subscription Line has been created. via Page 8009 “Imported Service Commitments”	not editable
101	Error Text	Text[250]	Specifies the error in processing the record. via Page 8009 “Imported Service Commitments”	not editable
102	Processed by	Code[50]	Specifies who processed the record. via Page 8009 “Imported Service Commitments”	TableRelation Table 91 “User Setup” (User Setup); not editable; DataClassification EndUserIdentifiableInformation
103	Processed at	DateTime	Specifies when the record was processed. via Page 8009 “Imported Service Commitments”	not editable
104	Sub. Contract Line created	Boolean	Specifies whether a contract line has been created for the Subscription Line. via Page 8009 “Imported Service Commitments”	not editable
8000	Usage Based Billing	Boolean	Specifies whether usage data is used as the basis for billing via contracts. via Page 8009 “Imported Service Commitments”	not editable
8001	Usage Based Pricing	Enum “Usage Based Pricing”	Specifies the method for customer based pricing. via Page 8009 “Imported Service Commitments”	enum Enum 8007 “Usage Based Pricing”; 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. via Page 8009 “Imported Service Commitments”	not editable
8003	Supplier Reference Entry No.	Integer	Specifies the sequence number of the related reference. via Page 8009 “Imported Service Commitments”	TableRelation Table 8015 “Usage Data Supplier Reference” (“Usage Data Supplier Reference” where(Type = const(Subscription))); not editable

Keys

PK: Entry No. (clustered)

Procedures

IsContractCommentLine(): Boolean
ClearErrorTextAndSetProcessedFields() (internal)
InitCurrencyData() (internal)
GetInvoicingItemNo(): Code[20] (internal)

Relations

Currency Code: TableRelation Table 4 “Currency”
Supplier Reference Entry No.: TableRelation Table 8015 “Usage Data Supplier Reference”
Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract” (conditional)
Template Code: TableRelation Table 8054 “Sub. Package Line Template”
Subscription Package Code: TableRelation Table 8055 “Subscription Package”
Quantity: CalcFormula Table 8057 “Subscription Header”
Subscription Header No.: TableRelation Table 8057 “Subscription Header”
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)
Processed by: TableRelation Table 91 “User Setup”

Pages and codeunits on this table

Page 8009 “Imported Service Commitments” (source table)
Codeunit 8006 “Create Subscription Line” (codeunit runs on it)
Codeunit 8007 “Create Sub. Contract Line” (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: "Imported Subscription Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.