Other table in Microsoft Dynamics 365 Business Central. 36 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Shopify Transaction Id.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Shpfy Order Transaction table through TableRelation properties.