Accounts

The Accounts table details the mapping of Internal Account IDs and external group IDs along with other account details.

The Accounts can be:

• External Fund Manager

• Internal Fund Manager

• Investor

• Wallet

• Introducer

• Index

• Coverage

Table Name: Accounts

Column Name	Data Type	Valid Values	Allow Nulls	Description
PK_AccountID	bigint identity		No	This field states the unique Account ID of a slave (or follower) in the Tradesocio environment generated by TC.
FK_AccountGroupID	int		No
ExternalID	varchar		No	This field states the external Account ID, which would also be the MT4/MT5 account ID (in some cases).
Password	varchar		Yes
Active	bit		No	The field lists the current activity of the component whether it is active or inactive.
LastUpdatedtime	datetime	(getutcdate())	Yes	The time when the last update took place.
ParticipantLoginID	varchar		Yes
ParticipantPassword	varchar		Yes
ParticipantAccountType	int		Yes	1 = Slave 2 = Master 3 = Coverage 4 = Introducer 5 = Wallet 6 = Index
InstantDeduction	int		Yes
isAccountDisabledForTCSL	int		Yes
IsStopCopyTriggerDisabled	int		Yes
Introducer	int		Yes
Balance	decimal	((0))	Yes	The field lists the balance, i.e., the amount of funds in an account after the closing of all trades.
Leverage	decimal	((0))	Yes	Leverage
Credit	decimal	((0))	Yes	Not in use
Currency	varchar		Yes	Deposit Currency
NoSwapDeduction	bit	((0))	No
IsForIndex	bit	((0))	No	0 = Not an index 1 = Index
VAMI	decimal	((1000))	No	This field lists the VAMI, i.e., a measure to track the monthly performance of an investment.
ReturnPerc	decimal		Yes	Return value in percentage.
AUM	decimal		Yes	This Sum of current allocation for all slaves under a master.
UsedMargin	decimal	((0))	No	Used margin
isBBookMaster	int	((0))	No	0 = Disabled 1 = Enabled
FK_FundType	int	((0))	No	1 = Mirror 2 = Invest 3 = Index
MappingCount	int		Yes
IsNonHedge	int	((0))	No
FK_BasketFundID	int		Yes
FK_ProfileId	bigint		Yes
HideStatus	bit		Yes
FK_AccountType	int		Yes
AccountName	varchar		Yes
StrategyDescription	text		Yes
AccountInceptionDate	datetime		Yes