Table 30133 "Shpfy Order Transaction"

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

Learn documents this table through its pages: Page 30111 “Shpfy Gift Card Transactions” (1 Learn page), Page 30131 “Shpfy Order Transactions” (1), Page 30134 “Shpfy Transactions” (1).

Properties

Property	Value
Caption	Shopify Order Transaction
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	Shopify Transaction Id	BigInteger	Specifies a unique identifier for the transaction. via Page 30131 “Shpfy Order Transactions”	not editable
2	Shopify Order Id	BigInteger	Specifies a unique identifier for the order. via Page 30131 “Shpfy Order Transactions”	not editable
3	Amount	Decimal	Specifies the amount of money included in the transaction. via Page 30131 “Shpfy Order Transactions”	not editable
4	Type	Enum “Shpfy Transaction Type”	Specifies the transaction type. Valid values are: authorization, capture, sale, void and refund. via Page 30131 “Shpfy Order Transactions”	enum Enum 30134 “Shpfy Transaction Type”; not editable
5	Gateway	Text[30]	Specifies the name of the gateway the transaction was issued through. via Page 30131 “Shpfy Order Transactions”	not editable
6	Status	Enum “Shpfy Transaction Status”	Specifies the status of the transaction. Valid values are: pending, failure, success and error. via Page 30131 “Shpfy Order Transactions”	enum Enum 30133 “Shpfy Transaction Status”; not editable
7	Message	Text[250]	Specifies a string generated by the payment provider with additional information about why the transaction succeeded or failed. via Page 30131 “Shpfy Order Transactions”	not editable
8	Created At	DateTime	Specifies the date and time when the transaction was created in Shopify. via Page 30131 “Shpfy Order Transactions”	not editable
9	Test	Boolean	Specifies if the transaction was created for a test mode Order or payment. via Page 30131 “Shpfy Order Transactions”	not editable
10	Authorization	Code[50]	Specifies the authorization of the transaction. via Page 30131 “Shpfy Order Transactions”	not editable
11	Currency	Code[20]	Specifies the currency of the transaction. via Page 30131 “Shpfy Order Transactions”	not editable
12	Presentment Currency	Code[20]	Specifies the currency of the transaction in the presentment currency.	not editable
13	Presentment Amount	Decimal	Specifies the amount of money included in the transaction in the presentment currency.	not editable
14	Gift Card Id	BigInteger	Specifies the id of the gift card used for a transaction. via Page 30134 “Shpfy Transactions”	not editable
15	Source Name	Code[20]	—	obsolete Removed 28.0; #if not CLEANSCHEMA28; not editable
16	Credit Card Bin	Code[10]	Specifies the issuer identification number. via Page 30134 “Shpfy Transactions”	not editable
17	AVS Result Code	Code[1]	Specifies the response code from the address verification system. via Page 30134 “Shpfy Transactions”	not editable
18	CVV Result Code	Code[1]	Specifies the response code from the credit card company indicating whether the customer entered the card security code, or card verificaion value, correctly. via Page 30134 “Shpfy Transactions”	not editable
19	Credit Card Number	Text[30]	Specifies the customer’s credit card number, with most of the leading digits redacted. via Page 30134 “Shpfy Transactions”	not editable
20	Credit Card Company	Text[50]	Specifies the name of the company that issued the customer’s credit card. via Page 30134 “Shpfy Transactions”	not editable
21	Parent Id	BigInteger	—	TableRelation Table 30133 “Shpfy Order Transaction” (Shpfy Order Transaction); not editable
22	Error Code	Text[30]	Specifies the standardized error code, independent of the payment provider. Valid values are: incorrect_number, invalid_number, invalid_expiry_date, invalid_cvc, expired_card, incorrect_cvc, incorrect_zip, incorrect_address, card_declined, processing_error, call_issuer, pick_up_card. via Page 30134 “Shpfy Transactions”	not editable
23	Payment Id	Text[250]	—	not editable; DataClassification CustomerContent
24	Rounding Amount	Decimal	—	not editable
25	Rounding Currency	Code[20]	—	not editable
26	Refund Id	BigInteger	—	not editable
27	Presentment Rounding Amount	Decimal	—	not editable
28	Presentment Rounding Currency	Code[20]	—	not editable
101	Sales Document No.	code[20]	Specifies the sales document number to which the transaction relates. via Page 30134 “Shpfy Transactions”	FlowField: lookup(“Sales Header”.“No.” where(“Shpfy Order Id” = field(“Shopify Order Id”)))
102	Posted Invoice No.	Code[20]	Specifies the Posted Invoice number to which the transaction relates. via Page 30134 “Shpfy Transactions”	FlowField: lookup(“Sales Invoice Header”.“No.” where(“Shpfy Order Id” = field(“Shopify Order Id”)))
103	Shop Code	Code[20]	—	obsolete Pending 28.0; #if not CLEANSCHEMA31; FlowField: lookup(“Shpfy Order Header”.“Shop Code” where(“Shopify Order Id” = field(“Shopify Order Id”)))
104	Payment Method	Code[10]	—	FlowField: lookup(“Shpfy Payment Method Mapping”.“Payment Method Code” where(“Shop Code” = field(“Shop”), Gateway = field(Gateway), “Credit Card Company” = field(“Credit Card Company”)))
105	Payment Priority	Integer	—	obsolete Removed 28.0; #if not CLEANSCHEMA28; FlowField: lookup(“Shpfy Payment Method Mapping”.Priority where(“Shop Code” = field(“Shop”), Gateway = field(Gateway), “Credit Card Company” = field(“Credit Card Company”)))
106	Used	Boolean	—	FlowField: exist(“Cust. Ledger Entry” where(“Shpfy Transaction Id” = field(“Shopify Transaction Id”)))
107	Manual Payment Gateway	Boolean	—	not editable
108	Shop	Code[20]	Shop Code caption	TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop)
109	Shpfy Order No.	Text[50]	Specifies the order number from Shopify. via Page 30131 “Shpfy Order Transactions”	FlowField: lookup(“Shpfy Order Header”.“Shopify Order No.” where(“Shopify Order Id” = field(“Shopify Order Id”)))

