Service table in Microsoft Dynamics 365 Business Central. 38 fields, 0 records in Cronus demo.
The Filed Contract Line table (ID 5971) is part of the Service area in Microsoft Dynamics 365 Business Central. It contains 38 fields, with a primary key of Line No., Entry No.. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Line No., Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Filed Contract Line table through TableRelation properties.