Table "Subscription Line"

ID 8059

Namespace: Microsoft.SubscriptionBilling

Properties

Name	Value
DataClassification	CustomerContent
Caption	Subscription Line
DrillDownPageId	Page Microsoft.SubscriptionBilling."Service Commitments List"
LookupPageId	Page Microsoft.SubscriptionBilling."Service Commitments List"

Fields

Name	Type	Description
"Subscription Header No."	Code[20]
"Entry No."	Integer
"Subscription Package Code"	Code[20]
Template	Code[20]
Description	Text[100]
"Subscription Line Start Date"	Date
"Subscription Line End Date"	Date
"Next Billing Date"	Date
"Calculation Base Amount"	Decimal
"Calculation Base %"	Decimal
Price	Decimal
"Discount %"	Decimal
"Discount Amount"	Decimal
Amount	Decimal
"Billing Base Period"	DateFormula
"Invoicing via"	Enum Microsoft.SubscriptionBilling."Invoicing Via"
"Invoicing Item No."	Code[20]
Partner	Enum Microsoft.SubscriptionBilling."Service Partner"
"Subscription Contract No."	Code[20]
"Notice Period"	DateFormula
"Initial Term"	DateFormula
"Extension Term"	DateFormula
"Billing Rhythm"	DateFormula
"Cancellation Possible Until"	Date
"Term Until"	Date
"Sub. Header Customer No."	Code[20]
"Subscription Contract Line No."	Integer
"Shortcut Dimension 1 Code"	Code[20]	Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 2 Code"	Code[20]	Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.
"Price (LCY)"	Decimal
"Discount Amount (LCY)"	Decimal
"Amount (LCY)"	Decimal
"Currency Code"	Code[10]
"Currency Factor"	Decimal
"Currency Factor Date"	Date
"Calculation Base Amount (LCY)"	Decimal
Discount	Boolean
Quantity	Decimal
"Create Contract Deferrals"	Enum Microsoft.SubscriptionBilling."Create Contract Deferrals"
"Customer Price Group"	Code[10]
"Next Price Update"	Date
"Exclude from Price Update"	Boolean
"Price Binding Period"	DateFormula
"Period Calculation"	Enum Microsoft.SubscriptionBilling."Period Calculation"
"Variant Code"	Code[10]	Specifies the Variant Code of the Subscription.
Closed	Boolean
"Unit Cost"	Decimal
"Unit Cost (LCY)"	Decimal
"Planned Sub. Line exists"	Boolean
"Renewal Term"	DateFormula
Selected	Boolean
Indent	Integer
"Dimension Set ID"	Integer
"Usage Based Billing"	Boolean
"Usage Based Pricing"	Enum Microsoft.SubscriptionBilling."Usage Based Pricing"
"Pricing Unit Cost Surcharge %"	Decimal
"Supplier Reference Entry No."	Integer
"Created in Contract line"	Boolean
"Source Type"	Enum Microsoft.SubscriptionBilling."Service Object Type"
"Source No."	Code[20]
"Item No."	Code[20]
"Subscription Description"	Text[100]
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

OpenExchangeSelectionPage

procedure OpenExchangeSelectionPage(var NewCurrencyFactorDate: Date; var NewCurrencyFactor: Decimal; CurrencyCode: Code[10]; NewMessageTxt: Text; CalledFromServiceObject: Boolean): Boolean

Parameters

Name	Type	Description
NewCurrencyFactorDate	Date
NewCurrencyFactor	Decimal
CurrencyCode	Code[10]
NewMessageTxt	Text
CalledFromServiceObject	Boolean

Returns

Type	Description
Boolean

UnitPriceForPeriod

procedure UnitPriceForPeriod(ChargePeriodStart: Date; ChargePeriodEnd: Date): Decimal

Parameters

Name	Type	Description
ChargePeriodStart	Date
ChargePeriodEnd	Date

Returns

Type	Description
Decimal

Events

OnAfterUpdateNextBillingDate

[IntegrationEvent(False,False)]
local procedure OnAfterUpdateNextBillingDate(var SubscriptionLine: Record "Subscription Line"; LastBillingToDate: Date)

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
LastBillingToDate	Date

OnAfterCalculateServiceAmount

[IntegrationEvent(False,False)]
local procedure OnAfterCalculateServiceAmount(var SubscriptionLine: Record "Subscription Line"; CalledByFieldNo: Integer)

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
CalledByFieldNo	Integer

OnAfterUpdateSubscriptionLine

[IntegrationEvent(False,False)]
local procedure OnAfterUpdateSubscriptionLine(var SubscriptionLine: Record "Subscription Line")

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"

OnAfterGetCombinedDimensionSetID

[IntegrationEvent(False,False)]
local procedure OnAfterGetCombinedDimensionSetID(var SubscriptionLine: Record "Subscription Line")

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"

OnBeforeValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateShortcutDimCode(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
xSubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
FieldNumber	Integer
ShortcutDimCode	Code[20]

OnAfterValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnAfterValidateShortcutDimCode(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
xSubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
FieldNumber	Integer
ShortcutDimCode	Code[20]

OnBeforeValidateDimensionSetID

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateDimensionSetID(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line")

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
xSubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"

OnAfterValidateDimensionSetID

[IntegrationEvent(False,False)]
local procedure OnAfterValidateDimensionSetID(var SubscriptionLine: Record "Subscription Line"; xSubscriptionLine: Record "Subscription Line")

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
xSubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"

OnAfterCopyFromSalesSubscriptionLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromSalesSubscriptionLine(var SubscriptionLine: Record "Subscription Line"; SalesSubscriptionLine: Record "Sales Subscription Line")

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
SalesSubscriptionLine	Table Microsoft.SubscriptionBilling."Sales Subscription Line"

OnBeforeCheckServiceDates

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckServiceDates(ServiceStartDate: Date; ServiceEndDate: Date; NextBillingDate: Date; var IsHandled: Boolean)

Parameters

Name	Type	Description
ServiceStartDate	Date
ServiceEndDate	Date
NextBillingDate	Date
IsHandled	Boolean

OnAfterUpdateServiceCommitmentFromContractPriceUpdateLine

[IntegrationEvent(False,False)]
local procedure OnAfterUpdateServiceCommitmentFromContractPriceUpdateLine(var SubscriptionLine: Record "Subscription Line"; SubContractPriceUpdateLine: Record "Sub. Contr. Price Update Line")

Parameters

Name	Type	Description
SubscriptionLine	Table Microsoft.SubscriptionBilling."Subscription Line"
SubContractPriceUpdateLine	Table Microsoft.SubscriptionBilling."Sub. Contr. Price Update Line"

See also

• Table