Service Contract Line #5964

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

36
Fields
0
Records
3
Primary key
0
FlowFields
9
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.FIELDTYPECLASSRELATION
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