Transactions Brex Mappings

card_id -> cardId
id -> transactionId -- PK, mandatory field, upsert on only this field
amount.amount -> Will be mapped to two fields totalAmountOriginal & lineItems.totalPrice
amount.currency ->  currencyOriginal
description ->  Will be mapped to three fields description/ lineItems.productName/ lineItems.description
merchant.mcc ->  networkCategory
[Generated by MCC Lookup] ->  "platformCategory": "Miscellaneous Auto Dealers ", -> categorySource
initiated_at_date -> initiatedDate
posted_at_date -> transactionDate
merchant.raw_descriptor ->  tenantVendorName
merchant.country -> tenantVendorCountry
Fields from MKB:
  "asatoVendorName": "Amazon" -> resolvedVendor.name
  "asatoVendorId": "33ef815a-49a6-4c75-825f-ac7682f69782", -> resolvedVendor.id

New fields to introduce:
Transaction schema
"id": Generate new UUID
"tenantId": should be present as always (from environment variable)

New mappings from source
type -> transactionType
expense_id -> expenseId