Table 6420 "FS Customer Asset"

Base Application · Microsoft.Integration.FieldService · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	CRM
DataClassification	SystemMetadata
ObsoleteState	Removed
ObsoleteTag	28.0
ObsoleteReason	Field Service is moved to Field Service Integration app.

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	CustomerAssetId	GUID	Customer Asset caption
2	CreatedOn	Datetime	Created On caption
3	CreatedBy	GUID	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	ModifiedOn	Datetime	Modified On caption
5	ModifiedBy	GUID	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6	CreatedOnBehalfBy	GUID	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	ModifiedOnBehalfBy	GUID	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
16	OwnerId	GUID	Owner caption
21	OwningBusinessUnit	GUID	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
22	OwningUser	GUID	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
23	OwningTeam	GUID	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
25	StateCode	Option	Status caption
27	StatusCode	Option	Status Reason caption
29	VersionNumber	BigInteger	Version Number caption
30	ImportSequenceNumber	Integer	Import Sequence Number caption
31	OverriddenCreatedOn	Date	Record Created On caption
32	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
33	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
34	Name	Text[100]	—
36	Account	GUID	—	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
37	CustomerAssetCategory	GUID	Category caption	TableRelation Table 6422 “FS Customer Asset Category” (“FS Customer Asset Category”.CustomerAssetCategoryId)
38	Latitude Δ BC28	Decimal	—
39	Longitude Δ BC28	Decimal	—
40	MasterAsset Δ BC28	GUID	Top-Level Asset caption
41	ParentAsset Δ BC28	GUID	Parent Asset caption
42	Product	GUID	—	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
46	MasterAssetName Δ BC28	Text[100]	—	FlowField:
47	ParentAssetName Δ BC28	Text[100]	—	FlowField:
48	CustomerAssetCategoryName	Text[100]	—	FlowField: lookup(“FS Customer Asset Category”.Name where(CustomerAssetCategoryId = field(CustomerAssetCategory)))
50	DeviceId	Text[100]	Device ID caption
52	LastCommandSentTime	Date	Last Command Sent Time caption
53	RegistrationStatus	Option	Registration Status caption
56	Alert	Boolean	Active or in-progress alerts caption
58	AlertCount	Integer	Alert Count caption
59	AalertCount_Date	Datetime	Alert Count (Last Updated On) caption
60	AlertCount_State	Integer	Alert Count (State) caption
61	LastAlertTime	Datetime	Last active alert time caption
62	LastAlertTime_Date	Datetime	Last active alert time (Last Updated On) caption
63	LastAlertTime_State	Integer	Last active alert time (State) caption
64	AssetTag	Text[100]	Asset Tag caption
66	WorkOrderProduct	GUID	Work Order Product caption	TableRelation Table 6402 “FS Work Order Product” (“FS Work Order Product”.WorkOrderProductId)
67	WorkOrderProductName	Text[200]	—	FlowField: lookup(“FS Work Order Product”.Name where(WorkOrderProductId = field(WorkOrderProduct)))
68	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

PK: customerassetId (clustered)
Name: Name

Relations

CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwningUser: TableRelation Table 5340 “CRM Systemuser”
Account: TableRelation Table 5341 “CRM Account”
Product: TableRelation Table 5348 “CRM Product”
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”
WorkOrderProductName: CalcFormula Table 6402 “FS Work Order Product”
WorkOrderProduct: TableRelation Table 6402 “FS Work Order Product”
CustomerAssetCategoryName: CalcFormula Table 6422 “FS Customer Asset Category”
CustomerAssetCategory: TableRelation Table 6422 “FS Customer Asset Category”

Referenced by

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

Table 6400 “FS Work Order”: CustomerAssetName, CustomerAsset
Table 6402 “FS Work Order Product”: CustomerAssetName, CustomerAsset
Table 6403 “FS Work Order Incident”: CustomerAssetName, CustomerAsset
Table 6406 “FS Work Order Service”: CustomerAssetName, CustomerAsset

Deprecations

object: Removed 28.0 (#if not CLEANSCHEMA28), “Field Service is moved to Field Service Integration app.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "FS Customer Asset"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.