Table 30105 "Shpfy Customer"

Shopify · Microsoft.Integration.Shopify · captioned “Shopify Customer” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30106 “Shpfy Customer Card” (2 Learn pages), Page 30107 “Shpfy Customers” (2).

Properties

Property	Value
Caption	Shopify Customer
DataClassification	CustomerContent
LookupPageId	Shpfy Customers
DrillDownPageId	Shpfy Customers

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Id	BigInteger	Specifies the unique identifier for the customer in Shopify. via Page 30106 “Shpfy Customer Card”	DataClassification SystemMetadata
2	First Name	Text[100]	Specifies the customer’s first name. via Page 30106 “Shpfy Customer Card”
3	Last Name	Text[100]	Specifies the customer’s last name. via Page 30106 “Shpfy Customer Card”
4	Email	Text[100]	Specifies the unique email address of the customer. Attempting to assign the same e-mail address to multiple customers returns an error. via Page 30106 “Shpfy Customer Card”
5	Phone No.	Text[30]	Specifies the customer’s telephone number. via Page 30106 “Shpfy Customer Card”
6	Accepts Marketing	Boolean	Specifies whether the customer consented to receive email updates from the shop. via Page 30106 “Shpfy Customer Card”
7	Accepts Marketing Update At	DateTime	—
8	ISO Currency Code	Code[3]	—
9	Tax Exempt	Boolean	—
10	Verified Email	Boolean	Specifies whether the customer has verified their e-mail address. via Page 30106 “Shpfy Customer Card”
11	State	enum “Shpfy Customer State”	Specifies the state of a customer’s account with a shop. The default value is disabled. Valid values are: disabled, invited, enabled and declined. via Page 30106 “Shpfy Customer Card”	enum Enum 30107 “Shpfy Customer State”
12	Note	Blob	—
13	Created At	DateTime	Created At (Shopify) caption
14	Updated At	DateTime	Updated At (Shopify) caption
15	Last Updated by BC	DateTime	—	DataClassification SystemMetadata
101	Customer SystemId	Guid	Specifies the unique identifier for the customer in D365BC. via Page 30106 “Shpfy Customer Card”	DataClassification SystemMetadata
102	Customer No.	Code[20]	Specifies the customer number. via Page 30107 “Shpfy Customers”	FlowField: lookup(Customer.“No.” where(SystemId = field(“Customer SystemId”)))
103	Shop Id	Integer	Shop ID caption	not editable; DataClassification SystemMetadata

Keys

PK: Id (clustered)
Idx1: Customer SystemId
Idx2: Shop Id

Procedures

GetCommaSeparatedTags(): Text (internal): Get Comma Seperated Tags.
GetNote(): Text (internal): Get Note.
SetNote(NewNote: Text) (internal): Set Note.
UpdateTags(CommaSeperatedTags: Text) (internal): Update Tags.

Triggers

OnDelete

Relations

drill-down page Page 30107 “Shpfy Customers”
lookup page Page 30107 “Shpfy Customers”

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 30100 “Shpfy Cue”: Unmapped Customers
Table 30150 “Shpfy Company”: Main Contact Customer Id

Pages and codeunits on this table

Page 30106 “Shpfy Customer Card” (source table)
Page 30107 “Shpfy Customers” (source table)
Page 30158 “Shpfy Main Contact Factbox” (source table)
Codeunit 30124 “Shpfy Update Customer” (codeunit runs on it)

Recent changes

2026-07-09 #9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips (main, BC30, fix)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Shpfy Customer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.