Table 30145 "Shpfy Refund Line"

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

Properties

Property	Value
Caption	Refund 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	Refund Line Id	BigInteger	—	not editable
2	Refund Id	BigInteger	—	TableRelation Table 30142 “Shpfy Refund Header” (“Shpfy Refund Header”.“Refund Id”); not editable
3	Order Line Id	BigInteger	—	TableRelation Table 30119 “Shpfy Order Line” (“Shpfy Order Line”.“Line Id”); not editable
4	Quantity	Integer	Specifies the quantity of a refunded line item. via Page 30146 “Shpfy Refund Lines”	not editable
5	Restock Type	Enum “Shpfy Restock Type”	Specifies the type of restock for the refunded line item. via Page 30146 “Shpfy Refund Lines”	enum Enum 30140 “Shpfy Restock Type”; not editable
6	Restocked	boolean	Specifies whether the refunded line item was restocked. via Page 30146 “Shpfy Refund Lines”	not editable
7	Amount	Decimal	Specifies the price of a refunded line item. via Page 30146 “Shpfy Refund Lines”	not editable
8	Presentment Amount	Decimal	Specifies the price in presentment currency of a refunded line item.	not editable
9	Subtotal Amount	Decimal	Specifies the subtotal price of a refunded line item. via Page 30146 “Shpfy Refund Lines”	not editable
10	Presentment Subtotal Amount	Decimal	Specifies the subtotal price of a refunded line item in presentment currency.	not editable
11	Total Tax Amount	Decimal	Specifies the total tax charged on a refunded line item. via Page 30146 “Shpfy Refund Lines”	not editable
12	Presentment Total Tax Amount	Decimal	Specifies the total tax charged on a refunded line item in presentment currency.	not editable
13	Can Create Credit Memo	Boolean	—	not editable
14	Is Exchange Item	Boolean	Specifies that this refund line was synthesized from a Return.exchangeLineItems entry rather than from a real Shopify refund line. Exchange-item refund lines carry a negative quantity so that the sales credit memo total matches the Shopify refund total without an extra balancing G/L line.	not editable
101	Item No.	Code[20]	Specifies the value of the Item No. field. via Page 30146 “Shpfy Refund Lines”	FlowField: lookup(“Shpfy Order Line”.“Item No.” where(“Line Id” = field(“Order Line Id”))); not editable
102	Description	Text[100]	Specifies the value of the Description field. via Page 30146 “Shpfy Refund Lines”	FlowField: lookup(“Shpfy Order Line”.Description where(“Line Id” = field(“Order Line Id”))); not editable
103	Variant Code	Code[10]	Specifies the value of the Variant Code field. via Page 30146 “Shpfy Refund Lines”	FlowField: lookup(“Shpfy Order Line”.“Variant Code” where(“Line Id” = field(“Order Line Id”))); not editable
104	Gift Card	Boolean	—	FlowField: lookup(“Shpfy Order Line”.“Gift Card” where(“Line Id” = field(“Order Line Id”))); not editable
105	Location Id	BigInteger	—	not editable
106	Unit of Measure Code	Code[10]	—	FlowField: lookup(“Shpfy Order Line”.“Unit of Measure Code” where(“Line Id” = field(“Order Line Id”))); not editable

Keys

PK: Refund Id, Refund Line Id (clustered)

Procedures

OrderCurrencyCode(): Code[10] (internal)
PresentmentCurrencyCode(): Code[10] (internal)

Triggers

OnDelete

Relations

Description: CalcFormula Table 30119 “Shpfy Order Line”
Gift Card: CalcFormula Table 30119 “Shpfy Order Line”
Item No.: CalcFormula Table 30119 “Shpfy Order Line”
Unit of Measure Code: CalcFormula Table 30119 “Shpfy Order Line”
Variant Code: CalcFormula Table 30119 “Shpfy Order Line”
Order Line Id: TableRelation Table 30119 “Shpfy Order Line”
Refund Id: TableRelation Table 30142 “Shpfy Refund Header”

Pages and codeunits on this table

Page 30146 “Shpfy Refund Lines” (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 Refund Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.