Cost Register

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1105

Table Type: Company

Table Name: Cost Register
Database Table Name: CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1105

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 Register can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Source]
   ,[Text]
   ,[From G_L Entry No_]
   ,[To G_L Entry No_]
   ,[From Cost Entry No_]
   ,[To Cost Entry No_]
   ,[No_ of Entries]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Processed Date]
   ,[Posting Date]
   ,[Closed]
   ,[Level]
   ,[Posting Time]
   ,[User ID]
   ,[Journal Batch Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Register]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Register].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Register].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Register table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalInteger4No_int
2Source Primary Key SearchSourceNormalOption4Sourceint
Available options are:
  • “Transfer from G/L”
  • “Cost Journal”
  • “Allocation”
  • “Transfer from Budget”
3Text SearchTextNormalText30Textnvarchar(60)
4From G/L Entry No. SearchFrom G/L Entry No.NormalInteger4From G_L Entry No_int
5To G/L Entry No. SearchTo G/L Entry No.NormalInteger4To G_L Entry No_int
6From Cost Entry No. SearchFrom Cost Entry No.NormalInteger4From Cost Entry No_int
Key to join to the Cost Entry table.

Show/hide example query

SELECT
	       [Cost Register].[From Cost Entry No_]
	       ,[Cost Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	              ON
	                     [Cost Register].[From Cost Entry No_] = [Cost Entry].[Entry No_]
7To Cost Entry No. SearchTo Cost Entry No.NormalInteger4To Cost Entry No_int
Key to join to the Cost Entry table.

Show/hide example query

SELECT
	       [Cost Register].[To Cost Entry No_]
	       ,[Cost Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	              ON
	                     [Cost Register].[To Cost Entry No_] = [Cost Entry].[Entry No_]
8No. of Entries SearchNo. of EntriesNormalInteger4No_ of Entriesint
15Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
16Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
20Processed Date SearchProcessed DateNormalDate4Processed Datedatetime
21Posting Date SearchPosting DateNormalDate4Posting Datedatetime
23Closed SearchClosedNormalBoolean4Closedtinyint
25Level SearchLevelNormalInteger4Levelint
26Posting Time SearchPosting TimeNormalTime4Posting Timedatetime
31User ID SearchUser IDNormalCode50User IDnvarchar(100)
32Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Cost Register].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Cost Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Register]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Cost Register].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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