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
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 Cost Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[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]
,[System-Created Entry]
,[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]Show/hide columns in Cost Entry table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Entry No_  | int |
| 3 | Cost Type No_ | nvarchar(40) |
| 4 | Posting Date | datetime |
| 5 | Document No_ | nvarchar(40) |
| 6 | Description | nvarchar(200) |
| 7 | Amount | decimal(38,38) |
| 8 | Debit Amount | decimal(38,38) |
| 9 | Credit Amount | decimal(38,38) |
| 10 | Cost Center Code | nvarchar(40) |
| 11 | Cost Object Code | nvarchar(40) |
| 12 | Reason Code | nvarchar(20) |
| 13 | G_L Account | nvarchar(40) |
| 14 | G_L Entry No_ | int |
| 15 | Source Code | nvarchar(20) |
| 16 | System-Created Entry | tinyint |
| 17 | Allocated | tinyint |
| 18 | Allocated with Journal No_ | int |
| 19 | User ID | nvarchar(100) |
| 20 | Batch Name | nvarchar(20) |
| 21 | Allocation Description | nvarchar(160) |
| 22 | Allocation ID | nvarchar(20) |
| 23 | Additional-Currency Amount | decimal(38,38) |
| 24 | Add_-Currency Debit Amount | decimal(38,38) |
| 25 | Add_-Currency Credit Amount | decimal(38,38) |
| 26 | $systemId | uniqueidentifier |
| 27 | $systemCreatedAt | datetime |
| 28 | $systemCreatedBy | uniqueidentifier |
| 29 | $systemModifiedAt | datetime |
| 30 | $systemModifiedBy | uniqueidentifier |