Contract Gain_Loss Entry

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

Table Type: Company

Table Name: Contract Gain_Loss Entry
Database Table Name: CRONUS UK Ltd_$Contract Gain_Loss Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5969

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 Contract Gain_Loss Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Contract Gain_Loss Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Contract No_]
   ,[Contract Group Code]
   ,[Change Date]
   ,[Reason Code]
   ,[Type of Change]
   ,[Responsibility Center]
   ,[Customer No_]
   ,[Ship-to Code]
   ,[User ID]
   ,[Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Contract Gain_Loss Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Contract Gain_Loss Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Contract No_ Searchnvarchar(40)
4Contract Group Code Searchnvarchar(20)
5Change Date Searchdatetime
6Reason Code Searchnvarchar(20)
7Type of Change Searchint
8Responsibility Center Searchnvarchar(20)
9Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Contract Gain_Loss Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Contract Gain_Loss Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Gain_Loss Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Contract Gain_Loss Entry].[Customer No_] = [Customer].[No_]
10Ship-to Code Searchnvarchar(20)
11User ID Searchnvarchar(100)
12Amount Searchdecimal(38,38)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Contract Gain_Loss Entry table

Leave a Reply

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