| transaction_id | bigint | Unique surrogate primary key for the transaction record |
| transaction_hash | string | Cryptographic hash uniquely identifying the transaction on the XRP Ledger; used for cross-referencing with on-chain data |
| transaction_type | string | Transaction category (e.g., Payment, OfferCreate, TrustSet, NFTokenMint); determines applicable fields and behavior |
| transaction_result | string | Final outcome code (e.g., tesSUCCESS, tecNO_DST), indicating whether the transaction succeeded or the reason for failure |
| ledger_close_date | date | Calendar date the ledger containing this transaction was closed |
| ledger_close_time | timestamp | Precise timestamp the ledger was closed and the transaction was confirmed |
| ledger_index | bigint | Sequence number of the ledger in which this transaction was included |
| transaction_index | bigint | Position of this transaction within its ledger, reflecting execution order |
| transaction_fee | decimal(38,6) | XRP fee consumed by this transaction, expressed in XRP |
| account_id | bigint | Surrogate key for the sending account (→ accounts) |
| account_address | string | XRPL address of the transaction sender |
| destination_id | bigint | Surrogate key for the receiving account (→ accounts) |
| destination_address | string | XRPL address of the transaction recipient |
| destination_tag | bigint | Off-ledger routing tag identifying the intended beneficiary at the destination address (e.g., a customer account at an exchange) |
| account_transaction_id | string | Chained hash linking to the sender’s previous transaction, used to enforce transaction ordering |
| delivered_amount | struct(currency: string, issuer: string, value: string, mpt_issuance_id: string) | Actual amount delivered to the destination, structured with currency, issuer, value, and MPT issuance ID |
| flags | bigint | Bitwise integer encoding transaction-specific behavior modifiers |
| last_ledger_sequence | bigint | Maximum ledger index at which the transaction remains valid; used to bound transaction expiry |
| memos | array(json) | Array of arbitrary key-value memo objects attached to the transaction for off-ledger annotation or metadata |
| signers | array(json) | Array of signers for multi-signature transactions, each containing account, public key, and signature |
| signing_pub_key | string | Hex-encoded public key used to authorize a single-signed transaction |
| source_tag | bigint | Off-ledger routing tag identifying the originating customer or purpose at the sending address |
| ticket_sequence | bigint | Sequence number of the ticket used in place of a standard account sequence, enabling out-of-order transaction submission |
| transaction_sequence | bigint | Account sequence number ensuring replay protection and ordering for transactions from the same sender |
| transaction_signature | string | Cryptographic signature proving the transaction was authorized by the account’s private key |
| uri | string | URI associated with the transaction, typically used in NFT-related transactions to reference off-chain metadata |
