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?