userid | string | Unique User ID | 9F8134BC4A372DDEE0A9E41D20FBC061B6084468 |
transactionid | string | Unique Transaction ID | MBOY9BJX55S5EBWPD1QATQ9BJVQKYNHMM7DWE |
authorized_date | date | Date user authorizes purchase | 2022-05-07 |
transaction_date | date | Date bank authorizes purchase; can be several days after authorized date; otherwise known as the posted date | 2022-05-09 |
clean_merchant_name | string | Merchant name field that has been processed for data hygiene | Walmart |
merchant_name | string | Merchant Name | WALMART |
transaction_name | string | Transaction Name | WALMART |
amount | float | Transaction Total Amount | 96.21 |
payment_channel | string | online, in-store, or other | in store |
category_level1 | string | Transaction Category Level 1 | SHOPS |
category_level2 | string | Transaction Category Level 2 | SUPERMARKETS AND GROCERIES |
category_level3 | string | Transaction Category Level 3 | |
num_levels | int | Number of Category Levels (how many categories exist for this transaction) | 2 |
primary_personal_finance_category | string | Primary Transaction Category, will soon replace Transaction Category Level 1 | GENERAL MERCHANDISE |
detailed_personal_finance_category | string | Detailed Transaction Category, will soon replace Transaction Category Level 2 | SUPERSTORES |
merchant_address | string | Merchant Street Address | 5710 MCFARLAND BLVD |
merchant_city | string | Merchant City | NORTHPORT |
merchant_state | string | Merchant State Abbreviation | AL |
merchant_zip | string | Merchant Zip Code | 35476 |