Filed Contract Line #5971

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

38
Fields
0
Records
2
Primary key
0
FlowFields
10
Relations
Open in Data Explorer →

Primary key

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

All fields (38)

Filed Contract Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Contract Type Option Normal
2 Contract No. Code Normal → Filed Service Contract Header #5970
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
80 Attached to Line No. Integer Normal → Filed Contract Line #5971
100 Entry No. PK 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 (9)

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

Filed Service Contract Header
#5970 · 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
Filed Contract Line
#5971 · Service · via Attached to Line No.