Shpfy Shop

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Shop

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

Table Type: Company

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

Table Number: 30102

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 Shop can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Shopify URL]
   ,[Enabled]
   ,[Log Enabled]
   ,[Customer Price Group]
   ,[Customer Discount Group]
   ,[Shipping Charges Account]
   ,[Language Code]
   ,[Sync Item]
   ,[Item Template Code]
   ,[Sync Item Images]
   ,[Sync Item Extended Text]
   ,[Sync Item Attributes]
   ,[Sync Item Marketing Text]
   ,[Auto Create Orders]
   ,[Auto Create Unknown Items]
   ,[Auto Create Unknown Customers]
   ,[Customer Template Code]
   ,[Product Collection]
   ,[Shopify Order No_ on Doc_ Line]
   ,[Customer Import From Shopify]
   ,[Export Customer To Shopify]
   ,[Shopify Can Update Customer]
   ,[Can Update Shopify Customer]
   ,[Name Source]
   ,[Name 2 Source]
   ,[Contact Source]
   ,[County Source]
   ,[Default Customer No_]
   ,[UoM as Variant]
   ,[Option Name for UoM]
   ,[Shopify Can Update Items]
   ,[Can Update Shopify Products]
   ,[Variant Prefix]
   ,[Inventory Tracked]
   ,[Default Inventory Policy]
   ,[Allow Background Syncs]
   ,[Tip Account]
   ,[Sold Gift Card Account]
   ,[Customer Mapping Type]
   ,[Status for Created Products]
   ,[Action for Removed Products]
   ,[Currency Code]
   ,[Gen_ Bus_ Posting Group]
   ,[VAT Bus_ Posting Group]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Country_Region Code]
   ,[Customer Posting Group]
   ,[Prices Including VAT]
   ,[Auto Release Sales Orders]
   ,[Allow Line Disc_]
   ,[Customer Templ_ Code]
   ,[Item Templ_ Code]
   ,[Return and Refund Process]
   ,[Return Location]
   ,[Refund Acc_ non-restock Items]
   ,[Refund Account]
   ,[Collection Last Export Version]
   ,[Collection Last Import Version]
   ,[Product Last Export Version]
   ,[Product Last Import Version]
   ,[SKU Mapping]
   ,[SKU Field Separator]
   ,[Tax Area Priority]
   ,[Allow Outgoing Requests]
   ,[Order Created Webhooks]
   ,[Order Created Webhook User]
   ,[Fulfillment Service Activated]
   ,[Order Created Webhook User Id]
   ,[Order Created Webhook Id]
   ,[Logging Mode]
   ,[Bulk Operation Webhook User Id]
   ,[Bulk Operation Webhook Id]
   ,[Sync Prices]
   ,[Shop Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Shop$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 Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Shpfy Shop].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Shpfy Shop].[Customer Discount Group] = [Customer Discount Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Shpfy Shop].[Shipping Charges Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Shpfy Shop].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Shpfy Shop].[Tip Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Shpfy Shop].[Sold Gift Card Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Shpfy Shop].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Shpfy Shop].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Shpfy Shop].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Shpfy Shop].[Refund Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Shop].[Order Created Webhook User] = [User].[User Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Shop].[Order Created Webhook User Id] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Shop].[Bulk Operation Webhook User Id] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Shop].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Shop].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Shop table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Shopify URL SearchShopify URLNormalText250Shopify URLnvarchar(500)
3Enabled SearchEnabledNormalBoolean4Enabledtinyint
5Log Enabled SearchLog EnabledNormalBoolean4Log Enabledtinyint
6Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Shpfy Shop].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Shpfy Shop].[Customer Price Group] = [Customer Price Group].[Code]
7Customer Discount Group SearchCustomer Discount GroupNormalCode20Customer Discount Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Shpfy Shop].[Customer Discount Group]
       ,[Customer Discount Group].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Shpfy Shop].[Customer Discount Group] = [Customer Discount Group].[Code]
8Shipping Charges Account SearchShipping Charges AccountNormalCode20Shipping Charges Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Shpfy Shop].[Shipping Charges Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Shpfy Shop].[Shipping Charges Account] = [G/L Account].[No_]
9Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Shpfy Shop].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Shpfy Shop].[Language Code] = [Language].[Code]
10Sync Item SearchSync ItemNormalOption4Sync Itemint
Available options are:
  • ” “
  • “To Shopify”
  • “From Shopify”
11Item Template Code SearchItem Template CodeNormalCode10Item Template Codenvarchar(20)
12Sync Item Images SearchSync Item ImagesNormalOption4Sync Item Imagesint
Available options are:
  • ” “
  • “To Shopify”
  • “From Shopify”
