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
   [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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Gen. Jnl. Allocation].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Gen. Jnl. Allocation].[Shortcut Dimension 2 Code] = [Dimension].[Code]
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]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Gen. Jnl. Allocation].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Gen. Jnl. Allocation].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Gen. Jnl. Allocation].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Gen. Jnl. Allocation table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name Primary Key SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
3Journal Line No. Primary Key SearchJournal Line No.NormalInteger4Journal Line No_int
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Gen. Jnl. Allocation].[Account No_] = [G/L Account].[No_]
6Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Gen. Jnl. Allocation].[Shortcut Dimension 1 Code] = [Dimension].[Code]
7Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Gen. Jnl. Allocation].[Shortcut Dimension 2 Code] = [Dimension].[Code]
8Allocation Quantity SearchAllocation QuantityNormalDecimal12Allocation Quantitydecimal(38,38)
9Allocation % SearchAllocation %NormalDecimal12Allocation _decimal(38,38)
10Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
11Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
12Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Gen. Jnl. Allocation].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
13Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Gen. Jnl. Allocation].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
14VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
15VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
16VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
17Account Name SearchAccount NameFlowFieldText100
18Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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 SearchTax LiableNormalBoolean4Tax Liabletinyint
20Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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 SearchUse TaxNormalBoolean4Use Taxtinyint
22VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Gen. Jnl. Allocation].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
23VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Gen. Jnl. Allocation].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
24Additional-Currency Amount SearchAdditional-Currency AmountNormalDecimal12Additional-Currency Amountdecimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Gen. Jnl. Allocation].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [User] AS [User]
              ON
                     [Gen. Jnl. Allocation].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Gen. Jnl. Allocation].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Gen_ Jnl_ Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Allocation]
LEFT JOIN
       [User] AS [User]
              ON
                     [Gen. Jnl. Allocation].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Gen. Jnl. Allocation table

Leave a Reply

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