# Account Metrics Per Master Slave

The Account Metrices Per Master Slave table details the account description of the Slave with respect to the Master accounts. The fields for the Account\_MetricesPerMasterSlave table are:

**Table Name: Account\_MetricesPerMasterSlave**

| **Column Name**    | **Data Type** | **Valid Values** | **Allow Nulls** | **Description**                                                                                                                                       |
| ------------------ | ------------- | ---------------- | --------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| PK\_ID             | int identity  |                  | No              | It is a unique ID.                                                                                                                                    |
| AccountID          | bigint        |                  | No              | This field states the Account ID of a slave (or follower) in the Tradesocio environment and is referenced from the Accounts table.                    |
| MasterAccountID    | bigint        |                  | No              | This field lists the Account ID of the Master whom the slave is following and is referenced from the Accounts table.                                  |
| Balance            | decimal       | ((0))            | No              | The field lists the balance, i.e., the amount of funds in an account after the closing of all trades.                                                 |
| Equity             | decimal       | ((0))            | No              | This field lists the equity, i.e., the amount of funds in an account that includes all open trades.                                                   |
| MaxDDPercentForDay | decimal       | ((0))            | No              | This field lists the maximum drawdown, i.e., the decline of investment from peak to dip in a day. It is calculated as a percentage of the peak value. |
| EOD\_DDPercent     | decimal       | ((0))            | No              | End of the Day Drawdown percent.                                                                                                                      |
| VAMI               | decimal       | ((0))            | No              | This field lists the VAMI, i.e., a measure to track the monthly performance of an investment.                                                         |
| ReturnPercent      | decimal       | ((0))            | No              | Return value in percentage.                                                                                                                           |
| BrokerTime         | datetime      | (getutcdate())   | No              | This field specifies the time when deductions and update occur in the table in a day.                                                                 |
| PNL                | decimal       | ((0))            | No              | This field lists the realized Profit and Loss, i.e., the loss or profit has been added to the equity as the transaction is completed.                 |
| isEOD              | int           | ((0))            | No              | <p>0 = The current day status is not yet updated and will get updated by end of day.</p><p>1 = The previous day status is updated.</p>                |
| UPNL               | decimal       | ((0))            | No              | This field lists the Unrealized Profit and Loss, i.e., the loss or profit has occurred on paper, but the transactions are not yet completed.          |
| LastUpdatedTime    | datetime      | (getutcdate())   | No              | The time when the last update took place in this specific table.                                                                                      |
