Invt. Post to G/L Test Buffer

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

Table Type: Company

Table Name: Invt. Post to G/L Test Buffer
Database Table Name:

Table Number: 5822

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 Invt. Post to G/L Test Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   []

Show/hide an example select of all columns by name

SELECT
   [Line No_]
   ,[Account No_]
   ,[Posting Date]
   ,[Document No_]
   ,[Description]
   ,[Amount]
   ,[Source Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Additional-Currency Posting]
   ,[Source Currency Code]
   ,[Source Currency Amount]
   ,[Value Entry No_]
   ,[Location Code]
   ,[Invt_ Posting Group Code]
   ,[Inventory Account Type]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   []

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Invt_ Post to G_L Test Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Invt. Post to G/L Test Buffer].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Invt. Post to G/L Test Buffer].[Source Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt. Post to G/L Test Buffer].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Invt. Post to G/L Test Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Post to G/L Test Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Post to G/L Test Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Invt. Post to G/L Test Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Line No. Primary Key SearchLine No.NormalInteger4Line No_int
2Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Account No_]
       ,[G/L Account].[No_]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Invt. Post to G/L Test Buffer].[Account No_] = [G/L Account].[No_]
3Posting Date SearchPosting DateNormalDate4Posting Datedatetime
4Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
5Description SearchDescriptionNormalText100Descriptionnvarchar(200)
6Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
8Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Source Code]
       ,[Source Code].[Code]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Invt. Post to G/L Test Buffer].[Source Code] = [Source Code].[Code]
9System-Created Entry SearchSystem-Created EntryNormalBoolean4
10Gen. 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
       [Invt. Post to G/L Test Buffer].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Invt. Post to G/L Test Buffer].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
11Gen. 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
       [Invt. Post to G/L Test Buffer].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Invt. Post to G/L Test Buffer].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
13Additional-Currency Posting SearchAdditional-Currency PostingNormalOption4Additional-Currency Postingint
Available options are:
  • “None”
  • “Amount Only”
  • “Additional-Currency Amount Only”
14Source Currency Code SearchSource Currency CodeNormalCode10Source Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Source Currency Code]
       ,[Currency].[Code]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Invt. Post to G/L Test Buffer].[Source Currency Code] = [Currency].[Code]
15Source Currency Amount SearchSource Currency AmountNormalDecimal12Source Currency Amountdecimal(38,38)
16Value Entry No. SearchValue Entry No.NormalInteger4Value Entry No_int
Key to join to the Value Entry table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Value Entry No_]
       ,[Value Entry].[Entry No_]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
              ON
                     [Invt. Post to G/L Test Buffer].[Value Entry No_] = [Value Entry].[Entry No_]
17Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Location Code]
       ,[Location].[Code]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Invt. Post to G/L Test Buffer].[Location Code] = [Location].[Code]
18Invt. Posting Group Code SearchInvt. Posting Group CodeNormalCode20Invt_ Posting Group Codenvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Invt_ Posting Group Code]
       ,[Inventory Posting Group].[Code]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Invt. Post to G/L Test Buffer].[Invt_ Posting Group Code] = [Inventory Posting Group].[Code]
19Inventory Account Type SearchInventory Account TypeNormalOption4Inventory Account Typeint
Available options are:
  • “Inventory (Interim)”
  • “Invt. Accrual (Interim)”
  • “Inventory”
  • “WIP Inventory”
  • “Inventory Adjmt.”
  • “Direct Cost Applied”
  • “Overhead Applied”
  • “Purchase Variance”
  • “COGS”
  • “COGS (Interim)”
  • “Material Variance”
  • “Capacity Variance”
  • “Subcontracted Variance”
  • “Cap. Overhead Variance”
  • “Mfg. Overhead Variance”
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Invt. Post to G/L Test Buffer].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Invt. Post to G/L Test Buffer].[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
       [Invt. Post to G/L Test Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Invt. Post to G/L Test Buffer].[$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
       [Invt. Post to G/L Test Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [] AS [Invt. Post to G/L Test Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Invt. Post to G/L Test Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Invt. Post to G/L Test Buffer table

Leave a Reply

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