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	Different types of fees are: 1 = Subscription 2 = Fixed 3 = Performance 4 = Management 5 = Exit
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