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 native protocols fields docid\ ppid 7 b64vvj4vay42sk native protocols fields docid\ ppid 7 b64vvj4vay42sk native protocols fields docid\ ppid 7 b64vvj4vay42sk native protocols fields docid\ ppid 7 b64vvj4vay42sk native protocols fields 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 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