Table 30150 "Shpfy Company"
Shopify · Microsoft.Integration.Shopify
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 9 connected objects and pages
Shopify · Microsoft.Integration.Shopify · captioned “Shopify Company” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 30156 “Shpfy Companies” (1 Learn page), Page 30157 “Shpfy Company Card” (1).
Properties
| Property | Value |
|---|---|
| Caption | Shopify Company |
| DataClassification | CustomerContent |
| LookupPageId | Shpfy Companies |
| DrillDownPageId | Shpfy Companies |
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 in Shopify. via Page 30157 “Shpfy Company Card” | DataClassification SystemMetadata |
| 2 | Name | Text[500] | Specifies the company’s name. via Page 30157 “Shpfy Company Card” | |
| 3 | Note | Blob | — | |
| 4 | Created At | DateTime | Created At (Shopify) caption | |
| 5 | Updated At | DateTime | Updated At (Shopify) caption | |
| 6 | Last Updated by BC | DateTime | — | DataClassification SystemMetadata |
| 7 | Customer SystemId | Guid | Specifies the unique identifier for the customer in D365BC. via Page 30157 “Shpfy Company Card” | DataClassification SystemMetadata |
| 8 | Customer No. | Code[20] | Specifies the customer number. via Page 30156 “Shpfy Companies” | FlowField: lookup(Customer.“No.” where(SystemId = field(“Customer SystemId”))) |
| 9 | Shop Id | Integer | Shop ID caption | not editable; DataClassification SystemMetadata |
| 10 | Shop Code | Code[20] | — | TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop); not editable |
| 11 | Main Contact Customer Id | BigInteger | Main Contact Id caption | TableRelation Table 30105 “Shpfy Customer” (Shpfy Customer); not editable |
| 12 | Main Contact Id | BigInteger | — | not editable |
| 13 | Location Id | BigInteger | — | not editable |
| 14 | External Id | Text[500] | Specifies the external ID of the company. via Page 30157 “Shpfy Company Card” | not editable |
Keys
- PK: Id (clustered)
- Idx1: Customer SystemId
- Idx2: Shop Id
Procedures
GetNote(): Text(internal)SetNote(NewNote: Text)(internal)
Triggers
OnDelete
Relations
- drill-down page Page 30156 “Shpfy Companies”
- lookup page Page 30156 “Shpfy Companies”
- Shop Code: TableRelation Table 30102 “Shpfy Shop”
- Main Contact Customer Id: TableRelation Table 30105 “Shpfy Customer”
Referenced by
3 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 30100 “Shpfy Cue”: Unmapped Companies
- Table 30151 “Shpfy Company Location”: Company Name
- Table 30152 “Shpfy Catalog”: Company Name
Pages and codeunits on this table
- Page 30156 “Shpfy Companies” (source table)
- Page 30157 “Shpfy Company Card” (source table)
- Codeunit 30301 “Shpfy Company Import” (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 Company"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.