Service Contract Line #5964

Service table in Microsoft Dynamics 365 Business Central. 36 fields, 0 records in Cronus demo.

The Service Contract Line table (ID 5964) is part of the Service area in Microsoft Dynamics 365 Business Central. It contains 36 fields, with a primary key of Contract Type, Contract No., Line 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: Contract Type, Contract No., Line No..

All fields (36)

Service Contract Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Contract Type PK	Option	Normal
2	Contract No. PK	Code	Normal	→ Service Contract Header #5965
3	Line No. PK	Integer	Normal
4	Contract Status	Option	Normal
5	Service Item No.	Code	Normal	→ Service Item #5940
6	Description	Text	Normal
7	Serial No.	Code	Normal
8	Service Item Group Code	Code	Normal	→ Service Item Group #5904
9	Customer No.	Code	Normal	→ Customer #18
10	Ship-to Code	Code	Normal	→ Ship-to Address #222
11	Item No.	Code	Normal	→ Item #27
12	Unit of Measure Code	Code	Normal
13	Response Time (Hours)	Decimal	Normal
14	Last Planned Service Date	Date	Normal
15	Next Planned Service Date	Date	Normal
16	Last Service Date	Date	Normal
17	Last Preventive Maint. Date	Date	Normal
18	Invoiced to Date	Date	Normal
19	Credit Memo Date	Date	Normal
20	Contract Expiration Date	Date	Normal
21	Service Period	DateFormula	Normal
22	Line Value	Decimal	Normal
23	Line Discount %	Decimal	Normal
24	Line Amount	Decimal	Normal
28	Variant Code	Code	Normal	→ Item Variant #5401
29	Starting Date	Date	Normal
30	New Line	Boolean	Normal
31	Credited	Boolean	Normal
32	Line Cost	Decimal	Normal
33	Line Discount Amount	Decimal	Normal
34	Profit	Decimal	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 (8)

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

Service Contract Header

#5965 · Service · via Contract No.

Service Item

#5940 · Service · via Service Item No.

Service Item Group

#5904 · Service · via Service Item Group Code

Customer

#18 · Sales · via Customer No.

Ship-to Address

#222 · Other · via Ship-to Code

Item

#27 · Inventory · via Item No.

Item Variant

#5401 · Other · via Variant Code