Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Primary Ticket Number
|
primary_ticket_number
|
char(12)
|
Yes
|
Revision
|
revision
|
char(3)
|
Yes
|
Product ID
|
product_id
|
char(20)
|
Yes
|
Other Party Code
|
other_party_code
|
char(12)
|
No
|
Transaction Type
|
transaction_type
|
char(6)
|
Yes
|
Comments
|
comments
|
varchar(80)
|
No
|
Delivery Code
|
delivery_code
|
varchar(8)
|
No
|
Payment Code
|
payment_code
|
varchar(8)
|
No
|
Contact
|
contact
|
varchar(31)
|
No
|
Custodian
|
custodian
|
char(6)
|
No
|
Is Back Office Pending
|
is_bop
|
tinyint
|
No
|
Outside Origination
|
outside_origination
|
tinyint
|
No
|
Is Approved
|
is_approved
|
tinyint
|
No
|
Is Internal Transfer
|
is_internal_transfer
|
tinyint
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Agent
|
agent
|
tinyint
|
No
|
Unsolicited
|
unsolicited
|
tinyint
|
No
|
Aggressor
|
aggressor
|
tinyint
|
No
|
Variable Rate
|
variable_rate
|
tinyint
|
No
|
Hold In Custody
|
hold_in_custody
|
tinyint
|
No
|
Year Basis
|
year_basis
|
tinyint
|
No
|
Facility
|
facility
|
tinyint
|
No
|
Floater Index
|
floater_index
|
tinyint
|
No
|
Coupon Frequency
|
coupon_frequency
|
tinyint
|
No
|
Posting Status
|
posting_status
|
tinyint
|
No
|
Average Price
|
average_price
|
float
|
No
|
Average Yield
|
average_yield
|
float
|
No
|
Average Concession
|
average_concession
|
float
|
No
|
Average Yield Call
|
average_yield_call
|
float
|
No
|
Forward Rate
|
forward_rate
|
float
|
No
|
Total Quantity
|
total_quantity
|
float
|
No
|
Total SEC Fees
|
total_sec_fees
|
float
|
No
|
Total Principal
|
total_principal
|
float
|
No
|
Total Accrued Interest
|
total_accrued_int
|
float
|
No
|
Is Accrued Interest Override
|
is_accrued_interest_override
|
tinyint
|
No
|
Total Taxes
|
total_taxes
|
float
|
No
|
Total Other Charges
|
total_other_charges
|
float
|
No
|
Total Sales Gross
|
total_sales_gross
|
float
|
No
|
Total Buy Gross
|
total_buy_gross
|
float
|
No
|
Commission Rate
|
commission_rate
|
float
|
No
|
Commission Amount
|
commission_amount
|
float
|
No
|
Commission Indicator
|
commission_indicator
|
varchar(1)
|
No
|
Settlement Exchange Rate
|
settle_exchange_rate
|
float
|
No
|
Desk Code
|
desk
|
char(4)
|
No
|
Industry
|
industry
|
char(6)
|
No
|
Settlement Currency
|
settlement_currency
|
char(3)
|
No
|
Trade Date
|
trade_date
|
datetime
|
No
|
Entry Date
|
entry_date
|
datetime
|
No
|
Stage
|
stage
|
char(6)
|
No
|
Settlement Date
|
settlement_date
|
datetime
|
No
|
Is SEC Override
|
is_sec_override
|
tinyint
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Rollout Date
|
rollout_date
|
datetime
|
No
|
Is Cancelled
|
is_cancelled
|
tinyint
|
No
|
Transactor ID1
|
transactor_id1
|
char(4)
|
No
|
Operator ID
|
operator
|
char(4)
|
No
|
Trader ID
|
trader
|
char(4)
|
No
|
Legal ID
|
legal
|
char(4)
|
No
|
Approved By ID
|
approved_by
|
char(4)
|
No
|
Legal Approval Date
|
legal_approval_date
|
datetime
|
No
|
Approved Date
|
approved_date
|
datetime
|
No
|
Active Calculation Value
|
active_calc_value
|
tinyint
|
No
|
Is Account Allocation
|
is_allocation
|
tinyint
|
No
|
Calculate SEC Fee
|
calc_sec_fee
|
tinyint
|
No
|
Trade Time
|
trade_time
|
smallint
|
No
|
Total Net Amount
|
total_net_amount
|
float
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
Is Private
|
is_private
|
tinyint
|
No
|
Include Commission
|
include_comm
|
tinyint
|
No
|
Commission Type
|
comm_type
|
char(6)
|
No
|
Is Deleted
|
is_deleted
|
tinyint
|
No
|
Coupon
|
coupon
|
float
|
No
|
Issue Date
|
issue_date
|
datetime
|
No
|
Maturity Date
|
maturity_date
|
datetime
|
No
|
Is Tri Party Repo
|
is_tri_party_repo
|
tinyint
|
No
|
MBS Principal Factor
|
mbs_principal_factor
|
float
|
No
|
Is Primary
|
is_primary
|
tinyint
|
No
|
Best Execution Type
|
best_execution_type
|
char(6)
|
No
|
Best Execution Details
|
best_execution_details
|
varchar(40)
|
No
|
Reference ID
|
reference_id
|
varchar(32)
|
No
|
Is Customer Side
|
is_customer_side
|
tinyint
|
No
|
Commission BP
|
commission_bp
|
float
|
No
|
Sales Points Factor
|
sales_points_factor
|
float
|
No
|
Has Sales Credit
|
has_sales_credit
|
tinyint
|
No
|
FIPS Status
|
fips_status
|
char(6)
|
No
|
Is Mark_To_Market
|
is_mark_to_market
|
tinyint
|
No
|
Send OS
|
send_os
|
tinyint
|
No
|
Is Not Calculable
|
is_not_calculable
|
tinyint
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
tckmast_entry_date_index
|
No
|
No
|
No
|
No
|
No
|
ASC
|
tckmast_trade_date_index
|
No
|
No
|
No
|
No
|
No
|
ASC
|
pk_tckmast
|
Yes
|
No
|
No
|
Yes
|
Yes
|
ASC ASC |
tckmast_last_update_index
|
No
|
No
|
No
|
No
|
No
|
ASC
|
tckmast_reference_id_index
|
No
|
No
|
No
|
No
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
code
|
bestexec
|
best_execution_type
|
other_party_code
|
opmast
|
other_party_code
|
product_id
|
product
|
product_id
|
code
|
tckstage
|
stage
|
code
|
transtyp
|
transaction_type
|