Coverage Orders

The Coverage Orders table explains the order details of coverage accounts. The fields for the CoverageOrders table are:

Table Name: CoverageOrders

Column Name	Data Type	Valid Values	Allow Nulls	Description
PK_OrderID	bigint identity		No	OrderID
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	varchar		Yes	External order ID of Abook (master). Bbook (inhouse order ID in the case of web trading platform)
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	(getutcdate())	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
TP	decimal		Yes
ClosePrice	decimal		Yes	Close price
ClosePriceRequested	decimal		Yes	Requested close price
ContractSize	decimal		Yes	Position size
Digit	int		Yes	digit
OpenOrigIDFix	varchar		Yes	External FIX ID generated when trade opens.
CloseOrigIDFix	varchar		Yes	FIX ID generated when trade is closed.