Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30137
Table Type: Company
Table Name: Shpfy Initial Import Line
Database Table Name: CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb
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 Shpfy Initial Import Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb]
Show/hide an example select of all columns by name
SELECT
[Name]
,[Dependency Filter]
,[Session ID]
,[Job Status]
,[Job Queue Entry ID]
,[Job Queue Entry Status]
,[Shop Code]
,[Page ID]
,[Demo Import]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Initial Import Line]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Initial Import Line].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Initial Import Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Initial Import Line].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Shpfy Initial Import Line table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Name | Name | Normal | Code | 20 | Name | nvarchar(40) |
2 | Dependency Filter | Dependency Filter | Normal | Text | 250 | Dependency Filter | nvarchar(500) |
3 | Session ID | Session ID | Normal | Integer | 4 | Session ID | int |
4 | Job Status | Job Status | Normal | Option | 4 | Job Status | int |
Available options are:
| |||||||
5 | Job Queue Entry ID | Job Queue Entry ID | Normal | GUID | 16 | Job Queue Entry ID | uniqueidentifier |
6 | Job Queue Entry Status | Job Queue Entry Status | Normal | Option | 4 | Job Queue Entry Status | int |
Available options are:
| |||||||
7 | Shop Code | Shop Code | Normal | Code | 20 | Shop Code | nvarchar(40) |
Key to join to the Shpfy Shop table.Show/hide example querySELECT
[Shpfy Initial Import Line].[Shop Code]
,[Shpfy Shop].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Initial Import Line]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Initial Import Line].[Shop Code] = [Shpfy Shop].[Code] | |||||||
8 | Page ID | Page ID | Normal | Integer | 4 | Page ID | int |
9 | Demo Import | Demo Import | Normal | Boolean | 4 | Demo Import | tinyint |
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Shpfy Initial Import Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Initial Import Line]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Initial Import Line].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Shpfy Initial Import Line].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Initial Import Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Initial Import Line]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Initial Import Line].[$systemModifiedBy] = [User].[User Security ID] |