Database Table "hyp_Foreign Exchange Trades"

Table Description

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Hyper Trade ID Integer 0 Edit Read Only
Key Field
HyperTradeID
Phase 2 Trade ID Integer 0 Edit Read Only Phase2TradeID
Trade Type Status 0 Select Mandatory TradeType
Command Status 0 Select Mandatory Command
NDF / CFD Trade Bool 0 Select NDFCFDTrade
ccy1 String 5 Select Mandatory Ccy1
ccy2 String 5 Select Mandatory Ccy2
Exchange Rate Real 0 Edit Mandatory /G:2 ExchangeRate
Interest (pips) Real 0 Edit InterestPips
Final Rate Real 0 Edit Read Only FinalRate
Order ccy1 Amount Real 0 Edit Mandatory /G:1 OrderCcy1Amount
Order ccy2 Amount Real 0 Edit Mandatory /G:1 OrderCcy2Amount
BK Entry Date Date 0 SelectEdit Mandatory BKEntryDate
Cash Flow Date Date 0 SelectEdit Mandatory CashFlowDate
Final ccy1 Volume Real 0 Edit Read Only FinalCcy1Volume
Final ccy2 Volume Real 0 Edit Read Only FinalCcy2Volume
Trading Account Name String 90 PopupList Mandatory TradingAccountName
Hyper Trading Account No. Integer 0 Edit Read Only HyperTradingAccountNo
Client Nickname String 40 Edit Read Only ClientNickname
Contact Person String 100 PopupList ContactPerson
Open Time FixDT 0 SelectEdit Read Only OpenTime
Close Time FixDT 0 SelectEdit Read Only CloseTime
Option Strike Real 0 Edit Mandatory /G:2 OptionStrike
Option Expiry Date 0 SelectEdit OptionExpiry
Option Price Real 0 Edit OptionPrice
Option Price Method
Values List:
pips
percent
Status 0 Select OptionPriceMethod
Premium Money 0 Edit Read Only Premium
Premium ccy String 5 Select PremiumCcy
Premium Date Date 0 SelectEdit PremiumDate
Exotic Option 1 Status 0 Select ExoticOption1
Trigger 1 Real 0 Edit Trigger1
Exotic Option 2 Status 0 Select ExoticOption2
Trigger 2 Real 0 Edit Trigger2
Option Result
Values List:
-N/A-
Waiting for Knock In
Waiting for Expiry
Carried Out
Gave Up
Status 0 Select Read Only OptionResult
Market Rate Real 0 Edit MarketRate
Market Profit ccy2 Money 0 Edit Read Only MarketProfitCcy2
Market Profit LC Money 0 Edit Read Only MarketProfitLC
Representative Rate Real 0 Edit Read Only RepresentativeRate
Profit on ccy2 Money 0 Edit Read Only ProfitOnCcy2
Profit LC Money 0 Edit Read Only ProfitLC
Margin Demands % Real 0 Edit MarginDemands
Margin (ccy2) Money 0 Edit Read Only MarginCcy2
Margin LC Money 0 Edit Read Only MarginLC
Commission Catalogic Number String 30 PopupList CommissionCatalogicNumber
Commission Description String 100 Edit CommissionDescription
Commission Price Money 0 Edit CommissionPrice
Commission ccy String 5 Select CommissionCcy
Commission in Deposit ccy Money 0 Edit Read Only CommissionInDepositCcy
NDF / CFD Trade - Accounting ccy String 5 Select NDFCFDTrade-AccountingCcy
Comments String 300 Memo Comments
Last Update FixDT 0 SelectEdit Read Only LastUpdate
Created By String 40 Edit Read Only CreatedBy
Money IN From String 100 PopupEdit MoneyINFrom
Money IN To String 100 PopupEdit MoneyINTo
Money IN to Account Integer 0 Edit Hidden
Read Only
MoneyINToAccount
Money OUT From String 100 PopupEdit MoneyOUTFrom
Money OUT from Account Integer 0 Edit Hidden
Read Only
MoneyOUTFromAccount
Money OUT To String 100 PopupEdit MoneyOUTTo
Office Management Step
Values List:
None
Waiting for Backoffice
Waiting for Margin Deposit
Waiting for Due Date
Waiting for NDF / Option Feedback !
Print order to bank
Send order to bank
Waiting for bank Execution
Done
Status 0 Select OfficeManagementStep
Order Doc sent to Client on FixDT 0 SelectEdit Read Only OrderDocSentToClientOn
Order Doc sent to Client by String 40 SelectEdit Read Only OrderDocSentToClientBy
Money IN Confirmation FixDT 0 SelectEdit Read Only MoneyINConfirmation
Money IN Confirmation by String 40 SelectEdit Read Only MoneyINConfirmationBy
Money OUT Doc Sent to Bank FixDT 0 SelectEdit Read Only MoneyOUTDocSentToBank
Money OUT Doc Sent to Bank by String 40 SelectEdit Read Only MoneyOUTDocSentToBankBy
Money OUT Done by Bank FixDT 0 SelectEdit Read Only MoneyOUTDoneByBank
Money OUT Done Verified by String 40 SelectEdit Read Only MoneyOUTDoneVerifiedBy
Rollover Bool 0 Select Read Only Rollover
Tax Process UTC FixDT 0 SelectEdit Read Only TaxProcessUTC
Print Ticket Flag Bool 0 Select Read Only PrintTicketFlag
Doc Language Status 0 Select Read Only DocLanguage
ccy Pair String 10 Edit Read Only CcyPair
Trade Volume USD Money 0 Edit Read Only TradeVolumeUSD
Jump to tables index