FasCard Admin Site - Export Data TransactDetail.csv Details

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

Column

Description

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

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.

  • 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"

TransactID

OptionType

OptionNo

Value

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

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

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

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

TransactID

OptionType

OptionNo

Value

104

20 = Credit card

0 = Entry method

1 = Mag stripe