# Account Transaction History

The Account Transaction History table provides an insight into the transaction details of a master or slave account. The fields for the AccountTransactionHistory table are:

**Table Name: AccountTransactionHistory**

| **Column Name**      | **Data Type** | **Valid Values** | **Allow Nulls** | **Description**                                                                                                                      |
| -------------------- | ------------- | ---------------- | --------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| PK\_ID               | int identity  |                  | No              | This field consists of unique IDs of the account, which is further used in various other tables in database.                         |
| FK\_AccountId        | int           |                  | No              | This field states the Account ID of a master or slave (or follower) in the Tradesocio environment.                                   |
| ValueDate            | datetime      | (getutcdate())   | No              | Time when the value is updated.                                                                                                      |
| Narration            | text          |                  | Yes             | Specific comments are listed over here.                                                                                              |
| Ref                  | varchar       |                  | Yes             | References                                                                                                                           |
| Debit                | decimal       | ((0))            | Yes             | Debit                                                                                                                                |
| Credit               | decimal       | ((0))            | Yes             | Credit                                                                                                                               |
| Balance              | decimal       | ((0))            | Yes             | The field lists the balance, i.e., the amount of funds in an account after the closing of all trades.                                |
| FK\_FeeType          | int           | ((0))            | No              | <p>Different types of fees are:</p><p>1 = Subscription</p><p>2 = Fixed</p><p>3 = Performance</p><p>4 = Management</p><p>5 = Exit</p> |
| BrokerTime           | datetime      | (getutcdate())   | No              | This field specifies the time when deductions and update occur in the table in a day.                                                |
| WalletTransactionID  | int           |                  | Yes             | This field lists the transaction IDs for the fee deductions and transactions from the slave’s wallet account.                        |
| Currency             | varchar       |                  | Yes             |                                                                                                                                      |
| ConversionRate       | decimal       | ((0))            | Yes             |                                                                                                                                      |
| MasterBrokerFee      | decimal       |                  | Yes             |                                                                                                                                      |
| MasterCurrency       | varchar       |                  | Yes             |                                                                                                                                      |
| MasterConversionRate | decimal       | ((0))            | Yes             |                                                                                                                                      |
| MasterAccountID      | int           | ((0))            | Yes             |                                                                                                                                      |
| SlaveAccountID       | int           | ((0))            | No              |                                                                                                                                      |
| OrderID              | int           | ((0))            | No              |                                                                                                                                      |
| AllocationID         | int           |                  | Yes             |                                                                                                                                      |
| AllocationStartDate  | datetime      | (getutcdate())   | No              |                                                                                                                                      |
| IsPerFlag            | int           |                  | Yes             |                                                                                                                                      |
| MasterFeePer         | decimal       |                  | Yes             |                                                                                                                                      |
| BrokerFeePer         | decimal       |                  | Yes             |                                                                                                                                      |
| MasterFeeAmount      | decimal       |                  | Yes             |                                                                                                                                      |
| BrokerFeeAmount      | decimal       |                  | Yes             |                                                                                                                                      |
| HWM                  | decimal       |                  | Yes             |                                                                                                                                      |
| HWMProfit            | decimal       |                  | Yes             |                                                                                                                                      |
| ReverseFeeID         | int           |                  | Yes             | This field lists the ID of the fee that will be reversed to the account.                                                             |
| DeploymentServer     | int           |                  | Yes             |                                                                                                                                      |
| IntroducerID         | int           |                  | Yes             |                                                                                                                                      |
| IntroducerPercent    | decimal       |                  | Yes             |                                                                                                                                      |
| IntroducerAmount     | decimal       |                  | Yes             |                                                                                                                                      |
