Invoice Post_ Buffer

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

Table Type: Company

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

Table Number: 49

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 Invoice Post_ Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Invoice 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_]
   ,[Fixed Asset Line No_]
   ,[Deferral Code]
   ,[Additional Grouping Identifier]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Amount]
   ,[VAT Amount]
   ,[VAT Calculation Type]
   ,[VAT Base Amount]
   ,[System-Created Entry]
   ,[Quantity]
   ,[Amount (ACY)]
   ,[VAT Amount (ACY)]
   ,[VAT Base Amount (ACY)]
   ,[VAT Difference]
   ,[VAT _]
   ,[VAT Base Before Pmt_ Disc_]
   ,[Entry Description]
   ,[Deferral Line No_]
   ,[FA Posting Date]
   ,[FA Posting Type]
   ,[Depreciation Book Code]
   ,[Salvage Value]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[Maintenance Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Invoice 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_$Invoice Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invoice Post_ Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Invoice Post_ Buffer].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Invoice Post_ Buffer].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Invoice Post_ Buffer].[Job No_] = [Job].[Job No_]

Show/hide columns in Invoice 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
       [Invoice Post_ Buffer].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Invoice Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invoice Post_ Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Invoice 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
       [Invoice Post_ Buffer].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Invoice Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invoice Post_ Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Invoice 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
       [Invoice Post_ Buffer].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Invoice Post_ Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invoice Post_ Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Invoice Post_ Buffer].[Job No_] = [Job].[Job No_]
14Fixed Asset Line No_ Primary Key Searchint
15Deferral Code Primary Key Searchnvarchar(20)
16Additional Grouping Identifier Primary Key Searchnvarchar(40)
17Global Dimension 1 Code Searchnvarchar(40)
18Global Dimension 2 Code Searchnvarchar(40)
19Amount Searchdecimal(38,38)
20VAT Amount Searchdecimal(38,38)
21VAT Calculation Type Searchint
22VAT Base Amount Searchdecimal(38,38)
23System-Created Entry Searchtinyint
24Quantity Searchdecimal(38,38)
25Amount (ACY) Searchdecimal(38,38)
26VAT Amount (ACY) Searchdecimal(38,38)
27VAT Base Amount (ACY) Searchdecimal(38,38)
28VAT Difference Searchdecimal(38,38)
29VAT _ Searchdecimal(38,38)
30VAT Base Before Pmt_ Disc_ Searchdecimal(38,38)
31Entry Description Searchnvarchar(200)
32Deferral Line No_ Searchint
33FA Posting Date Searchdatetime
34FA Posting Type Searchint
35Depreciation Book Code Searchnvarchar(20)
36Salvage Value Searchdecimal(38,38)
37Depr_ until FA Posting Date Searchtinyint
38Depr_ Acquisition Cost Searchtinyint
39Maintenance Code Searchnvarchar(20)
40Insurance No_ Searchnvarchar(40)
41Budgeted FA No_ Searchnvarchar(40)
42Duplicate in Depreciation Book Searchnvarchar(20)
43Use Duplication List Searchtinyint
44$systemId Searchuniqueidentifier
45$systemCreatedAt Searchdatetime
46$systemCreatedBy Searchuniqueidentifier
47$systemModifiedAt Searchdatetime
48$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Invoice Post_ Buffer table

Leave a Reply

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