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 Loyalty 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 > 0 if free start was earned
  • <0 < 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)

...

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)converted to bonus

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

...

Column

Description

DateTime

UTC date/time of transaction

LocationID

RecID of location where transaction took place, or 0 if via website

MachNo

Machine number where transaction took place, or 0 if via website

TransID

Transaction ID generated by reader, if reader-based transaction; else 0

TransType

2 = Add value (TransType.AddValue)

TransSubType

0 = Credit -> account @ reader (TransSubType.AddValue.CreditCardViaReader)

1 = Credit -> account @ website (TransSubType.AddValue.CreditCardViaWeb)

2 = Cash -> employee (TransSubType.AddValue.CashToEmployee)

3 = Automatic reload (TransSubType.AddValue.AutoReload)

CardType

0 = No card used in transaction (CardType.Undefined)

2 = Credit card (CardType.Credit)

CardNumber

Number of credit card used in transaction, else null

CardName

Name from credit card used, else null

CreditCardAmount

Amount spent from credit card

CashAmount

Amount of cash paid

BalanceAmount

Amount of balance added

BonusAmount

Amount of bonus awarded

FreeStarts

Unused (always 0)

LoyaltyPoints

Unused (always 0)

RootTransactID

Unused (always 0)

AdditionalInfo

Unused (always null)

EmployeeUserID

If TransSubType = CashToEmployee:

  • If website user is a customer user, User.RecID of that user
  • If website user is a CCI user, -MasterLogin.RecID of that user (negative)

    Unused for all other transaction subtypes (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

    ...

    Column

    Description

    DateTime

    UTC date/time of transaction

    LocationID

    Always 0 indicating transaction came from website

    MachNo

    Always 0

    TransID

    Always 0

    TransType

    3 = Adjust value (TransType.AdjustValue)

    TransSubType

    Unused (always 0)

    CardType

    Unused (always 0)

    CardNumber

    Unused (always 0)

    CardName

    Unused (always null)

    CreditCardAmount

    Unused (always 0)

    CashAmount

    Unused (always 0)

    BalanceAmount

    Amount of balance added

    BonusAmount

    Amount of bonus added

    FreeStarts

    Number of free starts added

    LoyaltyPoints

    Number of loyalty points added

    RootTransactID

    Unused (always 0)

    AdditionalInfo

    Unused (always null)

    EmployeeUserID

    User that performed the transaction:

  • If website user is a customer user, User.RecID of that user
  • If website user is a CCI user, -MasterLogin.RecID of that user (negative)

    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