Transactions Native

• The transaction hash in this table does not have a 0x prefix.

Table Columns

Unique Key: hash

Column Name	Description
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