> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Fungible Credit Debit

### Table Details

| Property     | Value                                |
| ------------ | ------------------------------------ |
| Table Name   | `aptos.assets.fungible_credit_debit` |
| Table Status | Production-Ready                     |
| Unique Key   | `transaction_hash`, `unique_id`      |

### Table Columns

| Column Name           | Data Type         | Description                                                                                                                                                                                                           |
| --------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| address               | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.                                                                |
| token\_type           | VARCHAR(14)       | Token standard for the asset. One of: `erc20` (fungible), `erc721` (non-fungible), `erc1155` (semi-fungible), or the native currency symbol (e.g. `eth`, `matic`, `bnb`).                                             |
| coin\_address         | VARCHAR(16777216) | Aptos Move type address of the fungible token (Coin Standard type, e.g. 0x1::aptos\_coin::AptosCoin).                                                                                                                 |
| coin\_name            | VARCHAR(16777216) | Full name of this coin. Short alias for token\_name in Aptos/Cosmos-style tables.                                                                                                                                     |
| coin\_symbol          | VARCHAR(16777216) | Ticker symbol of this coin. Short alias for token\_symbol in Aptos/Cosmos-style tables.                                                                                                                               |
| coin\_decimals        | NUMBER(38,0)      | Decimal precision of this coin. Short alias for token\_decimals in Aptos/Cosmos-style tables.                                                                                                                         |
| fa\_address           | VARCHAR(16777216) | Aptos Fungible Asset (FA) object address for this token under the new FA Standard.                                                                                                                                    |
| fa\_name              | VARCHAR(16777216) | Display name of this Fungible Asset token.                                                                                                                                                                            |
| fa\_symbol            | VARCHAR(16777216) | Ticker symbol of this Fungible Asset token.                                                                                                                                                                           |
| fa\_decimals          | NUMBER(38,0)      | Decimal precision of this Fungible Asset token.                                                                                                                                                                       |
| token\_address        | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address.               |
| token\_name           | VARCHAR(16777216) | Full name of the token (e.g. "USD Coin", "Wrapped Ether").                                                                                                                                                            |
| token\_symbol         | VARCHAR(16777216) | Ticker symbol of the token (e.g. "USDC", "WETH").                                                                                                                                                                     |
| token\_decimals       | NUMBER(38,0)      | Number of decimal places used to represent the token's smallest unit. Used to convert raw amounts: normalized\_amount = raw\_amount / 10^decimals. For example, USDC has 6 decimals, so 2500000 raw units = 2.5 USDC. |
| token\_metadata       | OBJECT            | Address of the token metadata account.                                                                                                                                                                                |
| raw\_amount           | FLOAT             | Token amount in the smallest indivisible unit (not decimal-adjusted). Same concept as `amount_raw` — the column is named `raw_amount` in models that follow the `raw_` prefix convention.                             |
| raw\_amount\_str      | VARCHAR(16777216) | Raw collateral amount in USDC base units (6 decimals), as a string.                                                                                                                                                   |
| amount\_str           | VARCHAR(16777216) | Normalized token amount stored as a string to preserve full precision. Equivalent to `amount` but avoids floating-point truncation for very large or very small values.                                               |
| amount                | FLOAT             | Token amount normalized by the token's decimal precision (amount\_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000).                                                           |
| usd\_amount           | FLOAT             | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate.                                                                                                                  |
| usd\_exchange\_rate   | FLOAT             | USD price per unit of the token at the time of the event, used to compute `usd_amount`. Sourced from Allium's hourly price feed.                                                                                      |
| is\_deposit           | BOOLEAN           | True if this operation is a deposit into a protocol or vault.                                                                                                                                                         |
| type                  | VARCHAR(16777216) | The type of the position on the perpetual.                                                                                                                                                                            |
| type\_address         | VARCHAR(16777216) | Move package address component of a fully-qualified type (e.g. 0x2 in 0x2::coin::Coin).                                                                                                                               |
| type\_module          | VARCHAR(16777216) | Move module name component of a fully-qualified type (e.g. coin in 0x2::coin::Coin).                                                                                                                                  |
| type\_struct          | VARCHAR(16777216) | Struct name component of a fully-qualified Move type.                                                                                                                                                                 |
| virtual\_type\_struct | VARCHAR(16777216) | Move type struct identifier for this virtual order record.                                                                                                                                                            |
| block\_hash           | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                                                                                        |
| block\_height         | NUMBER(38,0)      | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike `block_slot`, this only increments for slots that produced a block.                                                           |
| block\_timestamp      | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                                                               |
| transaction\_hash     | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                                                           |
| transaction\_index    | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                                                                                                |
| transaction\_version  | NUMBER(38,0)      | Monotonically increasing version number of the transaction on the Aptos blockchain. Aptos uses versions rather than block-scoped transaction indices.                                                                 |
| event\_index          | NUMBER(38,0)      | Zero-based index of this event within its transaction. The specific semantics depend on the chain — on Aptos this is the `event_index` within the transaction; on Cosmos this is within the message.                  |
| virtual\_order        | NUMBER(38,0)      | True if this is a virtual order used for internal accounting rather than a real trade.                                                                                                                                |
| unique\_id            | VARCHAR(16777216) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes.                                 |
