Capacity Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCapacity 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

   [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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Capacity Ledger Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Stop$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stop]
      ON
         [Capacity Ledger Entry].[Stop Code] = [Stop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Scrap$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Scrap]
      ON
         [Capacity Ledger Entry].[Scrap Code] = [Scrap].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
      ON
         [Capacity Ledger Entry].[Work Center Group Code] = [Work Center Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
      ON
         [Capacity Ledger Entry].[Work Shift Code] = [Work Shift].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Capacity Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Capacity Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Capacity Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Capacity Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Capacity Ledger Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	No.	No.	Normal	Code	20	No_	nvarchar(40)
3	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
4	Type	Type	Normal	Option	4	Type	int
	Available options are: “Work Center” “Machine Center” ” “ “Resource”
6	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Operation No.	Operation No.	Normal	Code	10	Operation No_	nvarchar(20)
9	Work Center No.	Work Center No.	Normal	Code	20	Work Center No_	nvarchar(40)
	Key to join to the Work Center table. Show/hide example query SELECT [Capacity Ledger Entry].[Work Center No_] ,[Work Center].[No_] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center] ON [Capacity Ledger Entry].[Work Center No_] = [Work Center].[No_]
10	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
11	Setup Time	Setup Time	Normal	Decimal	12	Setup Time	decimal(38,38)
12	Run Time	Run Time	Normal	Decimal	12	Run Time	decimal(38,38)
13	Stop Time	Stop Time	Normal	Decimal	12	Stop Time	decimal(38,38)
15	Invoiced Quantity	Invoiced Quantity	Normal	Decimal	12	Invoiced Quantity	decimal(38,38)
16	Output Quantity	Output Quantity	Normal	Decimal	12	Output Quantity	decimal(38,38)
17	Scrap Quantity	Scrap Quantity	Normal	Decimal	12	Scrap Quantity	decimal(38,38)
19	Concurrent Capacity	Concurrent Capacity	Normal	Decimal	12	Concurrent Capacity	decimal(38,38)
28	Cap. Unit of Measure Code	Cap. Unit of Measure Code	Normal	Code	10	Cap_ Unit of Measure Code	nvarchar(20)
	Key to join to the Capacity Unit of Measure table. Show/hide example query SELECT [Capacity Ledger Entry].[Cap_ Unit of Measure Code] ,[Capacity 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_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure] ON [Capacity Ledger Entry].[Cap_ Unit of Measure Code] = [Capacity Unit of Measure].[Code]
29	Qty. per Cap. Unit of Measure	Qty. per Cap. Unit of Measure	Normal	Decimal	12	Qty_ per Cap_ Unit of Measure	decimal(38,38)
33	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
34	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
39	Last Output Line	Last Output Line	Normal	Boolean	4	Last Output Line	tinyint
42	Completely Invoiced	Completely Invoiced	Normal	Boolean	4	Completely Invoiced	tinyint
43	Starting Time	Starting Time	Normal	Time	4	Starting Time	datetime
44	Ending Time	Ending Time	Normal	Time	4	Ending Time	datetime
52	Routing No.	Routing No.	Normal	Code	20	Routing No_	nvarchar(40)
	Key to join to the Routing Header table. Show/hide example query SELECT [Capacity Ledger Entry].[Routing No_] ,[Routing Header].[No_] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header] ON [Capacity Ledger Entry].[Routing No_] = [Routing Header].[No_]
53	Routing Reference No.	Routing Reference No.	Normal	Integer	4	Routing Reference No_	int
56	Item No.	Item No.	Normal	Code	20	Item No_	nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Capacity Ledger Entry].[Item No_] = [Item].[No_]
57	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Capacity Ledger Entry].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Capacity Ledger Entry].[Variant Code] = [Item Variant].[Code]
58	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
59	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
60	Document Date	Document Date	Normal	Date	4	Document Date	datetime
61	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
65	Stop Code	Stop Code	Normal	Code	10	Stop Code	nvarchar(20)
	Key to join to the Stop table. Show/hide example query SELECT [Capacity Ledger Entry].[Stop Code] ,[Stop].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Stop$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stop] ON [Capacity Ledger Entry].[Stop Code] = [Stop].[Code]
66	Scrap Code	Scrap Code	Normal	Code	10	Scrap Code	nvarchar(20)
	Key to join to the Scrap table. Show/hide example query SELECT [Capacity Ledger Entry].[Scrap Code] ,[Scrap].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Scrap$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Scrap] ON [Capacity Ledger Entry].[Scrap Code] = [Scrap].[Code]
68	Work Center Group Code	Work Center Group Code	Normal	Code	10	Work Center Group Code	nvarchar(20)
	Key to join to the Work Center Group table. Show/hide example query SELECT [Capacity Ledger Entry].[Work Center Group Code] ,[Work Center Group].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group] ON [Capacity Ledger Entry].[Work Center Group Code] = [Work Center Group].[Code]
69	Work Shift Code	Work Shift Code	Normal	Code	10	Work Shift Code	nvarchar(20)
	Key to join to the Work Shift table. Show/hide example query SELECT [Capacity Ledger Entry].[Work Shift Code] ,[Work Shift].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift] ON [Capacity Ledger Entry].[Work Shift Code] = [Work Shift].[Code]
71	Direct Cost	Direct Cost	FlowField	Decimal	12
72	Overhead Cost	Overhead Cost	FlowField	Decimal	12
76	Direct Cost (ACY)	Direct Cost (ACY)	FlowField	Decimal	12
77	Overhead Cost (ACY)	Overhead Cost (ACY)	FlowField	Decimal	12
78	Subcontracting	Subcontracting	Normal	Boolean	4	Subcontracting	tinyint
90	Order Type	Order Type	Normal	Option	4	Order Type	int
	Available options are: ” “ “Production” “Transfer” “Service” “Assembly”
91	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
92	Order Line No.	Order Line No.	Normal	Integer	4	Order Line No_	int
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Capacity Ledger Entry].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Capacity Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[] = [Dimension].[Code]
482	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[] = [Dimension].[Code]
483	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[] = [Dimension].[Code]
484	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[] = [Dimension].[Code]
485	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[] = [Dimension].[Code]
486	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Capacity Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Capacity Ledger Entry].[] = [Dimension].[Code]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Capacity Ledger Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry] LEFT JOIN [User] AS [User] ON [Capacity Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Capacity Ledger Entry table

Dynamics 365 BC Table Reference Tables Company Tables CCapacity Ledger Entry

Leave a Reply Cancel reply