Gen_ Jnl_ Allocation – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGen_ Jnl_ Allocation

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

Table Type: Company

Table Name: Gen_ Jnl_ Allocation
Database Table Name: CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 221

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 Gen_ Jnl_ Allocation can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[Journal Line No_]
   ,[Line No_]
   ,[Account No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Allocation Quantity]
   ,[Allocation _]
   ,[Amount]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[VAT Amount]
   ,[VAT _]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Additional-Currency Amount]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen_ Jnl_ Allocation]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Gen_ Jnl_ Allocation].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Gen_ Jnl_ Allocation].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in Gen_ Jnl_ Allocation table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Journal Template Name	nvarchar(20)
3	Journal Batch Name	nvarchar(20)
4	Journal Line No_	int
5	Line No_	int
6	Account No_	nvarchar(40)
7	Shortcut Dimension 1 Code	nvarchar(40)
8	Shortcut Dimension 2 Code	nvarchar(40)
9	Allocation Quantity	decimal(38,38)
10	Allocation _	decimal(38,38)
11	Amount	decimal(38,38)
12	Gen_ Posting Type	int
13	Gen_ Bus_ Posting Group	nvarchar(40)
14	Gen_ Prod_ Posting Group	nvarchar(40)
15	VAT Calculation Type	int
16	VAT Amount	decimal(38,38)
17	VAT _	decimal(38,38)
18	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Gen_ Jnl_ Allocation].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen_ Jnl_ Allocation] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Gen_ Jnl_ Allocation].[Tax Area Code] = [Tax Area].[Code]
19	Tax Liable	tinyint
20	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Gen_ Jnl_ Allocation].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen_ Jnl_ Allocation] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Gen_ Jnl_ Allocation].[Tax Group Code] = [Tax Group].[Code]
21	Use Tax	tinyint
22	VAT Bus_ Posting Group	nvarchar(40)
23	VAT Prod_ Posting Group	nvarchar(40)
24	Additional-Currency Amount	decimal(38,38)
25	Dimension Set ID	int
26	$systemId	uniqueidentifier
27	$systemCreatedAt	datetime
28	$systemCreatedBy	uniqueidentifier
29	$systemModifiedAt	datetime
30	$systemModifiedBy	uniqueidentifier