Table 6615 "FS Project Task"

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	ProjectTaskId	GUID	Business Central Project Task 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)
8	CreatedByName	Text[200]	—	FlowField: lookup(“CRM SystemUser”.FullName where(SystemUserId = field(CreatedBy)))
10	CreatedOnBehalfByName	Text[200]	—	FlowField: lookup(“CRM SystemUser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
12	ModifiedByName	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
14	ModifiedOnBehalfByName	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
18	StateCode	Option	Status caption
20	StatusCode	Option	Status Reason caption
22	VersionNumber	BigInteger	Version Number caption
23	ImportSequenceNumber	Integer	Import Sequence Number caption
24	OverriddenCreatedOn	Date	Record Created On caption
25	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
26	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
27	Description	Text[250]	Business Central Project Task Description caption
28	ProjectNumber	Text[250]	Business Central Project Number caption
29	ProjectTaskNumber	Text[250]	Business Central Project Task Number caption
30	ProjectDescription	Text[250]	Business Central Project Description caption
31	ServiceAccountId	GUID	Service Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
32	BillingAccountId	GUID	Billing Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
33	CompanyId	GUID	Company caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

PK: ProjectTaskId (clustered)
Name: Description

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
BillingAccountId: TableRelation Table 5341 “CRM Account”
ServiceAccountId: TableRelation Table 5341 “CRM Account”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

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

Table 6617 “FS Work Order”: ProjectTask
Table 6619 “FS Work Order Product”: ProjectTask
Table 6620 “FS Work Order Service”: ProjectTask

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 Project Task"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.