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
   [Claim ID]
   ,[Graph Contact ID]
   ,[Usage]
   ,[Offer]
   ,[Terms]
   ,[Code]
   ,[Expiration]
   ,[Discount Value]
   ,[Discount Type]
   ,[Created DateTime]
   ,[Amount Text]
   ,[Offer Blob]
   ,[Terms Blob]
   ,[Sales Invoice No_]
   ,[Customer Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$O365 Posted 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 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Posted Coupon Claim]
LEFT JOIN
   [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim]
      ON
         [O365 Posted Coupon Claim].[Claim ID] = [O365 Coupon Claim].[Claim ID]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [O365 Posted Coupon Claim].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Posted Coupon Claim].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Posted Coupon Claim].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in O365 Posted Coupon Claim table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Claim ID Primary Key SearchClaim IDNormalText150Claim IDnvarchar(300)
Key to join to the O365 Coupon Claim table.

Show/hide example query

SELECT
       [O365 Posted Coupon Claim].[Claim ID]
       ,[O365 Coupon Claim].[Claim ID]
FROM
       [CRONUS UK Ltd_$O365 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Posted Coupon Claim]
LEFT JOIN
       [CRONUS UK Ltd_$O365 Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Coupon Claim]
              ON
                     [O365 Posted Coupon Claim].[Claim ID] = [O365 Coupon Claim].[Claim ID]
2Graph Contact ID SearchGraph Contact IDNormalText250Graph Contact IDnvarchar(500)
3Usage SearchUsageNormalOption4Usageint
Available options are:
  • “oneTime”
  • “multiUse”
4Offer SearchOfferNormalText250Offernvarchar(500)
5Terms SearchTermsNormalText250Termsnvarchar(500)
6Code SearchCodeNormalText30Codenvarchar(60)
7Expiration SearchExpirationNormalDate4Expirationdatetime
8Discount Value SearchDiscount ValueNormalDecimal12Discount Valuedecimal(38,38)
9Discount Type SearchDiscount TypeNormalOption4Discount Typeint
Available options are:
  • “None”
  • “%”
  • “Amount”
10Created DateTime SearchCreated DateTimeNormalDateTime8Created DateTimedatetime
13Amount Text SearchDiscountNormalText30Amount Textnvarchar(60)
17Offer Blob SearchOffer BlobNormalBLOB8Offer Blobimage
18Terms Blob SearchTerms BlobNormalBLOB8Terms Blobimage
19Sales Invoice No. Primary Key SearchSales Invoice No.NormalCode20Sales Invoice No_nvarchar(40)
Key to join to the Sales Invoice Header table.

Show/hide example query

SELECT
       [O365 Posted Coupon Claim].[Sales Invoice No_]
       ,[Sales Invoice Header].[No_]
FROM
       [CRONUS UK Ltd_$O365 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Posted Coupon Claim]
LEFT JOIN
       [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header]
              ON
                     [O365 Posted Coupon Claim].[Sales Invoice No_] = [Sales Invoice Header].[No_]
8002Customer Id SearchCustomer IdNormalGUID16Customer Iduniqueidentifier
Key to join to the Customer table.

Show/hide example query

SELECT
       [O365 Posted Coupon Claim].[Customer Id]
       ,[Customer].[$systemId]
FROM
       [CRONUS UK Ltd_$O365 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Posted Coupon Claim]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [O365 Posted Coupon Claim].[Customer Id] = [Customer].[$systemId]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [O365 Posted Coupon Claim].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$O365 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Posted Coupon Claim]
LEFT JOIN
       [User] AS [User]
              ON
                     [O365 Posted Coupon Claim].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [O365 Posted Coupon Claim].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$O365 Posted Coupon Claim$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Posted Coupon Claim]
LEFT JOIN
       [User] AS [User]
              ON
                     [O365 Posted Coupon Claim].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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