Table 30119 "Shpfy Order Line"

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

Learn documents this table through its pages: Page 30122 “Shpfy Order Subform” (1 Learn page).

Properties

Property	Value
Caption	Shopify Order Line
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	Shopify Order Id	BigInteger	—	not editable
2	Line Id	BigInteger	—	not editable
3	Shopify Product Id	BigInteger	Specifies a unique identifier for the product. via Page 30122 “Shpfy Order Subform”
4	Description	Text[100]	Specifies the description of the product to be sold. via Page 30122 “Shpfy Order Subform”	not editable
5	Quantity	Decimal	Specifies how many units are being sold. via Page 30122 “Shpfy Order Subform”
6	Unit Price	Decimal	Specifies the prices for one unit on the line. via Page 30122 “Shpfy Order Subform”	not editable
7	Discount Amount	Decimal	Specifies the discount amount that is granted for the item on the line. via Page 30122 “Shpfy Order Subform”	not editable
8	Shopify Variant Id	BigInteger	Specifies a unique identifier for the variant. via Page 30122 “Shpfy Order Subform”	not editable
9	Variant Description	Text[50]	Specifies the description of the variant to be sold. via Page 30122 “Shpfy Order Subform”	not editable
11	Fulfillment Service	Text[100]	—	not editable
12	Taxable	Boolean	—	not editable
13	Gift Card	Boolean	—	not editable
14	Product Exists	Boolean	—	not editable
15	Fulfillable Quantity	Decimal	Specifies the quantity available to fulfill. via Page 30122 “Shpfy Order Subform”	not editable
16	Tip	Boolean	—
17	Location Id	BigInteger	—	not editable
18	Presentment Unit Price	Decimal	Specifies the prices in presentment currency for one unit on the line.	not editable
19	Presentment Discount Amount	Decimal	Specifies the discount amount in presentment currency that is granted for the item on the line.	not editable
20	Delivery Method Type	Enum “Shpfy Delivery Method Type”	—	enum Enum 30152 “Shpfy Delivery Method Type”; not editable
21	Weight	Decimal	—	not editable
22	Is Exchange Item	Boolean	Specifies that this line was added to the order as the new item in a return-with-exchange. Lines marked as exchange items are excluded from BC sales documents created from the Shopify order, because the corresponding credit memo will offset their value via the linked refund.	not editable
1000	Item No.	Code[20]	Specifies the item number. via Page 30122 “Shpfy Order Subform”	TableRelation Table 27 “Item”
1001	Variant Code	Code[10]	Specifies the variant of the item on the line. via Page 30122 “Shpfy Order Subform”	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
1002	Unit of Measure Code	Code[10]	Specifies how each unit of the item is measured. via Page 30122 “Shpfy Order Subform”	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)))

Keys

Key1: Shopify Order Id, Line Id (clustered)
Idx001: Shopify Order Id, Gift Card, Tip
Key3: Line Id

Procedures

3 local procedures, no public ones.

Triggers

OnDelete

Relations

Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”

Referenced by

14 fields in 4 objects relate to this table (TableRelation or CalcFormula).

Table 30145 “Shpfy Refund Line”: Description, Gift Card, Item No., Unit of Measure Code, Variant Code, Order Line Id
Table 30141 “Shpfy Return Line”: Description, Item No., Unit of Measure Code, Variant Code, Order Line Id
Table 30118 “Shpfy Order Header”: Number of Lines, Total Quantity of Items
Table 30139 “Shpfy Fulfillment Line”: Order Line Id

Pages and codeunits on this table

Page 30122 “Shpfy Order Subform” (source table)

Recent changes

2026-07-21 #8554 [Shopify] Fix incorrect G/L line on credit memo for refund with exchange item (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 Order Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.