Sub. Contr. Analysis Entry #8019

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

The Sub. Contr. Analysis Entry table (ID 8019) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 53 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

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)

Sub. Contr. Analysis Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Subscription No.	Code	Normal	→ Subscription Header #8057
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
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
27	Subscription Contract Line No.	Integer	Normal
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	Decimal	Normal
100	Unit Cost	Decimal	Normal
101	Unit Cost ($)	Decimal	Normal
202	Renewal Term	DateFormula	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
1000	Analysis Date	Date	Normal
1001	Monthly Recurring Revenue ($)	Decimal	Normal
1002	Monthly Recurring Cost ($)	Decimal	Normal
1005	Entry No.	Integer	Normal
1006	Partner No.	Code	Normal
8000	Usage Based Billing	Boolean	Normal
8007	Subscription Source Type	Option	Normal
8008	Subscription Source No.	Code	Normal
8009	Subscription Item No.	Code	Normal
8010	Subscription Description	Text	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 (7)

Tables referenced by fields on the Sub. Contr. Analysis Entry 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.

Currency

#4 · General Ledger · via Currency Code

Dimension Set Entry

#480 · Dimensions · via Dimension Set ID