O365 Posted Coupon Claim

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

Table Type: Company

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

Table Number: 2117

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Claim ID]
   ,[Sales Invoice No_]
   ,[Graph Contact ID]
   ,[Usage]
   ,[Offer]
   ,[Terms]
   ,[Code]
   ,[Expiration]
   ,[Discount Value]
   ,[Discount Type]
   ,[Created DateTime]
   ,[Amount Text]
   ,[Offer Blob]
   ,[Terms Blob]
   ,[Customer Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$O365 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in O365 Posted Coupon Claim table

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

Leave a Reply

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