Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30132
Table Type: Company
Table Name: Shpfy Credit Card Company
Database Table Name: CRONUS UK Ltd_$Shpfy Credit Card Company$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 Credit Card Company can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Name]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Credit Card Company$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 Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Credit Card Company].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Credit Card Company].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Credit Card Company table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Name   | Name | Normal | Text | 50 | Name | nvarchar(100) |
| 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 Credit Card Company].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Credit Card Company].[$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 Credit Card Company].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Credit Card Company].[$systemModifiedBy] = [User].[User Security ID] | |||||||