Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

  • >0 if free start was earned
  • <0 if free start was spent

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:

  • The new balance total for the user after the transaction

If anonymous credit card transaction:

  • The amount remaining on the authorization after the transaction

All other cases:

  • Unused (always 0)

NewBonus

If transaction is associated with a user:

  • The new bonus total for the user after the transaction

All other cases:

  • Unused (always 0)

NewFreeStarts

If transaction is associated with a user:

  • The new free starts total for the user after the transaction

All other cases:

  • Unused (always 0)

NewLoyaltyPoints

If transaction is associated with a user:

  • The new loyalty points total for the user after the transaction

All other cases:

  • Unused (always 0)

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

...