Shpfy Order Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Order Header

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

Table Type: Company

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

Table Number: 30118

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Shopify Order Id]
   ,[Email]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Post Code]
   ,[Sell-to Country_Region Code]
   ,[Sell-to Country_Region Name]
   ,[Phone No_]
   ,[Token]
   ,[Gateway]
   ,[Sell-to First Name]
   ,[Sell-to Last Name]
   ,[Currency]
   ,[Cart Token]
   ,[Checkout Token]
   ,[Reference]
   ,[Risk Level]
   ,[Fully Paid]
   ,[Processing Method]
   ,[Checkout Id]
   ,[Contact Email]
   ,[Total Tip Received]
   ,[Session Hash]
   ,[Ship-to First Name]
   ,[Ship-to Last Name]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Post Code]
   ,[Ship-to Country_Region Code]
   ,[Ship-to Country_Region Name]
   ,[Ship-to Latitude]
   ,[Ship-to Longitude]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Post Code]
   ,[Bill-to Country_Region Code]
   ,[Bill-to Country_Region Name]
   ,[Test]
   ,[Total Amount]
   ,[Subtotal Amount]
   ,[Total Weight]
   ,[VAT Amount]
   ,[VAT Included]
   ,[Currency Code]
   ,[Financial Status]
   ,[Confirmed]
   ,[Discount Amount]
   ,[Total Items Amount]
   ,[Fulfillment Status]
   ,[Buyer Accepts Marketing]
   ,[Cancelled At]
   ,[Cancel Reason]
   ,[Closed At]
   ,[Bill-to First Name]
   ,[Bill-to Lastname]
   ,[Processed At]
   ,[Shopify Order No_]
   ,[Order Status URL]
   ,[Created At]
   ,[Source Name]
   ,[Updated At]
   ,[Shipping Charges Amount]
   ,[Document Date]
   ,[Sell-to County]
   ,[Bill-to County]
   ,[Ship-to County]
   ,[Customer Id]
   ,[Closed]
   ,[Location Id]
   ,[Channel Name]
   ,[App Name]
   ,[Presentment Currency Code]
   ,[Unpaid]
   ,[Discount Code]
   ,[Discount Codes]
   ,[Refundable]
   ,[Presentment Total Amount]
   ,[Presentment Subtotal Amount]
   ,[Presentment VAT Amount]
   ,[Presentment Discount Amount]
   ,[Presentment Total Tip Received]
   ,[Pres_ Shipping Charges Amount]
   ,[Edited]
   ,[Return Status]
   ,[Shop Code]
   ,[Customer Template Code]
   ,[Customer Templ_ Code]
   ,[Sell-to Customer No_]
   ,[Sales Order No_]
   ,[Has Error]
   ,[Error Message]
   ,[Processed]
   ,[Sell-to Customer Name]
   ,[Sales Invoice No_]
   ,[Work Description]
   ,[Sell-to Customer Name 2]
   ,[Ship-to Name 2]
   ,[Bill-to Name 2]
   ,[Bill-to Customer No_]
   ,[Shipping Method Code]
   ,[Payment Method Code]
   ,[Sell-to Contact Name]
   ,[Bill-to Contact Name]
   ,[Ship-to Contact Name]
   ,[Sell-to Contact No_]
   ,[Bill-to Contact No_]
   ,[Ship-to Contact No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Order Header$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 Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Sell-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
      ON
         [Shpfy Order Header].[Gateway] = [Shpfy Transaction Gateway].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Shpfy Order Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Shpfy Order Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Shpfy Order Header].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Shpfy Order Header].[Location Id] = [Location].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
      ON
         [Shpfy Order Header].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Shpfy Order Header].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Shpfy Order Header].[Shipping Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Shpfy Order Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Order Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Order Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Order Header table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Shopify Order Id	Shopify Order Id	Normal	BigInteger	8	Shopify Order Id	bigint
2	Email	Email	Normal	Text	50	Email	nvarchar(100)
5	Sell-to Address	Sell-to Address	Normal	Text	100	Sell-to Address	nvarchar(200)
6	Sell-to Address 2	Sell-to Address 2	Normal	Text	100	Sell-to Address 2	nvarchar(200)
7	Sell-to City	Sell-to City	Normal	Text	50	Sell-to City	nvarchar(100)
	Key to join to the Post Code table. Show/hide example query SELECT [Shpfy Order Header].[Sell-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Shpfy Order Header].[Sell-to City] = [Post Code].[City]
8	Sell-to Post Code	Sell-to ZIP Code	Normal	Text	50	Sell-to Post Code	nvarchar(100)
	Key to join to the Post Code table. Show/hide example query SELECT [Shpfy Order Header].[Sell-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Shpfy Order Header].[Sell-to Post Code] = [Post Code].[Code]
9	Sell-to Country/Region Code	Sell-to Country/Region Code	Normal	Code	20	Sell-to Country_Region Code	nvarchar(40)
10	Sell-to Country/Region Name	Sell-to Country/Region Name	Normal	Text	50	Sell-to Country_Region Name	nvarchar(100)
11	Phone No.	Phone No.	Normal	Text	50	Phone No_	nvarchar(100)
12	Token	Token	Normal	Text	50	Token	nvarchar(100)
13	Gateway	Gateway	Normal	Text	50	Gateway	nvarchar(100)
	Key to join to the Shpfy Transaction Gateway table. Show/hide example query SELECT [Shpfy Order Header].[Gateway] ,[Shpfy Transaction Gateway].[Name] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway] ON [Shpfy Order Header].[Gateway] = [Shpfy Transaction Gateway].[Name]
