| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
The TransactDetail table contains additional metadata related to a specific record in the Transact table. |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
TransactDetail Table Exported Data
TransactDetail.csv Column Descriptions
| Column | Description |
|---|---|
| RecID | A unique identifier for the record in the TransactDetail table. |
| TransactID | Specifies the RecID of the associated record in the Transact table. |
OptionType | Defines the type of metadata associated with the transaction |
| OptionNo | Varies depending on OptionType; see below. |
| Value | Varies depending on OptionType; see below. |
| Text | Additional text description associated with the metadata. |
The meaning of the OptionNo and Value columns depend on the OptionType in the record.
| OptionType | OptionNo | Value |
|---|---|---|
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 purchase | 1 = Discount was applied to this purchase | Percentage of discount applied to the transaction. |
| 10 = Collection metadata | The denomination of a bill or coin in the collection, e.g.
| The count of the items of the specified denomination included in the collection. |
| 20 = Credit card metadata | 0 = Credit card entry method | 0 = Undefined |
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"
| TransactID | OptionType | OptionNo | Value |
|---|---|---|---|
| 100 | 0 = Base option | 1 = "Cold" | +1 = "Cold" purchased |
| 100 | 1 = Adder option | 3 = "Extra rinse" | +1 = "Extra rinse" purchased |
Transaction #101: User decides to upgrade "Cold" to "Warm"
| TransactID | OptionType | OptionNo | Value |
|---|---|---|---|
| 101 | 0 = Base option | 1 = "Cold" | -1 = "Cold" returned |
| 101 | 0 = Base option | 2 = "Warm" | +1 = "Warm" purchased |
Transaction #102: User purchases "Cold" w/ 15% discount
| TransactID | OptionType | OptionNo | Value |
|---|---|---|---|
| 102 | 0 = Base option | 1 = "Cold" | +1 = "Cold" purchased |
| 102 | 2 = Feature | 1 = Discount | 15 = 15% discount applied |
Transaction #103: Employee collects $75 cash from touch kiosk
| TransactID | OptionType | OptionNo | Value |
|---|---|---|---|
| 103 | 10 = Collection | 2000 = $20 bills | 2 = 2x $20 bills collected |
| 103 | 10 = Collection | 1000 = $10 bills | 1 = 1x $10 bills collected |
| 103 | 10 = Collection | 500 = $5 bills | 1 = 5x $5 bills collected |
Transaction #104: Credit card capture
| TransactID | OptionType | OptionNo | Value |
|---|---|---|---|
| 104 | 20 = Credit card | 0 = Entry method | 1 = Mag stripe |