transactions

Pipelined Data Sets > Banno Operation and Transaction > transactions

Column name	Description	Mode	Type
AccountId	Account ID (UUID, 36 chars)	NULLABLE	STRING
DatePosted	Date the transaction was posted	NULLABLE	TIMESTAMP
TransactionId	Transaction ID	NULLABLE	STRING
Sequence	Sequence number	NULLABLE	INTEGER
HBaseKey	HBase key	NULLABLE	STRING
OfxType	OFX type	NULLABLE	STRING
BannoType	Banno type	NULLABLE	STRING
SubType	Subtype	NULLABLE	STRING
PendingStatus	Pending status	NULLABLE	STRING
InstitutionId	Institution ID	NULLABLE	STRING
UserId	User ID	NULLABLE	STRING
AccountType	Account type	NULLABLE	STRING
AccountSubType	Account subtype	NULLABLE	STRING
Amount	Transaction amount	NULLABLE	NUMERIC
Currency	Currency	NULLABLE	STRING
FitId	FIT ID	NULLABLE	STRING
CheckNumber	Check number	NULLABLE	STRING
Memo	Memo	NULLABLE	STRING
PayeeName	Payee name	NULLABLE	STRING
FilteredMemo	Filtered memo	NULLABLE	STRING
MemoMerchantData	Memo merchant data	NULLABLE	JSON
CleanedMemo	Cleaned memo	NULLABLE	STRING
Description	Description	NULLABLE	STRING
BaseMerchant	Base merchant	NULLABLE	JSON
Bill	Bill	NULLABLE	JSON
Active	Active status	NULLABLE	BOOLEAN
LastUpdated	Last updated timestamp	NULLABLE	TIMESTAMP
CheckImageIds	Check image IDs	REPEATED	STRING
RunningBalance	Running balance	NULLABLE	NUMERIC
RunningBalanceCurrency	Running balance currency	NULLABLE	STRING
CleanMemo	Clean memo	NULLABLE	STRING
CustomTag	Custom tag	NULLABLE	STRING
Tag	Tag	NULLABLE	STRING
CreatedAt	Created at timestamp	NULLABLE	TIMESTAMP

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Wed Mar 4 2026