Table 30151 "Shpfy Company Location"

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

Properties

Property	Value
Caption	Shopify Company Location
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 unique identifier for the company location in Shopify.	not editable; DataClassification SystemMetadata
2	Company SystemId	Guid	Specifies the unique identifier for the company in Shopify.	not editable; DataClassification SystemMetadata
3	Address	Text[100]	Specifies the address of the company location.
4	Address 2	Text[100]	Specifies the second address line of the company location.
5	Zip	Code[20]	Specifies the postal code of the company location.
6	City	Text[50]	Specifies the city of the company location.
7	Country/Region Code	Code[2]	Specifies the country/region code of the company location.
8	Phone No.	Text[30]	Specifies the phone number of the company location.
9	Name	Text[100]	Specifies the name of the company location.	not editable
10	Province Code	Code[10]	Specifies the province code of the company location.
11	Province Name	Text[50]	Specifies the province name of the company location.
12	Tax Registration Id	Text[150]	Specifies the tax registration identifier of the company location.
13	Recipient	Text[100]	Specifies the recipient name for the company location.
14	Default	Boolean	Specifies whether the location is the default location for the company.
15	Shpfy Payment Terms Id	BigInteger	Specifies the Shopify Payment Terms Id which is mapped with Customer’s Payment Terms.
16	Company Name	Text[500]	Specifies the name of the company.	FlowField: lookup(“Shpfy Company”.Name where(SystemId = field(“Company SystemId”)))
17	Shpfy Payment Term	Text[150]	Specifies the description of the Shopify Payment Term.	FlowField: lookup(“Shpfy Payment Terms”.Description where(Id = field(“Shpfy Payment Terms Id”)))
18	Sell-to Customer No.	Code[20]	Specifies the customer number, which is used to set the Shopify Orders Sell-to value when importing orders from Shopify.	TableRelation Table 18 “Customer”
19	Bill-to Customer No.	Code[20]	Specifies the customer number, which is used to set the Shopify Orders Bill-to value when importing orders from Shopify.	TableRelation Table 18 “Customer”
20	Customer Id	Guid	Specifies the unique identifier of the customer associated with the company location.	not editable; DataClassification SystemMetadata

Keys

PK: Id (clustered)
Idx1: Company SystemId

Relations

Bill-to Customer No.: TableRelation Table 18 “Customer”
Sell-to Customer No.: TableRelation Table 18 “Customer”
Company Name: CalcFormula Table 30150 “Shpfy Company”
Shpfy Payment Term: CalcFormula Table 30158 “Shpfy Payment Terms”

Pages and codeunits on this table

Page 30165 “Shpfy Comp. Locations” (source table)
Page 30170 “Shpfy Comp. Locations Subform” (source table)

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