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