Current Orders Transactions
The B-Book Qty Trades table lists information about the B-book trades. The fields for the B-Book Qty Trades table are:
Table Name: CurrentOrdersTransactions
Column Name
Data Type
Valid Values
Allow Nulls
Description
PK_OrderID
bigint identity
No
ClOrdID
varchar
No
LPOrdID
varchar
Yes
OrigOrdID
varchar
Yes
FK_AccountID
int
No
PositionSize
bigint
Yes
Price
decimal
Yes
StopPx
decimal
Yes
FK_OrderType
int
No
FK_OrderStatusID
int
No
FK_Side
int
No
OrderDateTimeRequested
datetime
(getutcdate())
Yes
Contract
varchar
Yes
Product
varchar
Yes
FK_TIF
int
No
LastUpdateTime
datetime
(getutcdate())
Yes
IPAddress
varchar
Yes
CancelRejectReason
int
Yes
GTD
datetime
(getutcdate())
Yes
FilledQty
int
Yes
LeaveQty
int
Yes
AvgFillPRice
decimal
Yes
CancelQty
int
Yes
ProfitValue
decimal
Yes
UsedMargin
decimal
Yes
ReserveMargin
decimal
Yes
FK_OCO_ID
bigint
Yes
FK_OSO_ID
bigint
Yes
Reason
varchar
Yes
CloseQty
int
Yes
CloseOrderSent
int
Yes
ExpiryDate
datetime
(getutcdate())
Yes
DiscloseQty
bigint
Yes
PositionEffect
char
Yes
AccountType
varchar
Yes
EnteredBy
varchar
Yes
ClientName
varchar
Yes
Client
varchar
Yes
Commission
decimal
Yes
Tax
decimal
Yes
SettledQty
int
Yes
QtyClosed
bigint
Yes
LinkedOrderID
varchar
Yes
SL
decimal
Yes
TP
decimal
Yes
ClosePrice
decimal
Yes
FK_TCOrderID
bigint
No
Last updated
Was this helpful?