Prepayment Inv_ Line Buffer

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

Table Number: 461

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 IDColumn NameData Type
1timestamp Searchtimestamp
2G_L Account No_ Primary Key Searchnvarchar(40)
Key to join to the G_L Account table.

Show/hide example query

SELECT
       [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_]
3Job No_ Primary Key Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [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_]
4Tax Area Code Primary Key Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [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]
5Tax Liable Primary Key Searchtinyint
6Tax Group Code Primary Key Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [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]
7Invoice Rounding Primary Key Searchtinyint
8Adjustment Primary Key Searchtinyint
9Line No_ Primary Key Searchint
10Dimension Set ID Primary Key Searchint
11Amount Searchdecimal(38,38)
12Description Searchnvarchar(200)
13Gen_ Bus_ Posting Group Searchnvarchar(40)
14Gen_ Prod_ Posting Group Searchnvarchar(40)
15VAT Bus_ Posting Group Searchnvarchar(40)
16VAT Prod_ Posting Group Searchnvarchar(40)
17VAT Amount Searchdecimal(38,38)
18VAT Calculation Type Searchint
19VAT Base Amount Searchdecimal(38,38)
20Amount (ACY) Searchdecimal(38,38)
21VAT Amount (ACY) Searchdecimal(38,38)
22VAT Base Amount (ACY) Searchdecimal(38,38)
23VAT Difference Searchdecimal(38,38)
24VAT _ Searchdecimal(38,38)
25VAT Identifier Searchnvarchar(40)
26Global Dimension 1 Code Searchnvarchar(40)
27Global Dimension 2 Code Searchnvarchar(40)
28Amount Incl_ VAT Searchdecimal(38,38)
29VAT Base Before Pmt_ Disc_ Searchdecimal(38,38)
30Orig_ Pmt_ Disc_ Possible Searchdecimal(38,38)
31Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [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 Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Prepayment Inv_ Line Buffer table

Leave a Reply

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