Transfers

This tables aims to simply the Algorand tables by combining the Payment Transaction Table and the Asset Transfer Transaction table and decimal adjusting all amounts from both of these tables.

This means both payment transaction("pay") and asset transfer transaction("axfer") types will be included in the table. While the payment table was previously decimal adjusted we are now decimal adjusting all amounts for assets out side of ALGO(asset_id = 0) as well.

We have also broken out sender into asset_sender which is the wallet from which the asset is sent from and tx_sender which is the wallet which initiates the transaction. 99% of transactions these values are the same - however, this now gives us an easier way to look at clawback transactions(https://developer.algorand.org/docs/get-details/transactions/transactions/#asset-transfer-transaction) which are detailed here. For most purposes we can use asset_sender unless we want to look asset clawback transactions for the asset transfer transactions.

Table Schema

All transactions have a distinct intra and block_id combination. The intra is the transaction # into the block where the transaction was confirmed. Inner transactions(flagged with the inner tx flag) share the tx id of their parent application transactions so you can tie inner transaction to a parent transaction via a tx id. The inner transactions are seen as distinct transactions on the Algorand blockchain, which is signified by their intra and block id combination.

Field	Type	Description
BLOCK_TIMESTAMP	datetime	Timestamp of block minting(without a timezone)
INTRA	number	Transaction # into the block where this transaction was confirmed
BLOCK_ID	number	Block the transaction was confirmed
TX_GROUP_ID	text	Transaction group ID, can be NULL. Exists when a group of transactions are tied together
TX_ID	text	An identifier tied to a transaction and its inner transactions.
INNER_TX	boolean	A boolean true or false on whether or not this transaction has a parent transaction. The TX_ID will be the same as the parent transaction but will have it's own intra.
ASSET_SENDER	text	The wallet address from which the asset is transferred from. This can be different from the asset_sender if a wallet has opted in to allow another address to send an asset from its wallet(https://developer.algorand.org/docs/get-details/transactions/transactions/#asset-transfer-transaction).
TX_SENDER	text	The wallet address from which the transaction is initiated from and pays the fee. The tx_sender can send assets from a different asset_sender address if the asset_sender has opted into this action. This relates to clawback transactions: see asset_sender for more details.
RECEIVER	text	The recipient of the transfer.
ASSET_ID	number	ID associated with the asset
AMOUNT	number	The amount of the asset to be transferred. Can be 0.
FEE	number	Fee associated with the transaction, in ALGOs
ASSET_TRANSFERRED	number	The Asset ID of the asset transferred in the asset transfer transaction.
TX_TYPE	number	Number associated with transaction type
TX_TYPE_NAME	text	transaction type name
GENISIS_HASH	text	The hash of the genesis block of the network for which the transaction is valid
TX_MESSAGE	array	Encoded JSON message associated with the transaction
EXTRA	array	Extra json associated with transaction