Table 5964 "Service Contract Line"

Base Application · Microsoft.Service.Contract · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Service Contract Line
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Contract Type Δ BC28	Enum “Service Contract Type”	Specifies the type of the contract.	enum Enum 5965 “Service Contract Type”
2	Contract No. Δ BC28	Code[20]	Specifies the number of the service contract or service contract quote associated with the service contract line.	TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = field(“Contract Type”)))
3	Line No.	Integer	—
4	Contract Status Δ BC28	Enum “Service Contract Status”	Specifies the status of the contract.	enum Enum 5967 “Service Contract Status”
5	Service Item No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the service item that is subject to the service contract.	TableRelation Table 5940 “Service Item” (“Service Item” where(Blocked = filter(” “)))
6	Description Δ BC28	Text[100]	Specifies the description of the service item that is subject to the contract.
7	Serial No. Δ BC28	Code[50]	Specifies the serial number of the service item that is subject to the contract.
8	Service Item Group Code	Code[10]	—	TableRelation Table 5904 “Service Item Group” (Service Item Group)
9	Customer No. Δ BC28	Code[20]	Specifies the number of the customer associated with the service contract.	TableRelation Table 18 “Customer”
10	Ship-to Code Δ BC28	Code[10]	Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment.	TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”))); not editable
11	Item No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the item linked to the service item in the service contract.	TableRelation Table 27 “Item” (Item where(Type = const(Inventory), Blocked = const(false), “Service Blocked” = const(false)))
12	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (“Item No.” = filter(<> ‘’)) “Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)) else “Unit of Measure”)
13	Response Time (Hours) Δ BC28	Decimal	Specifies the response time for the service item associated with the service contract. via Page 6075 “Serv. Contr. List (Serv. Item)”
14	Last Planned Service Date Δ BC28	Date	Specifies the date of the last planned service on this item.	not editable
15	Next Planned Service Date Δ BC28	Date	Specifies the date of the next planned service on the item included in the contract.
16	Last Service Date Δ BC28	Date	Specifies the date when the service item on the line was last serviced.
17	Last Preventive Maint. Date Δ BC28	Date	Specifies the date when the last time preventative service was performed on this item.	not editable
18	Invoiced to Date	Date	—	not editable
19	Credit Memo Date Δ BC28	Date	Specifies the date when you can create a credit memo for the service item that needs to be removed from the service contract.
20	Contract Expiration Date Δ BC28	Date	Specifies the date when an item should be removed from the contract.
21	Service Period Δ BC28	DateFormula	Specifies the period of time that must pass between each servicing of an item.
22	Line Value Δ BC28	Decimal	Specifies the value of the service item line in the contract or contract quote.
23	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
24	Line Amount Δ BC28	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
28	Variant Code Δ BC24 Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”), Blocked = const(false), “Service Blocked” = const(false)))
29	Starting Date Δ BC28	Date	Specifies the starting date of the service contract.	not editable
30	New Line Δ BC28	Boolean	Specifies whether the service contract line is new or existing.	not editable
31	Credited Δ BC28	Boolean	Specifies if the service contract line has been credited.
32	Line Cost Δ BC28	Decimal	Specifies the calculated cost of the service item line in the service contract or contract quote.
33	Line Discount Amount Δ BC28	Decimal	Specifies the discount amount that is granted for the item on the line.
34	Profit Δ BC28	Decimal	Specifies the profit, expressed as the difference between the Line Amount and Line Cost fields on the service contract line.

Keys

Key1: Contract Type, Contract No., Line No. (clustered)
Key2: Contract No., Line No., Contract Type
Key3: Service Item No., Contract Status
Key4: Contract Type, Contract No., Credited, New Line
Key5: Customer No., Ship-to Code

Events published

