Table 6613 "FS Customer Asset"

FieldServiceIntegration · Microsoft.Integration.DynamicsFieldService · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	CRM
DataClassification	SystemMetadata

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]	Specifies the customer asset name. via Page 6611 “FS Customer Asset List”
36	Account	GUID	—	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
37	CustomerAssetCategory	GUID	Category caption	TableRelation Table 6614 “FS Customer Asset Category” (“FS Customer Asset Category”.CustomerAssetCategoryId)
38	Latitude	Decimal	—
39	Longitude	Decimal	—
40	MasterAsset	GUID	Top-Level Asset caption	TableRelation Table 6613 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
41	ParentAsset	GUID	Parent Asset caption	TableRelation Table 6613 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
42	Product	GUID	—	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
46	MasterAssetName	Text[100]	—	FlowField: lookup(“FS Customer Asset”.Name where(CustomerAssetId = field(MasterAsset)))
47	ParentAssetName	Text[100]	—	FlowField: lookup(“FS Customer Asset”.Name where(CustomerAssetId = field(ParentAsset)))
48	CustomerAssetCategoryName	Text[100]	Specifies the customer asset category name. via Page 6611 “FS Customer Asset List”	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]	Specifies the customer asset tag. via Page 6611 “FS Customer Asset List”
66	WorkOrderProduct	GUID	Work Order Product caption	TableRelation Table 6619 “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”
MasterAssetName: CalcFormula Table 6613 “FS Customer Asset”
ParentAssetName: CalcFormula Table 6613 “FS Customer Asset”
MasterAsset: TableRelation Table 6613 “FS Customer Asset”
ParentAsset: TableRelation Table 6613 “FS Customer Asset”
CustomerAssetCategoryName: CalcFormula Table 6614 “FS Customer Asset Category”
CustomerAssetCategory: TableRelation Table 6614 “FS Customer Asset Category”
WorkOrderProductName: CalcFormula Table 6619 “FS Work Order Product”
WorkOrderProduct: TableRelation Table 6619 “FS Work Order Product”

Referenced by

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

Table 6613 “FS Customer Asset”: MasterAssetName, ParentAssetName, MasterAsset, ParentAsset
Table 6617 “FS Work Order”: CustomerAssetName, CustomerAsset
Table 6618 “FS Work Order Incident”: CustomerAssetName, CustomerAsset
Table 6619 “FS Work Order Product”: CustomerAssetName, CustomerAsset
Table 6620 “FS Work Order Service”: CustomerAssetName, CustomerAsset

Pages and codeunits on this table

Page 6611 “FS Customer Asset List” (source table)

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.