Note
This page is relevant for Warehouse Trade, Traded Cash Activity, and Settled Cash Activity extracts only.
Field Group Number | Warehouse Trade Fields | Traded CA Fields | Settled CA Fields |
---|---|---|---|
1 | NET_CASH | AMOUNT | AMOUNT |
TRADE_BASE_AMOUNT | NET_AMOUNT_BASE | NET_AMOUNT_BASE | |
SETTLE_AMOUNT_LOCAL | SETTLE_AMOUNT_LOCAL | ||
REC_PAY_AMT_B | REC_PAY_AMT_B | ||
REC_PAY_AMT_L | REC_PAY_AMT_L | ||
2 | COST_BASE | (no fields) | (no fields) |
COST_LOCAL | |||
ORIG_ACQ_COST_BASE | |||
ORIG_ACQ_COST_LOCAL | |||
PAR_OR_SHARES | |||
3 | PRINCIPAL | PRINCIPAL | PRINCIPAL |
PRINCIPAL_BASE | PRINCIPAL_AMOUNT_BASE | PRINCIPAL_AMOUNT_BASE | |
4 | BASE COMMISSION AMOUNT | COMM_AMT_B | COMM_AMT_B |
LOCAL_COMMISSION_AMOUNT | COMM_AMT_L | COMM_AMT_L | |
EXCHANGE_FEE | OTHER_FEE_B | OTHER_FEE_B | |
EXCHANGE_FEE_BASE | OTHER_FEE_LOCAL | OTHER_FEE_LOCAL | |
OTHER_FEE | RECLAIM_AMOUNT_BASE | RECLAIM_AMOUNT_BASE | |
OTHER_FEE_BASE | RECLAIM_L | RECLAIM_L | |
SEC_FEES | SEC_FEE | SEC_FEE | |
SEC_FEES_BASE | SEC_FEE_B | SEC_FEE_B | |
TAXES | STAMP_DUTY_TAX_B | STAMP_DUTY_TAX_B | |
TAXES_BASE | STAMP_DUTY_TAX_L | STAMP_DUTY_TAX_L | |
TAX_AMT_B | TAX_AMT_B | ||
TAX_AMT_L | TAX_AMT_L | ||
TAX_EXPENSE_BASE | TAX_EXPENSE_BASE | ||
WITHHOLDING_L | WITHHOLDING_L | ||
5 | CURRENCY_GAIN | GAIN_CURRENCY | GAIN_CURRENCY |
SECURITY_GAIN | GAIN_SWAP_B | GAIN_SWAP_B | |
TOTAL_GAIN_LOCAL | GAIN_SWAP_L | GAIN_SWAP_L | |
TOTAL_GAIN | (no fields) | (no fields) | |
ST_GAIN_SEC_L | |||
ST_GAIN_SEC_B | |||
ST_GAIN | |||
ST_GAIN_CRRCY | |||
LT_GAIN_SEC_L | |||
LT_GAIN_SEC_B | |||
LT_GAIN | |||
LT_GAIN_CRRCY | |||
GAIN_CRRCY_988 | |||
6 | CURRENCY_LOSS | LOSS_CURRENCY | LOSS_CURRENCY |
SECURITY_LOSS | LOSS_SWAP_B | LOSS_SWAP_B | |
TOTAL_LOSS | LOSS_SWAP_L | LOSS_SWAP_L | |
TOTAL_LOSS_LOCAL | (no fields) | (no fields) | |
ST_LOSS_SEC_L | |||
ST_LOSS_SEC_B | |||
ST_LOSS | |||
ST_LOSS_CRRCY | |||
LT_LOSS_SEC_L | |||
LT_LOSS_SEC_B | |||
LT_LOSS | |||
LT_LOSS_CRRCY (no signage logic currently) | |||
LOSS_CRRCY_988 (no signage logic currently) | |||
7 | ACCRUED_INTEREST | INCOME | INCOME |
BASEINTERESTADJ | INCOME_AMOUNT_BASE | INCOME_AMOUNT_BASE | |
CLS_AMORT_LOCAL | (no fields) | (no fields) | |
CLS_AMORT_BASE | |||
CLS_OID_L | |||
CLS_OID_B | |||
CLS_ILB_INC_LTD_LOCAL | |||
CLS_ILB_INC_LTD_BASE | |||
8 | (no fields) | UNITS | UNITS |