O365 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
   [timestamp]
   ,[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 columns in O365 Coupon Claim table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Claim ID Primary Key Searchnvarchar(300)
3Graph Contact ID Primary Key Searchnvarchar(500)
4Usage Searchint
5Offer Searchnvarchar(500)
6Terms Searchnvarchar(500)
7Code Searchnvarchar(60)
8Expiration Searchdatetime
9Discount Value Searchdecimal(38,38)
10Discount Type Searchint
11Created DateTime Searchdatetime
12Is Valid Searchtinyint
13Status Text Searchnvarchar(100)
14Amount Text Searchnvarchar(60)
15Offer Blob Searchimage
16Terms Blob Searchimage
17Last Modified DateTime Searchdatetime
18Customer Id Searchuniqueidentifier
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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