OnAfterCalculateNextServiceVisit(ServContractHeader: Record "Service Contract Header"; ServMgtSetup: Record "Service Mgt. Setup") (integration)
OnAfterGetServiceItem(ServiceContractLine: Record "Service Contract Line"; var ServiceItem: Record "Service Item") (integration)
OnAfterLogContractLineChanges(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line") (integration)
OnAfterSetupNewLine(var ServiceContractLine: Record "Service Contract Line"; ServiceContractHeader: Record "Service Contract Header") (integration)
OnAfterTestStatusOpen(ServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer) (integration)
OnBeforeCheckServContractHeader(ServContractHeader: Record "Service Contract Header"; var IsHandled: Boolean) (integration)
OnBeforeCheckCreditMemoDate(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) (integration)
OnBeforeCreditMemoBaseExists(ServiceContractLine: Record "Service Contract Line"; var Result: Boolean; var IsHandled: Boolean) (integration)
OnBeforeValidateContractExpirationDate(var ServiceContractLine: Record "Service Contract Line"; var xServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
OnBeforeValidateLineAmount(var ServiceContractLine: Record "Service Contract Line"; var xServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
OnBeforeValidateLineDiscountPercent(var ServiceContractLine: Record "Service Contract Line"; var xServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
OnCalculateOtherLineAmountsOnAfterSetFilters(var ServiceContractLine: Record "Service Contract Line") (integration)
OnUpdateContractAnnualAmountOnAfterGetServContractHeader(var ServiceContractLine: Record "Service Contract Line"; ServContractHeader: Record "Service Contract Header"; var IsHandled: Boolean) (integration)
OnValidateServiceItemNoOnAfterCalcServiceItemNoIsNotEmpty(var ServiceContractLine: Record "Service Contract Line"; var ServiceItemNoIsNotEmpty: Boolean; xServiceContractLine: Record "Service Contract Line"; var HideDialog: Boolean) (integration)
OnValidateServiceItemNoOnBeforeCheckSameItemExist(var ServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) (integration)
OnValidateServiceItemNoOnAfterServContractLineSetFiltersWithContractStatus(var ServiceContractLine: Record "Service Contract Line"; var ServContractLine: Record "Service Contract Line") (integration)
OnValidateServiceItemNoOnBeforeCheckSameCustomer(ServItem: Record "Service Item"; var ServContractHeader: Record "Service Contract Header"; var IsHandled: Boolean) (integration)
OnValidateServiceItemNoOnBeforeModify(ServItem: Record "Service Item"; ServContractHeader: Record "Service Contract Header") (integration)
OnValidateServiceItemNoOnAfterInit(var ServContractLineRec: Record "Service Contract Line"; ServContractLine: Record "Service Contract Line") (integration)
OnValidateServiceItemNoOnBeforeOnValidate(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) (integration)
OnValidateServiceItemNoOnBeforeCheckServContractHeaderStatus(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) (integration)
OnBeforeSetupNewLine(var ServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) (integration)
OnBeforeCalculateNextServiceVisit(var ServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) (integration)
OnBeforeSelectMultipleServiceItems(var ServiceContractLine: Record "Service Contract Line") + BC24 (integration)
OnAfterSelectMultipleServiceItems(var ServiceContractLine: Record "Service Contract Line") + BC24 (integration)
OnBeforeAddServiceItems(var ServiceContractLine: Record "Service Contract Line"; SelectionFilter: Text; var IsHandled: Boolean) + BC24 (integration)

Trigger event subscribers

OnAfterDeleteEvent: Codeunit 6459 “Serv. Document Attachment Mgt.” DeleteAttachedDocumentsOnAfterDeleteServiceContractLine
OnAfterInsertEvent: Codeunit 6459 “Serv. Document Attachment Mgt.” DocumentAttachmentFlow_ForServiceContractLineInsert
OnAfterValidateEvent(Item No.): Codeunit 6459 “Serv. Document Attachment Mgt.” DocumentAttachmentFlow_ForServiceContractLineItemNoChange
OnAfterValidateEvent(Service Item No.): Codeunit 6459 “Serv. Document Attachment Mgt.” DocumentAttachmentFlow_ForServiceContractLineServiceItemNoChange
OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceContractLine

Procedures

SetupNewLine()
CalculateNextServiceVisit()
UpdateContractAnnualAmount(Deleting: Boolean)
HideDialogBox(Hide: Boolean)
TestStatusOpen()
GetStatusCheckSuspended(): Boolean
SuspendStatusCheck(Suspend: Boolean)
ShowComments()
ValidateServicePeriod(CurrentDate: Date)
CreditMemoBaseExists(): Boolean
LogContractLineChanges(ServContractLine2: Record "Service Contract Line")
SelectMultipleServiceItems() + BC24

Plus 8 local procedures.

Triggers

OnDelete, OnInsert, OnModify

Relations

drill-down page Page 6075 “Serv. Contr. List (Serv. Item)”
lookup page Page 6075 “Serv. Contr. List (Serv. Item)”
Customer No.: TableRelation Table 18 “Customer”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Ship-to Code: TableRelation Table 222 “Ship-to Address”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
Service Item Group Code: TableRelation Table 5904 “Service Item Group”
Service Item No.: TableRelation Table 5940 “Service Item”
Contract No.: TableRelation Table 5965 “Service Contract Header”

Referenced by

5 fields in 4 objects relate to this table (TableRelation or CalcFormula).

Table 5940 “Service Item”: No. of Active Contracts, Service Contracts
Table 5901 “Service Item Line”: Contract Line No.
Table 5965 “Service Contract Header”: Calcd. Annual Amount
Table 6011 “Service Item Line Archive”: Contract Line No.

Pages and codeunits on this table

Page 6052 “Service Contract Subform” (source table)
Page 6054 “Service Contract Quote Subform” (source table)
Page 6075 “Serv. Contr. List (Serv. Item)” (source table)
Page 6076 “Serv. Item List (Contract)” (source table)
Page 6078 “Service Contract Line List” (source table)
Codeunit 5945 “CreateCreditfromContractLines” (codeunit runs on it)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 5906 “ServLogManagement” (4 calls: OnDelete → ServItemRemovedFromContract, OnInsert → ServItemAddToContract, OnModify → ServItemAddToContract, …)
Codeunit 5940 “ServContractManagement” (3 calls: CreditMemoBaseExists → CalcContractLineAmount, CreditMemoBaseExists → FindFirstPrepaidTransaction, GetServItem → CheckServiceItemBlockedForServiceContract)
Codeunit 27 “Confirm Management” (1 call: OnDelete → GetResponseOrDefault)
Codeunit 5945 “CreateCreditfromContractLines” (1 call: OnDelete → (object))
Page 5911 “Service Comment Sheet” (1 call: ShowComments → (object))

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Service Contract Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.