Skip to main content

Table Description

Contains all transaction data from the XRP Ledger including payment types, account changes, and transaction metadata.

Column Descriptions

ColumntypeDescription
accountstringThe account that initiated the transaction
account_txn_idstringUnique identifier for the transaction from the account’s perspective
amountstruct(currency: string, issuer: string, value: string)The amount being transferred (for payment transactions)
amount2struct(currency: string, issuer: string, value: string)Secondary amount field for complex transactions
assetstruct(currency: string, issuer: string)Asset information for token-related transactions
asset2struct(currency: string, issuer: string)Secondary asset information
asset_classstringClassification of the asset being traded
auth_accountsarray(struct(authaccount: struct(account: string)))Accounts authorized for this transaction
authorizestringAccount to be authorized
balancestruct(currency: string, value: string)Balance information
bid_maxstruct(currency: string, issuer: string, value: string)Maximum bid amount for auction transactions
bid_minstruct(currency: string, issuer: string, value: string)Minimum bid amount for auction transactions
cancel_afterlongTimestamp after which the transaction should be cancelled
channelstringPayment channel identifier
check_idstringUnique identifier for a check
clear_flaglongFlag to be cleared from the account
conditionstringCondition for conditional transactions
deliver_maxstruct(currency: string, issuer: string, value: string)Maximum amount to deliver in a payment
deliver_minstruct(currency: string, issuer: string, value: string)Minimum amount to deliver in a payment
destinationstringDestination account for the transaction
destination_taglongTag for the destination account
domainstringDomain associated with the account
email_hashstringHash of the email address
expirationlongExpiration timestamp for the transaction
feestringTransaction fee in drops
finish_afterlongTimestamp after which the transaction should be finished
flagslongTransaction flags
fulfillmentstringFulfillment condition for conditional transactions
invoice_idstringInvoice identifier
issuerstringIssuer of the token
lp_token_instruct(currency: string, issuer: string, value: string)Liquidity pool token input amount
lp_token_outstruct(currency: string, value: string)Liquidity pool token output amount
last_ledger_sequencelongLast ledger sequence number
last_update_timelongLast update timestamp
ledger_sequencelongLedger sequence number
limit_amountstruct(currency: string, issuer: string, value: string)Limit amount for trust lines
memosarray(struct(Memo: struct(MemoData: string, MemoFormat: string, MemoType: string)))Transaction memos
metadatastringTransaction metadata in JSON format
nf_token_broker_feestruct(currency: string, issuer: string, value: string)NFT broker fee
nf_token_buy_offerstringNFT buy offer identifier
nf_token_idstringNFT token identifier
nf_token_minterstringNFT token minter
nf_token_offersarray(string)NFT token offers
nf_token_sell_offerstringNFT sell offer identifier
nf_token_taxonlongNFT token taxon
offer_sequencelongOffer sequence number
operation_limitlongOperation limit
oracle_document_idlongOracle document identifier
ownerstringOwner of the account or asset
pathsstringPayment paths for cross-currency payments
previous_txn_idstringPrevious transaction identifier
price_data_seriesarray(struct(PriceData: struct(AssetPrice: string, BaseAsset: String, QuoteAsset: string, Scale: long)))Price data series
providerstringProvider information
public_keystringPublic key of the account
quality_inlongQuality in for exchange transactions
quality_outlongQuality out for exchange transactions
regular_keystringRegular key for the account
send_maxstruct(currency: string, issuer: string, value: string)Maximum amount to send
sequencelongAccount sequence number
set_flaglongFlag to be set on the account
settle_delaylongSettlement delay
signaturestringTransaction signature
signer_entriesarray(struct(SignerEntry: struct(Account: String, SignerWeight: long)))Signer entries for multi-signing
signer_quorumlongSigner quorum
signersarray(struct(Signer: struct(Account: string, SigningPubKey: string, TxnSignature: string)))Transaction signers
signing_pub_keystringSigning public key
source_taglongSource tag
taker_getsstruct(currency: string, issuer: string, value: string)Amount the taker gets in an offer
taker_paysstruct(currency: string, issuer: string, value: string)Amount the taker pays in an offer
tick_sizelongTick size for trading
ticket_countlongNumber of tickets
ticket_sequencelongTicket sequence number
trading_feelongTrading fee
transaction_typestringType of transaction
transfer_feelongTransfer fee
transfer_ratelongTransfer rate
txn_signaturestringTransaction signature
unl_modify_disablinglongUNL modify disabling flag
unl_modify_validatorstringUNL modify validator
uristringURI associated with the account
hashstringTransaction hash
ledger_indexlongLedger index
_event_created_attimestampEvent creation timestamp
_ledger_close_time_humanstringHuman-readable ledger close time
ledger_close_datedateDate when the ledger closed
_inserted_attimestampRecord insertion timestamp
message_keystringMessage key
e_pricestruct(currency: string, value: string)Exchange price
unauthorizestringAccount to be unauthorized
amendmentstringAmendment identifier
_ingested_attimestampData ingestion timestamp

Table Sample

I