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
   [G_L Account No_]
   ,[Line No_]
   ,[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]
   ,[Job No_]
   ,[Amount Incl_ VAT]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Invoice Rounding]
   ,[Adjustment]
   ,[VAT Base Before Pmt_ Disc_]
   ,[Orig_ Pmt_ Disc_ Possible]
   ,[Location Code]
   ,[Dimension Set ID]
   ,[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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Prepayment Inv. Line Buffer].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Prepayment Inv. Line Buffer].[Global Dimension 2 Code] = [Dimension].[Code]
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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Prepayment Inv. Line Buffer].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Prepayment Inv. Line Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Prepayment Inv. Line Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Prepayment Inv. Line Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Prepayment Inv. Line Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1G/L Account No. Primary Key SearchG/L Account No.NormalCode20G_L Account No_nvarchar(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_]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
4Description SearchDescriptionNormalText100Descriptionnvarchar(200)
5Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting 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_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Prepayment Inv. Line Buffer].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
6Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting 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_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Prepayment Inv. Line Buffer].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
7VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[VAT Bus_ Posting Group]
       ,[VAT Business Posting 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_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Prepayment Inv. Line Buffer].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
8VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[VAT Prod_ Posting Group]
       ,[VAT Product Posting 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_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Prepayment Inv. Line Buffer].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
9VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
10VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
11VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
12Amount (ACY) SearchAmount (ACY)NormalDecimal12Amount (ACY)decimal(38,38)
13VAT Amount (ACY) SearchTax Amount (ACY)NormalDecimal12VAT Amount (ACY)decimal(38,38)
14VAT Base Amount (ACY) SearchTax Base Amount (ACY)NormalDecimal12VAT Base Amount (ACY)decimal(38,38)
15VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
16VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
17VAT Identifier SearchTax IdentifierNormalCode20VAT Identifiernvarchar(40)
19Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv. Line Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Prepayment Inv. Line Buffer].[Global Dimension 1 Code] = [Dimension].[Code]
20Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv. Line Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Prepayment Inv. Line Buffer].[Global Dimension 2 Code] = [Dimension].[Code]
21Job No. Primary Key SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Job No_]
       ,[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].[No_]
22Amount Incl. VAT SearchAmount Incl. TaxNormalDecimal12Amount Incl_ VATdecimal(38,38)
24Tax Area Code Primary Key SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
25Tax Liable Primary Key SearchTax LiableNormalBoolean4Tax Liabletinyint
26Tax Group Code Primary Key SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
27Invoice Rounding Primary Key SearchInvoice RoundingNormalBoolean4Invoice Roundingtinyint
28Adjustment Primary Key SearchAdjustmentNormalBoolean4Adjustmenttinyint
29VAT Base Before Pmt. Disc. SearchTax Base Before Pmt. Disc.NormalDecimal12VAT Base Before Pmt_ Disc_decimal(38,38)
30Orig. Pmt. Disc. Possible SearchOriginal Pmt. Disc. PossibleNormalDecimal12Orig_ Pmt_ Disc_ Possibledecimal(38,38)
31Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv. Line Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Prepayment Inv. Line Buffer].[Location Code] = [Location].[Code]
480Dimension Set ID Primary Key SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv. Line Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Prepayment Inv. Line Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv. Line Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Prepayment Inv. Line Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Prepayment Inv. Line Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Prepayment Inv_ Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prepayment Inv. Line Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Prepayment Inv. Line Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Prepayment Inv. Line Buffer table

Leave a Reply

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