Res_ 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Entry Type Searchint
4Document No_ Searchnvarchar(40)
5Posting Date Searchdatetime
6Resource No_ Searchnvarchar(40)
7Resource Group No_ Searchnvarchar(40)
8Description Searchnvarchar(200)
9Work Type Code Searchnvarchar(20)
10Job No_ Searchnvarchar(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_]
11Unit of Measure Code Searchnvarchar(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]
12Quantity Searchdecimal(38,38)
13Direct Unit Cost Searchdecimal(38,38)
14Unit Cost Searchdecimal(38,38)
15Total Cost Searchdecimal(38,38)
16Unit Price Searchdecimal(38,38)
17Total Price Searchdecimal(38,38)
18Global Dimension 1 Code Searchnvarchar(40)
19Global Dimension 2 Code Searchnvarchar(40)
20User ID Searchnvarchar(100)
21Source Code Searchnvarchar(20)
22Chargeable Searchtinyint
23Journal Batch Name Searchnvarchar(20)
24Reason Code Searchnvarchar(20)
25Gen_ Bus_ Posting Group Searchnvarchar(40)
26Gen_ Prod_ Posting Group Searchnvarchar(40)
27Document Date Searchdatetime
28External Document No_ Searchnvarchar(70)
29No_ Series Searchnvarchar(40)
30Source Type Searchint
31Source No_ Searchnvarchar(40)
32Qty_ per Unit of Measure Searchdecimal(38,38)
33Quantity (Base) Searchdecimal(38,38)
34Order Type Searchint
35Order No_ Searchnvarchar(40)
36Order Line No_ Searchint
37Dimension Set ID Searchint
38$systemId Searchuniqueidentifier
39$systemCreatedAt Searchdatetime
40$systemCreatedBy Searchuniqueidentifier
41$systemModifiedAt Searchdatetime
42$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Res_ Ledger Entry table

Leave a Reply

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