Table Sm_Subscription_Lines

Entity

Entity: Crm.Subscriptions.SubscriptionLines

Billable products within a subscription. Entity: Sm_Subscription_Lines (Introduced in version 24.1.2.6)

Owner Tables Hierarchy

Sm_Subscriptions

Summary

Name	Type	Description
Line_No	`int`	Consecutive number of the line within the subscription.
Notes	`nvarchar(max)`
Product_Id	`uniqueidentifier`	The product to be billed
Quantity	`decimal(12, 3)`	The quantity, which should be billed.
Quantity_Unit_Id	`uniqueidentifier`	The measurement unit of Quantity.
Row_Version	`timestamp`
Specific_Discount_Percent	`decimal(7, 6)`	The specific discount to apply for this line.
Subscription_Id	`uniqueidentifier`
Subscription_Line_Id	`uniqueidentifier` `PK`

Columns

Line_No

Consecutive number of the line within the subscription.

Property	Value
Auto Complete	no
Autoincrement	10
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	int
UI Memo Editor	no
UI Width	25
User Login	no
Visible	yes

Line_No - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	yes

Notes

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2147483647
Order	7
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(max) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Product_Id

The product to be billed

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Products
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Product_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Quantity

The quantity, which should be billed.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Format	N3
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(12, 3)
UI Memo Editor	no
UI Width	0
User Login	no
Visible	yes

Quantity - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	no

Quantity_Unit_Id

The measurement unit of Quantity.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Measurement_Units
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Quantity_Unit_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	8
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Specific_Discount_Percent

The specific discount to apply for this line.

Property	Value
Attributes	IsPercent
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(7, 6) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Subscription_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	1
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Sm_Subscriptions
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Subscription_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Subscription_Line_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Subscription_Line_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Table of Contents