Deferral Post. Buffer

Dynamics 365 BC Table ReferenceTablesCompany TablesDDeferral Post. Buffer

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

Table Type: Company

Table Name: Deferral Post. Buffer
Database Table Name: CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1703

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 Deferral Post. Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Type]
   ,[G_L Account]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Tax Area Code]
   ,[Tax Group Code]
   ,[Tax Liable]
   ,[Use Tax]
   ,[Job No_]
   ,[Posting Date]
   ,[Amount]
   ,[Amount (LCY)]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Description]
   ,[Deferral Account]
   ,[Period Description]
   ,[Deferral Doc_ Type]
   ,[Document No_]
   ,[Sales_Purch Amount]
   ,[Sales_Purch Amount (LCY)]
   ,[Gen_ Posting Type]
   ,[Partial Deferral]
   ,[Dimension Set ID]
   ,[Deferral Code]
   ,[Deferral Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Deferral Post. Buffer].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Deferral Post. Buffer].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Deferral Post. Buffer].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Deferral Post. Buffer].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Deferral Post. Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Deferral Post. Buffer].[Deferral Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Deferral Post. Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Deferral Post. Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Deferral Post. Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Prepmt. Exch. Rate Difference”
  • “G/L Account”
  • “Item”
  • “Resource”
  • “Fixed Asset”
2G/L Account Primary Key SearchG/L AccountNormalCode20G_L Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[G_L Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Deferral Post. Buffer].[G_L Account] = [G/L Account].[No_]
3Gen. Bus. Posting Group Primary Key SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

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

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Deferral Post. Buffer].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
5VAT Bus. Posting Group Primary Key SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Deferral Post. Buffer].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
6VAT Prod. Posting Group Primary Key SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Deferral Post. Buffer].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
7Tax Area Code Primary Key SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Deferral Post. Buffer].[Tax Area Code] = [Tax Area].[Code]
8Tax Group Code Primary Key SearchTax Group CodeNormalCode20Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Deferral Post. Buffer].[Tax Group Code] = [Tax Group].[Code]
9Tax Liable Primary Key SearchTax LiableNormalBoolean4Tax Liabletinyint
10Use Tax Primary Key SearchUse TaxNormalBoolean4Use Taxtinyint
11Job No. Primary Key SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Deferral Post. Buffer].[Job No_] = [Job].[No_]
12Posting Date Primary Key SearchPosting DateNormalDate4Posting Datedatetime
13Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
14Amount (LCY) SearchAmount (LCY)NormalDecimal12Amount (LCY)decimal(38,38)
15System-Created Entry SearchSystem-Created EntryNormalBoolean4
16Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Deferral Post. Buffer].[Global Dimension 1 Code] = [Dimension].[Code]
17Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Deferral Post. Buffer].[Global Dimension 2 Code] = [Dimension].[Code]
18Description SearchDescriptionNormalText100Descriptionnvarchar(200)
19Deferral Account SearchDeferral AccountNormalCode20Deferral Accountnvarchar(40)
20Period Description SearchPeriod DescriptionNormalText100Period Descriptionnvarchar(200)
21Deferral Doc. Type SearchDeferral Doc. TypeNormalOption4Deferral Doc_ Typeint
Available options are:
  • “Purchase”
  • “Sales”
  • “G/L”
22Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
24Sales/Purch Amount SearchSales/Purch AmountNormalDecimal12Sales_Purch Amountdecimal(38,38)
25Sales/Purch Amount (LCY) SearchSales/Purch Amount (LCY)NormalDecimal12Sales_Purch Amount (LCY)decimal(38,38)
26Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
27Partial Deferral Primary Key SearchPartial DeferralNormalBoolean4Partial Deferraltinyint
480Dimension Set ID Primary Key SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Deferral Post. Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1700Deferral Code Primary Key SearchDeferral CodeNormalCode10Deferral Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

SELECT
       [Deferral Post. Buffer].[Deferral Code]
       ,[Deferral Template].[Deferral Code]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
              ON
                     [Deferral Post. Buffer].[Deferral Code] = [Deferral Template].[Deferral Code]
1701Deferral Line No. SearchDeferral Line No.NormalInteger4Deferral Line No_int
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
       [Deferral Post. Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Deferral Post. 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
       [Deferral Post. Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Deferral Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Post. Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Deferral Post. Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Deferral Post. Buffer table

Tax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesDDeferral Post. Buffer

Leave a Reply

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