13Sync Item Extended Text SearchSync Item Extended TextNormalBoolean4Sync Item Extended Texttinyint
14Sync Item Attributes SearchSync Item AttributesNormalBoolean4Sync Item Attributestinyint
15Sync Item Marketing Text SearchSync Item Marketing TextNormalBoolean4Sync Item Marketing Texttinyint
21Auto Create Orders SearchAuto Create OrdersNormalBoolean4Auto Create Orderstinyint
22Auto Create Unknown Items SearchAuto Create Unknown ItemsNormalBoolean4Auto Create Unknown Itemstinyint
23Auto Create Unknown Customers SearchAuto Create Unknown CustomersNormalBoolean4Auto Create Unknown Customerstinyint
24Customer Template Code SearchCustomer Template CodeNormalCode10Customer Template Codenvarchar(20)
25Product Collection SearchProduct CollectionNormalOption4Product Collectionint
Available options are:
  • ” “
  • “Tax Group”
  • “VAT Prod. Posting Group”
27Shopify Order No. on Doc. Line SearchShopify Order No. on Doc. LineNormalBoolean4Shopify Order No_ on Doc_ Linetinyint
28Customer Import From Shopify SearchCustomer Import from ShopifyNormalOption4Customer Import From Shopifyint
29Export Customer To Shopify SearchExport Customer to ShopifyNormalBoolean4Export Customer To Shopifytinyint
30Shopify Can Update Customer SearchShopify Can Update CustomersNormalBoolean4Shopify Can Update Customertinyint
31Can Update Shopify Customer SearchCan Update Shopify CustomersNormalBoolean4Can Update Shopify Customertinyint
32Name Source SearchName SourceNormalOption4Name Sourceint
Available options are:
  • “CompanyName”
  • “FirstAndLastName”
  • “LastAndFirstName”
  • “None”
33Name 2 Source SearchName 2 SourceNormalOption4Name 2 Sourceint
Available options are:
  • “CompanyName”
  • “FirstAndLastName”
  • “LastAndFirstName”
  • “None”
34Contact Source SearchContact SourceNormalOption4Contact Sourceint
Available options are:
  • “CompanyName”
  • “FirstAndLastName”
  • “LastAndFirstName”
  • “None”
35County Source SearchState SourceNormalOption4County Sourceint
Available options are:
  • “Code”
  • “Name”
36Default Customer No. SearchDefault Customer No.NormalCode20Default Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Shpfy Shop].[Default Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Shpfy Shop].[Default Customer No_] = [Customer].[No_]
37UoM as Variant SearchUoM as VariantNormalBoolean4UoM as Varianttinyint
38Option Name for UoM SearchVariant Option Name for UoMNormalText50Option Name for UoMnvarchar(100)
39Shopify Can Update Items SearchShopify Can Update ItemsNormalBoolean4Shopify Can Update Itemstinyint
40Can Update Shopify Products SearchCan Update Shopify ProductsNormalBoolean4Can Update Shopify Productstinyint
41Variant Prefix SearchVariant PrefixNormalCode5Variant Prefixnvarchar(10)
42Inventory Tracked SearchInventory TrackedNormalBoolean4Inventory Trackedtinyint
43Default Inventory Policy SearchDefault Inventory PolicyNormalOption4Default Inventory Policyint
Available options are:
  • “DENY”
  • “CONTINUE”
44Allow Background Syncs SearchAllow Background SyncsNormalBoolean4Allow Background Syncstinyint
47Tip Account SearchTip AccountNormalCode20Tip Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Shpfy Shop].[Tip Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Shpfy Shop].[Tip Account] = [G/L Account].[No_]
48Sold Gift Card Account SearchSold Gift Card AccountNormalCode20Sold Gift Card Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Shpfy Shop].[Sold Gift Card Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Shpfy Shop].[Sold Gift Card Account] = [G/L Account].[No_]
49Customer Mapping Type SearchCustomer Mapping TypeNormalOption4Customer Mapping Typeint
Available options are:
  • “By EMail/Phone”
  • “By Bill-to Info”
  • “DefaultCustomer”
50Status for Created Products SearchStatus for Created ProductsNormalOption4Status for Created Productsint
Available options are:
  • “Active”
  • “Draft”
51Action for Removed Products SearchAction for Removed Products and Blocked ItemsNormalOption4Action for Removed Productsint
Available options are:
  • “DoNothing”
  • “StatusToArchived”
  • “StatusToDraft”
52Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Shpfy Shop].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Shpfy Shop].[Currency Code] = [Currency].[Code]
53Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Shpfy Shop].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Shpfy Shop].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
54VAT Bus. Posting Group SearchTax Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Shpfy Shop].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Shpfy Shop].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
55Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Shpfy Shop].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Shpfy Shop].[Tax Area Code] = [Tax Area].[Code]
56Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
57VAT Country/Region Code SearchTax Country/Region CodeNormalCode10VAT Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Shpfy Shop].[VAT Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Shpfy Shop].[VAT Country_Region Code] = [Country/Region].[Code]
58Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Shpfy Shop].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Shpfy Shop].[Customer Posting Group] = [Customer Posting Group].[Code]
59Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
60Auto Release Sales Orders SearchAuto Release Sales OrdersNormalBoolean4Auto Release Sales Orderstinyint
61Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
62Customer Templ. Code SearchCustomer Template CodeNormalCode20Customer Templ_ Codenvarchar(40)
Key to join to the Customer Templ. table.

