Account_wallet
The account_wallet Table
The account_wallet table in XCore Trade DB is a detailed ledger of all balance-related transactions for each account.
It provides critical insights into Account wallet activity, including deposits, withdrawals, and charges, with the capability to annotate operations for precise auditing and analysis.
| Attributes | Description |
|---|---|
| Account | The name of the Account as defined in the XCore system. |
| Seq | The unique sequence number of the Account wallet operations generated by XCore (deposit, withdrawal, etc.) |
| Prev | The ‘Seq’ ID of the preceding transaction for reference. |
| Pos_seq | Sequence number of the related position record, or -1 when no position is linked. |
| Time | Timestamp (date, time) when an operation on the account took place. (epoch format) |
| Wallet | Wallet name. Automatic bookings use the corresponding wallet name from AccountProfileWallet. |
| Type | Identifies transaction types: 0=Any manual operation executed via the XCore Portal or through an API request, and coverage synchronization entries (comment cov_sync).1=Automatic Swap as configured in Account swap profile 2=Automatic PnL as configured in Account PL profile 3=Automatic Dividend as configured in Account dividend profile 4=Automatic Dividend Tax as configured in Account dividend profile 5=Commissions as configured in Commission profile |
| Ccy | Currency of this wallet balance. |
| Balance | Resulting balance of this wallet in Ccy after the transaction. This is the cumulative balance, not the transaction amount. |
| Comment | This field is for adding transaction-specific remarks using standardized tags such as:#SYM#, #BASE#, #QUOTE#, #TYPE#, #ORDER# for commission charges;#SYM#, #POINT#, #CONV#, #%# for swap charges;#SYM#, #CONV#, #MARKUP# for PnL;and #SYM#, #VALUE#, #TAX#, #CONV#, #%# for dividends.These tokens in the configured comment template are replaced with transaction values when the booking is made. Text outside the tokens is retained as free text. |
| Comment_2 | An additional field for comments or notes related to account operations. |