Alloc. Account Distribution – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAlloc. Account Distribution

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

Table Type: Company

Table Name: Alloc. Account Distribution
Database Table Name: CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 2671

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 Alloc. Account Distribution can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Allocation Account No_]
   ,[Line No_]
   ,[Account Type]
   ,[Share]
   ,[Percent]
   ,[Share Updated at]
   ,[Destination Account Type]
   ,[Destination Account Number]
   ,[Breakdown Account Type]
   ,[Breakdown Account Number]
   ,[Calculation Period]
   ,[Dimension 1 Filter]
   ,[Dimension 2 Filter]
   ,[Dimension 3 Filter]
   ,[Dimension 4 Filter]
   ,[Dimension 5 Filter]
   ,[Dimension 6 Filter]
   ,[Dimension 7 Filter]
   ,[Dimension 8 Filter]
   ,[Business Unit Code Filter]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alloc. Account Distribution]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Alloc. Account Distribution].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Alloc. Account Distribution].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Alloc. Account Distribution].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Alloc. Account Distribution].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Alloc. Account Distribution].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Alloc. Account Distribution table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Allocation Account No.	Allocation Account No.	Normal	Code	20	Allocation Account No_	nvarchar(40)
	Key to join to the Allocation Account table. Show/hide example query SELECT [Alloc. Account Distribution].[Allocation Account No_] ,[Allocation Account].[No_] FROM [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alloc. Account Distribution] LEFT JOIN [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account] ON [Alloc. Account Distribution].[Allocation Account No_] = [Allocation Account].[No_]
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
4	Account Type	Account type	Normal	Option	4	Account Type	int
	Available options are: “Fixed” “Variable”
6	Share	Share	Normal	Decimal	12	Share	decimal(38,38)
7	Percent	Percent	Normal	Decimal	12	Percent	decimal(38,38)
8	Share Updated at	Shared Updated at	Normal	DateTime	8	Share Updated at	datetime
9	Destination Account Type	Destination Account Type	Normal	Option	4	Destination Account Type	int
	Available options are: “G/L Account” “Bank Account” “Inherit from Parent”
10	Destination Account Number	Destination Account Number	Normal	Code	20	Destination Account Number	nvarchar(40)
19	Breakdown Account Type	Breakdown Account Type	Normal	Option	4	Breakdown Account Type	int
	Available options are: “G/L Account” “Bank Account” “Statistical Account”
20	Breakdown Account Number	Breakdown Account Number	Normal	Code	20	Breakdown Account Number	nvarchar(40)
21	Calculation Period	Calculation Period	Normal	Option	4	Calculation Period	int
	Available options are: “Balance at Date” “Fiscal Year” “Week” “Last Week” “Month” “Last Month” “Quarter” “Last Quarter” “Year” “Last Year” “Month of Last Year” “Period” “Last Period” “Period of Last Year” “Last Fiscal Year”
23	Dimension 1 Filter	Dimension 1 Filter	Normal	Text	1024	Dimension 1 Filter	nvarchar(2048)
24	Dimension 2 Filter	Dimension 2 Filter	Normal	Text	1024	Dimension 2 Filter	nvarchar(2048)
25	Dimension 3 Filter	Dimension 3 Filter	Normal	Text	1024	Dimension 3 Filter	nvarchar(2048)
26	Dimension 4 Filter	Dimension 4 Filter	Normal	Text	1024	Dimension 4 Filter	nvarchar(2048)
27	Dimension 5 Filter	Dimension 5 Filter	Normal	Text	1024	Dimension 5 Filter	nvarchar(2048)
28	Dimension 6 Filter	Dimension 6 Filter	Normal	Text	1024	Dimension 6 Filter	nvarchar(2048)
29	Dimension 7 Filter	Dimension 7 Filter	Normal	Text	1024	Dimension 7 Filter	nvarchar(2048)
30	Dimension 8 Filter	Dimension 8 Filter	Normal	Text	1024	Dimension 8 Filter	nvarchar(2048)
35	Business Unit Code Filter	Business Unit Code Filter	Normal	Text	1024	Business Unit Code Filter	nvarchar(2048)
37	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 [Alloc. Account Distribution].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alloc. Account Distribution] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Alloc. Account Distribution].[Global Dimension 1 Code] = [Dimension].[Code]
38	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 [Alloc. Account Distribution].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alloc. Account Distribution] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Alloc. Account Distribution].[Global Dimension 2 Code] = [Dimension].[Code]
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 [Alloc. Account Distribution].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alloc. Account Distribution] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Alloc. Account Distribution].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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 [Alloc. Account Distribution].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Alloc_ Account Distribution$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alloc. Account Distribution] LEFT JOIN [User] AS [User] ON [Alloc. Account Distribution].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables AAlloc. Account Distribution

Leave a Reply Cancel reply