Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Desk Code
|
desk_code
|
char(4)
|
Yes
|
Account Code
|
acct_code
|
char(12)
|
Yes
|
Product ID
|
product_id
|
char(20)
|
Yes
|
Type Indicator
|
type_indicator
|
char(6)
|
Yes
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Hidden
|
hidden
|
tinyint
|
No
|
Last Settlement Date
|
last_settle_date
|
datetime
|
No
|
Average Cost
|
average_cost
|
float
|
No
|
Trade Qty
|
trade_qty
|
float
|
No
|
Settlement Qty
|
settle_qty
|
float
|
No
|
Average Price
|
average_price
|
float
|
No
|
Average Yield
|
average_yield
|
float
|
No
|
Average Concession
|
average_conc
|
float
|
No
|
Sales Gross
|
sales_gross
|
float
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Direction
|
direction
|
varchar(1)
|
No
|
Industry
|
industry
|
char(6)
|
No
|
Closed Quantity
|
closed_quantity
|
float
|
No
|
Closed Funds Buy USD
|
closed_funds_buy_usd
|
float
|
No
|
Closed Funds Buy Native
|
closed_funds_buy_native
|
float
|
No
|
Closed Funds Sell USD
|
closed_funds_sell_usd
|
float
|
No
|
Closed Funds Sell Native
|
closed_funds_sell_native
|
float
|
No
|
Buy Rate
|
buy_rate
|
float
|
No
|
Offer Rate
|
offer_rate
|
float
|
No
|
Reval Rate
|
reval_rate
|
float
|
No
|
Issue Date
|
issue_date
|
datetime
|
No
|
Settle Date
|
settle_date
|
datetime
|
No
|
Mat Date Short
|
mat_date_short
|
datetime
|
No
|
Mat Date Long
|
mat_date_long
|
datetime
|
No
|
Is Primary
|
is_primary
|
tinyint
|
No
|
Best Efforts
|
best_efforts
|
tinyint
|
No
|
Link ID
|
link_id
|
tinyint
|
No
|
Comments
|
comments
|
varchar(60)
|
No
|
Effective Mat Days
|
effective_mat_days
|
smallint
|
No
|
Accrued Interest
|
accrued_interest
|
float
|
No
|
After Tax Yield
|
after_tax_yield
|
float
|
No
|
Is Bluelist
|
is_bluelist
|
tinyint
|
No
|
Offer Price
|
offer_price
|
float
|
No
|
Offer Concession
|
offer_conc
|
float
|
No
|
Active Calc Value
|
active_calc_value
|
tinyint
|
No
|
Street Price
|
street_price
|
float
|
No
|
Street Yield
|
street_yield
|
float
|
No
|
Street Conc
|
street_conc
|
float
|
No
|
Creation Date
|
creation_date
|
datetime
|
No
|
Is Firm
|
is_firm
|
tinyint
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_currposn
|
Yes
|
Yes
|
No
|
Yes
|
Yes
|
ASC ASC ASC ASC |
index_currposn_trade_qty
|
No
|
No
|
No
|
No
|
No
|
ASC
|
index_currposn_mat_date_short
|
No
|
No
|
No
|
No
|
No
|
ASC
|
index_currposn_offer_rate
|
No
|
No
|
No
|
No
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
acct_code
|
account
|
acct_code
|
code
|
postype
|
type_indicator
|
desk_code
|
tradedsk
|
desk_code
|