Transactions and account states
- All transactions have Block fields
- Each transaction has emulated state of account on this transaction, which contains:
- account_state_state_init_code
- account_state_state_init_data
- account_storage_balance_grams
- Which is actual smart-contract code / data / balance on moment of transaction
- Account states table is last transaction for each account and have the same fields
- This is common fields mostly provided by blockchain itself. For each transactions there's extension with:
- Natively supported protocols:
- Auto-generated supported protocols by ABI. (WIP)
Column Name | Type | Description |
|---|---|---|
address | String | The HEX part of address of the account involved in the transaction. |
address__friendly | String | Friendly address of the account by TEP-2 |
hash | String (Primary Key) | The unique hash of the transaction, serving as its identifier. |
total_fees_grams | UInt64 | Total fees paid in grams for the transaction. |
total_fees_extra_key | Array(Nullable(UInt32)) | Array of extra keys related to additional fees in the transaction. |
total_fees_extra_value | Array(Nullable(UInt256)) | Array of extra values corresponding to the extra fee keys. |
lt | UInt64 | Logical time at which the transaction occurred. |
prev_trans_lt | UInt64 | Logical time of the previous transaction related to this one. |
now | DateTime | Timestamp indicating when the transaction was created. (UTC+3) |
outmsg_cnt | UInt16 | The count of outbound messages generated by this transaction, up to 255. |
prev_trans_hash | String | Hash of the previous transaction in the chain. |
state_update_old_hash | String | Hash of the state before the transaction. |
state_update_new_hash | String | Hash of the state after the transaction. |
orig_status | String | Original status of the account before the transaction. Status can be:
|
end_status | String | Status of the account after the transaction. |
transaction_type | String | Specifies the type of transaction: trans_ord / trans_tick_tock |
in_msg_cell | Nullable(String) | BOC message cell data for inbound message. |
emulator_status | Nullable(UInt8) | Status of the dTON emulator: # 0 - emulation not needed # + 1 - emulation fail # + 2 - emulation success # + 4 - same code # + 8 - same data # + 16 - same transaction hash # + 32 - same libs # + 64 - same frozen hash (not implemented) |
credit_first | Nullable(UInt8) | Indicates if the transaction credited the account first (1 for true). |
aborted | Nullable(UInt8) | Indicates if the transaction was aborted (1 for true). |
destroyed | Nullable(UInt8) | Indicates if the transaction destroy account (1 for true). |
is_tock | Nullable(UInt8) | Marks whether this transaction is a tock transaction (1 for true). |
Computation phase | | |
compute_ph | Nullable(UInt8) | Compute phase status. (1 if exist) |
compute_ph_type | Nullable(String) | Type of compute phase: computed or skipped |
compute_ph_reason | Nullable(String) | Reason for the compute phase status: cskip_no_gas / cskip_no_state / cskip_bad_state |
compute_ph_success | Nullable(UInt8) | Indicates if the compute phase was successful (1 for true). |
compute_ph_msg_state_used | Nullable(UInt8) | Indicates if the message state was used in the compute phase. |
compute_ph_account_activated | Nullable(UInt8) | Indicates if the account was activated during the compute phase. |
compute_ph_gas_fees | Nullable(UInt64) | Amount of gas fees used during the compute phase. |
compute_ph_gas_used | Nullable(UInt64) | Total gas consumed during the compute phase. |
compute_ph_gas_limit | Nullable(UInt64) | Gas limit set for the compute phase. |
compute_ph_mode | Nullable(UInt8) | Mode of operation during the compute phase. |
compute_ph_exit_code | Nullable(UInt32) | Exit code of the compute phase. |
compute_ph_vm_steps | Nullable(UInt32) | Number of VM steps executed in the compute phase. |
compute_ph_vm_init_state_hash | Nullable(String) | Hash of the VM's initial state. (not implemented by TON) |
compute_ph_vm_final_state_hash | Nullable(String) | Hash of the VM's final state. (not implemented by TON) |
Storage phase | | |
storage_ph | Nullable(UInt8) | Storage phase status. (1 if exist) |
storage_ph_storage_fees_collected | Nullable(UInt64) | Amount of storage fees collected in grams. |
storage_ph_storage_fees_due | Nullable(UInt64) | |
storage_ph_status_change | Nullable(String) | Change in status during the storage phase. |
Credit phase | | |
credit_ph | Nullable(UInt8) | Credit phase status. |
credit_ph_credit | Nullable(UInt64) | Amount of credit granted in this phase. |
credit_ph_credit_extra_key | Array(Nullable(UInt32)) | Array of extra keys related to credits. |
credit_ph_credit_extra_value | Array(Nullable(UInt256)) | Array of extra values corresponding to credit keys. |
credit_ph_due_fees_collected | Nullable(UInt64) | Amount of due fees collected in the credit phase. |
Action phase | | |
action_ph | Nullable(UInt8) | Action phase status. (1 if exist) |
action_ph_success | Nullable(UInt8) | Indicates if the action phase was successful (1 for true). |
action_ph_valid | Nullable(UInt8) | Indicates if the action was valid (1 for true). |
action_ph_no_funds | Nullable(UInt8) | Indicates if the action failed due to lack of funds. |
action_ph_status_change | Nullable(String) | Change in status during the action phase. |
action_ph_result_code | Nullable(Int32) | Result code of the action phase. |
action_ph_tot_actions | Nullable(UInt16) | Total number of actions executed in this phase. |
action_ph_spec_actions | Nullable(UInt16) | Number of special actions executed. |
action_ph_skipped_actions | Nullable(UInt16) | Number of actions skipped. |
action_ph_msgs_created | Nullable(UInt16) | Number of messages created during the action phase. |
action_ph_action_list_hash | Nullable(String) | Hash of the action list in this phase. |
action_ph_tot_msg_size_cells | Nullable(UInt32) | Total message size in cells. |
action_ph_tot_msg_size_bits | Nullable(UInt32) | Total message size in bits. |
action_ph_total_fwd_fees | Nullable(UInt64) | Total forwarding fees incurred. |
action_ph_total_action_fees | Nullable(UInt64) | Total action fees incurred. |
Bounce phase | | |
bounce_ph | Nullable(UInt8) | Bounce phase status. |
bounce_ph_type | Nullable(String) | Type of the bounce phase. |
bounce_ph_msg_size_cells | Nullable(UInt32) | Message size in cells for the bounce phase. |
bounce_ph_msg_size_bits | Nullable(UInt32) | Message size in bits for the bounce phase. |
bounce_ph_req_fwd_fees | Nullable(UInt64) | Required forwarding fees for bounce messages. |
bounce_ph_msg_fees | Nullable(UInt64) | Fees for messages in the bounce phase. |
bounce_ph_fwd_fees | Nullable(UInt64) | Forwarding fees for the bounce phase. |
Inbound message | | |
in_msg_type | Nullable(String) | Type of inbound message. ext_in_msg_info / int_msg_info / Null |
in_msg_hash | Nullable(String) | Hash of the inbound message. |
in_msg_dest_addr_type | Nullable(String) | Type of the destination address in the inbound message. |
in_msg_dest_addr_len | Nullable(UInt16) | Length of the destination address. |
in_msg_dest_addr_address_bin | Nullable(String) | Binary representation of the destination address. |
in_msg_dest_addr_address_hex | Nullable(String) | Hexadecimal representation of the destination address. |
in_msg_dest_addr_address_hex__friendly | Nullable(String) | Friendly address of the destination account |
in_msg_dest_addr_workchain_id | Nullable(Int16) | Workchain ID of the destination address. |
in_msg_dest_addr_anycast_depth | Nullable(UInt16) | Anycast depth of the destination address. |
in_msg_dest_addr_anycast_rewrite_pfx | Nullable(String) | Anycast rewrite prefix. |
in_msg_src_addr_type | Nullable(String) | Type of the source address in the inbound message. |
in_msg_src_addr_len | Nullable(UInt16) | Length of the source address. |
in_msg_src_addr_address_bin | Nullable(String) | Binary representation of the source address. |
in_msg_src_addr_address_hex | Nullable(String) | Same as address |
in_msg_src_addr_address_hex__friendly | Nullable(String) | Same as address_friendly |
in_msg_src_addr_workchain_id | Nullable(Int16) | Workchain ID of the source address. |
in_msg_src_addr_anycast_depth | Nullable(UInt16) | Anycast depth of the source address. |
in_msg_src_addr_anycast_rewrite_pfx | Nullable(String) | Anycast rewrite prefix. |
in_msg_ihr_disabled | Nullable(UInt8) | Indicates if the Inbound Hyperledger Routing (IHR) is disabled. |
in_msg_bounce | Nullable(UInt8) | Indicates if the message is a bounce message. |
in_msg_bounced | Nullable(UInt8) | Indicates if the message has bounced. |
in_msg_value_grams | Nullable(UInt64) | Value in grams of the inbound message. |
in_msg_value_extra_key | Array(Nullable(UInt32)) | Array of extra keys related to the inbound message's value. |
in_msg_value_extra_value | Array(Nullable(UInt256)) | Array of extra values corresponding to the extra keys. |
in_msg_created_lt | Nullable(UInt64) | Logical time of the creation of the inbound message. |
in_msg_created_at | Nullable(DateTime) | Timestamp of the inbound message's creation. (UTC+3) |
in_msg_import_fee_grams | Nullable(UInt64) | Import fee in grams for the inbound message. |
in_msg_ihr_fee_grams | Nullable(UInt64) | IHR fee in grams for the inbound message. |
in_msg_fwd_fee_grams | Nullable(UInt64) | Forwarding fee in grams for the inbound message. |
in_msg_init_split_depth | Nullable(UInt8) | Split depth of the inbound message's initialization. |
in_msg_init_special_tick | Nullable(UInt8) | Indicates if there is a special tick in initialization. |
in_msg_init_special_tock | Nullable(UInt8) | Indicates if there is a special tock in initialization. |
in_msg_init_code_hash | Nullable(String) | Hash of the initialization code. |
in_msg_init_code | Nullable(String) | Initialization code of the inbound message. |
in_msg_init_data | Nullable(String) | Initialization data of the inbound message. |
out_msg_count | Nullable(UInt64) | Count of outbound messages. |
in_msg_init_libs_count | Nullable(UInt16) | Count of initialization libraries. |
in_msg_init_init_libs_hash | Array(Nullable(String)) | Array of initialization libraries' hashes. |
in_msg_init_init_libs_public | Array(Nullable(UInt8)) | Array indicating if the libraries are public. |
in_msg_init_init_libs_cell | Array(Nullable(String)) | Array of initialization libraries' cells. |
in_msg_body | Nullable(String) | Body of the inbound message. |
in_msg_op_code | Nullable(UInt32) | Operation code of the inbound message. (first 32 bits) |
in_msg_skip512_op_code | Nullable(UInt32) | OP code after skip of 512 bits |
in_msg_comment | Nullable(String) | Parsed comment associated with the inbound message. |
Account state info | | |
account_storage_stat_last_paid | Nullable(UInt32) | Timestamp of the last payment for storage, on the end of block |
account_storage_stat_due_payment | Nullable(UInt64) | Amount due for storage fees, on the end of block |
account_storage_stat_used_cells | Nullable(UInt32) | Number of cells used in account storage, on the end of block |
account_storage_stat_used_bits | Nullable(UInt32) | Number of bits used in account storage, on the end of block |
account_storage_stat_used_public_cells | Nullable(UInt32) | Number of public cells used in account storage, on the end of block |
account_storage_last_trans_lt | Nullable(UInt64) | Logical time of the last transaction affecting the account storage, on the end of block |
account_storage_balance_grams | Nullable(UInt64) | Balance of the account |
account_storage_balance_extra_key | Array(Nullable(UInt32)) | Array of extra keys related to account storage balance. |
account_storage_balance_extra_value | Array(Nullable(UInt256)) | Array of extra values corresponding to the storage balance keys. |
account_state_type | Nullable(String) | Type of the account state, same as end_status, on the end of block |
account_state_state_init_split_depth | Nullable(UInt32) | Split depth for the account state initialization, on the end of block |
account_state_state_init_code | Nullable(String) | Code for account state of this transaction |
account_state_state_init_code_hash | Nullable(String) | Hash of code for account state of this transaction |
account_state_state_init_code_methods | Array(Int64) | Array of methods in the account state initialization code. |
account_state_state_init_data | Nullable(String) | Data for account state of this transaction |
account_state_state_init_data_hash | Nullable(String) | Hash of data for account state of this transaction |
account_state_state_init_libs_count | Nullable(UInt64) | Count of libraries in the account state initialization. |
account_state_state_init_libs_hash | Array(Nullable(String)) | Array of hashes of the libraries in the account state initialization. |
account_state_state_init_libs_public | Array(Nullable(UInt8)) | Array indicating if the initialization libraries are public. |
account_state_state_init_special_tick | Nullable(UInt8) | Indicates if there is a special tick in the account state initialization. |
account_state_state_init_special_tock | Nullable(UInt8) | Indicates if there is a special tock in the account state initialization. |
account_state_state_hash | Nullable(String) | Hash of the account state, on the end of block |
account_deleted | Nullable(UInt8) | Indicates if the account has been deleted (1 for true), on the end of block |
Outbound messages | | Up to 255 messages, indexes corresponding with each other. |
out_msg_value_grams | Array(Nullable(UInt64)) | Array of values in grams for outbound messages. |
out_msg_value_extra_key | Array(Array(Nullable(UInt32))) | Nested array of extra keys for outbound message values. |
out_msg_value_extra_value | Array(Array(Nullable(UInt256))) | Nested array of extra values corresponding to the extra keys. |
out_msg_body | Array(Nullable(String)) | Array of bodies of the outbound messages. |
out_msg_op_code | Array(Nullable(UInt64)) | Array of operation codes for outbound messages. |
out_msg_comment | Array(Nullable(String)) | Array of comments associated with outbound messages. |
out_msg_bounce | Array(Nullable(UInt8)) | Array indicating if outbound messages are bounce messages. |
out_msg_bounced | Array(Nullable(UInt8)) | Array indicating if outbound messages have bounced. |
out_msg_ihr_disabled | Array(Nullable(UInt8)) | Array indicating if IHR is disabled for outbound messages. |
out_msg_created_at | Array(Nullable(DateTime)) | Array of timestamps indicating when outbound messages were created. |
out_msg_created_lt | Array(Nullable(UInt64)) | Array of logical times for the creation of outbound messages. |
out_msg_fwd_fee_grams | Array(Nullable(UInt64)) | Array of forwarding fees for outbound messages. |
out_msg_ihr_fee_grams | Array(Nullable(UInt64)) | Array of IHR fees for outbound messages. |
out_msg_dest_addr_type | Array(Nullable(String)) | Array of destination address types for outbound messages. |
out_msg_dest_addr_len | Array(Nullable(UInt16)) | Array of destination address lengths. |
out_msg_dest_addr_address_bin | Array(Nullable(String)) | Array of binary representations of the destination addresses. |
out_msg_dest_addr_address_hex | Array(Nullable(String)) | Array of hexadecimal representations of the destination addresses. |
| | |
out_msg_dest_addr_workchain_id | Array(Nullable(Int16)) | Array of workchain IDs for destination addresses. |
out_msg_dest_addr_anycast_depth | Array(Nullable(UInt16)) | Array of anycast depths for destination addresses. |
out_msg_dest_addr_anycast_rewrite_pfx | Array(Nullable(String)) | Array of anycast rewrite prefixes for destination addresses. |
out_msg_type | Array(Nullable(String)) | Array of types for outbound messages, types same as in_msg_type, but ext_out_msg_info for log out messages |
Traces info | | |
trace_hash | Nullable(String) | Hash of first transaction in trace. |
trace_parent_hash | Nullable(String) | Hash representing the parent transaction of this transa |