Table 5942 "Service Item Log"

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

Properties

Property	Value
Caption	Service Item Log
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	Service Item No. Δ BC28	Code[20]	Specifies the number of the event associated with the service item.	TableRelation Table 5940 “Service Item” (Service Item); NotBlank
2	Entry No. Δ BC28	Integer	Specifies the number of the entry, as assigned from the specified number series when the entry was created.
3	Event No.	Integer	—
4	Document No. Δ BC28	Code[20]	Specifies the document number of the event associated with the service item.	TableRelation Table 5900 “Service Header”, Table 5965 “Service Contract Header” (if (“Document Type” = const(Quote)) “Service Header”.“No.” where(“Document Type” = const(Quote)) else if (“Document Type” = const(Order)) “Service Header”.“No.” where(“Document Type” = const(Order)) else if (“Document Type” = const(Contract)) “Service Contract Header”.“Contract No.” where(“Contract …)
5	After Δ BC28	Text[50]	Specifies the value of the field modified after the event takes place.
6	Before Δ BC28	Text[50]	Specifies the previous value of the field, modified after the event takes place.
7	Change Date Δ BC28	Date	Specifies the date of the event.
8	Change Time Δ BC28	Time	Specifies the time of the event.
9	User ID Δ BC28	Code[50]	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
10	Document Type Δ BC28	Option	Specifies the document type of the service item associated with the event, such as contract, order, or quote.	OptionCaption: ,Quote,Order,Contract

Keys

Key1: Service Item No., Entry No. (clustered)
Key2: Change Date

Trigger event subscribers

OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceItemLog

Triggers

OnInsert

Relations

drill-down page Page 5989 “Service Item Log”
lookup page Page 5989 “Service Item Log”
Document No.: TableRelation Table 5900 “Service Header” (conditional)
Service Item No.: TableRelation Table 5940 “Service Item”
Document No.: TableRelation Table 5965 “Service Contract Header” (conditional)

Pages and codeunits on this table

Page 5989 “Service Item Log” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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 Item Log"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.