Table 30106 "Shpfy Customer Address"

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

Learn documents this table through its pages: Page 30105 “Shpfy Customer Adresses” (1 Learn page).

Properties

Property	Value
Caption	Shopify Customer Address
DataClassification	CustomerContent

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 Shopify id of this address record. via Page 30105 “Shpfy Customer Adresses”	not editable; DataClassification SystemMetadata
2	Customer Id	BigInteger	—	not editable; DataClassification SystemMetadata
3	Company	Text[100]	Specifies the customer’s company. via Page 30105 “Shpfy Customer Adresses”
4	First Name	Text[50]	Specifies the customer’s first name. via Page 30105 “Shpfy Customer Adresses”
5	Last Name	Text[50]	Specifies the customer’s last name. via Page 30105 “Shpfy Customer Adresses”
6	Address 1	Text[100]	Specifies the customer’s address. via Page 30105 “Shpfy Customer Adresses”
7	Address 2	Text[100]	Specifies the customer’s address 2. via Page 30105 “Shpfy Customer Adresses”
8	Zip	Code[20]	Specifies the customer’s postal code. via Page 30105 “Shpfy Customer Adresses”
9	City	Text[50]	Specifies the city of the address. via Page 30105 “Shpfy Customer Adresses”
10	Country/Region Code	Code[2]	Specifies the country/region of the address. via Page 30105 “Shpfy Customer Adresses”
11	Country/Region Name	Text[50]	Specifies the country/region name of the address. via Page 30105 “Shpfy Customer Adresses”
12	Province Code	Code[10]	Specifies the customer’s region code. Typically a province, a state or a prefecture. via Page 30105 “Shpfy Customer Adresses”
13	Province Name	Text[50]	Specifies the customer’s region name. Typically a province, a state or a prefecture. via Page 30105 “Shpfy Customer Adresses”
14	Phone	Text[30]	Specifies the customer’s phone number at this address. via Page 30105 “Shpfy Customer Adresses”
15	Default	Boolean	Specifies the default address for the customer. via Page 30105 “Shpfy Customer Adresses”
102	CustomerSystemId	Guid	Customer System Id caption	DataClassification SystemMetadata
103	Customer No.	Code[20]	—	FlowField: lookup(Customer.“No.” where(SystemId = field(CustomerSystemId)))

Keys

PK: Id (clustered)
Key2: Customer Id, Default

Triggers

OnInsert

Pages and codeunits on this table

Page 30105 “Shpfy Customer Adresses” (source table)
Codeunit 30110 “Shpfy Create Customer” (codeunit runs on it)

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 Address"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.