Gen_ 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Journal Line No_ Primary Key Searchint
5Line No_ Primary Key Searchint
6Account No_ Searchnvarchar(40)
7Shortcut Dimension 1 Code Searchnvarchar(40)
8Shortcut Dimension 2 Code Searchnvarchar(40)
9Allocation Quantity Searchdecimal(38,38)
10Allocation _ Searchdecimal(38,38)
11Amount Searchdecimal(38,38)
12Gen_ Posting Type Searchint
13Gen_ Bus_ Posting Group Searchnvarchar(40)
14Gen_ Prod_ Posting Group Searchnvarchar(40)
15VAT Calculation Type Searchint
16VAT Amount Searchdecimal(38,38)
17VAT _ Searchdecimal(38,38)
18Tax Area Code Searchnvarchar(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]
19Tax Liable Searchtinyint
20Tax Group Code Searchnvarchar(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]
21Use Tax Searchtinyint
22VAT Bus_ Posting Group Searchnvarchar(40)
23VAT Prod_ Posting Group Searchnvarchar(40)
24Additional-Currency Amount Searchdecimal(38,38)
25Dimension Set ID Searchint
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Gen_ Jnl_ Allocation table

Leave a Reply

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