Table 6624 "FS Warehouse"
FieldServiceIntegration · Microsoft.Integration.DynamicsFieldService
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 3 connected objects and pages
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 | WarehouseId | Guid | Warehouse 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 | Name | Text[20] | — | |
| 28 | Description | Text[100] | — | |
| 33 | CompanyId | GUID | Company caption | TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId) |
Keys
- PK: WarehouseId (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”
- CompanyId: TableRelation Table 5393 “CDS Company”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 6619 “FS Work Order Product”: WarehouseId
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 Warehouse"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.