Capacity Ledger Entry

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

Table Type: Company

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

Table Number: 5832

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[No_]
   ,[Posting Date]
   ,[Type]
   ,[Document No_]
   ,[Description]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Quantity]
   ,[Setup Time]
   ,[Run Time]
   ,[Stop Time]
   ,[Invoiced Quantity]
   ,[Output Quantity]
   ,[Scrap Quantity]
   ,[Concurrent Capacity]
   ,[Cap_ Unit of Measure Code]
   ,[Qty_ per Cap_ Unit of Measure]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Last Output Line]
   ,[Completely Invoiced]
   ,[Starting Time]
   ,[Ending Time]
   ,[Routing No_]
   ,[Routing Reference No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Document Date]
   ,[External Document No_]
   ,[Stop Code]
   ,[Scrap Code]
   ,[Work Center Group Code]
   ,[Work Shift Code]
   ,[Subcontracting]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Capacity 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_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Capacity Ledger Entry].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Capacity Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Capacity Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3No_ Searchnvarchar(40)
4Posting Date Searchdatetime
5Type Searchint
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Operation No_ Searchnvarchar(20)
9Work Center No_ Searchnvarchar(40)
10Quantity Searchdecimal(38,38)
11Setup Time Searchdecimal(38,38)
12Run Time Searchdecimal(38,38)
13Stop Time Searchdecimal(38,38)
14Invoiced Quantity Searchdecimal(38,38)
15Output Quantity Searchdecimal(38,38)
16Scrap Quantity Searchdecimal(38,38)
17Concurrent Capacity Searchdecimal(38,38)
18Cap_ Unit of Measure Code Searchnvarchar(20)
19Qty_ per Cap_ Unit of Measure Searchdecimal(38,38)
20Global Dimension 1 Code Searchnvarchar(40)
21Global Dimension 2 Code Searchnvarchar(40)
22Last Output Line Searchtinyint
23Completely Invoiced Searchtinyint
24Starting Time Searchdatetime
25Ending Time Searchdatetime
26Routing No_ Searchnvarchar(40)
27Routing Reference No_ Searchint
28Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Capacity Ledger Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Capacity Ledger Entry].[Item No_] = [Item].[No_]
29Variant Code Searchnvarchar(20)
30Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Capacity Ledger Entry].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Capacity Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
31Qty_ per Unit of Measure Searchdecimal(38,38)
32Document Date Searchdatetime
33External Document No_ Searchnvarchar(70)
34Stop Code Searchnvarchar(20)
35Scrap Code Searchnvarchar(20)
36Work Center Group Code Searchnvarchar(20)
37Work Shift Code Searchnvarchar(20)
38Subcontracting Searchtinyint
39Order Type Searchint
40Order No_ Searchnvarchar(40)
41Order Line No_ Searchint
42Dimension Set ID Searchint
43$systemId Searchuniqueidentifier
44$systemCreatedAt Searchdatetime
45$systemCreatedBy Searchuniqueidentifier
46$systemModifiedAt Searchdatetime
47$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Capacity Ledger Entry table

Leave a Reply

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