| Description |
h2. In table below, add
Conversion rate as numeric 4,4 (eg 1000 or .0001)
Market Symbol Code Char 5
h2.
h2. tblRKElectronicPricing
{color:#3b73af}Click here to expand i21 Brokerage Account{color}
||ID||Field||Data Type||Neg/Zero
Allowed
||Max Byte Size||Nullable, Default Value||Description||Field in Legacy||Remarks||
|01|intElectronicPricingID|INT| | |NOTNULL|internal PK| | |
|02|intConcurrencyID|INT| | |NOTNULL|Used for multi-user| | |
|03|intFutureMarketID|INT| | |NOTNULL|fk to tblRKFutureMarket
| | |
|04|intMarketExchangeID|INT| | |NOTNULL|fk to tblRKMarketExchange (replaces old free form text)| |NEW|
|05|strSybmolPrefix|NVARCHAR(5)| | |NOTNULL|EG: Z for Agricharts or @ for DTN
| | |
|06|intNumberofForwardPeriods|INT| | |NOTNULL, 0|How many trading periods ahead do we get prices for this commodity and makret.| | |
|07|intReturnCurrency|INT| | |NULL|What currency does this market return| | |
|08|intConvertCurrency|INT| | |NULL|What currency do we display/return this value in.| |
|