Table 5344 "CRM Post"
Base Application · Microsoft.Integration.D365Sales
Across versions
- BC23present
- BC245 fields changed
- BC25-30unchanged
Neighbourhood 6 connected objects and pages
Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | CRM Post |
| TableType | CRM |
| DataClassification | CustomerContent |
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 | CreatedBy | Guid | Created By caption | TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId) |
| 2 | CreatedByName Δ BC24 | Text[200] | — | FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy))) |
| 3 | CreatedOn | DateTime | Created On caption | |
| 4 | CreatedOnBehalfBy | Guid | Created By (Delegate) caption | TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId) |
| 5 | CreatedOnBehalfByName Δ BC24 | Text[200] | — | FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy))) |
| 6 | OrganizationId | Guid | Organization caption | TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId) |
| 7 | OrganizationIdName Δ BC24 | Text[160] | — | FlowField: lookup(“CRM Organization”.Name where(OrganizationId = field(OrganizationId))) |
| 8 | PostId | Guid | Post caption | |
| 9 | RegardingObjectId | Guid | Regarding caption | TableRelation Table 5340 “CRM Systemuser”, Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (RegardingObjectTypeCode = const(systemuser)) “CRM Systemuser”.SystemUserId else if (RegardingObjectTypeCode = const(account)) “CRM Account”.AccountId else if (RegardingObjectTypeCode = const(contact)) “CRM Contact”.ContactId else if (RegardingObjectTypeCode = const(opportunity)) “CRM Opportunity…) |
| 10 | RegardingObjectTypeCode | Option | — | OptionCaption: ,systemuser,account,contact,opportunity,post,transactioncurrency,pricelevel,productpricelevel,product,incident,incidentresolution,quote,quotedetail,salesorder,salesorderdetail,invoice,invoicedetail,contract,team,customeraddress,uom,uomschedule,organization,businessunit,discount,discounttype |
| 11 | Source | Option | — | OptionCaption: Auto Post,Manual Post |
| 12 | Text | Text[250] | — | |
| 13 | TimeZoneRuleVersionNumber | Integer | Time Zone Rule Version Number caption | |
| 14 | Type | Option | — | OptionCaption: Check-in,Idea,News,Private Message,Question,Re-post,Status |
| 15 | UTCConversionTimeZoneCode | Integer | UTC Conversion Time Zone Code caption | |
| 16 | RegardingObjectOwnerId | Guid | Owner caption | TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (RegardingObjectOwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (RegardingObjectOwnerIdType = const(team)) “CRM Team”.TeamId) |
| 17 | RegardingObjectOwnerIdType | Option | — | OptionCaption: ,systemuser,team |
| 18 | RegardingObjectOwningBusinessU | Guid | Regarding object owning Business Unit caption | TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId) |
| 19 | ModifiedBy | Guid | Modified By caption | TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId) |
| 20 | ModifiedByName Δ BC24 | Text[200] | — | FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy))) |
| 21 | ModifiedOnBehalfBy | Guid | Modified By (Delegate) caption | TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId) |
| 22 | ModifiedOnBehalfByName Δ BC24 | Text[200] | — | FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy))) |
| 23 | ModifiedOn | DateTime | Modified On caption |
Keys
- Key1: PostId (clustered)
- Key2: Text
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”
- RegardingObjectId: TableRelation Table 5340 “CRM Systemuser” (conditional)
- RegardingObjectOwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
- RegardingObjectId: TableRelation Table 5341 “CRM Account” (conditional)
- RegardingObjectId: TableRelation Table 5342 “CRM Contact” (conditional)
- RegardingObjectOwnerId: TableRelation Table 5359 “CRM Team” (conditional)
- OrganizationIdName: CalcFormula Table 5363 “CRM Organization”
- OrganizationId: TableRelation Table 5363 “CRM Organization”
- RegardingObjectOwningBusinessU: TableRelation Table 5364 “CRM Businessunit”
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: "CRM Post"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.