14	Sell-to First Name	Sell-to First Name	Normal	Text	50	Sell-to First Name	nvarchar(100)
15	Sell-to Last Name	Sell-to Last Name	Normal	Text	50	Sell-to Last Name	nvarchar(100)
16	Currency	Currency	Normal	Code	10	Currency	nvarchar(20)
17	Cart Token	Cart Token	Normal	Text	50	Cart Token	nvarchar(100)
18	Checkout Token	Checkout Token	Normal	Text	50	Checkout Token	nvarchar(100)
19	Reference	Reference	Normal	Text	50	Reference	nvarchar(100)
21	Risk Level	Risk Level	Normal	Option	4	Risk Level	int
	Available options are: ” “ “Low” “Medium” “High”
22	Fully Paid	Fully Paid	Normal	Boolean	4	Fully Paid	tinyint
23	Processing Method	Processing Method	Normal	Option	4	Processing Method	int
	Available options are: “Checkout” “Direct” “Manual” “Offsite” “Express” “Free” “Unknown”
24	Checkout Id	Checkout Id	Normal	BigInteger	8	Checkout Id	bigint
25	Contact Email	Contact Email	Normal	Text	100	Contact Email	nvarchar(200)
26	Total Tip Received	Total Tip Received	Normal	Decimal	12	Total Tip Received	decimal(38,38)
27	Session Hash	Session Hash	Normal	Text	50	Session Hash	nvarchar(100)
48	Ship-to First Name	Ship-to First Name	Normal	Text	50	Ship-to First Name	nvarchar(100)
49	Ship-to Last Name	Ship-to Last Name	Normal	Text	50	Ship-to Last Name	nvarchar(100)
50	Ship-to Name	Ship-to Name	Normal	Text	50	Ship-to Name	nvarchar(100)
51	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
52	Ship-to Address 2	Ship-to Address 2	Normal	Text	100	Ship-to Address 2	nvarchar(200)
53	Ship-to City	Ship-to City	Normal	Text	50	Ship-to City	nvarchar(100)
	Key to join to the Post Code table. Show/hide example query SELECT [Shpfy Order Header].[Ship-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Shpfy Order Header].[Ship-to City] = [Post Code].[City]
54	Ship-to Post Code	Ship-to ZIP Code	Normal	Text	50	Ship-to Post Code	nvarchar(100)
	Key to join to the Post Code table. Show/hide example query SELECT [Shpfy Order Header].[Ship-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Shpfy Order Header].[Ship-to Post Code] = [Post Code].[Code]
