Res_ Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RRes_ Ledger Entry

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

Table Type: Company

Table Name: Res_ Ledger Entry
Database Table Name: CRONUS UK Ltd_$Res_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 203

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 Res_ Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Res_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Entry Type]
   ,[Document No_]
   ,[Posting Date]
   ,[Resource No_]
   ,[Resource Group No_]
   ,[Description]
   ,[Work Type Code]
   ,[Job No_]
   ,[Unit of Measure Code]
   ,[Quantity]
   ,[Direct Unit Cost]
   ,[Unit Cost]
   ,[Total Cost]
   ,[Unit Price]
   ,[Total Price]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[User ID]
   ,[Source Code]
   ,[Chargeable]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Document Date]
   ,[External Document No_]
   ,[No_ Series]
   ,[Source Type]
   ,[Source No_]
   ,[Qty_ per Unit of Measure]
   ,[Quantity (Base)]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Res_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Res_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Res_ Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Res_ Ledger Entry].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Res_ Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Res_ Ledger Entry table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Entry Type	int
4	Document No_	nvarchar(40)
5	Posting Date	datetime
6	Resource No_	nvarchar(40)
7	Resource Group No_	nvarchar(40)
8	Description	nvarchar(200)
9	Work Type Code	nvarchar(20)
10	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Res_ Ledger Entry].[Job No_] ,[Job].[Job No_] FROM [CRONUS UK Ltd_$Res_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Res_ Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Res_ Ledger Entry].[Job No_] = [Job].[Job No_]
11	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Res_ Ledger Entry].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Res_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Res_ Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Res_ Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
12	Quantity	decimal(38,38)
13	Direct Unit Cost	decimal(38,38)
14	Unit Cost	decimal(38,38)
15	Total Cost	decimal(38,38)
16	Unit Price	decimal(38,38)
17	Total Price	decimal(38,38)
18	Global Dimension 1 Code	nvarchar(40)
19	Global Dimension 2 Code	nvarchar(40)
20	User ID	nvarchar(100)
21	Source Code	nvarchar(20)
22	Chargeable	tinyint
23	Journal Batch Name	nvarchar(20)
24	Reason Code	nvarchar(20)
25	Gen_ Bus_ Posting Group	nvarchar(40)
26	Gen_ Prod_ Posting Group	nvarchar(40)
27	Document Date	datetime
28	External Document No_	nvarchar(70)
29	No_ Series	nvarchar(40)
30	Source Type	int
31	Source No_	nvarchar(40)
32	Qty_ per Unit of Measure	decimal(38,38)
33	Quantity (Base)	decimal(38,38)
34	Order Type	int
35	Order No_	nvarchar(40)
36	Order Line No_	int
37	Dimension Set ID	int
38	$systemId	uniqueidentifier
39	$systemCreatedAt	datetime
40	$systemCreatedBy	uniqueidentifier
41	$systemModifiedAt	datetime
42	$systemModifiedBy	uniqueidentifier