Slave Orders

The Slave Orders table explains the order details of slave accounts. The fields for the SlaveOrders table are:

Table Name: SlaveOrders

Column Name	Data Type	Valid Values	Allow Nulls	Description
PK_OrderID	bigint identity		No	TradeID of the order
LPOrdID	varchar		Yes	It is used in the case of partial close, it contains the ID of the original PK Order ID. Default it is kept as null
OrigOrdID
FK_AccountID	int		No	Account ID (TS ID)
PositionSize	bigint		Yes	Order quantity
Price	decimal		Yes	request price of the symbol
FK_OrderType	int		No	1 = MARKET 2 = LIMIT 3 = STOP 4 = STOP-LIMIT
FK_OrderStatusID	int		No	1 = NEW 2 = PARTIALLY_FILLED 3 = FILLED 4 = CANCEL 5 = CANCEL_ACK 6 = REPLACED 7 = PENDING_CANCEL 8 = REJECTED 9 = PENDING_NEW 10 = EXPIRED 11 = PENDING_REPLACE 12 = UNDEFINED 13 = ORDER_NOT_FOUND
FK_Side	int		No	1 = BUY 2 = SELL
OrderDateTimeRequested	datetime		Yes	Time when the order is placed. In UTC format.
Contract	varchar		No	Symbols
Product	varchar		No	Symbols
LastUpdateTime	datetime	(getutcdate())	Yes	The time when the last update took place.
FilledQty	int		Yes	filled position size
AvgFillPRice	decimal		Yes	Open price
CancelQty	int		Yes	At the event of a partial close, the remaining position size that will be opened as a new trade is the cancel quantity.
ProfitValue	decimal		Yes	Profit value
Reason	varchar		Yes	In case of trade rejection, error codes are listed here.
CloseQty	int		Yes	At the event of a partial close, the position size closed partially is the closed quantity.
PositionEffect	char		Yes	O = Open C = Closed
LinkedOrderID	varchar		Yes	It is the PK order ID of the coverage in current orders table.
SL	decimal		Yes	Stop loss
TP	decimal		Yes	Take profit
ClosePrice	decimal		Yes	Close price
CurrentAllocation	decimal		Yes	Current allocation
UsedMargin	decimal	((0))	Yes	Used margin
SlaveEquity	decimal		Yes	Equity of the slave
MasterEquity	decimal		Yes	Equity of the master
SlaveCurrency	varchar		Yes	Slave currency
MasterCurrency	varchar		Yes	Master currency
ClosePriceRequested	decimal		Yes	Request close price
PSType	int		Yes	1 = Fixed 2 = Percentage
PSValue	decimal		Yes	Profit share value
PSCommission	decimal		Yes
WalletPSCommission	decimal		Yes	Profit share commission in wallet account
RBType	int		Yes
RBValue	decimal		Yes
RBCommission	decimal		Yes
WalletRBCommission	decimal		Yes	Not in use
BSType	int		Yes	1 = Fixed 2 = Percentage
BSValue	decimal		Yes	Broker share value
BSCommission	decimal		Yes
WalletBSCommission	decimal		Yes	Broker share commission in wallet account
WalletCurrency	varchar		Yes	Currency of the wallet account
SwapType	int		Yes	0 = By point 1 = By money 2 = By interest 3 = By money in margin currency
Swap	decimal	((0))	Yes	Swap
SlaveContractSize	decimal	((0))	No	Contract size of the symbol in USD.
MasterContractSize	decimal	((0))	No	Master Contract Size
ReturnPerc	decimal	((0))	No	Return value in percentage.
RetunPercMapping	decimal	((0))	No	Mapping Return value in percentage.
VAMI	decimal	((0))	No	This field lists the VAMI, i.e., a measure to track the monthly performance of an investment.
MappingVAMI	decimal	((0))	No	This field lists the Mapping VAMI,
Profit_Mode	int	((0))	No	By default, it is 0.
ContractSize	decimal	((0))	No
ExternalSecurity	int	((0))	No
AllocationID	int		Yes