Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5905
Table Type: Company
Table Name: Service Cost
Database Table Name: CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Service Cost can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Code]
,[Description]
,[Account No_]
,[Default Unit Price]
,[Default Quantity]
,[Unit of Measure Code]
,[Cost Type]
,[Service Zone Code]
,[Default Unit Cost]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cost]
LEFT JOIN
[CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
ON
[Service Cost].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
[User] AS [User]
ON
[Service Cost].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Service Cost].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Service Cost table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Code  | Code | Normal | Code | 10 | Code | nvarchar(20) |
| 2 | Description  | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 3 | Account No. | Account No. | Normal | Code | 20 | Account No_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT [Service Cost].[Account No_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cost] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Service Cost].[Account No_] = [G/L Account].[No_] | |||||||
| 4 | Default Unit Price | Default Unit Price | Normal | Decimal | 12 | Default Unit Price | decimal(38,38) |
| 5 | Default Quantity | Default Quantity | Normal | Decimal | 12 | Default Quantity | decimal(38,38) |
| 6 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
| 7 | Cost Type | Cost Type | Normal | Option | 4 | Cost Type | int |
Available options are:
| |||||||
| 8 | Service Zone Code | Service Zone Code | Normal | Code | 10 | Service Zone Code | nvarchar(20) |
Key to join to the Service Zone table.Show/hide example querySELECT [Service Cost].[Service Zone Code] ,[Service Zone].[Code] FROM [CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cost] LEFT JOIN [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone] ON [Service Cost].[Service Zone Code] = [Service Zone].[Code] | |||||||
| 9 | Default Unit Cost | Default Unit Cost | Normal | Decimal | 12 | Default Unit Cost | decimal(38,38) |
| 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 [Service Cost].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cost] LEFT JOIN [User] AS [User] ON [Service Cost].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |