Table 30147 "Shpfy Return Header"

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

Learn documents this table through its pages: Page 30150 “Shpfy Returns” (1 Learn page), Page 30151 “Shpfy Return” (1).

Properties

Property	Value
Caption	Return Header
DataClassification	SystemMetadata
LookupPageId	Shpfy Returns
DrillDownPageId	Shpfy Returns

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	Return Id	BigInteger	Id caption	not editable
2	Order Id	BigInteger	—	TableRelation Table 30118 “Shpfy Order Header” (“Shpfy Order Header”.“Shopify Order Id”); not editable
3	Return No.	Text[30]	Specifies the No. of the return. via Page 30151 “Shpfy Return”	not editable
4	Status	Enum “Shpfy Return Status”	Specifies the status of the return. via Page 30151 “Shpfy Return”	enum Enum 30136 “Shpfy Return Status”; not editable
5	Total Quantity	Integer	Specifies the sum of all line item quantities for the return. via Page 30151 “Shpfy Return”	not editable
6	Decline Reason	Enum “Shpfy Return Decline Reason”	Specifies the reason the customer’s return request was declined. via Page 30151 “Shpfy Return”	enum Enum 30137 “Shpfy Return Decline Reason”; not editable
7	Decline Note	Blob	—
8	Shop Code	code[20]	Shop code caption	not editable
12	Discounted Total Amount	Decimal	—	FlowField: sum(“Shpfy Return Line”.“Discounted Total Amount” where(“Return Id” = field(“Return Id”))); not editable
13	Presentment Disc. Total Amt.	Decimal	Presentment Discounted Total Amount caption	FlowField: sum(“Shpfy Return Line”.“Presentment Disc. Total Amt.” where(“Return Id” = field(“Return Id”))); not editable
101	Sell-to Customer No.	Code[20]	Specifies the value of the Sell-to Customer No. field. via Page 30151 “Shpfy Return”	FlowField: lookup(“Shpfy Order Header”.“Sell-to Customer No.” where(“Shopify Order Id” = field(“Order Id”)))
102	Bill-to Customer No.	Code[20]	Specifies the value of the Bill-to Customer No. field. via Page 30151 “Shpfy Return”	FlowField: lookup(“Shpfy Order Header”.“Bill-to Customer No.” where(“Shopify Order Id” = field(“Order Id”)))
103	Sell-to Customer Name	Text[50]	Specifies the value of the Sell-to Customer Name field. via Page 30151 “Shpfy Return”	FlowField: lookup(“Shpfy Order Header”.“Sell-to Customer Name” where(“Shopify Order Id” = field(“Order Id”)))
104	Bill-to Customer Name	Text[50]	Specifies the value of the Bill-to Customer Name field. via Page 30151 “Shpfy Return”	FlowField: lookup(“Shpfy Order Header”.“Bill-to Name” where(“Shopify Order Id” = field(“Order Id”)))
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 30151 “Shpfy Return”	FlowField: lookup(“Shpfy Order Header”.“Shopify Order No.” where(“Shopify Order Id” = field(“Order Id”)))

Keys

PK: Return Id (clustered)
Idx01: Order Id
Idx02: Return No.

Procedures

GetDeclineNote(): Text (internal)
SetDeclineNote(NewDeclineNote: Text) (internal)

Plus 2 local procedures.

Triggers

OnDelete

Relations

drill-down page Page 30150 “Shpfy Returns”
lookup page Page 30150 “Shpfy Returns”
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”
Order Id: TableRelation Table 30118 “Shpfy Order Header”
Discounted Total Amount: CalcFormula Table 30141 “Shpfy Return Line”
Presentment Disc. Total Amt.: CalcFormula Table 30141 “Shpfy Return Line”

Referenced by

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

Table 30141 “Shpfy Return Line”: Return Id
Table 30142 “Shpfy Refund Header”: Return No.

Pages and codeunits on this table

Page 30150 “Shpfy Returns” (source table)
Page 30151 “Shpfy Return” (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 Return Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.