Shpfy Order Transaction

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Order Transaction

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

Table Type: Company

Table Name: Shpfy Order Transaction
Database Table Name: CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb

Table Number: 30133

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 Shpfy Order Transaction can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

Show/hide an example select of all columns by name

SELECT

   [Shopify Transaction Id]
   ,[Shopify Order Id]
   ,[Amount]
   ,[Type]
   ,[Gateway]
   ,[Status]
   ,[Message]
   ,[Created At]
   ,[Test]
   ,[Authorization]
   ,[Currency]
   ,[Gift Card Id]
   ,[Source Name]
   ,[Credit Card Bin]
   ,[AVS Result Code]
   ,[CVV Result Code]
   ,[Credit Card Number]
   ,[Credit Card Company]
   ,[Parent Id]
   ,[Error Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
      ON
         [Shpfy Order Transaction].[Gateway] = [Shpfy Transaction Gateway].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
      ON
         [Shpfy Order Transaction].[Credit Card Company] = [Shpfy Credit Card Company].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
      ON
         [Shpfy Order Transaction].[Parent Id] = [Shpfy Order Transaction].[Shopify Transaction Id]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
      ON
         [Shpfy Order Transaction].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Order Transaction].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Order Transaction].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Order Transaction table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Shopify Transaction Id Primary Key SearchShopify Transaction IdNormalBigInteger8Shopify Transaction Idbigint
2Shopify Order Id SearchShopify Order IdNormalBigInteger8Shopify Order Idbigint
3Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
4Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Authorization”
  • “Capture”
  • “Sale”
  • “Void”
  • “Refund”
5Gateway SearchGatewayNormalText30Gatewaynvarchar(60)
Key to join to the Shpfy Transaction Gateway table.

Show/hide example query

SELECT
       [Shpfy Order Transaction].[Gateway]
       ,[Shpfy Transaction Gateway].[Name]
FROM
       [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
LEFT JOIN
       [CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
              ON
                     [Shpfy Order Transaction].[Gateway] = [Shpfy Transaction Gateway].[Name]
6Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Pending”
  • “Failure”
  • “Success”
  • “Error”
7Message SearchMessageNormalText250Messagenvarchar(500)
8Created At SearchCreated AtNormalDateTime8Created Atdatetime
9Test SearchTestNormalBoolean4Testtinyint
10Authorization SearchAuthorizationNormalCode50Authorizationnvarchar(100)
11Currency SearchCurrencyNormalCode20Currencynvarchar(40)
14Gift Card Id SearchGift Card IdNormalBigInteger8Gift Card Idbigint
15Source Name SearchSource NameNormalCode20Source Namenvarchar(40)
16Credit Card Bin SearchCredit Card BinNormalCode10Credit Card Binnvarchar(20)
17AVS Result Code SearchAVS Result CodeNormalCode1AVS Result Codenvarchar(2)
18CVV Result Code SearchCVV Result CodeNormalCode1CVV Result Codenvarchar(2)
19Credit Card Number SearchCredit Card NumberNormalText30Credit Card Numbernvarchar(60)
20Credit Card Company SearchCredit Card companyNormalText50Credit Card Companynvarchar(100)
Key to join to the Shpfy Credit Card Company table.

Show/hide example query

SELECT
       [Shpfy Order Transaction].[Credit Card Company]
       ,[Shpfy Credit Card Company].[Name]
FROM
       [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
LEFT JOIN
       [CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
              ON
                     [Shpfy Order Transaction].[Credit Card Company] = [Shpfy Credit Card Company].[Name]
21Parent Id SearchParent IdNormalBigInteger8Parent Idbigint
22Error Code SearchError CodeNormalText30Error Codenvarchar(60)
101Sales Document No. SearchSales Document No.FlowFieldCode20
102Posted Invoice No. SearchPosted Invoice No.FlowFieldCode20
103Shop Code SearchShop CodeFlowFieldCode20
104Payment Method SearchPayment MethodFlowFieldCode10
105Payment Priority SearchPayment PriorityFlowFieldInteger4
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
       [Shpfy Order Transaction].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Order Transaction].[$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
       [Shpfy Order Transaction].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Order Transaction].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Order Transaction

Leave a Reply

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