Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Primary Ticket Number
|
primary_ticket_number
|
char(12)
|
Yes
|
Ticket Number
|
ticket_number
|
char(12)
|
Yes
|
Revision
|
revision
|
char(3)
|
Yes
|
Account Code
|
acct_code
|
char(12)
|
Yes
|
Quantity
|
quantity
|
float
|
No
|
Price
|
price
|
float
|
No
|
Yield
|
yield
|
float
|
No
|
Has Remaining Quantity
|
has_remaining_quantity
|
tinyint
|
No
|
Active Calculation Value
|
active_calc_value
|
tinyint
|
No
|
Is Backoffice Pending
|
is_bop
|
tinyint
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Posting Status
|
posting_status
|
tinyint
|
No
|
Sales Gross
|
sales_gross
|
float
|
No
|
Buy Gross
|
buy_gross
|
float
|
No
|
Floater Index Spread
|
floater_index_spread
|
float
|
No
|
Sales Points Factor
|
sales_points_factor
|
float
|
No
|
Coupon
|
coupon
|
float
|
No
|
Concession
|
concession
|
float
|
No
|
Yield Call
|
yield_call
|
float
|
No
|
Principal
|
principal
|
float
|
No
|
Accrued Interest
|
accrued_interest
|
float
|
No
|
Commission Amount
|
commission_amount
|
float
|
No
|
SEC Fee
|
sec_fee
|
float
|
No
|
Realized P&L Value
|
realized_pl_value
|
float
|
No
|
Factor
|
factor
|
float
|
No
|
Remaining Quantity
|
remaining_quantity
|
float
|
No
|
Tax Amount
|
tax_amount
|
float
|
No
|
Other Charges Amount
|
other_charges
|
float
|
No
|
Cancelled Revision
|
cancelled_revision
|
char(3)
|
No
|
Is Cancelled
|
is_cancelled
|
tinyint
|
No
|
Calculate SEC Fee
|
calc_sec_fee
|
tinyint
|
No
|
Transaction Type
|
transaction_type
|
char(6)
|
Yes
|
Product ID
|
product_id
|
char(20)
|
No
|
Desk Code
|
desk
|
char(4)
|
Yes
|
Trade Date
|
trade_date
|
datetime
|
Yes
|
Settlement Date
|
settlement_date
|
datetime
|
No
|
Spot Rate
|
spot_rate
|
float
|
No
|
Position Average Cost
|
average_cost
|
float
|
No
|
Position Average Price
|
pos_average_price
|
float
|
No
|
Position Average Yield
|
pos_average_yield
|
float
|
No
|
Position Average Concession
|
pos_average_concession
|
float
|
No
|
Net Amount
|
net_amount
|
float
|
No
|
Other Party Code
|
other_party_code
|
char(12)
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Reference_ID
|
reference_id
|
varchar(12)
|
No
|
Trade Status
|
trade_status
|
char(6)
|
No
|
ID Control Number
|
id_control_number
|
varchar(20)
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_tckdtl
|
Yes
|
No
|
No
|
Yes
|
Yes
|
ASC ASC ASC |
tckdtl_prod_acct_desk_index
|
No
|
No
|
No
|
No
|
No
|
ASC ASC ASC ASC |
tckdtl_trade_status
|
No
|
No
|
No
|
No
|
No
|
ASC
|
tckdtl_settlement_date_index
|
No
|
No
|
No
|
No
|
No
|
ASC
|
tckdtl_other_party_code
|
No
|
No
|
No
|
No
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
acct_code
|
account
|
acct_code
|
product_id
|
product
|
product_id
|
code
|
trdstat
|
trade_status
|