Subscription Line Archive #8073

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

54
Fields
0
Records
1
Primary key
1
FlowFields
11
Relations
Open in Data Explorer →

Primary key

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

All fields (54)

Subscription Line Archive — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Subscription No. Code Normal → Subscription Header #8057
4 Original Entry No. Integer Normal
5 Subscription Package Code Code Normal → Subscription Package #8055
6 Template Code Normal → Sub. Package Line Template #8054
7 Description Text Normal
8 Subscription Line Start Date Date Normal
9 Subscription Line End Date Date Normal
10 Next Billing Date Date Normal
11 Calculation Base Amount Decimal Normal
12 Calculation Base % Decimal Normal
13 Price Decimal Normal
14 Discount % Decimal Normal
15 Discount Amount Decimal Normal
16 Amount Decimal Normal
17 Billing Base Period DateFormula Normal
18 Invoicing via Option Normal
19 Invoicing Item No. Code Normal → Item #27
20 Partner Option Normal
21 Subscription Contract No. Code Normal
22 Notice Period DateFormula Normal
23 Initial Term DateFormula Normal
24 Subsequent Term DateFormula Normal
25 Billing Rhythm DateFormula Normal
26 Cancelation Possible Until Date Normal
27 Term Until Date Normal
28 Subscription Header Customer No. ⚡ FLOW Code FlowField
29 Subscription Contract Line No. Integer Normal
30 Customer Price Group Code Normal → Customer Price Group #6
31 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
32 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
33 Price ($) Decimal Normal
34 Discount Amount ($) Decimal Normal
35 Amount ($) Decimal Normal
36 Currency Code Code Normal → Currency #4
37 Currency Factor Decimal Normal
38 Currency Factor Date Date Normal
39 Calculation Base Amount ($) Decimal Normal
40 Discount Boolean Normal
41 Serial No. (Subscription) Code Normal
42 Quantity (Subscription) Decimal Normal
50 Next Price Update Date Normal
53 Type Of Update Option Normal
54 Perform Update On Date Normal
96 Variant Code (Subscription) Code Normal
100 Unit Cost Decimal Normal
101 Unit Cost ($) Decimal Normal
107 Closed Boolean Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
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 (9)

Tables referenced by fields on the Subscription Line Archive 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.
Customer Price Group
#6 · General Ledger · via Customer Price Group
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Currency
#4 · General Ledger · via Currency Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID