Table 6420 FS Customer Asset in 24

Jonas Paprotka, Base Application 24.5.23489.36097, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Integration.FieldService
Obsolete: Pending 25.0. Field Service is moved to Field Service Integration app.

Versions171819202122232425 26 27 28 latest

Source29

Fields, 43

Id	Name	Type	Obsolete
1	CustomerAssetId	Guid	-
2	CreatedOn	DateTime	-
3	CreatedBy	Guid	-
4	ModifiedOn	DateTime	-
5	ModifiedBy	Guid	-
6	CreatedOnBehalfBy	Guid	-
7	ModifiedOnBehalfBy	Guid	-
16	OwnerId	Guid	-
21	OwningBusinessUnit	Guid	-
22	OwningUser	Guid	-
23	OwningTeam	Guid	-
25	StateCode	Option	-
27	StatusCode	Option	-
29	VersionNumber	BigInteger	-
30	ImportSequenceNumber	Integer	-
31	OverriddenCreatedOn	Date	-
32	TimeZoneRuleVersionNumber	Integer	-
33	UTCConversionTimeZoneCode	Integer	-
34	Name	Text[100]	-
36	Account	Guid	-
37	CustomerAssetCategory	Guid	-
38	Latitude	Decimal	-
39	Longitude	Decimal	-
40	MasterAsset	Guid	-
41	ParentAsset	Guid	-
42	Product	Guid	-
46	MasterAssetName	Text[100]	-
47	ParentAssetName	Text[100]	-
48	CustomerAssetCategoryName	Text[100]	-
50	DeviceId	Text[100]	-
52	LastCommandSentTime	Date	-
53	RegistrationStatus	Option	-
56	Alert	Boolean	-
58	AlertCount	Integer	-
59	AalertCount_Date	DateTime	-
60	AlertCount_State	Integer	-
61	LastAlertTime	DateTime	-
62	LastAlertTime_Date	DateTime	-
63	LastAlertTime_State	Integer	-
64	AssetTag	Text[100]	-
66	WorkOrderProduct	Guid	-
67	WorkOrderProductName	Text[200]	-
68	CompanyId	Guid	-

Name	Fields	Obsolete
PK, clustered	CustomerAssetId	-
Name	Name	-