Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5714
Table Type: Company
Table Name: Responsibility Center
Database Table Name: CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 5714Due 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 Responsibility Center can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Code]
,[Name]
,[Address]
,[Address 2]
,[City]
,[Post Code]
,[Country_Region Code]
,[Phone No_]
,[Fax No_]
,[Name 2]
,[Contact]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Location Code]
,[County]
,[E-Mail]
,[Home Page]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Responsibility Center].[City] = [Post Code].[City]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Responsibility Center].[Post Code] = [Post Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Responsibility Center].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Responsibility Center].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Responsibility Center].[Location Code] = [Location].[Code]
LEFT JOIN
[User] AS [User]
ON
[Responsibility Center].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Responsibility Center].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Code  | Code | Normal | Code | 10 | Code | nvarchar(20) |
| 2 | Name  | Name | Normal | Text | 100 | Name | nvarchar(200) |
| 3 | Address | Address | Normal | Text | 100 | Address | nvarchar(200) |
| 4 | Address 2 | Address 2 | Normal | Text | 50 | Address 2 | nvarchar(100) |
| 5 | City | City | Normal | Text | 30 | City | nvarchar(60) |
| Key to join to the Post Code table.SELECT
[Responsibility Center].[City]
,[Post Code].[City]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Responsibility Center].[City] = [Post Code].[City] |
| 6 | Post Code | ZIP Code | Normal | Code | 20 | Post Code | nvarchar(40) |
| Key to join to the Post Code table.SELECT
[Responsibility Center].[Post Code]
,[Post Code].[Code]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Responsibility Center].[Post Code] = [Post Code].[Code] |
| 7 | Country/Region Code | Country/Region Code | Normal | Code | 10 | Country_Region Code | nvarchar(20) |
| 8 | Phone No. | Phone No. | Normal | Text | 30 | Phone No_ | nvarchar(60) |
| 9 | Fax No. | Fax No. | Normal | Text | 30 | Fax No_ | nvarchar(60) |
| 10 | Name 2 | Name 2 | Normal | Text | 50 | Name 2 | nvarchar(100) |
| 11 | Contact | Contact | Normal | Text | 100 | Contact | nvarchar(200) |
| 12 | Global Dimension 1 Code | Global Dimension 1 Code | Normal | Code | 20 | Global Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Responsibility Center].[Global Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Responsibility Center].[Global Dimension 1 Code] = [Dimension].[Code] |
| 13 | Global Dimension 2 Code | Global Dimension 2 Code | Normal | Code | 20 | Global Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Responsibility Center].[Global Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Responsibility Center].[Global Dimension 2 Code] = [Dimension].[Code] |
| 14 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
| Key to join to the Location table.SELECT
[Responsibility Center].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Responsibility Center].[Location Code] = [Location].[Code] |
| 15 | County | State | Normal | Text | 30 | County | nvarchar(60) |
| 102 | E-Mail | Email | Normal | Text | 80 | E-Mail | nvarchar(160) |
| 103 | Home Page | Home Page | Normal | Text | 90 | Home Page | nvarchar(180) |
| 5900 | Date Filter | Date Filter | FlowFilter | Date | 4 | | |
| 5901 | Contract Gain/Loss Amount | Contract Gain/Loss Amount | FlowField | Decimal | 12 | | |
| 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.SELECT
[Responsibility Center].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
LEFT JOIN
[User] AS [User]
ON
[Responsibility Center].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
