Skip to main content
Schema: ton.core Table: fact_transactions Type: Base Table

What

Contains information about transactions in the TON blockchain, tracking account changes, fees, and computation results.

Columns

Column NameData TypeDescription
BLOCK_TIMESTAMPTIMESTAMP_NTZBLOCK_TIMESTAMP column
TX_HASHTEXTTX_HASH column
PREV_TX_HASHTEXTPREV_TX_HASH column
TX_SUCCEEDEDBOOLEANTX_SUCCEEDED column
ABORTEDBOOLEANABORTED column
ACCOUNTTEXTACCOUNT column
ORIG_STATUSTEXTORIG_STATUS column
END_STATUSTEXTEND_STATUS column
COMPUTE_SUCCESSBOOLEANCOMPUTE_SUCCESS column
COMPUTE_SKIPPEDBOOLEANCOMPUTE_SKIPPED column
COMPUTE_GAS_FEESNUMBERCOMPUTE_GAS_FEES column
ACTION_RESULT_CODENUMBERACTION_RESULT_CODE column
ACTION_SUCCESSBOOLEANACTION_SUCCESS column
ACTION_SPEC_ACTIONSNUMBERACTION_SPEC_ACTIONS column
ACTION_RESULT_ARGNUMBERACTION_RESULT_ARG column
ACTION_SKIPPED_ACTIONSNUMBERACTION_SKIPPED_ACTIONS column
ACTION_VALIDBOOLEANACTION_VALID column
ACTION_TOT_ACTIONSNUMBERACTION_TOT_ACTIONS column
ACTION_NO_FUNDSBOOLEANACTION_NO_FUNDS column
ACTION_STATUS_CHANGETEXTACTION_STATUS_CHANGE column
COMPUTE_MSG_STATE_USEDBOOLEANCOMPUTE_MSG_STATE_USED column
DESCRTEXTDESCR column
BLOCK_WORKCHAINNUMBERBLOCK_WORKCHAIN column
BLOCK_SEQNONUMBERBLOCK_SEQNO column
BLOCK_SHARDNUMBERBLOCK_SHARD column
MC_BLOCK_SEQNONUMBERMC_BLOCK_SEQNO column
TOTAL_FEESNUMBERTOTAL_FEES column
STORAGE_FEES_COLLECTEDNUMBERSTORAGE_FEES_COLLECTED column
CREDIT_DUE_FEES_COLLECTEDNUMBERCREDIT_DUE_FEES_COLLECTED column
ACTION_TOTAL_FWD_FEESNUMBERACTION_TOTAL_FWD_FEES column
STORAGE_FEES_DUENUMBERSTORAGE_FEES_DUE column
ACTION_TOTAL_ACTION_FEESNUMBERACTION_TOTAL_ACTION_FEES column
ACCOUNT_STATE_BALANCE_BEFORENUMBERACCOUNT_STATE_BALANCE_BEFORE column
ACCOUNT_STATE_BALANCE_AFTERNUMBERACCOUNT_STATE_BALANCE_AFTER column
ACCOUNT_STATE_HASH_BEFORETEXTACCOUNT_STATE_HASH_BEFORE column
ACCOUNT_STATE_HASH_AFTERTEXTACCOUNT_STATE_HASH_AFTER column
ACCOUNT_STATE_CODE_HASH_BEFORETEXTACCOUNT_STATE_CODE_HASH_BEFORE column
ACCOUNT_STATE_CODE_HASH_AFTERTEXTACCOUNT_STATE_CODE_HASH_AFTER column
INSTALLEDBOOLEANINSTALLED column
DESTROYEDBOOLEANDESTROYED column
IS_TOCKBOOLEANIS_TOCK column
CREDIT_FIRSTBOOLEANCREDIT_FIRST column
COMPUTE_ACCOUNT_ACTIVATEDBOOLEANCOMPUTE_ACCOUNT_ACTIVATED column
COMPUTE_VM_STEPSNUMBERCOMPUTE_VM_STEPS column
COMPUTE_EXIT_ARGNUMBERCOMPUTE_EXIT_ARG column
COMPUTE_GAS_CREDITNUMBERCOMPUTE_GAS_CREDIT column
COMPUTE_GAS_LIMITNUMBERCOMPUTE_GAS_LIMIT column
COMPUTE_GAS_USEDNUMBERCOMPUTE_GAS_USED column
COMPUTE_VM_INIT_STATE_HASHTEXTCOMPUTE_VM_INIT_STATE_HASH column
COMPUTE_VM_FINAL_STATE_HASHTEXTCOMPUTE_VM_FINAL_STATE_HASH column
SKIPPED_REASONTEXTSKIPPED_REASON column
COMPUTE_EXIT_CODENUMBERCOMPUTE_EXIT_CODE column
STORAGE_STATUS_CHANGETEXTSTORAGE_STATUS_CHANGE column
COMPUTE_MODENUMBERCOMPUTE_MODE column
CREDITNUMBERCREDIT column
TRACE_IDTEXTTRACE_ID column
LTNUMBERLT column
PREV_TRANS_LTNUMBERPREV_TRANS_LT column
NOWNUMBERNOW column
FACT_TRANSACTIONS_IDTEXTFACT_TRANSACTIONS_ID column
INSERTED_TIMESTAMPTIMESTAMP_NTZINSERTED_TIMESTAMP column
MODIFIED_TIMESTAMPTIMESTAMP_NTZMODIFIED_TIMESTAMP column