Table 30110 "Shpfy Gift Card"
Shopify · Microsoft.Integration.Shopify
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 3 connected objects and pages
Shopify · Microsoft.Integration.Shopify · captioned “Shopify Gift Card” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 30110 “Shpfy Gift Cards” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Shopify Gift Card |
| Access | Internal |
| DataClassification | SystemMetadata |
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 id of the Shopify gift card. via Page 30110 “Shpfy Gift Cards” | |
| 2 | Last Characters | Text[4] | Specifies the last characters of the gift card code. via Page 30110 “Shpfy Gift Cards” | |
| 3 | Amount | Decimal | Specifies the amount of the Shopify gift card. via Page 30110 “Shpfy Gift Cards” | |
| 4 | Order Line Id | BigInteger | — | |
| 101 | Known Used Amount | Decimal | Specifies the balance of the gift card. via Page 30110 “Shpfy Gift Cards” | FlowField: sum(“Shpfy Order Transaction”.Amount where(“Gift Card Id” = field(Id))) |
Keys
- PK: Id (clustered)
Relations
- Known Used Amount: CalcFormula Table 30133 “Shpfy Order Transaction”
Pages and codeunits on this table
- Page 30110 “Shpfy Gift Cards” (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 Gift Card"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.