Table 6251 "Sust. Unit"
Sustainability · Microsoft.Sustainability.CRM
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 5 connected objects and pages
Sustainability · Microsoft.Sustainability.CRM · captioned “Unit” · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Unit |
| 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 | UnitId | Guid | Unit 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 data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6293 “Sust. ESG Unit List” | |
| 35 | BaseUnit | Guid | Base Unit caption | TableRelation Table 6251 “Sust. Unit” (“Sust. Unit”.UnitId) |
| 36 | ConversionFactor | Decimal | Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6293 “Sust. ESG Unit List” | |
| 37 | IsBaseUnit | Boolean | Is Base Unit caption | |
| 39 | ShouldValidateCreate | Boolean | Should Validate Create caption | |
| 42 | BaseUnitName | Text[100] | Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6293 “Sust. ESG Unit List” | FlowField: lookup(“Sust. Unit”.Name where(UnitId = field(BaseUnit))) |
Keys
- PK: UnitId (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”
- OwningTeam: TableRelation Table 5359 “CRM Team”
- OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
- BaseUnitName: CalcFormula Table 6251 “Sust. Unit”
- BaseUnit: TableRelation Table 6251 “Sust. Unit”
Referenced by
4 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 6246 “Sust. ESG Fact”: UnitName, Unit
- Table 6251 “Sust. Unit”: BaseUnitName, BaseUnit
Pages and codeunits on this table
- Page 6293 “Sust. ESG Unit 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: "Sust. Unit"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.