55	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	20	Ship-to Country_Region Code	nvarchar(40)
56	Ship-to Country/Region Name	Ship-to Country/Region Name	Normal	Text	50	Ship-to Country_Region Name	nvarchar(100)
57	Ship-to Latitude	Ship-to Latitude	Normal	Decimal	12	Ship-to Latitude	decimal(38,38)
58	Ship-to Longitude	Ship-to Longitude	Normal	Decimal	12	Ship-to Longitude	decimal(38,38)
60	Bill-to Name	Bill-to Name	Normal	Text	50	Bill-to Name	nvarchar(100)
	Key to join to the Customer table. Show/hide example query SELECT [Shpfy Order Header].[Bill-to Name] ,[Customer].[Name] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Shpfy Order Header].[Bill-to Name] = [Customer].[Name]
61	Bill-to Address	Bill-to Address	Normal	Text	100	Bill-to Address	nvarchar(200)
62	Bill-to Address 2	Bill-to Address 2	Normal	Text	100	Bill-to Address 2	nvarchar(200)
63	Bill-to City	Bill-to City	Normal	Text	50	Bill-to City	nvarchar(100)
	Key to join to the Post Code table. Show/hide example query SELECT [Shpfy Order Header].[Bill-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Shpfy Order Header].[Bill-to City] = [Post Code].[City]
64	Bill-to Post Code	Bill-to ZIP Code	Normal	Text	50	Bill-to Post Code	nvarchar(100)
	Key to join to the Post Code table. Show/hide example query SELECT [Shpfy Order Header].[Bill-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Shpfy Order Header].[Bill-to Post Code] = [Post Code].[Code]
65	Bill-to Country/Region Code	Bill-to Country/Region Code	Normal	Code	20	Bill-to Country_Region Code	nvarchar(40)
66	Bill-to Country/Region Name	Bill-to Country/Region Name	Normal	Text	50	Bill-to Country_Region Name	nvarchar(100)
67	Test	Test	Normal	Boolean	4	Test	tinyint
68	Total Amount	Total Amount	Normal	Decimal	12	Total Amount	decimal(38,38)
69	Subtotal Amount	Subtotal Amount	Normal	Decimal	12	Subtotal Amount	decimal(38,38)
70	Total Weight	Total Weight	Normal	Decimal	12	Total Weight	decimal(38,38)
71	VAT Amount	Tax Amount	Normal	Decimal	12	VAT Amount	decimal(38,38)
72	VAT Included	Tax Included	Normal	Boolean	4	VAT Included	tinyint
73	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Shpfy Order Header].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Shpfy Order Header].[Currency Code] = [Currency].[Code]
74	Financial Status	Financial Status	Normal	Option	4	Financial Status	int
	Available options are: ” “ “Pending” “Authorized” “Partially Paid” “Paid” “Partially Refunded” “Refunded” “Voided” “Unknown”
75	Confirmed	Confirmed	Normal	Boolean	4	Confirmed	tinyint
76	Discount Amount	Discount Amount	Normal	Decimal	12	Discount Amount	decimal(38,38)
77	Total Items Amount	Total Items Amount	Normal	Decimal	12	Total Items Amount	decimal(38,38)
78	Fulfillment Status	Fulfillment Status	Normal	Option	4	Fulfillment Status	int
	Available options are: ” “ “Fulfilled” “In Progress” “Open” “Pending Fulfillment” “Restocked” “Unfulfilled” “Partially Fulfilled”
79	Buyer Accepts Marketing	Buyer Accepts Marketing	Normal	Boolean	4	Buyer Accepts Marketing	tinyint
80	Cancelled At	Canceled At	Normal	DateTime	8	Cancelled At	datetime
81	Cancel Reason	Cancel Reason	Normal	Option	4	Cancel Reason	int
	Available options are: ” “ “Customer” “Fraud” “Inventory” “Other” “Unknown”
