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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Type  | int | ||||
| 3 | G_L Account | nvarchar(40) | ||||
| 4 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 5 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 6 | VAT Bus_ Posting Group | nvarchar(40) | ||||
| 7 | VAT Prod_ Posting Group | nvarchar(40) | ||||
| 8 | Tax Area Code | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[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] | ||||||
| 9 | Tax Group Code | nvarchar(40) | ||||
Key to join to the Tax Group table.Show/hide example querySELECT
[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] | ||||||
| 10 | Tax Liable | tinyint | ||||
| 11 | Use Tax | tinyint | ||||
| 12 | Dimension Set ID | int | ||||
| 13 | Job No_ | nvarchar(40) | ||||
Key to join to the Job table.Show/hide example querySELECT
[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_] | ||||||
| 14 | Fixed Asset Line No_ | int | ||||
| 15 | Deferral Code | nvarchar(20) | ||||
| 16 | Additional Grouping Identifier | nvarchar(40) | ||||
| 17 | Global Dimension 1 Code | nvarchar(40) | ||||
| 18 | Global Dimension 2 Code | nvarchar(40) | ||||
| 19 | Amount | decimal(38,38) | ||||
| 20 | VAT Amount | decimal(38,38) | ||||
| 21 | VAT Calculation Type | int | ||||
| 22 | VAT Base Amount | decimal(38,38) | ||||
| 23 | System-Created Entry | tinyint | ||||
| 24 | Quantity | decimal(38,38) | ||||
| 25 | Amount (ACY) | decimal(38,38) | ||||
| 26 | VAT Amount (ACY) | decimal(38,38) | ||||
| 27 | VAT Base Amount (ACY) | decimal(38,38) | ||||
| 28 | VAT Difference | decimal(38,38) | ||||
| 29 | VAT _ | decimal(38,38) | ||||
| 30 | VAT Base Before Pmt_ Disc_ | decimal(38,38) | ||||
| 31 | Entry Description | nvarchar(200) | ||||
| 32 | Deferral Line No_ | int | ||||
| 33 | FA Posting Date | datetime | ||||
| 34 | FA Posting Type | int | ||||
| 35 | Depreciation Book Code | nvarchar(20) | ||||
| 36 | Salvage Value | decimal(38,38) | ||||
| 37 | Depr_ until FA Posting Date | tinyint | ||||
| 38 | Depr_ Acquisition Cost | tinyint | ||||
| 39 | Maintenance Code | nvarchar(20) | ||||
| 40 | Insurance No_ | nvarchar(40) | ||||
| 41 | Budgeted FA No_ | nvarchar(40) | ||||
| 42 | Duplicate in Depreciation Book | nvarchar(20) | ||||
| 43 | Use Duplication List | tinyint | ||||
| 44 | $systemId | uniqueidentifier | ||||
| 45 | $systemCreatedAt | datetime | ||||
| 46 | $systemCreatedBy | uniqueidentifier | ||||
| 47 | $systemModifiedAt | datetime | ||||
| 48 | $systemModifiedBy | uniqueidentifier | ||||