Cust_ Invoice Disc_

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

Table Type: Company

Table Name: Cust_ Invoice Disc_
Database Table Name: CRONUS UK Ltd_$Cust_ Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 19

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 Cust_ Invoice Disc_ can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cust_ Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Currency Code]
   ,[Minimum Amount]
   ,[Discount _]
   ,[Service Charge]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cust_ Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cust_ Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust_ Invoice Disc_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Cust_ Invoice Disc_].[Currency Code] = [Currency].[Code]

Show/hide columns in Cust_ Invoice Disc_ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Cust_ Invoice Disc_].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust_ Invoice Disc_]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Cust_ Invoice Disc_].[Currency Code] = [Currency].[Code]
4Minimum Amount Primary Key Searchdecimal(38,38)
5Discount _ Searchdecimal(38,38)
6Service Charge Searchdecimal(38,38)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Cust_ Invoice Disc_ table

Leave a Reply

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