Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/461
Table Type: Company
Table Name: Prepayment Inv_ Line Buffer
Database Table Name: CRONUS UK Ltd_$Prepayment Inv_ Line 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 Prepayment Inv_ Line Buffer can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[G_L Account No_]
,[Job No_]
,[Tax Area Code]
,[Tax Liable]
,[Tax Group Code]
,[Invoice Rounding]
,[Adjustment]
,[Line No_]
,[Dimension Set ID]
,[Amount]
,[Description]
,[Gen_ Bus_ Posting Group]
,[Gen_ Prod_ Posting Group]
,[VAT Bus_ Posting Group]
,[VAT Prod_ Posting Group]
,[VAT Amount]
,[VAT Calculation Type]
,[VAT Base Amount]
,[Amount (ACY)]
,[VAT Amount (ACY)]
,[VAT Base Amount (ACY)]
,[VAT Difference]
,[VAT _]
,[VAT Identifier]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Amount Incl_ VAT]
,[VAT Base Before Pmt_ Disc_]
,[Orig_ Pmt_ Disc_ Possible]
,[Job Task No_]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line 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_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv_ Line Buffer]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
ON
[Prepayment Inv_ Line Buffer].[G_L Account No_] = [G_L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
ON
[Prepayment Inv_ Line Buffer].[Job No_] = [Job].[Job No_]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Prepayment Inv_ Line Buffer].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
ON
[Prepayment Inv_ Line Buffer].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
ON
[Prepayment Inv_ Line Buffer].[Job Task No_] = [Job Task].[Job Task No_]Show/hide columns in Prepayment Inv_ Line Buffer table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | G_L Account No_  | nvarchar(40) | ||||
Key to join to the G_L Account table.Show/hide example querySELECT
[Prepayment Inv_ Line Buffer].[G_L Account No_]
,[G_L Account].[No_]
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv_ Line Buffer]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
ON
[Prepayment Inv_ Line Buffer].[G_L Account No_] = [G_L Account].[No_] | ||||||
| 3 | Job No_ | nvarchar(40) | ||||
Key to join to the Job table.Show/hide example querySELECT
[Prepayment Inv_ Line Buffer].[Job No_]
,[Job].[Job No_]
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv_ Line Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
ON
[Prepayment Inv_ Line Buffer].[Job No_] = [Job].[Job No_] | ||||||
| 4 | Tax Area Code | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[Prepayment Inv_ Line Buffer].[Tax Area Code]
,[Tax Area].[Code]
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv_ Line Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Prepayment Inv_ Line Buffer].[Tax Area Code] = [Tax Area].[Code] | ||||||
| 5 | Tax Liable | tinyint | ||||
| 6 | Tax Group Code | nvarchar(40) | ||||
Key to join to the Tax Group table.Show/hide example querySELECT
[Prepayment Inv_ Line Buffer].[Tax Group Code]
,[Tax Group].[Code]
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv_ Line Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
ON
[Prepayment Inv_ Line Buffer].[Tax Group Code] = [Tax Group].[Code] | ||||||
| 7 | Invoice Rounding | tinyint | ||||
| 8 | Adjustment | tinyint | ||||
| 9 | Line No_ | int | ||||
| 10 | Dimension Set ID | int | ||||
| 11 | Amount | decimal(38,38) | ||||
| 12 | Description | nvarchar(200) | ||||
| 13 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 14 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 15 | VAT Bus_ Posting Group | nvarchar(40) | ||||
| 16 | VAT Prod_ Posting Group | nvarchar(40) | ||||
| 17 | VAT Amount | decimal(38,38) | ||||
| 18 | VAT Calculation Type | int | ||||
| 19 | VAT Base Amount | decimal(38,38) | ||||
| 20 | Amount (ACY) | decimal(38,38) | ||||
| 21 | VAT Amount (ACY) | decimal(38,38) | ||||
| 22 | VAT Base Amount (ACY) | decimal(38,38) | ||||
| 23 | VAT Difference | decimal(38,38) | ||||
| 24 | VAT _ | decimal(38,38) | ||||
| 25 | VAT Identifier | nvarchar(40) | ||||
| 26 | Global Dimension 1 Code | nvarchar(40) | ||||
| 27 | Global Dimension 2 Code | nvarchar(40) | ||||
| 28 | Amount Incl_ VAT | decimal(38,38) | ||||
| 29 | VAT Base Before Pmt_ Disc_ | decimal(38,38) | ||||
| 30 | Orig_ Pmt_ Disc_ Possible | decimal(38,38) | ||||
| 31 | Job Task No_ | nvarchar(40) | ||||
Key to join to the Job Task table.Show/hide example querySELECT
[Prepayment Inv_ Line Buffer].[Job Task No_]
,[Job Task].[Job Task No_]
FROM
[CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv_ Line Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
ON
[Prepayment Inv_ Line Buffer].[Job Task No_] = [Job Task].[Job Task No_] | ||||||
| 32 | $systemId | uniqueidentifier | ||||
| 33 | $systemCreatedAt | datetime | ||||
| 34 | $systemCreatedBy | uniqueidentifier | ||||
| 35 | $systemModifiedAt | datetime | ||||
| 36 | $systemModifiedBy | uniqueidentifier | ||||