Subscription Line #8059

Other table in Microsoft Dynamics 365 Business Central. 66 fields, 0 records in Cronus demo.

66
Fields
0
Records
1
Primary key
7
FlowFields
12
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (66)

Subscription Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Subscription No. Code Normal → Subscription Header #8057
2 Entry No. PK Integer Normal
3 Subscription Package Code Code Normal → Subscription Package #8055
4 Template Code Normal → Sub. Package Line Template #8054
5 Description Text Normal
6 Subscription Line Start Date Date Normal
7 Subscription Line End Date Date Normal
8 Next Billing Date Date Normal
9 Calculation Base Amount Decimal Normal
10 Calculation Base % Decimal Normal
11 Price Decimal Normal
12 Discount % Decimal Normal
13 Discount Amount Decimal Normal
14 Amount Decimal Normal
15 Billing Base Period DateFormula Normal
16 Invoicing via Option Normal
17 Invoicing Item No. Code Normal → Item #27
18 Partner Option Normal
19 Subscription Contract No. Code Normal
20 Notice Period DateFormula Normal
21 Initial Term DateFormula Normal
22 Subsequent Term DateFormula Normal
23 Billing Rhythm DateFormula Normal
24 Cancelation Possible Until Date Normal
25 Term Until Date Normal
26 Subscription Customer No. ⚡ FLOW Code FlowField
27 Subscription Contract Line No. Integer Normal
29 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
30 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
31 Price ($) Decimal Normal
32 Discount Amount ($) Decimal Normal
33 Amount ($) Decimal Normal
34 Currency Code Code Normal → Currency #4
35 Currency Factor Decimal Normal
36 Currency Factor Date Date Normal
37 Calculation Base Amount ($) Decimal Normal
38 Discount Boolean Normal
39 Quantity ⚡ FLOW Decimal FlowField
40 Create Contract Deferrals Option Normal
42 Customer Price Group Code Normal → Customer Price Group #6
50 Next Price Update Date Normal
51 Exclude from Price Update Boolean Normal
52 Price Binding Period DateFormula Normal
59 Period Calculation Option Normal
100 Unit Cost Decimal Normal
101 Unit Cost ($) Decimal Normal
107 Closed Boolean Normal
200 Planned Subscription Line exists ⚡ FLOW Boolean FlowField
202 Renewal Term DateFormula Normal
210 Selected Boolean Normal
211 Indent Integer Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
8000 Usage Based Billing Boolean Normal
8001 Usage Based Pricing Option Normal
8002 Pricing Unit Cost Surcharge % Decimal Normal
8003 Supplier Reference Entry No. Integer Normal → Usage Data Supplier Reference #8015
8006 Created in Contract line Boolean Normal
8007 Source Type ⚡ FLOW Option FlowField
8008 Source No. ⚡ FLOW Code FlowField
8009 Item No. ⚡ FLOW Code FlowField
8010 Subscription Description ⚡ FLOW Text FlowField
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (10)

Tables referenced by fields on the Subscription Line table through TableRelation properties.

Subscription Header
#8057 · Other · via Subscription No.
Subscription Package
#8055 · Other · via Subscription Package Code
Sub. Package Line Template
#8054 · Other · via Template
Item
#27 · Inventory · via Invoicing Item No.
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Currency
#4 · General Ledger · via Currency Code
Customer Price Group
#6 · General Ledger · via Customer Price Group
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Usage Data Supplier Reference
#8015 · Other · via Supplier Reference Entry No.