Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 4
Next »
The TransactDetail table contains additional metadata related to a specific record in the Transact table.
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 | |
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. |
| 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. |
| The denomination of a bill or coin in the collection, e.g.25 = $0.25 quarter100 = $1 bill2000 = $20 bill
| The count of the items of the specified denomination included in the collection. |
| 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.
TransactID | OptionType | OptionNo | Value |
|---|
100 | 0 = Base option | 1 = "Cold" | +1 = "Cold" purchased |
100 | 1 = Adder option | | |
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 |