Service Item Line Archive #6011

Other table in Microsoft Dynamics 365 Business Central. 56 fields, 0 records in Cronus demo.

56
Fields
0
Records
5
Primary key
0
FlowFields
26
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document No., Line No., Document Type, Version No., Doc. No. Occurrence.

All fields (56)

Service Item Line Archive — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document No. PK Code Normal → Service Header Archive #6010
2 Line No. PK Integer Normal
3 Service Item No. Code Normal → Service Item #5940
4 Service Item Group Code Code Normal → Service Item Group #5904
5 Item No. Code Normal → Item #27
6 Serial No. Code Normal
7 Description Text Normal
8 Description 2 Text Normal
9 Repair Status Code Code Normal → Repair Status #5927
10 Priority Option Normal
11 Response Time (Hours) Decimal Normal
12 Response Date Date Normal
13 Response Time Time Normal
14 Starting Date Date Normal
15 Starting Time Time Normal
16 Finishing Date Date Normal
17 Finishing Time Time Normal
18 Service Shelf No. Code Normal → Service Shelf #5929
19 Warranty Starting Date (Parts) Date Normal
20 Warranty Ending Date (Parts) Date Normal
21 Warranty Boolean Normal
22 Warranty % (Parts) Decimal Normal
23 Warranty % (Labor) Decimal Normal
24 Warranty Starting Date (Labor) Date Normal
25 Warranty Ending Date (Labor) Date Normal
26 Contract No. Code Normal → Service Contract Header #5965
28 Loaner No. Code Normal → Loaner #5913
29 Vendor No. Code Normal → Vendor #23
30 Vendor Item No. Text Normal
31 Fault Reason Code Code Normal → Fault Reason Code #5917
32 Service Price Group Code Code Normal → Service Price Group #6080
33 Fault Area Code Code Normal → Fault Area #5915
34 Symptom Code Code Normal → Symptom Code #5916
35 Fault Code Code Normal → Fault Code #5918
36 Resolution Code Code Normal → Resolution Code #5919
40 Variant Code Code Normal → Item Variant #5401
42 Actual Response Time (Hours) Decimal Normal
43 Document Type PK Option Normal
44 Serv. Price Adjmt. Gr. Code Code Normal → Service Price Adjustment Group #6082
45 Adjustment Type Option Normal
46 Base Amount to Adjust Decimal Normal
63 Contract Line No. Integer Normal → Service Contract Line #5964
64 Ship-to Code Code Normal → Ship-to Address #222
65 Customer No. Code Normal → Customer #18
97 Responsibility Center Code Normal → Responsibility Center #5714
100 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
101 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
130 Release Status Option Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5047 Version No. PK Integer Normal
5048 Doc. No. Occurrence 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 (24)

Tables referenced by fields on the Service Item Line Archive table through TableRelation properties.

Service Header Archive
#6010 · Other · via Document No.
Service Item
#5940 · Service · via Service Item No.
Service Item Group
#5904 · Service · via Service Item Group Code
Item
#27 · Inventory · via Item No.
Repair Status
#5927 · Service · via Repair Status Code
Service Shelf
#5929 · Service · via Service Shelf No.
Service Contract Header
#5965 · Service · via Contract No.
Loaner
#5913 · Service · via Loaner No.
Vendor
#23 · Purchasing · via Vendor No.
Fault Reason Code
#5917 · Service · via Fault Reason Code
Service Price Group
#6080 · Other · via Service Price Group Code
Fault Area
#5915 · Service · via Fault Area Code
Symptom Code
#5916 · Service · via Symptom Code
Fault Code
#5918 · Service · via Fault Code
Resolution Code
#5919 · Service · via Resolution Code
Item Variant
#5401 · Other · via Variant Code
Service Price Adjustment Group
#6082 · Other · via Serv. Price Adjmt. Gr. Code
Service Contract Line
#5964 · Service · via Contract Line No.
Ship-to Address
#222 · Other · via Ship-to Code
Customer
#18 · Sales · via Customer No.
Responsibility Center
#5714 · Other · via Responsibility Center
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID