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 | |||
| 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 | |||
| 7 | ACCRUED_INTEREST | INCOME | INCOME |
| BASEINTERESTADJ | INCOME_AMOUNT_BASE | INCOME_AMOUNT_BASE | |
| 8 | (no fields) | UNITS | UNITS |