Shpfy Order Transaction #30133

Other table in Microsoft Dynamics 365 Business Central. 36 fields, 0 records in Cronus demo.

36
Fields
0
Records
1
Primary key
6
FlowFields
3
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Shopify Transaction Id.

All fields (36)

Shpfy Order Transaction — FIELDS
NO.FIELDTYPECLASSRELATION
1 Shopify Transaction Id PK BigInteger Normal
2 Shopify Order Id BigInteger Normal
3 Amount Decimal Normal
4 Type Option Normal
5 Gateway Text Normal
6 Status Option Normal
7 Message Text Normal
8 Created At DateTime Normal
9 Test Boolean Normal
10 Authorization Code Normal
11 Currency Code Normal
14 Gift Card Id BigInteger Normal
15 Source Name Code Normal
16 Credit Card Bin Code Normal
17 AVS Result Code Code Normal
18 CVV Result Code Code Normal
19 Credit Card Number Text Normal
20 Credit Card company Text Normal
21 Parent Id BigInteger Normal → Shpfy Order Transaction #30133
22 Error Code Text Normal
23 Payment Id Text Normal
24 Rounding Amount Decimal Normal
25 Rounding Currency Code Normal
26 Refund Id BigInteger Normal
101 Sales Document No. ⚡ FLOW Code FlowField
102 Posted Invoice No. ⚡ FLOW Code FlowField
103 Shop Code ⚡ FLOW Code FlowField
104 Payment Method ⚡ FLOW Code FlowField
105 Payment Priority ⚡ FLOW Integer FlowField
106 Used ⚡ FLOW Boolean FlowField
107 Manual Payment Gateway Boolean Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (2)

Tables referenced by fields on the Shpfy Order Transaction table through TableRelation properties.

Shpfy Order Transaction
#30133 · Other · via Parent Id