82	Closed At	Closed At	Normal	DateTime	8	Closed At	datetime
83	Bill-to First Name	Bill-to First Name	Normal	Text	50	Bill-to First Name	nvarchar(100)
84	Bill-to Lastname	Bill-to Last Name	Normal	Text	50	Bill-to Lastname	nvarchar(100)
87	Processed At	Processed At	Normal	DateTime	8	Processed At	datetime
89	Shopify Order No.	Shopify Order No.	Normal	Text	50	Shopify Order No_	nvarchar(100)
90	Order Status URL	Order Status URL	Normal	Text	250	Order Status URL	nvarchar(500)
91	Created At	Created At	Normal	DateTime	8	Created At	datetime
92	Source Name	Source Name	Normal	Code	20	Source Name	nvarchar(40)
93	Updated At	Updated At	Normal	DateTime	8	Updated At	datetime
94	Shipping Charges Amount	Shipping Charges Amount	Normal	Decimal	12	Shipping Charges Amount	decimal(38,38)
95	Document Date	Document Date	Normal	Date	4	Document Date	datetime
96	Sell-to County	Sell-to State	Normal	Text	30	Sell-to County	nvarchar(60)
97	Bill-to County	Bill-to State	Normal	Text	30	Bill-to County	nvarchar(60)
98	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
99	Customer Id	Customer Id	Normal	BigInteger	8	Customer Id	bigint
	Key to join to the Customer table. Show/hide example query SELECT [Shpfy Order Header].[Customer Id] ,[Customer].[$systemId] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Shpfy Order Header].[Customer Id] = [Customer].[$systemId]
100	Closed	Closed	Normal	Boolean	4	Closed	tinyint
101	Location Id	Location Id	Normal	BigInteger	8	Location Id	bigint
	Key to join to the Location table. Show/hide example query SELECT [Shpfy Order Header].[Location Id] ,[Location].[$systemId] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Shpfy Order Header].[Location Id] = [Location].[$systemId]
102	Channel Name	Channel Name	Normal	Text	100	Channel Name	nvarchar(200)
103	App Name	App Name	Normal	Text	100	App Name	nvarchar(200)
104	Presentment Currency Code	Presentment Currency Code	Normal	Code	10	Presentment Currency Code	nvarchar(20)
105	Unpaid	Unpaid	Normal	Boolean	4	Unpaid	tinyint
106	Discount Code	Discount Code	Normal	Code	20	Discount Code	nvarchar(40)
107	Discount Codes	Discount Codes	Normal	Text	250	Discount Codes	nvarchar(500)
108	Refundable	Refundable	Normal	Boolean	4	Refundable	tinyint
109	Presentment Total Amount	Presentment Total Amount	Normal	Decimal	12	Presentment Total Amount	decimal(38,38)
110	Presentment Subtotal Amount	Presentment Subtotal Amount	Normal	Decimal	12	Presentment Subtotal Amount	decimal(38,38)
111	Presentment VAT Amount	Presentment Tax Amount	Normal	Decimal	12	Presentment VAT Amount	decimal(38,38)
112	Presentment Discount Amount	Discount Amount	Normal	Decimal	12	Presentment Discount Amount	decimal(38,38)
113	Presentment Total Tip Received	Presentment Total Tip Received	Normal	Decimal	12	Presentment Total Tip Received	decimal(38,38)
114	Pres. Shipping Charges Amount	Presentment Shipping Charges Amount	Normal	Decimal	12	Pres_ Shipping Charges Amount	decimal(38,38)
115	Edited	Edited	Normal	Boolean	4	Edited	tinyint
116	Return Status	Return Status	Normal	Option	4	Return Status	int
	Available options are: ” “ “Inspection Complete” “In Progress” “No Return” “Returned” “Return Failed” “Return Requested”
500	Shop Code	Shop Code	Normal	Code	20	Shop Code	nvarchar(40)
	Key to join to the Shpfy Shop table. Show/hide example query SELECT [Shpfy Order Header].[Shop Code] ,[Shpfy Shop].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop] ON [Shpfy Order Header].[Shop Code] = [Shpfy Shop].[Code]
