Transactions Native
Table Columns
Unique Key: hash
hash
Unique identifier of the transaction
signature
Digital signature(s) of the transaction
contract_ret
Contract return status (e.g., SUCCESS)
ret
Return value of the contract execution
raw_data_hex
Raw transaction data in hexadecimal format
type
Type of the transaction (e.g., TransferContract)
type_url
URL of the transaction type definition
owner_address_hex
Hexadecimal representation of the transaction initiator's address
owner_address
Base58 representation of the transaction initiator's address
to_address_hex
Hexadecimal representation of the recipient's address
to_address
Base58 representation of the recipient's address
amount
Amount of TRX or tokens transferred
asset_name_hex
Hexadecimal representation of the asset name (for token transfers)
asset_name
Name of the asset being transferred (for token transfers)
contract_address_hex
Hexadecimal representation of the contract address (for contract interactions)
contract_address
Base58 representation of the contract address (for contract interactions)
data
Additional data included in the transaction
parameter_value
JSON string containing transaction parameters
expiration
Expiration timestamp of the transaction
fee_limit
Maximum fee the sender is willing to pay
ref_block_bytes
Reference block bytes
ref_block_hash
Reference block hash
timestamp
Timestamp when the transaction was created
block_timestamp
Timestamp of the block containing this transaction
block_number
Block number containing this transaction
block_hash
Hash of the block containing this transaction
parent_hash
Hash of the parent block
version
Version of the transaction
tx_trie_root
Merkle root of the transaction trie
witness_address
Address of the block producer (witness)
witness_signature
Signature of the block producer (witness)
has_receipts
Boolean indicating if the transaction has receipts
receipt_json
JSON string containing receipt details
unfreeze_amount
Amount unfrozen in this transaction
withdraw_amount
Amount withdrawn in this transaction
withdraw_expire_amount
Expired withdrawal amount
receipt_contract_address_hex
Hexadecimal representation of the contract address in the receipt
receipt_contract_address
Base58 representation of the contract address in the receipt
receipt_contract_result
Result of the contract execution
receipt_fee
Total fee charged for the transaction
receipt_net_fee
Network fee charged for the transaction
receipt_net_usage
Network resources used by the transaction
receipt_energy_fee
Energy fee charged for the transaction
receipt_energy_usage_total
Total energy used by the transaction
receipt_energy_usage
Energy used by the transaction execution
receipt_origin_energy_usage
Energy used by the contract owner
receipt_res_message
Resource message in the receipt
receipt_result
Result status in the receipt
parameter_json
JSON string containing parsed transaction parameters
_created_at
Timestamp when this record was created
_updated_at
Timestamp when this record was last updated
_extra_fields
Additional fields not covered by the standard schema
Last updated