Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2610
Table Type: System
Table Name: Feature Data Update Status
Database Table Name:
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Feature Data Update Status can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]Show/hide an example select of all columns by name
SELECT
FROM
[]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [Feature Data Update Status]
LEFT JOIN
[Company] AS [Company]
ON
[Feature Data Update Status].[Company Name] = [Company].[Name]
LEFT JOIN
[User] AS [User]
ON
[Feature Data Update Status].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Feature Data Update Status].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Feature Data Update Status table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Feature Key   | Feature Key | Normal | Text | 50 | ||
| 2 | Company Name | Company Name | Normal | Text | 30 | ||
| 3 | Data Update Required | Data Update Required | Normal | Boolean | 4 | ||
| 4 | Feature Status | Current Company Status | Normal | Option | 4 | ||
| 5 | Start Date/Time | Start Date/Time | Normal | DateTime | 8 | ||
| 6 | Confirmed | Confirmed | Normal | Boolean | 4 | ||
| 7 | Task Id | Task Id | Normal | GUID | 16 | ||
| 8 | Session Id | Session Id | Normal | Integer | 4 | ||
| 9 | Server Instance Id | Server Instance Id | Normal | Integer | 4 | ||
| 10 | Background Task | Background Task | Normal | Boolean | 4 | ||
| 7049 | Use Default Price Lists | Use default price lists | Normal | Boolean | 4 | ||
| 30200 | Shpfy Templates Migrate | Migrate Shopify templates | Normal | Boolean | 4 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | ||
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | ||
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | ||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 |