Table 30142 "Shpfy Refund Header"

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

Learn documents this table through its pages: Page 30145 “Shpfy Refund” (1 Learn page), Page 30147 “Shpfy Refunds” (1).

Properties

Property	Value
Caption	Refund Header
DataClassification	SystemMetadata
LookupPageId	Shpfy Refund
DrillDownPageId	Shpfy Refunds

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 Id	BigInteger	Specifies the Refund Id. via Page 30145 “Shpfy Refund”	not editable
2	Order Id	BigInteger	—	not editable
3	Created At	DateTime	Specifies the date and time when the refund was created in Shopify. via Page 30145 “Shpfy Refund”	not editable
4	Updated At	DateTime	Specifies the date and time when the refund was updated in Shopify. via Page 30145 “Shpfy Refund”	not editable
5	Return Id	BigInteger	—	not editable
6	Total Refunded Amount	Decimal	Specifies the total amount across all transactions for the refund. via Page 30145 “Shpfy Refund”	not editable
7	Pres. Tot. Refunded Amount	Decimal	Specifies the total amount in presentment currency across all transactions for the refund.	not editable
8	Note	Blob	—
9	Shop Code	code[20]	Shop code caption	not editable
50	Has Processing Error	Boolean	—	not editable
51	Last Error Description	Blob	—
52	Last Error Call Stack	Blob	—
101	Sell-to Customer No.	Code[20]	Specifies the Sell-to Customer No. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Sell-to Customer No.” where(“Shopify Order Id” = field(“Order Id”))); not editable
102	Bill-to Customer No.	Code[20]	Specifies the Bill-to Customer No. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Bill-to Customer No.” where(“Shopify Order Id” = field(“Order Id”))); not editable
103	Sell-to Customer Name	Text[50]	Specifies the Sell-to Customer Name via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Sell-to Customer Name” where(“Shopify Order Id” = field(“Order Id”))); not editable
104	Bill-to Customer Name	Text[50]	Specifies the Bill-to Customer Name. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Bill-to Name” where(“Shopify Order Id” = field(“Order Id”))); not editable
105	Shopify Order No.	Text[50]	Specifies the unique identifier for the order that appears on the order page in the Shopify admin and the order status page. For example, “#1001”, “EN1001”, or “1001-A”. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Shopify Order No.” where(“Shopify Order Id” = field(“Order Id”))); not editable
106	Return No.	Text[30]	Specifies the Shopify return associated with the refund. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Return Header”.“Return No.” where(“Return Id” = field(“Return Id”))); not editable
107	Is Processed	Boolean	Specifies if this refunds already is processed into a Business Central document. via Page 30145 “Shpfy Refund”	FlowField: exist(“Shpfy Doc. Link To Doc.” where(“Shopify Document Type” = const(“Shopify Shop Refund”), “Shopify Document Id” = field(“Refund Id”))); not editable
108	Currency Code	Code[10]	Specifies the currency code for the refund. via Page 30145 “Shpfy Refund”
109	Presentment Currency Code	Code[10]	Specifies the presentment currency code for the refund.
110	Tax Area Code	Code[20]	Specifies the tax area code from the parent order. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Tax Area Code” where(“Shopify Order Id” = field(“Order Id”))); not editable
111	Tax Liable	Boolean	Specifies whether the parent order is liable for sales tax. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Tax Liable” where(“Shopify Order Id” = field(“Order Id”))); not editable
112	Tax Exempt	Boolean	Specifies whether the parent order is exempt from tax. via Page 30145 “Shpfy Refund”	FlowField: lookup(“Shpfy Order Header”.“Tax Exempt” where(“Shopify Order Id” = field(“Order Id”))); not editable

Keys

PK: Refund Id (clustered)
Key1: Created At

Procedures

GetNote(): Text (internal)
SetNote(NewNote: Text) (internal)
GetLastErrorDescription(): Text (internal)
GetLastErrorCallStack(): Text (internal)
SetLastErrorDescription(NewLastErrorDescription: Text) (internal)
SetLastErrorCallStack(NewLastErrorCallStack: Text) (internal)
CheckCanCreateDocument(): Boolean (internal)

Plus 1 local procedures.

Triggers

OnDelete

Relations

lookup page Page 30145 “Shpfy Refund”
drill-down page Page 30147 “Shpfy Refunds”
Bill-to Customer Name: CalcFormula Table 30118 “Shpfy Order Header”
Bill-to Customer No.: CalcFormula Table 30118 “Shpfy Order Header”
Sell-to Customer Name: CalcFormula Table 30118 “Shpfy Order Header”
Sell-to Customer No.: CalcFormula Table 30118 “Shpfy Order Header”
Shopify Order No.: CalcFormula Table 30118 “Shpfy Order Header”
Tax Area Code: CalcFormula Table 30118 “Shpfy Order Header”
Tax Exempt: CalcFormula Table 30118 “Shpfy Order Header”
Tax Liable: CalcFormula Table 30118 “Shpfy Order Header”
Is Processed: CalcFormula Table 30146 “Shpfy Doc. Link To Doc.”
Return No.: CalcFormula Table 30147 “Shpfy Return Header”

Referenced by

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

Table 30145 “Shpfy Refund Line”: Refund Id
Table 30162 “Shpfy Refund Shipping Line”: Refund Id
Table extension 30108 “Shpfy Sales Cr.Memo Header”: Shpfy Refund Id
Table extension 30109 “Shpfy Sales Cr.Memo Line”: Shpfy Refund Id
Table extension 30110 “Shpfy Return Receipt Header”: Shpfy Refund Id
Table extension 30111 “Shpfy Return Receipt Line”: Shpfy Refund Id

Pages and codeunits on this table

Page 30145 “Shpfy Refund” (source table)
Page 30147 “Shpfy Refunds” (source table)

Recent changes

2026-10-01 #11854 [Shopify] Make refund currency codes read-only (main, BC30, fix)
2026-08-20 #10407 Shopify connector: persist order Tax Area Code, Tax Liable, and Tax Exempt (stack 1/3) (main, BC30, feature)
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 Refund Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.