Skip to main content

Order Completion

Data Dictionary - Entity Table: Order_Completion#

Table shows the working status of an order from the Order Table. The status can be any valid order life cycle management status, e.g. rejected, done for day. It holds information for executed fills and the end value of the transactions. Separate fills/transactions can be created based on limits on the traded quantities.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
DateDATETIMENULL10/10/2020 12:30:00 PMOrder completion date/time
StatusVARCHAR(42)NULLfilled;working;cancelled;rejected; completed;expiredOrder status - can show only status that means that part of the order is closed. One order can be completed with one completed fill and the remaining quantity rejected
Filled_QuantityDECIMALNULL243Filled quantity of the order
Remaining_QuantityDECIMALNULL546Remaining unfilled quantity of the order
AvgPriceDECIMALNULL12Average execution price
CurrencyBIGINT(12)NULL2Order currency
GrossValueDECIMALNULL2940Total value of the order: sum of order itself (net) plus charges (fees and comissions)
NetValueDECIMALNULL2916Net value of the order (without fees and comissions)
TotalChargesDECIMALNULL24Total sum of execution and other fees and comissions
ChargeCurrencyBIGINT(12)NULL1Fees and comissions currency. Can differ from the currency of the order
Currency(Currency)Currency (id)NO ACTIONNO ACTION
Charge_Currency(Charge_Currency)Currency (id)NO ACTIONNO ACTION
Currency_idxOrder_Completion(Currency ASC)VISIBLE.
Charge_Currency_idxOrder_Completion(ChargeCurrency ASC)VISIBLE.