--- id: object/table/30133 type: object title: Table 30133 "Shpfy Order Transaction" summary: Table 30133 "Shpfy Order Transaction" in Shopify (Microsoft.Integration.Shopify). 37 fields. 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: cc21c46c1a20b359fa1ee09c0e62fa6b7dd3c07bc5d86d3fc4ff4a4d2e12da3d evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Transactions/Tables/ShpfyOrderTransaction.Table.al title: src/Apps/W1/Shopify/app/src/Transactions/Tables/ShpfyOrderTransaction.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 - https://learn.microsoft.com/dynamics365/business-central/shopify/transactions-and-payouts objects: [] features: [] topics: - topic/business-central/business-functionality/online-store-with-shopify localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/9525 - change/bcapps/9253 - change/bcapps/9112 object_type: table object_id: 30133 name: Shpfy Order Transaction caption: Shopify Order Transaction 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: 37 procedures: 0 events: 0 subscribers: 0 relations: out: 10 referenced_by: 3 pages: 3 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 30133 "Shpfy Order Transaction" > Table 30133 "Shpfy Order Transaction" in Shopify (Microsoft.Integration.Shopify). 37 fields. Introduced in BC29, still in BC30, changed in BC30. Shopify · Microsoft.Integration.Shopify · captioned "Shopify Order Transaction" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Transactions/Tables/ShpfyOrderTransaction.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 30111 "Shpfy Gift Card Transactions"](../page/30111.md) (1 Learn page), [Page 30131 "Shpfy Order Transactions"](../page/30131.md) (1), [Page 30134 "Shpfy Transactions"](../page/30134.md) (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"](../page/30131.md) | not editable | | 2 | Shopify Order Id | BigInteger | Specifies a unique identifier for the order. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | not editable | | 3 | Amount | Decimal | Specifies the amount of money included in the transaction. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | 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"](../page/30131.md) | enum [Enum 30134 "Shpfy Transaction Type"](../enum/30134.md); not editable | | 5 | Gateway | Text[30] | Specifies the name of the gateway the transaction was issued through. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | 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"](../page/30131.md) | enum [Enum 30133 "Shpfy Transaction Status"](../enum/30133.md); 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"](../page/30131.md) | not editable | | 8 | Created At | DateTime | Specifies the date and time when the transaction was created in Shopify. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | not editable | | 9 | Test | Boolean | Specifies if the transaction was created for a test mode Order or payment. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | not editable | | 10 | Authorization | Code[50] | Specifies the authorization of the transaction. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | not editable | | 11 | Currency | Code[20] | Specifies the currency of the transaction. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | 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"](../page/30134.md) | 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"](../page/30134.md) | not editable | | 17 | AVS Result Code | Code[1] | Specifies the response code from the address verification system. via [Page 30134 "Shpfy Transactions"](../page/30134.md) | 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"](../page/30134.md) | 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"](../page/30134.md) | 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"](../page/30134.md) | not editable | | 21 | Parent Id | BigInteger | — | TableRelation [Table 30133 "Shpfy Order Transaction"](../table/30133.md) (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"](../page/30134.md) | 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"](../page/30134.md) | 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"](../page/30134.md) | 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"](../table/30102.md) (Shpfy Shop) | | 109 | Shpfy Order No. | Text[50] | Specifies the order number from Shopify. via [Page 30131 "Shpfy Order Transactions"](../page/30131.md) | 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"](../page/30131.md) - Posted Invoice No.: CalcFormula [Table 112 "Sales Invoice Header"](../table/112.md) - Used: CalcFormula [Table 21 "Cust. Ledger Entry"](../table/21.md) - Shop: TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md) - Shop Code: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Shpfy Order No.: CalcFormula [Table 30118 "Shpfy Order Header"](../table/30118.md) - Parent Id: TableRelation [Table 30133 "Shpfy Order Transaction"](../table/30133.md) - Payment Method: CalcFormula [Table 30134 "Shpfy Payment Method Mapping"](../table/30134.md) - Payment Priority: CalcFormula [Table 30134 "Shpfy Payment Method Mapping"](../table/30134.md) - Sales Document No.: CalcFormula [Table 36 "Sales Header"](../table/36.md) ## Referenced by 3 fields in 3 objects relate to this table (TableRelation or CalcFormula). - [Table 30110 "Shpfy Gift Card"](../table/30110.md): Known Used Amount - [Table 30133 "Shpfy Order Transaction"](../table/30133.md): Parent Id - [Table 30154 "Shpfy Suggest Payment"](../table/30154.md): Shpfy Transaction Id ## Pages and codeunits on this table - [Page 30111 "Shpfy Gift Card Transactions"](../page/30111.md) (source table) - [Page 30131 "Shpfy Order Transactions"](../page/30131.md) (source table) - [Page 30134 "Shpfy Transactions"](../page/30134.md) (source table) ## Recent changes - 2026-09-18 [#9525 [Shopify] Automatic Transaction Posting](../../changes/bcapps/9525.md) (main, BC30, feature) - 2026-07-09 [#9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips](../../changes/bcapps/9253.md) (main, BC30, fix) - 2026-07-09 [#9112 [Shopify] Skip refund credit memo while transaction is pending](../../changes/bcapps/9112.md) (main, BC30, fix) ## Across versions - Present in: BC29-30 - Changed (declaration) in: BC30 ## 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.