FasCard Admin Site - Export Data TransactDetail.csv Details
- Steve Marcionetti
- AJ Johnson
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 | 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 |