Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30106
Table Type: Company
Table Name: Shpfy Customer Address
Database Table Name: CRONUS UK Ltd_$Shpfy Customer Address$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 Customer Address can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Id]
,[Customer Id]
,[Company]
,[First Name]
,[Last Name]
,[Address 1]
,[Address 2]
,[Zip]
,[City]
,[Country_Region Code]
,[Country_Region Name]
,[Province Code]
,[Province Name]
,[Phone]
,[Default]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$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 Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Shpfy Customer Address].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
[Company] AS [Company]
ON
[Shpfy Customer Address].[Company] = [Company].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Shpfy Customer Address].[City] = [Post Code].[City]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Customer Address].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Customer Address].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Customer Address table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Id   | Id | Normal | BigInteger | 8 | Id | bigint |
| 2 | Customer Id | Customer Id | Normal | BigInteger | 8 | Customer Id | bigint |
Key to join to the Customer table.Show/hide example querySELECT
[Shpfy Customer Address].[Customer Id]
,[Customer].[$systemId]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Shpfy Customer Address].[Customer Id] = [Customer].[$systemId] | |||||||
| 3 | Company | Company | Normal | Text | 100 | Company | nvarchar(200) |
Key to join to the Company table.Show/hide example querySELECT
[Shpfy Customer Address].[Company]
,[Company].[Name]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[Company] AS [Company]
ON
[Shpfy Customer Address].[Company] = [Company].[Name] | |||||||
| 4 | First Name | First Name | Normal | Text | 50 | First Name | nvarchar(100) |
| 5 | Last Name | Last Name | Normal | Text | 50 | Last Name | nvarchar(100) |
| 6 | Address 1 | Address1 | Normal | Text | 100 | Address 1 | nvarchar(200) |
| 7 | Address 2 | Address2 | Normal | Text | 100 | Address 2 | nvarchar(200) |
| 8 | Zip | Zip | Normal | Code | 20 | Zip | nvarchar(40) |
| 9 | City | City | Normal | Text | 50 | City | nvarchar(100) |
Key to join to the Post Code table.Show/hide example querySELECT
[Shpfy Customer Address].[City]
,[Post Code].[City]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Shpfy Customer Address].[City] = [Post Code].[City] | |||||||
| 10 | Country/Region Code | Country/Region Code | Normal | Code | 2 | Country_Region Code | nvarchar(4) |
Key to join to the Country/Region table.Show/hide example querySELECT
[Shpfy Customer Address].[Country_Region Code]
,[Country/Region].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
ON
[Shpfy Customer Address].[Country_Region Code] = [Country/Region].[Code] | |||||||
| 11 | Country/Region Name | Country/Region Name | Normal | Text | 50 | Country_Region Name | nvarchar(100) |
| 12 | Province Code | Province Code | Normal | Code | 2 | Province Code | nvarchar(4) |
| 13 | Province Name | Province Name | Normal | Text | 50 | Province Name | nvarchar(100) |
| 14 | Phone | Phone | Normal | Text | 30 | Phone | nvarchar(60) |
| 15 | Default | Default | Normal | Boolean | 4 | Default | tinyint |
| 101 | Ship-To Address SystemId | Ship-To Address SystemId | Normal | GUID | 16 | ||
| 102 | CustomerSystemId | Customer System Id | Normal | GUID | 16 | ||
| 103 | Customer No. | Customer No. | FlowField | Code | 20 | ||
| 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 Customer Address].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Customer Address].[$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 Customer Address].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Customer Address$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Customer Address]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Customer Address].[$systemModifiedBy] = [User].[User Security ID] | |||||||