Table 6011 "Service Item Line Archive"

Base Application · Microsoft.Service.Archive · BC25-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Service Item Line Archive
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	Document No.	Code[20]	—	TableRelation Table 6010 “Service Header Archive” (“Service Header Archive”.“No.” where(“Document Type” = field(“Document Type”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable
2	Line No. Δ BC28	Integer	Specifies the line number.
3	Service Item No. Δ BC28	Code[20]	Specifies the service item number registered in the Service Item table.	TableRelation Table 5940 “Service Item” (“Service Item”.“No.”)
4	Service Item Group Code Δ BC28	Code[10]	Specifies the code of the service item group for this item.	TableRelation Table 5904 “Service Item Group” (“Service Item Group”.Code)
5	Item No. Δ BC28	Code[20]	Specifies the item number linked to this service item.	TableRelation Item.“No.”
6	Serial No. Δ BC28	Code[50]	Specifies the serial number of this item.
7	Description Δ BC28	Text[100]	Specifies a description of this service item.
8	Description 2 Δ BC28	Text[50]	Specifies an additional description of this item.
9	Repair Status Code Δ BC28	Code[10]	Specifies the repair status of this service item.	TableRelation Table 5927 “Repair Status” (Repair Status)
10	Priority Δ BC28	Option	Specifies the service priority for this item.	OptionCaption: Low,Medium,High
11	Response Time (Hours) Δ BC28	Decimal	Specifies the estimated hours from order creation, to the time when the repair status of the item line changes from Initial, to In Process. via Page 6269 “Service Quote Archive Subform”
12	Response Date Δ BC28	Date	Specifies the estimated date when service should start on this service item line.
13	Response Time Δ BC28	Time	Specifies the estimated time when service should start on this service item.
14	Starting Date Δ BC28	Date	Specifies the date when service on this item began and when the repair status changed to In process.
15	Starting Time Δ BC28	Time	Specifies the time when service on this item began and when the repair status changed to In process.
16	Finishing Date Δ BC28	Date	Specifies the finishing date of the service and when the repair status of this item changes to Finished.
17	Finishing Time Δ BC28	Time	Specifies the finishing time of the service and when the repair status of this item changes to Finished.
18	Service Shelf No. Δ BC28	Code[10]	Specifies the number of the service shelf this item is stored on.	TableRelation Table 5929 “Service Shelf” (Service Shelf)
19	Warranty Starting Date (Parts)	Date	Specifies the starting date of the spare parts warranty for this item. via Page 6269 “Service Quote Archive Subform”
20	Warranty Ending Date (Parts)	Date	Specifies the ending date of the spare parts warranty for this item. via Page 6269 “Service Quote Archive Subform”
21	Warranty Δ BC28	Boolean	Specifies that warranty on either parts or labor exists for this item.
22	Warranty % (Parts) Δ BC28	Decimal	Specifies the percentage of spare parts costs covered by the warranty for this item. via Page 6269 “Service Quote Archive Subform”
23	Warranty % (Labor) Δ BC28	Decimal	Specifies the percentage of labor costs covered by the warranty for this item. via Page 6269 “Service Quote Archive Subform”
24	Warranty Starting Date (Labor)	Date	Specifies the starting date of the labor warranty for this item. via Page 6269 “Service Quote Archive Subform”
25	Warranty Ending Date (Labor)	Date	Specifies the ending date of the labor warranty for this item. via Page 6269 “Service Quote Archive Subform”
26	Contract No. Δ BC28	Code[20]	Specifies the number of the service contract associated with the item or service on the line.	TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract)))
28	Loaner No. Δ BC28	Code[20]	Specifies the number of the loaner that has been lent to the customer in the service order to replace this item.	TableRelation Loaner.“No.”
29	Vendor No. Δ BC28	Code[20]	Specifies the number of the vendor of this item.	TableRelation Table 23 “Vendor”
30	Vendor Item No. Δ BC28	Text[50]	Specifies the number that the vendor uses for this item.
31	Fault Reason Code Δ BC28	Code[10]	Specifies the fault reason code for the item.	TableRelation Table 5917 “Fault Reason Code” (Fault Reason Code)
32	Service Price Group Code Δ BC28	Code[10]	Specifies the code of the service price group associated with the item.	TableRelation Table 6080 “Service Price Group” (Service Price Group)
33	Fault Area Code Δ BC28	Code[10]	Specifies the fault area code for this item.	TableRelation Table 5915 “Fault Area” (Fault Area)
34	Symptom Code Δ BC28	Code[10]	Specifies the symptom code for this item.	TableRelation Table 5916 “Symptom Code” (Symptom Code)
35	Fault Code Δ BC28	Code[10]	Specifies the fault code for this item.	TableRelation Table 5918 “Fault Code” (“Fault Code”.Code where(“Fault Area Code” = field(“Fault Area Code”), “Symptom Code” = field(“Symptom Code”)))
36	Resolution Code Δ BC28	Code[10]	Specifies the resolution code for this item.	TableRelation Table 5919 “Resolution Code” (Resolution Code)
40	Variant Code Δ 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.”)))
42	Actual Response Time (Hours) Δ BC28	Decimal	—
43	Document Type	Enum “Service Document Type”	—	enum Enum 5900 “Service Document Type”; not editable
44	Serv. Price Adjmt. Gr. Code	Code[10]	—	TableRelation Table 6082 “Service Price Adjustment Group” (Service Price Adjustment Group); not editable
45	Adjustment Type Δ BC28	Option	Specifies the adjustment type for the line.	OptionCaption: Fixed,Maximum,Minimum; not editable
46	Base Amount to Adjust Δ BC28	Decimal	Specifies the amount that the service line, linked to this service item line, will be adjusted to.	not editable
63	Contract Line No.	Integer	—	TableRelation Table 5964 “Service Contract Line” (“Service Contract Line”.“Line No.” where(“Contract Type” = const(Contract), “Contract No.” = field(“Contract No.”)))
64	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
65	Customer No.	Code[20]	—	TableRelation Customer.“No.”; not editable
97	Responsibility Center	Code[10]	—	TableRelation Table 5714 “Responsibility Center” (Responsibility Center); not editable
100	Shortcut Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
101	Shortcut Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
130	Release Status	Enum “Service Doc. Release Status”	—	enum Enum 5916 “Service Doc. Release Status”
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
5047	Version No.	Integer	—
5048	Doc. No. Occurrence	Integer	—