Keys

Key1: Shopify Transaction Id (clustered)
Idx001: Gift Card Id
Idx002: Created At
Idx003: Type
Key5: Shopify Order Id, Status
Key6: Refund Id, Type, Status

Triggers

OnDelete

Relations

lookup page Page 30131 “Shpfy Order Transactions”
Posted Invoice No.: CalcFormula Table 112 “Sales Invoice Header”
Used: CalcFormula Table 21 “Cust. Ledger Entry”
Shop: TableRelation Table 30102 “Shpfy Shop”
Shop Code: CalcFormula Table 30118 “Shpfy Order Header”
Shpfy Order No.: CalcFormula Table 30118 “Shpfy Order Header”
Parent Id: TableRelation Table 30133 “Shpfy Order Transaction”
Payment Method: CalcFormula Table 30134 “Shpfy Payment Method Mapping”
Payment Priority: CalcFormula Table 30134 “Shpfy Payment Method Mapping”
Sales Document No.: CalcFormula Table 36 “Sales Header”

Referenced by

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

Table 30110 “Shpfy Gift Card”: Known Used Amount
Table 30133 “Shpfy Order Transaction”: Parent Id
Table 30154 “Shpfy Suggest Payment”: Shpfy Transaction Id

Pages and codeunits on this table

Page 30111 “Shpfy Gift Card Transactions” (source table)
Page 30131 “Shpfy Order Transactions” (source table)
Page 30134 “Shpfy Transactions” (source table)

Recent changes

2026-09-18 #9525 [Shopify] Automatic Transaction Posting (main, BC30, feature)
2026-07-09 #9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips (main, BC30, fix)
2026-07-09 #9112 [Shopify] Skip refund credit memo while transaction is pending (main, BC30, fix)

Deprecations

field Payment Priority: Removed 28.0 (#if not CLEANSCHEMA28), “Priority is no longer used.”
field Shop Code: Pending 28.0 (#if not CLEANSCHEMA31), “Use field Shop instead.”
field Source Name: Removed 28.0 (#if not CLEANSCHEMA28), “Source name is no longer used.”

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