O365 Coupon Claim – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OO365 Coupon Claim

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

Table Type: Company

Table Name: O365 Coupon Claim
Database Table Name: CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 2115

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 O365 Coupon Claim can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Claim ID]
   ,[Graph Contact ID]
   ,[Usage]
   ,[Offer]
   ,[Terms]
   ,[Code]
   ,[Expiration]
   ,[Discount Value]
   ,[Discount Type]
   ,[Created DateTime]
   ,[Is Valid]
   ,[Status Text]
   ,[Amount Text]
   ,[Offer Blob]
   ,[Terms Blob]
   ,[Last Modified DateTime]
   ,[Customer Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim]
LEFT JOIN
   [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim]
      ON
         [O365 Coupon Claim].[Claim ID] = [O365 Coupon Claim].[Claim ID]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [O365 Coupon Claim].[Document Type Filter] = [Sales Header].[Document Type]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [O365 Coupon Claim].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Coupon Claim].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Coupon Claim].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in O365 Coupon Claim table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Claim ID	Claim ID	Normal	Text	150	Claim ID	nvarchar(300)
2	Graph Contact ID	Graph Contact ID	Normal	Text	250	Graph Contact ID	nvarchar(500)
3	Usage	Usage	Normal	Option	4	Usage	int
	Available options are: “oneTime” “multiUse”
4	Offer	Offer	Normal	Text	250	Offer	nvarchar(500)
5	Terms	Terms	Normal	Text	250	Terms	nvarchar(500)
6	Code	Code	Normal	Text	30	Code	nvarchar(60)
7	Expiration	Expiration	Normal	Date	4	Expiration	datetime
8	Discount Value	Discount Value	Normal	Decimal	12	Discount Value	decimal(38,38)
9	Discount Type	Discount Type	Normal	Option	4	Discount Type	int
	Available options are: “Custom” “%” “Amount”
10	Created DateTime	Created DateTime	Normal	DateTime	8	Created DateTime	datetime
11	Is Valid	Is Valid	Normal	Boolean	4	Is Valid	tinyint
12	Status Text	Status	Normal	Text	50	Status Text	nvarchar(100)
13	Amount Text	Discount	Normal	Text	30	Amount Text	nvarchar(60)
14	Is applied	Is applied	FlowField	Boolean	4
15	Document Type Filter	Document Type Filter	FlowFilter	Option	4
16	Document No. Filter	Document No. Filter	FlowFilter	Code	20
17	Offer Blob	Offer Blob	Normal	BLOB	8	Offer Blob	image
18	Terms Blob	Terms Blob	Normal	BLOB	8	Terms Blob	image
8001	Last Modified DateTime	Last Modified DateTime	Normal	DateTime	8	Last Modified DateTime	datetime
8002	Customer Id	Customer Id	Normal	GUID	16	Customer Id	uniqueidentifier
	Key to join to the Customer table. Show/hide example query SELECT [O365 Coupon Claim].[Customer Id] ,[Customer].[$systemId] FROM [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [O365 Coupon Claim].[Customer Id] = [Customer].[$systemId]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [O365 Coupon Claim].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim] LEFT JOIN [User] AS [User] ON [O365 Coupon Claim].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [O365 Coupon Claim].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim] LEFT JOIN [User] AS [User] ON [O365 Coupon Claim].[$systemModifiedBy] = [User].[User Security ID]