| ID | NUMBER | Unique identifier for the transaction |
| TRANSACTION_HASH | TEXT | Hash of the transaction. |
| LEDGER_SEQUENCE | NUMBER | The sequence number of the ledger. |
| CLOSED_AT | TIMESTAMP_NTZ | Timestamp when the ledger was closed and committed to the network. Ledgers are expected to close ~every 5 seconds. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | A clone of closed_at for join convenience. |
| ACCOUNT | TEXT | The account involved in the operation. |
| ACCOUNT_SEQUENCE | NUMBER | Sequence number for the account. |
| MAX_FEE | NUMBER | Maximum fee for the transaction. |
| OPERATION_COUNT | NUMBER | The total number of successful operations applied to this ledger. |
| CREATED_AT | TIMESTAMP_NTZ | Creation timestamp of the transaction. |
| MEMO_TYPE | TEXT | Type of memo attached to transaction. |
| MEMO | TEXT | Memo content of the transaction. |
| TIME_BOUNDS | TEXT | Time bounds for transaction validity. |
| SUCCESSFUL | BOOLEAN | Whether the operation was successful. |
| FEE_CHARGED | NUMBER | Actual fee charged for the operation. |
| INNER_TRANSACTION_HASH | TEXT | A transaction hash of a transaction wrapped with its signatures for fee-bump transactions |
| FEE_ACCOUNT | TEXT | Account charged the fee. |
| NEW_MAX_FEE | NUMBER | Updated maximum fee. |
| ACCOUNT_MUXED | TEXT | Muxed account identifier. |
| FEE_ACCOUNT_MUXED | TEXT | Muxed fee account identifier. |
| BATCH_ID | TEXT | String representation of the run id for a given DAG in Airflow. Takes the form of “scheduled_<batchenddate>-<dagalias>”. Batch ids are unique to the batch and help with monitoring and rerun capabilities. |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | The start date for the batch interval. When taken with the date in the batchid, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closedat for a ledger. |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | The timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfill. The timestamp should not be used during ad hoc analysis and is useful for data engineering purposes. |
| LEDGER_BOUNDS | TEXT | Bounds of the ledger. |
| MIN_ACCOUNT_SEQUENCE | NUMBER | Minimum account sequence number. |
| MIN_ACCOUNT_SEQUENCE_AGE | NUMBER | Minimum age of account sequence. |
| MIN_ACCOUNT_SEQUENCE_LEDGER_GAP | NUMBER | Minimum gap in ledger sequences. |
| TX_ENVELOPE | TEXT | A base-64 encoded XDR blob of the tx envelope (transaction and its signatures) |
| TX_RESULT | TEXT | A base-64 encoded XDR blob of the tx result |
| TX_META | TEXT | A base-64 encoded XDR blob of the tx meta |
| TX_FEE_META | TEXT | A base-64 encoded XDR blob of the tx fee meta |
| EXTRA_SIGNERS | ARRAY | Additional transaction signers. |
| RESOURCE_FEE | NUMBER | Fee for resource usage. |
| SOROBAN_RESOURCES_INSTRUCTIONS | NUMBER | Instructions for Soroban resources. |
| SOROBAN_RESOURCES_READ_BYTES | NUMBER | Bytes read by Soroban resources. |
| SOROBAN_RESOURCES_WRITE_BYTES | NUMBER | Bytes written by Soroban resources. |
| TRANSACTION_RESULT_CODE | TEXT | Result code of the transaction. |
| INCLUSION_FEE_BID | NUMBER | Bid for inclusion fee. |
| INCLUSION_FEE_CHARGED | NUMBER | Actual inclusion fee charged. |
| RESOURCE_FEE_REFUND | NUMBER | Refund of resource fee. |
| NON_REFUNDABLE_RESOURCE_FEE_CHARGED | NUMBER | The amount of the resource fee charged for the transaction that is non-refundable. |
| REFUNDABLE_RESOURCE_FEE_CHARGED | NUMBER | The amount of the resource fee charged for the transaction that is refundable. |
| RENT_FEE_CHARGED | NUMBER | The fee charged for renting resources on the network, such as storage space for data. |
| TX_SIGNERS | TEXT | The public keys of the signers who authorized the transaction. |
| REFUNDABLE_FEE | NUMBER | The portion of the transaction fee that is refundable under certain conditions. |
| FACT_TRANSACTIONS_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |
