Planned Subscription Line #8002

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

53
Fields
0
Records
1
Primary key
1
FlowFields
13
Relations
Open in Data Explorer →

Primary key

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

All fields (53)

Planned 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
42 Customer Price Group Code Normal → Customer Price Group #6
50 Next Price Update Date Normal
53 Type Of Update Option Normal
54 Perform Update On Date Normal
55 Price Binding Period DateFormula Normal
100 Unit Cost Decimal Normal
101 Unit Cost ($) Decimal Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1000 Sales Quote No. Code Normal → Sales Header #36
1001 Sales Quote Line No. Integer Normal
1002 Sales Order No. Code Normal → Sales Header #36
1003 Sales Order Line No. Integer Normal
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 Planned 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
Sales Header
#36 · Sales Documents · via Sales Quote No., Sales Order No.