Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1104
Table Type: Company
Table Name: Cost Entry
Database Table Name: CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 1104Due 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 Cost Entry can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Entry No_]
,[Cost Type No_]
,[Posting Date]
,[Document No_]
,[Description]
,[Amount]
,[Debit Amount]
,[Credit Amount]
,[Cost Center Code]
,[Cost Object Code]
,[Reason Code]
,[G_L Account]
,[G_L Entry No_]
,[Source Code]
,[Allocated]
,[Allocated with Journal No_]
,[User ID]
,[Batch Name]
,[Allocation Description]
,[Allocation ID]
,[Additional-Currency Amount]
,[Add_-Currency Debit Amount]
,[Add_-Currency Credit Amount]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
ON
[Cost Entry].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
ON
[Cost Entry].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Cost Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Cost Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
ON
[Cost Entry].[Batch Name] = [Gen. Journal Batch].[Journal Template Name]
LEFT JOIN
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
ON
[Cost Entry].[Allocation ID] = [Cost Allocation Source].[ID]
LEFT JOIN
[User] AS [User]
ON
[Cost Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cost Entry].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Entry No.  | Entry No. | Normal | Integer | 4 | Entry No_ | int |
| 4 | Cost Type No.  | Cost Type No. | Normal | Code | 20 | Cost Type No_ | nvarchar(40) |
| Key to join to the Cost Type table.SELECT
[Cost Entry].[Cost Type No_]
,[Cost Type].[No_]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
ON
[Cost Entry].[Cost Type No_] = [Cost Type].[No_] |
| 5 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
| 7 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
| 8 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 16 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
| 17 | Debit Amount | Debit Amount | Normal | Decimal | 12 | Debit Amount | decimal(38,38) |
| 18 | Credit Amount | Credit Amount | Normal | Decimal | 12 | Credit Amount | decimal(38,38) |
| 20 | Cost Center Code | Cost Center Code | Normal | Code | 20 | Cost Center Code | nvarchar(40) |
| Key to join to the Cost Center table.SELECT
[Cost Entry].[Cost Center Code]
,[Cost Center].[Code]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
ON
[Cost Entry].[Cost Center Code] = [Cost Center].[Code] |
| 21 | Cost Object Code | Cost Object Code | Normal | Code | 20 | Cost Object Code | nvarchar(40) |
| Key to join to the Cost Object table.SELECT
[Cost Entry].[Cost Object Code]
,[Cost Object].[Code]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
ON
[Cost Entry].[Cost Object Code] = [Cost Object].[Code] |
| 27 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
| Key to join to the Reason Code table.SELECT
[Cost Entry].[Reason Code]
,[Reason Code].[Code]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Cost Entry].[Reason Code] = [Reason Code].[Code] |
| 28 | G/L Account | G/L Account | Normal | Code | 20 | G_L Account | nvarchar(40) |
| 29 | G/L Entry No. | G/L Entry No. | Normal | Integer | 4 | G_L Entry No_ | int |
| 30 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
| Key to join to the Source Code table.SELECT
[Cost Entry].[Source Code]
,[Source Code].[Code]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Cost Entry].[Source Code] = [Source Code].[Code] |
| 31 | System-Created Entry | System-Created Entry | Normal | Boolean | 4 | | |
| 32 | Allocated | Allocated | Normal | Boolean | 4 | Allocated | tinyint |
| 33 | Allocated with Journal No. | Allocated with Register No. | Normal | Integer | 4 | Allocated with Journal No_ | int |
| 40 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 41 | Batch Name | Batch Name | Normal | Code | 10 | Batch Name | nvarchar(20) |
| Key to join to the Gen. Journal Batch table.SELECT
[Cost Entry].[Batch Name]
,[Gen. Journal Batch].[Journal Template Name]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
ON
[Cost Entry].[Batch Name] = [Gen. Journal Batch].[Journal Template Name] |
| 50 | Allocation Description | Allocation Description | Normal | Text | 80 | Allocation Description | nvarchar(160) |
| 51 | Allocation ID | Allocation ID | Normal | Code | 10 | Allocation ID | nvarchar(20) |
| Key to join to the Cost Allocation Source table.SELECT
[Cost Entry].[Allocation ID]
,[Cost Allocation Source].[ID]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
ON
[Cost Entry].[Allocation ID] = [Cost Allocation Source].[ID] |
| 68 | Additional-Currency Amount | Additional-Currency Amount | Normal | Decimal | 12 | Additional-Currency Amount | decimal(38,38) |
| 69 | Add.-Currency Debit Amount | Add.-Currency Debit Amount | Normal | Decimal | 12 | Add_-Currency Debit Amount | decimal(38,38) |
| 70 | Add.-Currency Credit Amount | Add.-Currency Credit Amount | Normal | Decimal | 12 | Add_-Currency Credit Amount | 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.SELECT
[Cost Entry].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
[User] AS [User]
ON
[Cost Entry].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
