Cost Entry

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: 1104

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Cost Type No_ Searchnvarchar(40)
4Posting Date Searchdatetime
5Document No_ Searchnvarchar(40)
6Description Searchnvarchar(200)
7Amount Searchdecimal(38,38)
8Debit Amount Searchdecimal(38,38)
9Credit Amount Searchdecimal(38,38)
10Cost Center Code Searchnvarchar(40)
11Cost Object Code Searchnvarchar(40)
12Reason Code Searchnvarchar(20)
13G_L Account Searchnvarchar(40)
14G_L Entry No_ Searchint
15Source Code Searchnvarchar(20)
16System-Created Entry Searchtinyint
17Allocated Searchtinyint
18Allocated with Journal No_ Searchint
19User ID Searchnvarchar(100)
20Batch Name Searchnvarchar(20)
21Allocation Description Searchnvarchar(160)
22Allocation ID Searchnvarchar(20)
23Additional-Currency Amount Searchdecimal(38,38)
24Add_-Currency Debit Amount Searchdecimal(38,38)
25Add_-Currency Credit Amount Searchdecimal(38,38)
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *