Vendor Amount

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

Table Type: Company

Table Name: Vendor Amount
Database Table Name: CRONUS UK Ltd_$Vendor Amount$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 267

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 Vendor Amount can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Vendor Amount$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Amount (LCY)]
   ,[Amount 2 (LCY)]
   ,[Vendor No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Vendor Amount$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Vendor Amount$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Amount]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Vendor Amount].[Vendor No_] = [Vendor].[No_]

Show/hide columns in Vendor Amount table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Amount (LCY) Primary Key Searchdecimal(38,38)
3Amount 2 (LCY) Primary Key Searchdecimal(38,38)
4Vendor No_ Primary Key Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Vendor Amount].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Vendor Amount$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Amount]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Vendor Amount].[Vendor No_] = [Vendor].[No_]
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Vendor Amount table

Leave a Reply

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