TradeSuite ID BTI Allocation Export Profile Fields

The next table shows the selected fields for export for the Allocation Export profile available in BTI. The Order column in the table corresponds with the columns in the Microsoft Excel spreadsheet that is available for download. You cannot modify or delete the Allocation Export predefined profile.

Table 5  Allocation Export profile fields
Order Field Description Field Type Format Length Code Field Type Code Format Code Length
A Executing Broker Number ID number of the executing broker. Value Text 8      
B Institution Number ID number of the institution. Value Text 10      
C Agent Number ID number of the agent. Value Text 8      
D Security Identifier Security identification number assigned to the traded security. Value Text 12      
E Common Security Numbering System National or user-originated numbering system associated with the security identifier. Description Text 10 Code Text 2
F Security Type Type of expanded security that is the subject of the trade. Description Text 10 Code Text 3
G Side BUY or SELL, indicating whether the institution bought or sold the underlying securities. Description Text 10 Code Text 1
H Settlement Location Country or depository where the security is to settle. Outside of the US, settlement locations are by country, except for Euroclear and CEDEL (Clearstream). Description Text 40 Code Text 3
I Trade Date Date on which the transaction was executed as reported by the broker/dealer. Value Date 10      
J Settlement Date Date when the trade is due to settle. Value Date 10      
K Settlement Type

Indicates how the trade is to settle. Regular Way trades settle according to local market conventions. Other values are:

  • When-Issued
  • When-Distributed
  • When-Issued and When-Distributed
 Description Text 20 Code Text 1
L Share Quantity Face value of the shares when issued. Value Float 12.5f      
M Price Per Share Price per share at which this security was traded (exclusive of commission and other charges). Value Float 11.5f      
N Principal Amount Shares/face value multiplied by the price. Value Float 12.2f      
O International Currency Code representing the currency denomination of the trade and net amount. Description Text 10 Code Text 3
P Fee Statutory fee levied on the sale of equity securities registered on an exchange or certain equity securities in OTC markets in the United States. Value Float 7.2f      
Q Net Amount

Cash settlement amount which is the sum of the principal amount and interest, plus or minus the following cash fields:

  • Registration/Shipping or Fees 
  • Research Amount
  • Country Tax
  • Commission
  • Other Charges
 Value Float 12.2f      
R Commission Fee, either directly charged or allocated to this transaction, that the broker/dealer charged to its customer. Value Float 7.2f      
S Broker Dealer Account Number Broker/dealer account number. Value Text 35      
T Institution Internal Account Number Institution internal account number. Value Text 35      
U Agent Internal Account Number Agent internal account number. Value Text 35