Database
  • Introduction
  • Database Design
    • Primary Tables
      • Accounts
      • Account Groups
      • Account Group History
      • Account Transaction History
      • Account Metrics Per Master Slave
      • Account Daily Return Detail
      • Account Introducer Map Log
      • Gateways
      • Gateway Components
      • Component-Gateway Mapping
      • Coverage Orders
      • Current Orders
      • Fund Fee Mapping
      • GlobalHealth Monitor
      • Master Fee Mapping
      • Master Broker Fee Mapping
      • Master Slave Mapping History
      • Slave Orders
      • Trade API GUID
    • Common Tables
      • Account Validation History
      • Account Group Asset Mapping
      • Application Log
      • Account Type
      • Account Transaction History For Deployment Server
      • ATT Operation
      • Activity Log
      • Account Group History
      • Account Metrics
      • Accounts History
      • ATT Trade Analysis
      • Auto Testing Logs
      • AT Configuration History
      • Application State Log
      • Account DD Audit
      • AT Instance History
      • Asset Class Type
      • Account Analytics
      • Account Equity
      • B-Book Qty Trades
      • Basket Slave Mapping
      • Basket Fund
      • Basket Master Mapping
      • Basket Cash Mapping
      • Basket Product Type
      • Broker Master Commission Mapping
      • Broker Asset Mapping
      • Basket Instrument Mapping
      • Calculation Mode
      • Currency
      • Connection State Log
      • Commission TS Security Mapping
      • Component Type
      • Current Orders Transactions
      • Commission Profile
      • Connection Setting
      • Copy Missed Reject Trades Request
      • Currency USD Conversion
      • Default Fee Setting History
      • Default Fee Setting
      • Deployment Servers
      • Database State Log
      • Error Codes
      • External Security
      • Errors Trade Analysis
      • External Internal Security Mapping
      • Fix Connection Settings
      • Fee Setting
      • Fund Type
      • Fee Type
      • Feed Server Connection Mapping
      • Group Type
      • Group Security Mapping
      • Gateway Connections
      • Gateway Type
      • HTCA Request
      • HM User Account
      • Health Monitor
      • HTCA Calculation Dump
      • Introducer Broker Mapping
      • Introducer Transaction History
      • Introducer Broker Deal Amount
      • Instruments
      • Index Accounts Mapping History
      • Introducer Rebate Profile Mapping
      • Index Accounts Mapping
      • Introducer
      • Interval
      • Introducer Multi-Level Proposal
      • Master Profit-Share Security Mapping
      • Master Slave Broker-Share Mapping
      • Master Feed Profile Mapping
      • Maintenance Logs
      • Master Profit-Share
      • Master Slave Account Mapping
      • Master Slave Mapping Snapshot
      • Mutual Fund Request
      • Mapping Allocation History
      • Manage Lots
      • Order Execution Type
      • Order Route To Gateway
      • Order Routing Trade History Table
      • Order Archive
      • Order Side
      • Order Status Types
      • Order Types
      • Participant Account Type
      • PHP Request Error Log
      • Platform
      • Risk Profile
      • Rebate Profile
      • Rebate Profile Security Mapping
      • Risk Profile Master Mapping
      • Revenues For Deployment Server
      • Server Symbol Mapping
      • Slave Orders
      • Start-Stop Copy Logs
      • Synced Orders
      • Settings
      • Swap Audit
      • Technical Support Levels
      • Trade Type
      • TS Security Global
      • TS Security Local Global Map
      • TS Security
      • Test Table
      • Trade Analysis
      • Trade History
      • Trades Synced With MySQL
      • TIF
      • User Profile
      • UDP Components
      • UDP Message Log
      • Validation Check Params
Powered by GitBook
On this page

Was this helpful?

  1. Database Design
  2. Common Tables

Currency USD Conversion

The Currency USD Conversion table lists information about the B-book trades. The fields for the Currency USD Conversion table are:

Table Name: CurrencyUSDConversion

Column Name

Data Type

Valid Values

Allow Nulls

Description

PK_SymConv_ID

int identity

No

Currency

varchar

No

ConversionRate

decimal

((0))

No

LastUpdatedTime

datetime

(getutcdate())

No

PreviousCopy Missed Reject Trades RequestNextDefault Fee Setting History

Last updated 5 years ago

Was this helpful?