Show/hide example query

SELECT
       [Shpfy Shop].[Customer Templ_ Code]
       ,[Customer Templ.].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.]
              ON
                     [Shpfy Shop].[Customer Templ_ Code] = [Customer Templ.].[Code]
63Item Templ. Code SearchItem Template CodeNormalCode20Item Templ_ Codenvarchar(40)
Key to join to the Item Templ. table.

Show/hide example query

SELECT
       [Shpfy Shop].[Item Templ_ Code]
       ,[Item Templ.].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.]
              ON
                     [Shpfy Shop].[Item Templ_ Code] = [Item Templ.].[Code]
70Return and Refund Process SearchReturn and Refund ProcessNormalOption4Return and Refund Processint
Available options are:
  • ” “
  • “Import Only”
  • “Auto Create Credit Memo”
73Return Location SearchReturn LocationNormalCode10Return Locationnvarchar(20)
75Refund Acc. non-restock Items SearchRefund Account non-restock ItemsNormalCode20Refund Acc_ non-restock Itemsnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Shpfy Shop].[Refund Acc_ non-restock Items]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Shpfy Shop].[Refund Acc_ non-restock Items] = [G/L Account].[No_]
76Refund Account SearchRefund AccountNormalCode20Refund Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Shpfy Shop].[Refund Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Shpfy Shop].[Refund Account] = [G/L Account].[No_]
100Collection Last Export Version SearchCollection Last Export VersionNormalBigInteger8Collection Last Export Versionbigint
101Collection Last Import Version SearchCollection Last Import VersionNormalBigInteger8Collection Last Import Versionbigint
102Product Last Export Version SearchProduct Last Export VersionNormalBigInteger8Product Last Export Versionbigint
103Product Last Import Version SearchProduct Last Import VersionNormalBigInteger8Product Last Import Versionbigint
104SKU Mapping SearchSKU MappingNormalOption4SKU Mappingint
Available options are:
  • ” “
  • “Item No.”
  • “Variant Code”
  • “Item No. + Variant Code”
  • “Vendor Item No.”
  • “Bar Code”
105SKU Field Separator SearchSKU Field SeparatorNormalCode10SKU Field Separatornvarchar(20)
106Tax Area Priority SearchTax Area PriorityNormalOption4Tax Area Priorityint
Available options are:
  • “No Taxes”
  • “Ship-to -> Sell-to -> Bill-to”
  • “Ship-to -> Bill-to -> Sell-to”
  • “Sell-to -> Ship-to -> Bill-to”
  • “Sell-to -> Bill-to -> Ship-to”
  • “Bill-to -> Sell-to -> Ship-to”
  • “Bill-to Ship-to Sell-to”
107Allow Outgoing Requests SearchAllow Outgoing RequestsNormalBoolean4Allow Outgoing Requeststinyint
108Order Created Webhooks SearchOrder Created WebhooksNormalBoolean4Order Created Webhookstinyint
109Order Created Webhook User SearchOrder Created Webhook UserNormalCode50Order Created Webhook Usernvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Shpfy Shop].[Order Created Webhook User]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Shop].[Order Created Webhook User] = [User].[User Name]
110Fulfillment Service Activated SearchFulfillment Service ActivatedNormalBoolean4Fulfillment Service Activatedtinyint
111Order Created Webhook User Id SearchOrder Created Webhook User IdNormalGUID16Order Created Webhook User Iduniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Shpfy Shop].[Order Created Webhook User Id]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Shop].[Order Created Webhook User Id] = [User].[User Security ID]
112Order Created Webhook Id SearchOrder Created Webhook IdNormalText500Order Created Webhook Idnvarchar(1000)
113Logging Mode SearchLogging ModeNormalOption4Logging Modeint
Available options are:
  • “Error Only”
  • “All”
  • “Disabled”
114Bulk Operation Webhook User Id SearchBulk Operation Webhook User IdNormalGUID16Bulk Operation Webhook User Iduniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Shpfy Shop].[Bulk Operation Webhook User Id]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Shop].[Bulk Operation Webhook User Id] = [User].[User Security ID]
115Bulk Operation Webhook Id SearchBulk Operation Webhook IdNormalText500Bulk Operation Webhook Idnvarchar(1000)
116Sync Prices SearchSync Prices with ProductsNormalBoolean4Sync Pricestinyint
200Shop Id SearchShop IdNormalInteger4Shop Idint
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 Shop].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Shop].[$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 Shop].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Shop].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Shpfy Shop table

CurrencyCustomer Posting GroupCustomer Price GroupLanguageTax Area
Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Shop

Leave a Reply

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