Explanation of the Gift Card transaction table
Gift Card transactions includes all transactions made for Gift Cards (purchases and redemptions). Users can filter (based on transaction date) and export results.
Updates to filter and exports are in development so are not yet included in this Knowledge Base article.
Table of Contents
View all Gift Card transactions
Gift Card transaction table details
All columns can be sorted in either ascending or descending order.
Number |
Columns (in order) |
Description |
Column logic |
---|---|---|---|
1 |
Type (which is the Card Type) |
Card Type |
P = Physical Cards
E = eGift Cards |
2 |
NBI Transaction ID |
NBI system transaction ID |
|
3 |
Transaction Date |
Date transaction was made - this is not the last modified date |
For redemption |
4 |
Transaction Type |
Type of transaction that was made. |
|
5 |
Transaction Amount |
Amount for the transaction. |
|
6 |
Payment Transaction ID |
Payment gateway transaction ID |
|
7 |
Purchaser/Redeemer |
User who made transaction. |
Purchaser Redeemer |
Notes:
-
NBI Card Number and Physical Card are not included in this view because customers can have multiple cards purchased in 1 transaction.
-
Card Type is included because customers can only purchase 1 card type at a time.
View specific transaction details
Transaction specific table details
Number |
Section |
Field |
Description |
---|
Number |
Section |
Field |
Description |
---|---|---|---|
1 |
Transaction Details |
NBI Transaction ID |
Unique NBI Transaction ID |
2 |
Transaction Details |
Payment Data |
Date payment was made |
3 |
Payment Details |
Payment Type |
How the payment was made |
4 |
Payment Details |
Payment Gateway Transaction ID |
Unique payment gateway (ie Stripe) transaction ID |
5 |
Payment Details |
Total Transaction Amount |
Total amount for the transaction |
6 |
Payment Details |
Processing Fee |
|
7 |
Payment Details |
NBI Fee (Additional charge) |
|
8 |
Payment Details |
Postage Fee |
|
9 |
Payment Details |
Experience Fee |
|
10 |
Payment Details |
Total Discount |
|
11 |
Payment Details |
Cards value |
|
12 |
Gift Cards |
|
List of Gift Cards purchased within the transaction. Can be multiple. |
13 |
Customer Details |
Purchaser First Name |
|
14 |
Customer Details |
Purchaser Surname |
|
15 |
Customer Details |
Purchaser Phone |
|
16 |
Customer Details |
Purchaser Email |
|