Table 30141 "Shpfy Return Line"

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

Properties

Property	Value
Caption	Return 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	Return Line Id	BigInteger	—	not editable
2	Return Id	BigInteger	—	TableRelation Table 30147 “Shpfy Return Header” (“Shpfy Return Header”.“Return Id”); not editable
3	Fulfillment Line Id	BigInteger	—	TableRelation Table 30139 “Shpfy Fulfillment Line” (“Shpfy Fulfillment Line”.“Fulfillment Line Id”); not editable
4	Order Line Id	BigInteger	—	TableRelation Table 30119 “Shpfy Order Line” (“Shpfy Order Line”.“Line Id”); not editable
5	Quantity	Integer	Specifies the quantity being returned. via Page 30149 “Shpfy Return Lines”	not editable
6	Return Reason	Enum “Shpfy Return Reason”	Specifies the reason for returning the item. via Page 30149 “Shpfy Return Lines”	enum Enum 30138 “Shpfy Return Reason”; not editable
7	Return Reason Note	Blob	—
8	Refundable Quantity	Integer	Specifies the quantity that can be refunded. via Page 30149 “Shpfy Return Lines”	not editable
9	Refunded Quantity	Integer	Specifies the quantity that was refunded. via Page 30149 “Shpfy Return Lines”	not editable
10	Weight Unit	Code[20]	Specifies the unit of measurement. via Page 30149 “Shpfy Return Lines”	not editable
11	Weight	Decimal	Specifies the weight value using the unit. via Page 30149 “Shpfy Return Lines”	not editable
12	Discounted Total Amount	Decimal	Specifies the total line price after all discounts on the line item, including both line item level discounts and code-based line item discounts, are applied. via Page 30149 “Shpfy Return Lines”	not editable
13	Presentment Disc. Total Amt.	Decimal	Specifies the total line price in the presentment currency after all discounts on the line item, including both line item level discounts and code-based line item discounts, are applied.	not editable
14	Customer Note	Blob	—
15	Type	Enum “Shpfy Return Line Type”	Specifies the type of return line. via Page 30149 “Shpfy Return Lines”	enum Enum 30170 “Shpfy Return Line Type”; not editable
16	Unit Price	Decimal	Specifies the price of a single unit of the item. via Page 30149 “Shpfy Return Lines”	not editable
17	Unit Price Currency	Code[10]	—	not editable
18	Return Reason Name	Text[100]	Specifies the reason for returning the item. via Page 30149 “Shpfy Return Lines”	not editable
19	Return Reason Handle	Text[100]	—	not editable
101	Item No.	Code[20]	Specifies the value of the Item No. field. via Page 30149 “Shpfy Return Lines”	FlowField: lookup(“Shpfy Order Line”.“Item No.” where(“Line Id” = field(“Order Line Id”)))
102	Description	Text[100]	Specifies the value of the Description field. via Page 30149 “Shpfy Return Lines”	FlowField: lookup(“Shpfy Order Line”.Description where(“Line Id” = field(“Order Line Id”)))
103	Variant Code	Code[10]	Specifies the value of the Variant Code field. via Page 30149 “Shpfy Return Lines”	FlowField: lookup(“Shpfy Order Line”.“Variant Code” where(“Line Id” = field(“Order Line Id”)))
104	Location Id	BigInteger	—	not editable
105	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: Return Line Id (clustered)
Idx01: Return Id, Discounted Total Amount, Presentment Disc. Total Amt.

Procedures

GetReturnReasonNote(): Text (internal)
SetReturnReasonNote(NewReturnReasonNote: Text) (internal)
GetCustomerNote(): Text (internal)
SetCustomerNote(NewCustomerNote: Text) (internal)

Plus 2 local procedures.

Triggers

OnDelete

Relations

Description: 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”
Fulfillment Line Id: TableRelation Table 30139 “Shpfy Fulfillment Line”
Return Id: TableRelation Table 30147 “Shpfy Return Header”

Referenced by

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

Table 30147 “Shpfy Return Header”: Discounted Total Amount, Presentment Disc. Total Amt.

Pages and codeunits on this table

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