...
Column | Description |
---|---|
DateTime | UTC date/time of transaction |
LocationID | RecID of location where transaction took place |
MachNo | Machine number where transaction took place |
TransID | Transaction ID generated by reader |
TransType | 100 = Vend (TransType.Vend) |
TransSubType | 0 = Machine (TransSubType.Vend.Machine) |
CardType | 0 = No card used in transaction (CardType.Undefined) 1 = Loyalty card (CardType.Laundry) 2 = Credit card (CardType.Credit) 3 = User account w/out card (CardType.UserToken) |
CardNumber | Number from card used in transaction |
CardName | Name from credit card used, if appropriate; else null |
CreditCardAmount | Amount spent from credit card |
CashAmount | Amount of cash paid |
UserID | User account paying for vend, or 0 if anonymous transaction |
BalanceAmount | Amount of balance spent |
BonusAmount | Amount of bonus spent |
FreeStarts | Number of free starts earned:
|
LoyaltyPoints | Number of loyalty points awarded as a result of the vend |
RootTransactID | Unused (always 0) |
AdditionalInfo | Unused (always null) |
EmployeeUserID | Unused (always 0) |
NewBalance | If transaction is associated with a user:
If anonymous credit card transaction:
All other cases:
|
NewBonus | If transaction is associated with a user:
All other cases:
|
NewFreeStarts | If transaction is associated with a user:
All other cases:
|
NewLoyaltyPoints | If transaction is associated with a user:
All other cases:
|
Points
...
Converted to Bonus (TransType 5)
Column | Description |
---|---|
DateTime | UTC date/time of transaction |
LocationID | RecID of location where associated vend took place |
MachNo | Machine number where associated vend took place |
TransID | Unused (always 0) |
TransType | 5 = Loyalty points -> bonus (TransType.PointsAward) |
TransSubType | Always 0 |
CardType | Unused (always 0) |
CardNumber | Unused (always 0) |
CreditCardAmount | Unused (always 0) |
CardName | Unused (always null) |
CashAmount | Unused (always 0) |
BalanceAmount | Unused (always 0) |
BonusAmount | Amount of bonus awarded |
FreeStarts | Unused (always 0) |
LoyaltyPoints | Number of points taken away from account LoyaltyPoints (always negative) |
RootTransactID | Transact.RecID of transaction that triggered the award |
AdditionalInfo | Unused (always null) |
EmployeeUserID | Unused (always 0) |
NewBalance | The new balance total for the user after the transaction |
NewBonus | The new bonus total for the user after the transaction |
NewFreeStarts | The new free starts total for the user after the transaction |
NewLoyaltyPoints | The new loyalty points total for the user after the transaction |
...