Contract Gain_Loss Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CContract 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Contract No_	nvarchar(40)
4	Contract Group Code	nvarchar(20)
5	Change Date	datetime
6	Reason Code	nvarchar(20)
7	Type of Change	int
8	Responsibility Center	nvarchar(20)
9	Customer No_	nvarchar(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_]
10	Ship-to Code	nvarchar(20)
11	User ID	nvarchar(100)
12	Amount	decimal(38,38)
13	$systemId	uniqueidentifier
14	$systemCreatedAt	datetime
15	$systemCreatedBy	uniqueidentifier
16	$systemModifiedAt	datetime
17	$systemModifiedBy	uniqueidentifier