Deferral 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
   [timestamp]
   ,[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]
   ,[Dimension Set ID]
   ,[Job No_]
   ,[Deferral Code]
   ,[Posting Date]
   ,[Partial Deferral]
   ,[Amount]
   ,[Amount (LCY)]
   ,[System-Created Entry]
   ,[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]
   ,[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_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Deferral Post_ Buffer].[Job No_] = [Job].[Job No_]

Show/hide columns in Deferral Post_ Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Type Primary Key Searchint
3G_L Account Primary Key Searchnvarchar(40)
4Gen_ Bus_ Posting Group Primary Key Searchnvarchar(40)
5Gen_ Prod_ Posting Group Primary Key Searchnvarchar(40)
6VAT Bus_ Posting Group Primary Key Searchnvarchar(40)
7VAT Prod_ Posting Group Primary Key Searchnvarchar(40)
8Tax Area Code Primary Key Searchnvarchar(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]
9Tax Group Code Primary Key Searchnvarchar(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]
10Tax Liable Primary Key Searchtinyint
11Use Tax Primary Key Searchtinyint
12Dimension Set ID Primary Key Searchint
13Job No_ Primary Key Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Deferral Post_ Buffer].[Job No_]
       ,[Job].[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].[Job No_]
14Deferral Code Primary Key Searchnvarchar(20)
15Posting Date Primary Key Searchdatetime
16Partial Deferral Primary Key Searchtinyint
17Amount Searchdecimal(38,38)
18Amount (LCY) Searchdecimal(38,38)
19System-Created Entry Searchtinyint
20Global Dimension 1 Code Searchnvarchar(40)
21Global Dimension 2 Code Searchnvarchar(40)
22Description Searchnvarchar(200)
23Deferral Account Searchnvarchar(40)
24Period Description Searchnvarchar(200)
25Deferral Doc_ Type Searchint
26Document No_ Searchnvarchar(40)
27Sales_Purch Amount Searchdecimal(38,38)
28Sales_Purch Amount (LCY) Searchdecimal(38,38)
29Gen_ Posting Type Searchint
30Deferral Line No_ Searchint
31$systemId Searchuniqueidentifier
32$systemCreatedAt Searchdatetime
33$systemCreatedBy Searchuniqueidentifier
34$systemModifiedAt Searchdatetime
35$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Deferral Post_ Buffer table

Leave a Reply

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