Table 5941 Service Item ComponentSetup BC Server URL to get a link to the data

Fields

#	Name ・Caption	Type
4 PK	Active	Boolean	CaptionML ENU=Active
1 PK	Parent Service Item No.	Code20	TableRelation "Service Item" Refers To Service Item CaptionML ENU=Parent Service Item No.
3 PK	Line No.	Integer	CaptionML ENU=Line No.
5	Type	Option	CaptionML ENU=Type OptionCaptionML ENU=Service Item,Item OptionString [Service Item,Item]
6	No.	Code20	TableRelation IF (Type=CONST(Service Item)) "Service Item" ELSE IF (Type=CONST(Item)) Item; Refers To Service Item Item CaptionML ENU=No.
7	Date Installed	Date	CaptionML ENU=Date Installed
8	Variant Code	Code10	TableRelation IF (Type=CONST(Item)) "Item Variant".Code WHERE (Item No.=FIELD(No.)) Refers To Item Variant CaptionML ENU=Variant Code
11	Serial No.	Code20	CaptionML ENU=Serial No.
12	Description	Text50	CaptionML ENU=Description
13	Description 2	Text50	CaptionML ENU=Description 2
15	Service Order No.	Code20	CaptionML ENU=Service Order No.
16	From Line No.	Integer	CaptionML ENU=From Line No.
17	Last Date Modified	Date	CaptionML ENU=Last Date Modified

Name	Fields
0	Active Parent Service Item No. Line No.	Clustered
1	Active Parent Service Item No. From Line No.
2	Type No. Active
3	Active Parent Service Item No. Type No.

From Field	To Table	To Field
No.	Item	No.	TableRelation IF (Type=CONST(Service Item)) "Service Item" ELSE IF (Type=CONST(Item)) Item; n:1
Variant Code	Item Variant	Code	TableRelation IF (Type=CONST(Item)) "Item Variant".Code WHERE (Item No.=FIELD(No.)) n:1
Parent Service Item No.	Service Item	No.	TableRelation "Service Item" n:1
No.	Service Item	No.	TableRelation IF (Type=CONST(Service Item)) "Service Item" ELSE IF (Type=CONST(Item)) Item; n:1