SpendLimits

Spend limit management information from Brex API

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique spend limit identifier
AccountId	String	True	CardAccounts.Id	Associated account identifier
DepartmentId	String	False	Departments.Id	Associated department identifier
LegalEntityId	String	False	LegalEntities.Id	Associated legal entity identifier
ParentBudgetId	String	False	Budgets.BudgetId	Parent budget identifier
MemberUserIds	String	False		Member user IDs array
ExpensePolicyId	String	False		Expense policy identifier
OwnerUserIds	String	False		Owner user IDs array
LimitApprovalPolicyId	String	False		Limit approval policy identifier
Name	String	False		Spend limit name
Status	String	False		Spend limit status
EndDate	Date	False		End date of the spend limit
EndTimeUtc	Datetime	True		End time in UTC
StartDate	Date	False		Start date of the spend limit
StartTimeUtc	Datetime	True		Start time in UTC
AuthorizationVisibility	String	False		Authorization visibility setting The allowed values are PUBLIC, PRIVATE.
AutoCreateLimitCardsSetting	String	False		Auto create limit cards setting The allowed values are ALL_MEMBERS, DISABLED.
AutoTransferCardsSetting	String	False		Auto transfer cards setting The allowed values are ENABLED, DISABLED.
Description	String	False		Spend limit description
ExpenseVisibility	String	False		Expense visibility level The allowed values are SHARED, PRIVATE.
LimitIncreaseSetting	String	False		Limit increase setting The allowed values are ENABLED, DISABLED.
LimitIncreaseRequestPolicyId	String	False		Limit increase request policy ID
PeriodRecurrenceType	String	False		Period recurrence type The allowed values are PER_WEEK, PER_MONTH, PER_QUARTER, PER_YEAR, ONE_TIME.
SpendType	String	False		Spend type configuration The allowed values are BUDGET_PROVISIONED_CARDS_ONLY, NON_BUDGET_PROVISIONED_CARDS_ALLOWED.
AuthorizationSettings	String	False		Authorization configuration settings
CurrentPeriodBalance	String	True		Current period balance information
MerchantCategoryControls	String	False		Merchant category control settings
TransactionLimit	String	False		Transaction limit configuration

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
MemberUserId	String	Member user ID