Keys

Key1: Document Type, Document No., Doc. No. Occurrence, Version No., Line No. (clustered)

Trigger event subscribers

OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceItemLineArchive

Procedures

ShowDimensions()
ShowComments(Type: Option General,Fault,Resolution,Accessory,Internal,"Service Item Loaner")

Triggers

OnDelete

Relations

Ship-to Code: TableRelation Table 222 “Ship-to Address”
Vendor No.: TableRelation Table 23 “Vendor”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Variant Code: TableRelation Table 5401 “Item Variant”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Service Item Group Code: TableRelation Table 5904 “Service Item Group”
Fault Area Code: TableRelation Table 5915 “Fault Area”
Symptom Code: TableRelation Table 5916 “Symptom Code”
Fault Reason Code: TableRelation Table 5917 “Fault Reason Code”
Fault Code: TableRelation Table 5918 “Fault Code”
Resolution Code: TableRelation Table 5919 “Resolution Code”
Repair Status Code: TableRelation Table 5927 “Repair Status”
Service Shelf No.: TableRelation Table 5929 “Service Shelf”
Service Item No.: TableRelation Table 5940 “Service Item”
Contract Line No.: TableRelation Table 5964 “Service Contract Line”
Contract No.: TableRelation Table 5965 “Service Contract Header”
Document No.: TableRelation Table 6010 “Service Header Archive”
Service Price Group Code: TableRelation Table 6080 “Service Price Group”
Serv. Price Adjmt. Gr. Code: TableRelation Table 6082 “Service Price Adjustment Group”

Referenced by

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

Table 6012 “Service Line Archive”: Service Item Line No.
Table 6014 “Service Order Allocat. Archive”: Service Item Line No.

Pages and codeunits on this table

Page 6269 “Service Quote Archive Subform” (source table)
Page 6272 “Service Order Archive Subform” (source table)

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 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
Page 6266 “Service Archive 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 Item Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.