501	Customer Template Code	Customer Template Code	Normal	Code	10	Customer Template Code	nvarchar(20)
502	Customer Templ. Code	Customer Template Code	Normal	Code	20	Customer Templ_ Code	nvarchar(40)
	Key to join to the Customer Templ. table. Show/hide example query SELECT [Shpfy Order Header].[Customer Templ_ Code] ,[Customer Templ.].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] ON [Shpfy Order Header].[Customer Templ_ Code] = [Customer Templ.].[Code]
601	Total Quantity of Items	Total Quantity of Items	FlowField	Decimal	12
602	Number of Lines	Number of Lines	FlowField	Integer	4
1000	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	Sell-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Shpfy Order Header].[Sell-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Shpfy Order Header].[Sell-to Customer No_] = [Customer].[No_]
1001	Sales Order No.	Sales Order No.	Normal	Code	20	Sales Order No_	nvarchar(40)
1002	Has Error	Has Error	Normal	Boolean	4	Has Error	tinyint
1003	Error Message	Error Message	Normal	Text	2048	Error Message	nvarchar(4096)
1004	Processed	Processed	Normal	Boolean	4	Processed	tinyint
1005	Sell-to Customer Name	Sell-to Customer Name	Normal	Text	50	Sell-to Customer Name	nvarchar(100)
	Key to join to the Customer table. Show/hide example query SELECT [Shpfy Order Header].[Sell-to Customer Name] ,[Customer].[Name] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Shpfy Order Header].[Sell-to Customer Name] = [Customer].[Name]
1006	Sales Invoice No.	Sales Invoice No.	Normal	Code	20	Sales Invoice No_	nvarchar(40)
	Key to join to the Sales Invoice Header table. Show/hide example query SELECT [Shpfy Order Header].[Sales Invoice No_] ,[Sales Invoice Header].[No_] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header] ON [Shpfy Order Header].[Sales Invoice No_] = [Sales Invoice Header].[No_]
1007	Work Description	Work Description	Normal	BLOB	8	Work Description	image
1008	Sell-to Customer Name 2	Sell-to Customer Name 2	Normal	Text	50	Sell-to Customer Name 2	nvarchar(100)
1009	Ship-to Name 2	Ship-to Name 2	Normal	Text	50	Ship-to Name 2	nvarchar(100)
1010	Bill-to Name 2	Bill-to Name 2	Normal	Text	50	Bill-to Name 2	nvarchar(100)
1011	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Shpfy Order Header].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Shpfy Order Header].[Bill-to Customer No_] = [Customer].[No_]
1012	Shipping Method Code	Shipping Method Code	Normal	Code	10	Shipping Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Shpfy Order Header].[Shipping Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Shpfy Order Header].[Shipping Method Code] = [Shipment Method].[Code]
1013	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(20)
	Key to join to the Payment Method table. Show/hide example query SELECT [Shpfy Order Header].[Payment Method Code] ,[Payment Method].[Code] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method] ON [Shpfy Order Header].[Payment Method Code] = [Payment Method].[Code]
1014	Sell-to Contact Name	Sell-to Contact Name	Normal	Text	100	Sell-to Contact Name	nvarchar(200)
1015	Bill-to Contact Name	Bill-to Contact Name	Normal	Text	100	Bill-to Contact Name	nvarchar(200)
1016	Ship-to Contact Name	Ship-to Contact Name	Normal	Text	100	Ship-to Contact Name	nvarchar(200)
1017	Sell-to Contact No.	Sell-to Contact No.	Normal	Code	20	Sell-to Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Shpfy Order Header].[Sell-to Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Shpfy Order Header].[Sell-to Contact No_] = [Contact].[No_]
1018	Bill-to Contact No.	Bill-to Contact No.	Normal	Code	20	Bill-to Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Shpfy Order Header].[Bill-to Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Shpfy Order Header].[Bill-to Contact No_] = [Contact].[No_]
1019	Ship-to Contact No.	Ship-to Contact No.	Normal	Code	20	Ship-to Contact No_	nvarchar(40)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Shpfy Order Header].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] LEFT JOIN [User] AS [User] ON [Shpfy Order Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Shpfy Order Header table

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Order Header

Leave a Reply Cancel reply