Shpfy Shop #30102

Other table in Microsoft Dynamics 365 Business Central. 96 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code.

All fields (96)

Shpfy Shop — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Shopify Admin URL	Text	Normal
3	Enabled	Boolean	Normal
6	Customer Price Group	Code	Normal	→ Customer Price Group #6
7	Customer Discount Group	Code	Normal	→ Customer Discount Group #340
8	Shipping Charges Account	Code	Normal	→ G/L Account #15
9	Language Code	Code	Normal	→ Language #8
10	Sync Item	Option	Normal
12	Sync Item Images	Option	Normal
13	Sync Item Extended Text	Boolean	Normal
14	Sync Item Attributes	Boolean	Normal
15	Sync Item Marketing Text	Boolean	Normal
21	Auto Create Orders	Boolean	Normal
22	Auto Create Unknown Items	Boolean	Normal
23	Auto Create Unknown Customers	Boolean	Normal
25	Product Collection	Option	Normal
27	Shopify Order No. on Doc. Line	Boolean	Normal
28	Customer Import from Shopify	Option	Normal
30	Shopify Can Update Customers	Boolean	Normal
31	Can Update Shopify Customers	Boolean	Normal
32	Name Source	Option	Normal
33	Name 2 Source	Option	Normal
34	Contact Source	Option	Normal
35	State Source	Option	Normal
36	Default Customer No.	Code	Normal	→ Customer #18
37	UoM as Variant	Boolean	Normal
38	Variant Option Name for UoM	Text	Normal
39	Shopify Can Update Items	Boolean	Normal
40	Can Update Shopify Products	Boolean	Normal
41	Variant Prefix	Code	Normal
42	Inventory Tracked	Boolean	Normal
43	Default Inventory Policy	Option	Normal
44	Run Syncs in Background	Boolean	Normal
47	Tip Account	Code	Normal	→ G/L Account #15
48	Sold Gift Card Account	Code	Normal	→ G/L Account #15
49	Customer Mapping Type	Option	Normal
50	Status for Created Products	Option	Normal
51	Action for Removed Products and Blocked Items	Option	Normal
52	Currency Code	Code	Normal	→ Currency #4
53	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
54	Tax Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
55	Tax Area Code	Code	Normal	→ Tax Area #318
56	Tax Liable	Boolean	Normal
57	Tax Country/Region Code	Code	Normal	→ Country/Region #9
58	Customer Posting Group	Code	Normal	→ Customer Posting Group #92
59	Prices Including Tax	Boolean	Normal
60	Auto Release Sales Orders	Boolean	Normal
61	Allow Line Disc.	Boolean	Normal
62	Customer Template Code	Code	Normal	→ Customer Templ. #1381
63	Item Template Code	Code	Normal	→ Item Templ. #1382
70	Return and Refund Process	Option	Normal
73	Default Return Location	Code	Normal	→ Location #14
75	Refund Account non-restock Items	Code	Normal	→ G/L Account #15
76	Refund Account	Code	Normal	→ G/L Account #15
104	SKU Mapping	Option	Normal
105	SKU Field Separator	Code	Normal
106	Tax Area Priority	Option	Normal
107	Allow Outgoing Requests	Boolean	Normal
108	Order Created Webhooks	Boolean	Normal
109	Order Created Webhook User	Code	Normal
110	Fulfillment Service Activated	Boolean	Normal
111	Order Created Webhook User Id	GUID	Normal
112	Order Created Webhook Id	Text	Normal
113	Logging Mode	Option	Normal
114	Bulk Operation Webhook User Id	GUID	Normal
115	Bulk Operation Webhook Id	Text	Normal
116	Sync Prices with Products	Boolean	Normal
117	B2B Enabled	Boolean	Normal
118	Can Update Shopify Companies	Boolean	Normal
119	Default Contact Permission	Option	Normal
120	Auto Create Catalog	Boolean	Normal
121	Company Import from Shopify	Option	Normal
122	Shopify Can Update Companies	Boolean	Normal
123	Auto Create Unknown Companies	Boolean	Normal
124	Send Shipping Confirmation	Boolean	Normal
125	Default Company No.	Code	Normal	→ Customer #18
126	Company Mapping Type	Option	Normal
128	Return Location Priority	Option	Normal
129	Weight Unit	Option	Normal
130	Sync Product/Variant Metafields to Shopify	Boolean	Normal
131	Sync Customer Metafields	Boolean	Normal
132	Sync Company Metafields	Boolean	Normal
133	Sync Business Central Doc. No. as Attribute	Boolean	Normal
134	Company Tax Id Mapping	Option	Normal
200	Shop Id	Integer	Normal
201	Items Must be Mapped to Products	Boolean	Normal
202	Posted Invoice Sync	Boolean	Normal
203	Cash Roundings Account	Code	Normal	→ G/L Account #15
204	Archive Processed Shopify Orders	Boolean	Normal
205	Create Fulfilled Orders as Invoices	Boolean	Normal
206	Fulfillment Service Updated	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal