---
title: Transactions and account states
slug: transactions-and-account-states
docTags:
createdAt: 2024-09-27T14:49:16.274Z
---
- 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:
- [NFTs](docId\:pPid_7_b64VVj4vay42sk)
- [NFT Collections](docId\:pPid_7_b64VVj4vay42sk)
- [NFT sale contracts](docId\:pPid_7_b64VVj4vay42sk)
- [DNS](docId\:pPid_7_b64VVj4vay42sk)
- [Jettons](docId\:pPid_7_b64VVj4vay42sk)
- 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](https://github.com/ton-blockchain/TEPs/blob/master/text/0002-address.md) |
| `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:
- `active`
- `nonexist`
- `uninit`
- `frozen` |
| `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 |