Shpfy Orders to Import

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Orders to Import

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

Table Type: Company

Table Name: Shpfy Orders to Import
Database Table Name: CRONUS UK Ltd_$Shpfy Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb

Table Number: 30121

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 Orders to Import can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Shpfy Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Shop Id]
   ,[Shop Code]
   ,[Id]
   ,[Order No_]
   ,[Created At]
   ,[Updated At]
   ,[Test]
   ,[Confirmed]
   ,[Fully Paid]
   ,[Unpaid]
   ,[Risk Level]
   ,[Financial Status]
   ,[Fulfillment Status]
   ,[Order Amount]
   ,[Currency Code]
   ,[Total Quantity of Items]
   ,[Number of Order Lines]
   ,[Tags]
   ,[Channel Name]
   ,[Import Action]
   ,[Has Error]
   ,[Error Message]
   ,[Error Call Stack]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Orders to Import$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 Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Orders to Import]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
      ON
         [Shpfy Orders to Import].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Shpfy Orders to Import].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Orders to Import].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Orders to Import].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Orders to Import table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Shop Id SearchShop IdNormalInteger4Shop Idint
3Shop Code SearchShop CodeNormalCode20Shop Codenvarchar(40)
Key to join to the Shpfy Shop table.

Show/hide example query

SELECT
       [Shpfy Orders to Import].[Shop Code]
       ,[Shpfy Shop].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Orders to Import]
LEFT JOIN
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
              ON
                     [Shpfy Orders to Import].[Shop Code] = [Shpfy Shop].[Code]
4Id SearchIdNormalBigInteger8Idbigint
5Order No. SearchOrder No.NormalText50Order No_nvarchar(100)
6Created At SearchCreated AtNormalDateTime8Created Atdatetime
7Updated At SearchUpdatedAtNormalDateTime8Updated Atdatetime
8Test SearchTestNormalBoolean4Testtinyint
9Confirmed SearchConfirmedNormalBoolean4Confirmedtinyint
10Fully Paid SearchFully PaidNormalBoolean4Fully Paidtinyint
11Unpaid SearchUnpaidNormalBoolean4Unpaidtinyint
12Risk Level SearchRisk LevelNormalOption4Risk Levelint
Available options are:
  • ” “
  • “Low”
  • “Medium”
  • “High”
13Financial Status SearchFinancial StatusNormalOption4Financial Statusint
Available options are:
  • ” “
  • “Pending”
  • “Authorized”
  • “Partially Paid”
  • “Paid”
  • “Partially Refunded”
  • “Refunded”
  • “Voided”
  • “Unknown”
14Fulfillment Status SearchFulfillment StatusNormalOption4Fulfillment Statusint
Available options are:
  • ” “
  • “Fulfilled”
  • “In Progress”
  • “Open”
  • “Pending Fulfillment”
  • “Restocked”
  • “Unfulfilled”
  • “Partially Fulfilled”
15Order Amount SearchOrder AmountNormalDecimal12Order Amountdecimal(38,38)
16Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Shpfy Orders to Import].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Orders to Import]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Shpfy Orders to Import].[Currency Code] = [Currency].[Code]
17Total Quantity of Items SearchTotal Quantity of ItemsNormalInteger4Total Quantity of Itemsint
18Number of Order Lines SearchNumber of Order LinesNormalInteger4Number of Order Linesint
19Tags SearchTagsNormalText2048Tagsnvarchar(4096)
20Attribute Key Filter SearchAttribute Key FilterFlowFilterText100
21Attribute Key Exists SearchAttribute Key ExistsFlowFieldBoolean4
22Channel Name SearchChannel NameNormalText100Channel Namenvarchar(200)
100Import Action SearchImport ActionNormalOption4Import Actionint
Available options are:
  • “New”
  • “Update”
102Has Error SearchHas ErrorNormalBoolean4Has Errortinyint
103Error Message SearchError MessageNormalBLOB8Error Messageimage
104Error Call Stack SearchError Call StackNormalBLOB8Error Call Stackimage
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 Orders to Import].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Orders to Import]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Orders to Import].[$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 Orders to Import].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Orders to Import$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Orders to Import]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Orders to Import].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Shpfy Orders to Import table

Currency
Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Orders to Import

Leave a Reply

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