Point transaction - export fields
pointTransaction
Field | Description | Data type | Example value |
pointTransactionId | The transaction's ID | Integer | 120912726 |
pointAccountId | ID of the point account | Integer | 1 |
transactionType | What kind of transaction this is | String | Addition, Deduction, Expiry, Cancellation |
source | Where the transaction was created | String | Automation, Purchase, Manual, Return, ReceiptAdjustment, BonusPromotion, BonusPromotionReturn, RewardVoucher, Adjustment, BonusBalanceAdjustment, UpdateBalance, PointTransactionCancellation |
amount | The transaction amount | Decimal | 150 |
description | A description of the transaction | String | Chainmail bought |
ValidFromUTC | The date from which the transaction is valid | DateTime | 2020-06-28T21:59:59Z |
ValidToUTC | The last date the transaction is valid on | DateTime | 2020-06-28T21:59:59Z |
transactionDate | When the transaction was registered | DateTime | 2020-06-28T21:59:59Z |
changeType | Not applicable. | String | CREATE/UPDATE/DELETE |
ContactID | Unique ID for the contact | GUID | DFD03C68-592C-463F-A46D-A86400011A28 |