Table 30112 "Shpfy Shop Inventory"
Shopify · Microsoft.Integration.Shopify
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 5 connected objects and pages
Shopify · Microsoft.Integration.Shopify · captioned “Shopify Shop Inventory” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 30116 “Shpfy Inventory FactBox” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Shopify Shop Inventory |
| Access | Internal |
| 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 | Shop Code | Code[20] | Specifies the Shopify Shop. via Page 30116 “Shpfy Inventory FactBox” | TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop); not editable |
| 2 | Product Id | BigInteger | — | not editable |
| 3 | Variant Id | BigInteger | — | not editable |
| 4 | Location Id | BigInteger | — | not editable |
| 5 | Inventory Item Id | BigInteger | — | not editable |
| 6 | Shopify Stock | Integer | Specifies the stock value on Shopify. via Page 30116 “Shpfy Inventory FactBox” | not editable |
| 7 | Stock | Integer | Specifies the stock value in D365BC via Page 30116 “Shpfy Inventory FactBox” | not editable |
| 8 | Last Synced On | DateTime | Specifies the date and time when the stock was last synchronized from Shopify. via Page 30116 “Shpfy Inventory FactBox” | not editable |
| 9 | Last Calculated On | DateTime | Specifies the date and time when the stock of D365BC was last calculated. via Page 30116 “Shpfy Inventory FactBox” | |
| 10 | Location Name | Text[250] | Specifies the location name. via Page 30116 “Shpfy Inventory FactBox” | FlowField: lookup(“Shpfy Shop Location”.Name where(“Shop Code” = field(“Shop Code”), Id = field(“Location Id”))) |
Keys
- PK: Shop Code, Product Id, Variant Id, Location Id (clustered)
- Key2: Variant Id
Relations
- Shop Code: TableRelation Table 30102 “Shpfy Shop”
- Location Name: CalcFormula Table 30113 “Shpfy Shop Location”
Pages and codeunits on this table
- Page 30116 “Shpfy Inventory FactBox” (source table)
- Codeunit 30197 “Shpfy Sync Inventory” (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 Shop Inventory"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.