Page tree
Skip to end of metadata
Go to start of metadata
Overview

The TransactDetail table contains additional metadata related to a specific record in the Transact table. 

On this Page

TransactDetail Table Exported Data


TransactDetail.csv Column Descriptions

ColumnDescription
RecIDA unique identifier for the record in the TransactDetail table.
TransactIDSpecifies the RecID of the associated record in the Transact table.

OptionType

Defines the type of metadata associated with the transaction

OptionNoVaries depending on OptionType; see below.
ValueVaries depending on OptionType; see below.
TextAdditional text description associated with the metadata.


The meaning of the OptionNo and Value columns depend on the OptionType in the record.

OptionTypeOptionNoValue

0 = A base option (e.g. hot, warm, cold) was purchased


The index of the option that was purchased (0-16).

The count of option #{OptionNo} that was purchased in this transaction.

1 = An adder option (e.g. extra rinse, extra spin) was purchased The index of the option that was purchased (0-16).Same as above.
2 = A loyalty feature was associated with this purchase1 = Discount was applied to this purchasePercentage of discount applied to the transaction.
10 = Collection metadataThe denomination of a bill or coin in the collection, e.g.
  • 25 = $0.25 quarter
  • 100 = $1 bill
  • 2000 = $20 bill
The count of the items of the specified denomination included in the collection.
20 = Credit card metadata 0 = Credit card entry method

0 = Undefined
1 = Mag stripe
3 = Manually entered
4 = In-app Apple Pay
5 = In-app Google Pay
6 = NFC mag stripe
7 = NFC EMV
8 = Chip EMV


Examples

Following are several examples of different types of transactions and the multiple TransactDetail records that would be associated with each.


Transaction #100: User starts machine by selecting "Cold + Extra Rinse"
TransactIDOptionTypeOptionNoValue
100

0 = Base option

1 = "Cold"

+1 = "Cold" purchased

1001 = Adder option3 = "Extra rinse"

+1 = "Extra rinse" purchased


Transaction #101: User decides to upgrade "Cold" to "Warm"
TransactIDOptionTypeOptionNoValue
101

0 = Base option

1 = "Cold"-1 = "Cold" returned
1010 = Base option2 = "Warm"+1 = "Warm" purchased


Transaction #102: User purchases "Cold" w/ 15% discount
TransactIDOptionTypeOptionNoValue
102

0 = Base option

1 = "Cold"

+1 = "Cold" purchased

1022 = Feature1 = Discount

15 = 15% discount applied


Transaction #103: Employee collects $75 cash from touch kiosk
TransactIDOptionTypeOptionNoValue
103

10 = Collection

2000 = $20 bills

2 = 2x $20 bills collected

10310 = Collection1000 = $10 bills

1 = 1x $10 bills collected

10310 = Collection500 = $5 bills1 = 5x $5 bills collected


Transaction #104: Credit card capture
TransactIDOptionTypeOptionNoValue
104

20 = Credit card

0 = Entry method

1 = Mag stripe