Expenses

General expense records from Brex API

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique expense identifier
BudgetId	String	True	Budgets.BudgetId	Associated budget identifier
DepartmentId	String	True	Departments.Id	Associated department identifier
LocationId	String	True	Locations.Id	Associated location identifier
UserId	String	True	Users.Id	Associated user identifier
CardProgramId	String	True		Associated card program identifier
ExpenseReportId	String	True		Associated expense report identifier
ReimbursementId	String	True		Associated reimbursement identifier
MerchantId	String	True		Associated merchant identifier
Memo	String	False		Expense memo or description
ExpenseType	String	True		Type of expense
PaymentStatus	String	True		Payment processing status
Status	String	True		Expense approval status
CreatedAt	Datetime	True		Date and time expense was created
ProcessedAt	Datetime	True		Date and time expense was processed
PurchasedAt	Datetime	True		Date and time expense was purchased
UpdatedAt	Datetime	True		Date and time expense was last updated
BillingAmountCurrency	String	True		Billing amount currency code
BillingAmountValue	Decimal	True		Billing amount in smallest currency unit
BudgetAmountCurrency	String	True		Budget amount currency code
BudgetAmountValue	Decimal	True		Budget amount in smallest currency unit
ExchangeRate	Double	True		Exchange rate applied to the expense
IsEmployeeReimbursable	Boolean	True		Whether expense is employee reimbursable
MccCode	String	True		Merchant Category Code
MccDescription	String	True		Merchant Category Code description
OriginalAmountCurrency	String	True		Original expense currency code
OriginalAmountValue	Decimal	True		Original expense amount in smallest currency unit
PurchasedAmountCurrency	String	True		Purchased amount currency code
PurchasedAmountValue	Decimal	True		Purchased amount in smallest currency unit
ReimbursementStatus	String	True		Reimbursement status
UsdEquivalentAmountCurrency	String	True		USD equivalent amount currency code
UsdEquivalentAmountValue	Decimal	True		USD equivalent amount in smallest currency unit
Address	String	True		Address information object
CustomFields	String	True		Custom field data array
Department	String	True		Department information object
ExpenseItemizations	String	True		Expense itemization details array
Location	String	True		Location information object
Merchant	String	True		Merchant information object
PaymentMethod	String	True		Payment method information object
PersonalExpensePolicy	String	True		Personal expense policy configuration
Receipts	String	True		Receipt information array
Tags	String	True		Expense tags array
User	String	True		User information object

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Expand	String	Get additional details for the expense, e.g. merchant mcc code, by passing in expand[]=merchant
ShouldLoadCustomFields	Boolean	Load custom fields for the expense.
ParentExpenseId	String	Get itemized expenses belonging to the provided parent expense ID(s).
PaymentPostedAt	Datetime	Date and time expense was purchased
SpendingEntityId	String	Filter by specific spending entity identifiers