Table 30124 "Shpfy Payment Transaction"

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

Learn documents this table through its pages: Page 30124 “Shpfy Payment Transactions” (1 Learn page).

Properties

Property	Value
Caption	Shopify Payment Transaction
DataClassification	CustomerContent

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	Id	BigInteger	—	DataClassification SystemMetadata
2	Type	Enum “Shpfy Payment Trans. Type”	Specifies the type of the payment transaction. via Page 30124 “Shpfy Payment Transactions”	enum Enum 30127 “Shpfy Payment Trans. Type”
3	Test	Boolean	Specifies if the transaction was created for a test mode Order or payment. via Page 30124 “Shpfy Payment Transactions”
4	Payout Id	BigInteger	—	DataClassification SystemMetadata
5	Currency	Code[10]	Specifies the currency of the transaction. via Page 30124 “Shpfy Payment Transactions”
6	Amount	Decimal	Specifies the gross amount of the transaction. via Page 30124 “Shpfy Payment Transactions”
7	Fee	Decimal	Specifies the total amount of fees deducted from the transaction amount. via Page 30124 “Shpfy Payment Transactions”
8	Net Amount	Decimal	Specifies the net amount of the transaction. via Page 30124 “Shpfy Payment Transactions”
9	Source Id	BigInteger	Specifies the id of the resource leading to the transaction. via Page 30124 “Shpfy Payment Transactions”	DataClassification SystemMetadata
10	Source Type	Enum “Shpfy Payment Trans. Type”	Specifies the type of resource leading to the transaction. The options are Charge, Refund, Dispute, Reserve, Adjustment, Payout. via Page 30124 “Shpfy Payment Transactions”	enum Enum 30127 “Shpfy Payment Trans. Type”
11	Source Order Transaction Id	BigInteger	Specifies the id the order transaction that resulted in this balance transaction. via Page 30124 “Shpfy Payment Transactions”	DataClassification SystemMetadata
12	Source Order Id	BigInteger	Specifies the id the order that resulted in this balance transaction. via Page 30124 “Shpfy Payment Transactions”	DataClassification SystemMetadata
13	Processed At	DateTime	Specifies the date and time when the transaction was processed in Shopify. via Page 30124 “Shpfy Payment Transactions”
101	Shop Code	Code[20]	—	TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop); DataClassification SystemMetadata
102	Invoice No.	Code[20]	Specifies the Invoice number to which the transaction relates. via Page 30124 “Shpfy Payment Transactions”	FlowField: lookup(“Sales Invoice Header”.“No.” where(“Shpfy Order Id” = field(“Source Order Id”), “Shpfy Order Id” = filter(‘<>0’)))

Keys

PK: Id (clustered)
Idx1: Payout Id
Idx2: Shop Code

Relations

Invoice No.: CalcFormula Table 112 “Sales Invoice Header”
Shop Code: TableRelation Table 30102 “Shpfy Shop”

Pages and codeunits on this table

Page 30124 “Shpfy Payment Transactions” (source table)

Recent changes

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 Payment Transaction"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.