Confirm Export Profile Fields

The following table shows the selected fields for the default export profile, Confirm Export. 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 Confirm Export predefined profile.

Table 3  Confirm Export Profile Fields
Order Field Name
 Description Field Type Format Length Code Field Type Code Format Code Length
A DTC Control Number Unique control number to identify the trade. Value Text 9      
B Trade Status Status of the trade. Description Text 20 Code Text 1
C Executing Broker Number ID number of the executing broker. Value Text 8      
D Executing Broker Name Name of the executing broker. Value Text 40      
E Clearing Broker Number ID number of the clearing broker. Value Text 8      
F Trade Date Date on which the transaction was executed as reported by the broker/dealer. Value Date 10      
G Settlement Date Date when the trade is due to settle. Value Date 10      
H Side Sell (1) or Buy (2), indicating whether the institution bought or sold the underlying securities. Description Text 10 Code Text 1
I Security Type Type of expanded security that is the subject of the trade. Description Text 10 Code Text 3
J Security Identifier Security identification number assigned to the traded security. Value Text 12      
K Price Per Share Price per share at which this security was traded (exclusive of commission and other charges). Value Float 11.5f      
L Principal Amount Shares/face value multiplied by the price. Value Float 12.2f      
M 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      
N 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      
O Commission Fee, either directly charged or allocated to this transaction, that the broker/dealer charged to its customer. Value Float 7.2f      
P Institution Name Name of the institution. Value Text 40      
Q Institution Number ID number of the institution. Value Text 10      
R Agent Number ID number of the agent. Value Text 8      
S Agent Name Name of the agent. Value Text 40      
T 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
U Account Found Yes/No indicator if an ALERT® account was found. Description Text 8 Code Text 1
V Accrued Interest Accrued interest amount due at maturity. Value Float 9.2f      
W Agent Internal Account Number Internal account number of the agent. Value Text 35      
X Confirm Purpose Reason for the confirmation message or reason why a confirm is being issued. Description Text 35 Code Text 2
Y Current Yield Annual percentage return. Value Float 11.5f      
Z Disclosure Link Path to view the confirm disclosure. Value Text 50      
AA Disclosure Reference Number Reference number of the disclosure. Value Text 16      
AB Institution Internal Account Number Internal account number of the institution. Value Text 16      
AC International Currency Code that represents the currency denomination of the trade and net amount. Description Text 10 Code Text 3
AD Security Description Name or description of the traded security. Value Text 78      
AE Settlement Mode DTC settlement mode. Description Text 10 Code Text 1
AF Share Quantity Face value of the shares when issued. Value Float 12.5f      
AG User Disclosure Code User-defined code used in the confirm backer/disclosure enrichment. It is broker/dealer supplied data that also resides on the backer/disclosure repository as enrichment criteria. Value Text 17      
AH Eligibility Type Indicates the trade's eligibility status for settlement at DTCC. Description Text 20 Code Text 1
AI Interested Party 1 Number Identification number of the interested party 1 or broker sub-custodian. Value Text 8      
AJ Interested Party 1 Name Identification name of the interested party 1 or broker sub-custodian. Value Text 40