--- id: object/table/30142 type: object title: Table 30142 "Shpfy Refund Header" summary: Table 30142 "Shpfy Refund Header" in Shopify (Microsoft.Integration.Shopify). 24 fields, 7 public procedures. Introduced in BC29, still in BC30, changed in BC30. tier: official language: en tags: - table - shopify versions: introduced: "29" last_changed: "30" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 357215dbec4e41da43d909ba8f9193ce89ee6274bf8f96b2982f369947905d01 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Order%20Refunds/Tables/ShpfyRefundHeader.Table.al title: src/Apps/W1/Shopify/app/src/Order Refunds/Tables/ShpfyRefundHeader.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/shopify/synchronize-orders objects: [] features: [] topics: - topic/business-central/business-functionality/online-store-with-shopify localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/11854 - change/bcapps/10407 - change/bcapps/9253 object_type: table object_id: 30142 name: Shpfy Refund Header caption: Refund Header namespace: Microsoft.Integration.Shopify app: Shopify extends: null first_version: "29" last_version: "30" present_in: - "29" - "30" changed_in: - "30" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 24 procedures: 8 events: 0 subscribers: 0 relations: out: 12 referenced_by: 6 pages: 2 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 30142 "Shpfy Refund Header" > Table 30142 "Shpfy Refund Header" in Shopify (Microsoft.Integration.Shopify). 24 fields, 7 public procedures. Introduced in BC29, still in BC30, changed in BC30. Shopify · Microsoft.Integration.Shopify · captioned "Refund Header" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Order%20Refunds/Tables/ShpfyRefundHeader.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 30145 "Shpfy Refund"](../page/30145.md) (1 Learn page), [Page 30147 "Shpfy Refunds"](../page/30147.md) (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"](../page/30145.md) | 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"](../page/30145.md) | not editable | | 4 | Updated At | DateTime | Specifies the date and time when the refund was updated in Shopify. via [Page 30145 "Shpfy Refund"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | | | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) | 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"](../page/30145.md) - drill-down page [Page 30147 "Shpfy Refunds"](../page/30147.md) - Bill-to Customer Name: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Bill-to Customer No.: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Sell-to Customer Name: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Sell-to Customer No.: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Shopify Order No.: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Tax Area Code: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Tax Exempt: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Tax Liable: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Is Processed: CalcFormula [Table 30146 "Shpfy Doc. Link To Doc."](../table/30146.md) - Return No.: CalcFormula [Table 30147 "Shpfy Return Header"](../table/30147.md) ## Referenced by 6 fields in 6 objects relate to this table (TableRelation or CalcFormula). - [Table 30145 "Shpfy Refund Line"](../table/30145.md): Refund Id - [Table 30162 "Shpfy Refund Shipping Line"](../table/30162.md): Refund Id - [Table extension 30108 "Shpfy Sales Cr.Memo Header"](../tableextension/30108.md): Shpfy Refund Id - [Table extension 30109 "Shpfy Sales Cr.Memo Line"](../tableextension/30109.md): Shpfy Refund Id - [Table extension 30110 "Shpfy Return Receipt Header"](../tableextension/30110.md): Shpfy Refund Id - [Table extension 30111 "Shpfy Return Receipt Line"](../tableextension/30111.md): Shpfy Refund Id ## Pages and codeunits on this table - [Page 30145 "Shpfy Refund"](../page/30145.md) (source table) - [Page 30147 "Shpfy Refunds"](../page/30147.md) (source table) ## Recent changes - 2026-10-01 [#11854 [Shopify] Make refund currency codes read-only](../../changes/bcapps/11854.md) (main, BC30, fix) - 2026-08-20 [#10407 Shopify connector: persist order Tax Area Code, Tax Liable, and Tax Exempt (stack 1/3)](../../changes/bcapps/10407.md) (main, BC30, feature) - 2026-07-09 [#9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips](../../changes/bcapps/9253.md) (main, BC30, fix) ## Across versions - Present in: BC29-30 - Changed (declaration) in: BC30 Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10). ## 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.