Transaction Data Table

Field Name Description Data Type Size Sample Data Notes
TransactionID* The client’s unique ID of this transaction. String 50 “T101123456” Used to group line items, can be defaulted if no transaction grouping is required. Each Transaction ID must be unique within each file and across all files sent to TIBCO Loyalty LabID must be unique within each file and across all files sent to TIBCO Reward.
RetailStoreID* The client’s ID of the store where the transaction took place. String 50 “S101” Among other purposes, this field is used to qualify store-specific offers. This functionality requires Store file integration.
ReceiptDate Time* The client’s date and time stamp of when the transaction took place, that is, the time on the receipt. DateTime “2012-10-14T 10:00am” By default, this is the transaction date used to establish award eligibility. This is compared with membership start date on the customer (shopper) record. This data can also be used to define the membership start date, if a new customer record is being created during import of this file. The “T” is needed between the date and the time as part of the XML schema xs:dateTime data type syntax.

*Data is required in the file.