Internet Dealer Commission User Guide-June2017

Financial Services
INTERNET DEALER COMMISSIONS

User Guide
June 16, 2017
DST Systems, Inc. (DST) has provided the information in this Reference Guide for general informational purposes only, has a right to alter it at any time, and does not
guarantee its timeliness, accuracy or completeness. All obligations of DST with respect to its systems and services are described solely in written agreements
between DST and its customers. This document does not constitute any express or implied representation or warranty by DST, or any amendment, interpretation or
other modification of any agreement between DST and any party. DST hereby disclaims all warranties, either express or implied, including the warranties of
merchantability and fitness for a particular purpose. In no event shall DST or its suppliers be liable for any damages whatsoever including direct, indirect, incidental,
consequential, loss of business profits or special damages, even if DST or its suppliers have been advised of the possibility of such damages."
©2017 DST Systems, Inc. All rights reserved. The trademarks and service marks of DST and its affiliates, and those of third parties, used herein are the property of
their respective owners.
DST Systems, Inc.
333 W. 11th
Kansas City, MO 64105
www.dstsystems.com
Contents
About This Guide ........................................................................................................................................................ 5
Administration ............................................................................................................................................................................... 5
Selection Criteria ........................................................................................................................................................................... 5
Downloading Internet Dealer Commission Files .................................................................................................................... 5
File Naming Convention .............................................................................................................................................................. 6
Interpreting Record Layouts ....................................................................................................................................................... 7
Locating More Information ......................................................................................................................................................... 8
Submitting Documentation Comments ................................................................................................................................... 8
1. Getting Started ....................................................................................................................................................... 9

Sign In Page ................................................................................................................................................................................ 10
My Directory Page ..................................................................................................................................................................... 11
My CSV Directory Page............................................................................................................................................................. 13
My PDF Directory Page ............................................................................................................................................................. 15
2. Using the IDC Website ....................................................................................................................................... 20

Logging Onto the IDC Website ................................................................................................................................................ 21
Changing Your Password......................................................................................................................................................... 22
Downloading Files From the IDC Website ............................................................................................................................ 23
Restoring Previously Downloaded Files ................................................................................................................................ 24
Removing Files From the My Directory Page ....................................................................................................................... 26
3. Cross-Referencing Customer Registrations and Transactions with Commissions .............................. 27

FAN Mail Data Feeds ................................................................................................................................................................ 27
Internet Dealer Commission Plus ........................................................................................................................................... 28
4. IDC Record Layouts ............................................................................................................................................ 29

Header Record ........................................................................................................................................................................... 29
Header (Record 1 of 1) ............................................................................................................................................................. 29
Trailer Record ............................................................................................................................................................................. 29
Commission (Record 1 of 1) ................................................................................................................................................... 30
12b-1 (Record 1 of 1) ................................................................................................................................................................ 32
Commission History Record Redefines (Record 1 of 1) .................................................................................................... 34
Reclaim Record Redefines (Record 1 of 1) ........................................................................................................................... 35
TRAC Record Redefines (Record 1 of 1) ............................................................................................................................... 36
3
Internet Dealer Commissions User Guide
Contractual Record Redefines (Record 1 of 1) .................................................................................................................... 38

Multiple Trailer Fees Record Redefines (Record 1 of 1) ..................................................................................................... 40
Optional DFA Cross-Reference Record Redefines (Record 1 of 1) ................................................................................. 41
Commission Fee Type Identification Record Redefines (Record 1 of 1) ........................................................................ 42
Annuity Commission (Record 1 of 1) ..................................................................................................................................... 44
Appendix A. DSTHTTPDL Download Manager .................................................................................................. 46

ActiveX Download Manager .................................................................................................................................................... 46
Properties .................................................................................................................................................................................... 48
Methods ...................................................................................................................................................................................... 49
Events (Asynchronous Mode Only) ........................................................................................................................................ 51
Example HTML ........................................................................................................................................................................... 52
Appendix B. Social Codes ...................................................................................................................................... 57

General Social Codes ................................................................................................................................................................ 57
Restricted Social Codes ........................................................................................................................................................... 60
Special Accounts Social Codes .............................................................................................................................................. 62
Appendix C. Commission Basis Reason Code List........................................................................................... 64
Appendix D. Product Type Codes......................................................................................................................... 70
Appendix E. Revisions ............................................................................................................................................ 71
Glossary ....................................................................................................................................................... 72
Index ....................................................................................................................................................... 75
4
About This Guide

DST Internet Dealer Commissions (IDC) is an automated file delivery system for Commission/Trail data. This data is
generated by the Product Companies record keeping platform at their discretion and distributed by DST.
Administration
The DST IDC department is structured to handle technical and non-technical user inquiries. The department also serves as a
central administrative hub for all of the mutual funds, alternative investments, and variable annuities available through the
service. All requests for access are directed to the DST IDC department. This enables the IDC group to track the exact status
of all requests for both the product company and the financial institution.
In addition to providing user access, the IDC department also assists users with the development of their interfaces. The IDC
group is available to help define and interpret the specific fields within the file.
Selection Criteria
Commission and Trailers data is downloaded based on an authorized financial institution number for specific product
company data. All commission related account activity for a specific financial institution number within a product company is
transmitted. All requests for access must receive the approval of the respective mutual fund, alternative investments, or
variable annuity company.
Downloading Internet Dealer Commission Files

All commission files are available on the IDC website located at www.dstidc.com. IDC users can download files using their
Internet browser or a script provided by DST. Both methods provide the same level of encryption (HTTPS/SSL) during file
transit.
Manual Website Download

When downloading files using an Internet browser, you are authenticated at the user log in window by entering a user ID and
password. After you have logged onto the IDC website, a list of available files to download appears. You can choose to
download files individually or all at once. You also can remove files.
Automated Website Download

You can automate the download process by downloading an ActiveX control script created by DST. The DSTHTTPDL ActiveX
control provides a method of downloading files from the IDC website. This program is scriptable and can be used as an
independent process or modified to be used with existing software. Your ID and password must be authenticated before you
can download files.
Warning: It is possible for a user to access the website twice in a 24-hour period and download the same file. DST
recommends that each user delete each file after it is successfully downloaded, or track the file names of successfully
downloaded files to ensure duplicate files are not downloaded.
5
File Naming Convention

Production Files
Production files use the following naming convention SYSMTXX.AXXXX.ZIP, where:
Position Description
1-5 The system and management code of the data provider. Each data provider has a unique system and management code
combination.
Contact the IDC group for a complete listing of the system and management codes.
6-7 File type

C1 Commission Text File
OR
6-7 File type

CX Comma Delimited File
OR
6-7 File type

CP PDF
8 A – Z = Production data files (except R = Resend data files)
9-12 XXXX is a unique number within a user’s directory intended to avoid overwriting existing files in that directory
Extension .ZIP (indicates a compressed ZIP file). This file is not password-protected.
In addition to the file name, a timestamp shows the date that IDC processed the data. A count of the total number of files
found on the website helps to insure that all files are successfully downloaded.
Resend Files
Resend files follow the same naming convention as Production files, but an ‘R’ is used to differentiate them from the
production files.
6
Uncompressed File Names

Production files use the following naming convention SYSMTXX.AXXXX.TXT and follow the format below.
Position Description
1-5 The system and management code of the data provider. Each data provider has a unique system and management code
combination.
Contact the IDC group for a complete listing of the system and management codes.
6-7 File type

C1 Commission Text File
8 A – Z = production (except R = resend)
9-12 XXXX is a unique sequential number within a user’s directory intended to avoid overwriting existing files in that directory
Extension .TXT (indicates an ASCII text file)

.CSV (indicates Comma Delimited file)
.PDF (indicates Portable Document Format)
Interpreting Record Layouts

Record layouts in this manual use the format shown in the following diagram. Letters A–J in the Record Layout Field
Descriptions table correspond to the letters in the following diagram.
Name of Record
AAAAAAAAAAAAAAA
BBBB Record C of D
Start End Length Data/Type Description
E F G HHHHH IIIIIIIIIIIIIIIIIIIIIIIII
JJJJJJJJJJJJJJJJJJJJJJ
Figure 1 Record Layout diagram
A Indicates special information or comments regarding the sequence or fields within the sequence.
B Indicates the type of record defined (Header, Detail, or Trailer).
C Indicates the sequence number of the record (1 = first record, 2 = second record).
D Indicates the total number of records in the sequence (for example, 6 = six records).
E Indicates the first byte in the field or starting position of the data.
F Indicates the last byte in the field or ending position of the data
G Describes the total number of bytes or length of the field.
H Indicates the type of data in the field (alphabetic, alphanumeric, or numeric).
I Indicates the contents or description of the field.
J If there are various options available for the field description, each option is identified and defined.
7
Locating More Information

Additional information about Internet Dealer Commissions (IDC) is available from the IDC department at (844) 279-2005 or
[email protected].
Submitting Documentation Comments

DST makes every effort to ensure the accuracy of this guide and its contents. If you have comments, questions, or ideas
regarding this guide, please contact DST Technical Communications at [email protected].
Include the following information with your correspondence:
• Title of the guide and date on the cover
• Document section, chapter, and page number
• Your suggestion for how to correct or improve documentation
Note: This email address is only for documentation feedback. Contact your Client Relations representative for product
support.
8
1. Getting Started
Retrieval of your firm’s Internet Dealer Commissions (IDC) data files is done through the IDC website at www.dstidc.com.
This process is secured and by following the steps described below it is simple to accomplish.
For more information on the… See…
Sign In Page Page 10
My Directory Page Page 11
My CSV Directory Page Page 13
My PDF Directory Page 15
My File History Page Page 18
9
Sign In Page
The Sign In page enables you to access your IDC data files. For more information on accessing Internet Dealer Commissions,
see Logging Onto the IDC Website on page 21.
Figure 2. Internet Dealer Commissions Sign In page
Field Descriptions
ID Enter your IDC user ID in this box.
Password Enter your IDC password in this box.
Button\Link Descriptions
Sign In Display the IDC My Directory page after you enter your user ID and password.
Enroll Allow Home Office associates to enroll to receive IDC files.
Participating Companies A list of the management companies that deliver their commission and trailer/12b-1 data through
the Internet Dealer Commissions product.
CUSIP Information Lists out all of the fund details for each of the participating companies.
Software Vendors A list of the compatible software vendors that are able to read/interpret the commission data.
Contact Us Request additional management companies; send comments, feedback, or general questions by email to the
IDC website administrator.
Forgot ID? Click this link to display a form to provide your information, this provides the
self-service security questions. Upon answering the questions you will receive your IDC ID.
Forgot Password? Click this link to display a form to provide your information, this provides the self-service security
questions. Upon answering the questions you can reset your password.
10
My Directory Page
The My Directory page enables you to download or remove the text (.TXT) version of files from your IDC directory.
Figure 3. Internet Dealer Commissions My Directory page
Field Descriptions
Page Header
Sign Out Log off the Internet Dealer Commissions website and display the Sign In page.
Participating Companies List the management companies that delivers their commission and trailer/12b-1 data through
the Internet Dealer Commissions Product.
Help Access the Help system to assist with IDC file layouts.
User Profile Details
This section, displays your firm’s primary contact information attached to the user ID. Profile information includes the
following:
• Name
• Address
• Company
• Phone number
11
• Fax number
• E-mail
• Software interpreting data feeds
File List
Total Number of files available for retrieval.
File Name All IDC files use the naming convention SYSMTC1.AXXXX.ZIP. For more information, see File Naming
Convention on page 6.
Date/Time The date and time the file was placed in the IDC directory.
• File Activity Indicator A check box to the right of the File Name and Date/Time fields to select files to download or
remove.
Download To Enables you to enter the drive and folder to which the selected files are downloaded. For example, C:\2006
DEALER COMMISSIONS.
Button/Link Descriptions
Download button Download selected files. For more information on downloading files, see Downloading Files From the IDC
Website on page 23.
Remove button Delete selected files. For more information on removing files, see Removing Files From the My Directory
Page on page 26.
Check All Select all available files.
Uncheck All Deselect all available files.
Update Registration Allow IDC users to maintain the most up-to-date contact details.
Change Password Allow IDC users to change their password.
Add/Update Access Allow IDC users to request access to more data providers.
12
My CSV Directory Page

The My CSV Directory page enables you to download or remove the Comma Delimited (.CSV) version of files from your IDC
directory.
Figure 4. Internet Dealer Commissions My File History page
Field Descriptions
Page Header
Participating Companies List the management companies that deliver their commission and trailer/12b-1 data through the
Internet Dealer Commissions Product.
This section displays your firm’s primary contact information attached to the user ID. Profile information includes the
following:
• Name
• Address
13
• Company
• Phone number
• Fax number
• E-mail
File List
Mgmt Company The name of the management company the file is related to.
Records The total number of records within the file.
Activity Date The date the commission activity took place.
File Name All IDC files use the naming convention SYSMTCX.AXXXX.ZIP. For more information, see File Naming
remove.
DEALER COMMISSIONS.
Website on page 23.
Page on page 26.
Update Software Vendor Allow IDC users to change their software vendor.
Review Current Access Allow IDC users to review their current approved, denied, and pending access requests.
14
My PDF Directory Page

The My PDF Directory page enables you to download, view or remove the Portable Document Format (.PDF) version of files
from your IDC directory.
Important: The PDF file is not available for files that are over 3,500 lines of detail.
Figure 5. Internet Dealer Commissions My PDF Directory page
Field Descriptions
Page Header
Participating Companies List the management companies that deliver their commission and trailer/12b-1 data through the
Internet Dealer Commissions Product.
Contact Us Request additional management companies, send comments, feedback, or general questions by email to the
15
This section displays your firm’s primary contact information attached to the user ID. Profile information includes the
following:
• Name
• Address
• Company
• Phone number
• Fax number
• E-mail
File List
Mgmt Company The name of the management company the file is related to.
Records The total number of records within the file.
Activity Date The date the commission activity took place.
File Name All IDC files use the naming convention SYSMTCX.AXXXX.ZIP. For more information, see File Naming
remove.
DEALER COMMISSIONS.
Website on page 23.
Page on page 26.
View Allow IDC users to view the PDF file prior to downloading.
16
Update Software Vendor Allow IDC users to change their software vendor.
Review Current Access Allow IDC users to review their current approved, denied, and pending access requests.
17
My File History Page

The My File History page enables you to restore IDC files downloaded within the last 45 days.
Field Descriptions
Page Header
Participating Companies Lists the management companies that deliver their commission and trailer/12b-1 data through
the Internet Dealer Commissions Product.
18
My File History Filter Selection
The shaded area of this page enables you to filter the files that appear in your file history listing.
Management Company Filter Click the arrow in this box to select the management company files you want to view. You
can select an individual management company or view all companies by selecting All Management Companies.
All Dates Select this option if you want to view all files from the last 45 days.
Note: You cannot use the From: and To: date range fields if you have selected the All Dates option.
From Select this option if you want to view files from a specific date range. Enter the start date
(MM/DD/CCYY format) of the range in this field.
To Enter the end date (MM/DD/CCYY format) of the range in this field.
Note: You cannot use the All Dates option if you have selected the From: and To: option.
Retrieve button View the results of the search query you specified.
File List
Files Displayed The number of files that matched your specified search criteria.
Mgmt Company Name of the management company sending the data.
Records Number of lines in the file.
Activity Date Identifies the management company’s ending commission cycle run period for which commission details
records are represented within the file.
File Name The original name of the data file delivered. All IDC files use a standard naming convention: For more information
on the file naming convention, see File Naming Convention on page 6.
Date/Time The date the file was originally downloaded.
File Activity Indicator A check box to the right of the File Name and Download Date. Select this box to move a single or
multiple files to the My Directory page. This enables you to download the files again.
Restore Files Move the selected files to the My Directory page.
Uncheck All Deselect all available files
19
2. Using the IDC Website

This section describes how to perform routine tasks on the Internet Dealer Commissions (IDC) website. This includes:
For more information… See…
Logging Onto the IDC Website page 21
Changing Your Password page 22
Downloading Files From the IDC Website page 23
Restoring Previously Downloaded Files page 24
Removing Files From the My Directory Page page 26
20
Logging Onto the IDC Website

To log onto the Internet Dealer Commissions website
1. Start your browser and type www.dstidc.com in the address bar. The Internet Dealer Commissions Sign In page appears.
Figure 6. Internet Dealer Commissions Sign In page
2. On the IDC Sign In page, enter your user ID in the ID box, enter your password in the Password box, and click Sign In.
One of the following occurs:
• If you entered a valid ID and password, the IDC My Directory page (Figure 8) appears.
• If you entered an incorrect or invalid ID or password, the following error message appears: The ID or Password
you entered was not correct. Please re-enter your Commission ID and Password.
Repeat step 2 to access the IDC website.

Note: After three invalid attempts, your IDC ID will be disabled. You will need to contact the IDC Group to have
the ID enabled.
If you have forgotten your IDC ID, click Forgot ID? to access the Internet Dealer Commissions (IDC) ID Retrieval
System page. If you have forgotten your password, click Forgot Password? to access the Internet Dealer
Commissions (IDC) Password Reset System page.
21
Changing Your Password

The IDC website enables you to change your firm’s password whenever needed. This ensures that only appropriate users can
access your firm’s data.
To change your IDC password
1. Click Change Password. The Change Password page appears.
Figure 7. Internet Dealer Commissions Change Password page
2. Enter your IDC ID in the IDC ID box.
3. Enter your current password in the Password box.
4. Enter your new password in the New Password box. Your password must be seven to 12 characters in length and must
contain at least one alpha and one numeric or special character. All passwords are case-sensitive.
5. Enter your new password again in the Re-enter New Password box, and click Update. The password is changed and the
new password should be used the next time you log on.
22
Downloading Files From the IDC Website

The IDC website enables you to easily select and download files.
To download files from the IDC website
1. Sign in the IDC website. The My Directory page appears.
2. Select the files to download by placing a check mark in the File Activity Indicator box to the right of the Date/Time
column.
Tip: You can select all available files by clicking Check All. You can also deselect all files by clicking Uncheck All.
3. In the Download to: box, type the path where the selected files are to be downloaded. For example, C:\2006 Dealer
Commissions Files.
4. Click Download. The files are downloaded to the directory you specified.
Note: Files successfully downloaded within the last 45 days can be viewed on the My File History page.
23
Restoring Previously Downloaded Files

The My File History page enables you to view a list of files downloaded in the last 45 days and restore files downloaded in the
last 45 days to the My Directory page. To restore files downloaded in the last 46 to 90 days contact the IDC group at
[email protected].
Important: Files downloaded more than 90 days ago cannot be restored.
To restore a previously downloaded file
1. Sign in to the Internet Dealer Commissions website. The My Directory page appears.
2. Click My File History. The My File History page (Figure 10) appears.
24
3. Click the arrow in the Management Company Selection box, and select a management company.
Tip: You can view histories for all management companies by selecting the All Management Companies option.
4. Perform one of the following:
• To view all files from the last 45 days, select the All Dates option.
• To specify a date range, select the From option, and enter a beginning date (MM/DD/CCYY format) in the first box
and the end date in the To box.
5. Click Retrieve. The page refreshes displaying a list of files that match the selection criteria you specified.
6. Select the files to be restored by placing a checkmark in the File Activity Indicator box to the right of the Download Date
column.
7. Click Restore Files. The selected files are placed in their respective directory. The restored files should be available to
download the next time you go to the My Directory, My CSV, or My PDF Directory page.
Note: Follow the procedure for downloading these files as documented in the Downloading Files From the IDC
Website section on page 23.
25
Removing Files From the My Directory Page

The My Directory page enables you to remove files that you do not want to download.
To remove files from the My Directory page
1. Sign in to the Internet Dealer Commissions website. The My Directory page appears.
2. Select the files to remove by placing a checkmark in the box to the right of the File Name and Date/Time columns.
3. Click Remove. The files are removed from the My Directory page.
Note: Files removed within the last 45 days can be viewed on the My File History page.
26
3. Cross-Referencing Customer Registrations

and Transactions with Commissions
FAN Mail Data Feeds
In today’s ever-changing financial industry, it is imperative that your employees’ valuable time is spent working towards your
business plan, rather than on administrative tasks like data entry. We know that access to timely and accurate information
about your customers and their activity is critical. DST Systems’ Financial Advisor Network® Mail (FAN Mail®) service
enables you to leverage your back-office software’s full capabilities, while eliminating manual data entry of your customers’
trade activity. FAN Mail is your source for complete customer account information. Sign up for DST FAN Mail at
www.dstfanmail.com.
FAN Mail enhances your ability to close the back-office automation gap through the following features:
• Trade activity, such as purchases, redemptions and exchanges, distributions, positions, and daily prices are transferred
directly into your back-office software
• Delivery of customer registration information through the use of DST’s FAN Mail data feeds will move your firm closer to
meeting the regulatory requirements of serving your customers
• Compatibility with the most popular customer-management software packages available, including Operations Plus™,
Albridge™ Solutions, Investigo®, Caesar®, and Foxtrot®.
27
Internet Dealer Commission Plus

DST offers optional indicators of the transactions delivered in the DST FAN Mail Direct Financial Activity file. These data
elements offer a unique indicator of the transactions that took place in your customer’s accounts. These same indicators are
now available in the DST Internet Dealer Commission file to allow reconciliation of your firm’s transactional activity to the
corresponding commission payout.
Your firm’s back-office processes will be greatly enhanced through the use of these complementary DST product offerings
by:
• Removal of manual data input of customer information and transactional activity.

• Streamline the reconciliation of transactions to commissions received that will assist in verification of proper receipt of
revenue.
• Reduction of employee intervention and occurrences of errors.

• Meeting regulatory requirements for “Knowing Your Customer”.
• Providing necessary data to utilize in production of sales and budgetary reports through quantitative figures reported
from the investment company’s record keeping platforms.
28
4. IDC Record Layouts

Header Record
The Internet Dealer Commission detail data text file is preceded by a header record. The header record contains internal
information for IDC files including file type, system ID, management code, fund sponsor ID, and date. Header records
separate each financial institution number being sent to the firm.
Note: The CSV file format uses the same breaks with slightly different descriptions.
Header (Record 1 of 1)
1 3 3 Alpha/Num Record Type

RHR = Request Header
4 13 10 Alpha/Num File Type (Description)

COMMISSION
14 16 3 Alpha System ID
17 18 2 Alpha Management Code
19 23 5 Numeric Fund Sponsor ID
24 31 8 Numeric Transmission Date (CCYYMMDD)
32 200 169 Alpha/Num Unused
Trailer Record
Each Internet Dealer Commission detail data text file ends with a trailer record. The trailer record identifies the file type and
the number of records contained in the file. There is a trailer record for each corresponding header record. The record count
shown in the trailer includes all detail records plus the header and trailer.
1 3 3 Alpha/Num Record Type

RTR = Request Trailer
4 13 10 Alpha/Num File Type (Description)

COMMISSION
14 20 7 Numeric Trailer Record Count

(Includes header, detail, and trailer)
29
Commission (Record 1 of 1)
Each Commission File Layout is defined based on the Commission Record Type Code located in position 1. Record Type
Code 1 and 4 may have a corresponding Record Type Code of 9 (if the optional DFA Cross-Reference record is interpreted by
your software) or a corresponding Record Type Code of A (if the total commission payment includes further details regarding
the breakout of the commission).
1 1 1 Alpha/Num Commission Record Type Code

1 = Commission
3 = 12B-1
4 = Commission History
5 = Reclaim
6 = TRAC
7 = Contractual
8 = Multiple Trailer Fees
9 = Optional DFA Cross-reference Record
A = Commission Fee Type Identification
V = Annuity Commission
2 8 7 Numeric Dealer Number
9 17 9 Alpha/Num Dealer/Branch Number
18 26 9 Alpha/Num Representative Number
27 56 30 Alpha/Num Representative Name
57 65 9 Alpha/Num CUSIP Number
66 75 10 Alpha/Num Alpha Code
76 83 8 Numeric Trade Date (CCYYMMDD)
84 98 15 Numeric Gross Transaction Amount (two decimal places)
99 99 1 Alpha/Num Gross Amount Sign Code

0 = Positive
1 = Negative
100 114 15 Numeric Dealer Commission Amount (two decimal places)
115 119 5 Numeric Commission Rate (four decimal places)
120 139 20 Alpha/Num Customer Account Number
140 140 1 Alpha/Num Account Number Type Code

F = Fund Account Number
(used in positions 120 – 130)
E = External Account Number
P = Plan Number
141 141 1 Numeric Purchase Type Code

1 = Initial
0 = Subsequent
30
142 144 3 Numeric Social Code (see General Social Codes on page 57)
145 153 9 Numeric Cumulative Discount Number
154 162 9 Numeric Letter of Intent (LOI) Number
163 171 9 Numeric Social Security Number
172 172 1 Numeric Social Security Number Status Code

0 = SSN Missing
1 = SSN Non-Certified
2 = SSN Certified
3 = TIN Non-Certified
4 = TIN Certified
5 = SS Applied
6 = SSN IRS Offender
7 = TIN IRS Offender
8 = SSN Exempt Account
9 = TIN Exempt Account
173 187 15 Numeric Transaction Share Count (four decimal places)
188 196 9 Numeric Share Price Amount (four decimal places)
197 199 3 Numeric Resident State/Country Code.
200 200 1 Alpha/Num Dealer Commission Sign Code

0 = Positive
1 = Negative
31
12b-1 (Record 1 of 1)
If the Commission Record Type Code field is set to 3 in the Commission record a 12b-1 record is sent.

3 = 12B-1

0 = Positive
1 = Negative

P = Plan Number

1 = Initial
0 = Subsequent
32

0 = SSN Missing
2 = SSN Certified
4 = TIN Certified
5 = SS Applied
197 199 3 Numeric Resident State/Country Code.

0 = Positive
1 = Negative
33
Commission History Record Redefines (Record 1 of 1)

If the Commission Record Type Code field is set to 4, a Commission History Record Redefines record is sent. This record
may have a corresponding Record Type Code of 9 if the optional DFA Cross-reference record is interpreted by your software.
Commission History records are always sent for informational purposes with a corresponding Reclaim Item Record Type
Code 5. These items should not be processed for payment purposes by your system.

4 = Commission History
9 16 8 Numeric Commission Period End Date (CCYYMMDD)
26 36 11 Numeric Customer Account Number
94 108 15 Numeric Gross Commission Amount (two decimal places)
109 123 15 Numeric Commission Percent (10 decimal places)
124 138 15 Numeric Net Commission Amount (two decimal places)
139 139 1 Alpha/Num Commission Account Type Code

1 = Voluntary
2 = IRA
3 = Keogh
4 = Pension Profit Sharing
5 = 403(B)
6 = Pre-Authorized Check
140 140 1 Alpha/Num Commission Transaction Type Code

1 = Regular Price Purchase
2 = Letter of Intent (LOI) Purchase
3 = Special Price Purchase
4 = Rights of Accumulation (ROA) Purchase
34
Reclaim Record Redefines (Record 1 of 1)

If the Commission Record Type Code field is set to 5, a Commission History records is sent to provide details that make up
the Reclaim Amount.
Note: Commission History records are always sent for informational purposes with a corresponding Reclaim item,
Record Type Code 5. These items should not be processed for payment purposes by your system.

5 = Reclaim
9 16 8 Numeric Reclaim Item Date (CCYYMMDD)
26 40 15 Numeric Reclaim History Item Account (two decimal places)
41 160 120 Alpha/Num Reclaim History Comments
161 168 8 Numeric Source Commission Period End Date (CCYYMMDD)
35
TRAC Record Redefines (Record 1 of 1)

If the Commission Record Type Code field is set to 6 in the Commission record a TRAC Record Redefines record is sent.
TRAC is the DST Defined Contribution record keeping platform and these types of commissions relate to accounts which are
part of Defined Contribution Plans.

6 = TRAC

0 = Positive
1 = Negative
120 139 20 Alpha/Num Plan ID

P = Plan Number

1 = Initial
0 = Subsequent
163 171 9 Numeric Social Security number
36
172 172 1 Numeric Social Security number Status Code

0 = SSN Missing
2 = SSN Certified
4 = TIN Certified
5 = SS Applied
197 199 3 Numeric Resident State/Country Code
37
Contractual Record Redefines (Record 1 of 1)

If the Commission Record Type Code field is set to 7 in the Commission record a Contractual Record Redefines record is
sent.

7 = Contractual
2 8 7 Alpha/Num Financial Institution ID
9 17 9 Alpha/Num Financial Institution Branch ID
18 26 9 Alpha/Num Branch Representative ID
57 63 7 Alpha/Num Fund Code
64 74 11 Numeric Account Number
75 82 8 Numeric Payment Date (CCYYMMDD)

“+” = Positive
“-” = Negative
99 101 3 Alpha/Num Transaction Code
102 104 3 Alpha/Num Transaction Code Suffix
105 105 1 Alpha/Num Sales Creation Charge Sign Code

“+” = Positive
“-” = Negative
106 120 15 Numeric Sales Creation Charge (two decimal places)
121 121 1 Alpha/Num Dealer Commission Payment Timing Code

F = Payment Timing First Year
T = Payment Timing Trail Year
122 122 1 Alpha/Num Dealer Commission Amount Sign Code

“+” = Commission Amount Positive
“-” = Commission Amount Negative
138 138 1 Alpha/Num Bonus Commission Amount Sign Code

“+” = Bonus Commission Amount Positive
“-” = Bonus Commission Amount Negative
139 153 15 Numeric Bonus Commission Amount (two decimal places)
154 161 8 Numeric Record Date (CCYYMMDD)
162 162 1 Alpha/Num Shares Sign Code

“+” = Share Sign Positive
“-” = Share Sign Negative
38
187 187 1 Alpha/Num Carriage Control Code

0D = Carriage Control Yes
spaces = Carriage Control No
188 188 1 Alpha/Num Line Feed Code

25 = Line Feed Yes
spaces = Line Feed No
39
Multiple Trailer Fees Record Redefines (Record 1 of 1)

If the Commission Record Type Code field is set to 8 in the Commission record a Multiple Trailer Fees Record Redefines
record is sent. Some management companies utilize this format for their Trail/12b-1 payments instead of the Record Type
Code 3.

8 = Multiple Trailer Fees
76 83 8 Numeric Trailer Payout Date (CCYYMMDD)
84 98 15 Numeric Total Average Daily Assets (two decimal places)
99 99 1 Alpha/Num Total Average Daily Assets Sign Code

0 = Positive
1 = Negative
100 114 15 Numeric Commission Amount (two decimal places)
115 119 5 Alpha/Num Commission Rate
120 139 20 Alpha/Num Customer/Dealer Account Number or External Plan ID

P = Plan Number
163 171 9 Numeric Social Security number
40
172 172 1 Numeric Social Security number Status Code

0 = SSN Missing
2 = SSN Certified
4 = TIN Certified
5 = SS Applied
173 176 4 Alpha/Num Trailer Fee Code (12b-1)
Optional DFA Cross-Reference Record Redefines

(Record 1 of 1)
Optional DFA Cross-reference allows reconciliation of Direct Financial Activity FAN Mail and Transmission Interface Package
(TIP) Outbound direct data files to their corresponding Commission and Commission History Records. These unique
identifiers are located in the TIP Outbound optional Direct Financial Activity – DFA Detail Record 3 of 5.

9 = Optional DFA Cross-reference Record
2 12 11 Numeric Mutual Fund Transaction Identifier 1
13 23 11 Numeric Mutual Fund Transaction Identifier 2
24 30 7 Numeric Fund Code
31 200 170 Alpha/Numeric Unused
41
Commission Fee Type Identification Record Redefines (Record

1 of 1)
If the value in the Commission Record Type Code field is set to A in the Commission record, a Fees Record Redefines record
is sent. Some management companies use this format for providing a detailed breakout of the values that make up the
commission.

A = Commission Fee Type Identification
84 87 4 Alpha/Num Commission Fee Type ID
88 102 15 Numeric Commission Fee Rate (10 digits maximum)
103 117 15 Numeric Commission Fee Amount (two digits maximum)
118 118 1 Numeric Commission Fee Sign Code

0 = positive
1 = negative

F = fund account number
E = external account number
P = plan number
42

0 = SSN missing
1 = SSN non-certified
2 = SSN certified
3 = TIN non-certified
4 = TIN certified
5 = SS applied
6 = SSN IRS offender
7 = TIN IRS offender
8 = SSN exempt account
9 = TIN exempt account
43
Annuity Commission (Record 1 of 1)

If the Commission Record Type Code field is set to V in the Commission record, an Annuity Commission Record Redefines
record is sent and will follow the redefined data values as listed below.

V = Annuity Commission
2 8 7 Numeric Dealer Number (alpha characters allowed, will be prefilled to left with
zeros)
9 11 3 Alpha/Num Product Type Code (see Product Type Codes on page 71)
12 15 3 Alpha/Num Commission Reason Code (see Commission Basis Reason Code List on
page 64)
57 65 9 Alpha/Num Registered Product CUSIP Number
84 98 15 Numeric Gross Transaction Amount/Commission Basis Amount (two decimal

places)

0 = Positive
1 = Negative
120 139 20 Alpha/Num Contract Number/Dealer Account Number/External Plan ID

F = Group Annuity Plan ID
D = Dealer Account Number

1 = Initial
0 = Subsequent
145 151 7 Numeric DST FAN Mail Product Code Identifier
152 153 2 Numeric Unused
44

0 = SSN Missing
2 = SSN Certified
4 = TIN Certified
5 = SS Applied
173 187 15 Numeric Net/Prepaid Commission Retained by Firm
188 196 9 Numeric Unit Price Amount (six decimal places)

0 = Positive
1 = Negative
45
Appendix A. DSTHTTPDL Download Manager

DSTHTTPDL is an ActiveX control that provides a programmable method of downloading files from an EComm Core web
application. It is scriptable so that JavaScript within an HTML page can be used to tell it which files to download. The
Download Manager can also be used from within a C++, Visual Basic, or Visual FoxPro application. The download manager
has no graphical user interface; the host program, script, or web page is responsible for that. There are two modes of
operation; asynchronous and synchronous.
Asynchronous Mode
The asynchronous mode is the default mode of operation. During asynchronous operations, the file downloads are
performed on a worker thread; events are fired for error notification, status updates and download completion and the
download may be canceled by calling the Cancel() or Terminate() methods. A failed download for a single file does not
cause the entire download to stop.
Synchronous Mode
During synchronous operations, the file downloads are performed on the same thread in which the DownloadFiles() method
was called; no events are fired and causes for errors are retrieved through the GetLastErrorCode() and
GetLastErrorMessage() methods. A single error stops the entire download process. Synchronous mode is recommended for
environments where it is difficult to receive or wait for events from the control.
Requirements
For hosting in a HTML page, this control requires Microsoft® Internet Explorer version 6.0 or later.
ActiveX Download Manager

The DST HTTP Download Manager is a signed ActiveX control provided by FAN Mail that can be used by several
programming languages. This control has been tested with:
• Visual FoxPro 6.0 (VFP6)
• Visual Basic 6.0 (VB6)
• JavaScript
• C++
• .NET languages such a C#
46
The following table documents the values required to use the Download Manager ActiveX control in both the test and
production environments. For more information on a specific property, see Properties on page 48.
Property Test Environment Production Environment
User ID Assigned ID Assigned User ID
Password Assigned Password Selected Password
Host filetransfer.financialtrans.com filetransfer.financialtrans.com
Target /tf/FANMail-test /tf/FANMail
Client 419041819 415171403
UseHTTPS True True
UseProxy True (if using a proxy) True (if using a proxy)

False (if not using a proxy) False (if not using a proxy)
Identification
Information Element Details
File Name DSTHTTPDL.DLL
Program ID DSTHTTPDL.DownloadManager
CLSID 2DEA82A9-7FEF-4F68-8091-B800ECF54C9F
47
Properties
User ID The ID used for HTTP authentication.
Password The password used for HTTP authentication. This is a “set only” property.
Session
Session An EComm session ID. The Session property is mutually exclusive of the UserID and Password pair of properties.
If the control already has a Session, it is cleared if either the UserID or Password property is set. If the control already has a
UserID and/or Password, they are both cleared when the Session property is set. If the UserID and Password properties are
initially set, they are cleared after the server validates the pair and returns a valid EComm session ID. If an EComm session
times out, the Session property is cleared and the host application is required to either
re-populate the UserID and Password properties (after prompting the user); or to re-populate the Session property with a
new and valid Session ID.
Host The base URL of the web server (for example www.dstsystems.com).
Target The target application/page on the web server (example: /tf/FileRetr). A URL such as
www.dstsystems.com/tf/FileRketr has two parts, the host and the target. The host is the base URL and the target identifies
the application or page the server is supposed to access.
Client The Ecomm client (the CZ value in an Ecomm URL).
LocalDirectory The directory on the local workstation where the downloaded files are to be stored.
UseHTTPS A flag indicating whether to use SSL through an HTTPS request. The default value is True. If the value is False,
use a normal HTTP request.
UseProxy A flag indicating whether to use a proxy server. The default value is True. The proxy identified for Microsoft
Internet Explorer is the proxy that is used.
Asynchronous Indicates whether the file downloads are performed asynchronously. The default value is True. In
asynchronous mode, the DownloadFiles() method spins off a worker thread to download the files and return immediately. In
synchronous mode, the DownloadFiles() method does not return until the download is complete or there is an error. Set this
property to False to operate in synchronous mode.
48
Methods
GetFileListAsXML
Description Returns the list of files available to download.
Parameters None.
Return A string containing the list of files as an XML document.
Example Here is an example return from the method:

<FileList>
<File name=”file001.zip” short-name=”file001.zip”/>
<File name=”file002.zip” short-name=”file002.zip”/>
</FileList>
Remarks When this method is called, the control sends an HTTP/HTTPS request to the server for the file list. This list must
be a valid XML document using the following tags:
<?xml version="1.0" encoding="UTF-8" ?>
<FileRetriever>
<FileList>
<File name=" file001.zip " />
<File name=" file002.zip " />
</FileList>
</FileRetriever>
DownloadFiles
Description Downloads the list of files.
Parameters A string containing the list of files as XML or a semicolon delimited list.
Example
<FileList><File name=”file001.zip/></FileList>
or
file001.zip;file002.zip;
Return True if successfully started (async): true if all files were downloaded without error (sync).
Remarks The asynchronous method returns immediately and the files are downloaded one at a time on a worker thread.
Events are fired after each file is downloaded, after the download is complete, and if any errors are encountered. The
synchronous method does not return until all the files have downloaded successfully or there is an error. If there is an error, a
value of false is returned. No events are fired in synchronous mode. A call to GetLastErrorCode() and/or
GetLastErrorMessage() provides the reason for a failure.
49
DeleteSingleFile
Description Sends a request to the server to delete a file.
Parameters A string containing the file to delete.
Return True if the file was deleted from the server.
Remarks This method is used to remove a file from the server.
CancelRequest
Description Cancels the download (asynchronous mode only).
Parameters None.
Return None.
Remarks The method should be called in response to a user request to cancel the download. A DownloadError event is fired
with the message Download Request Canceled with code 605 as a result.
Terminate
Description Cancels the download and suppresses all events (asynchronous mode only).
Parameters None.
Return None.
Remarks This method should be called when an HTML page is unloaded or the hosting application is closing. All events are
suppressed.
GetLastErrorCode
Description Returns the code for the last error encountered. Used primarily for synchronous processing.
Parameters None.
Return An error code.
Remarks This method is provided to determine the cause of an error when a failure (false) is returned from a method call
while the control is in the synchronous mode.
GetLastErrorMessage
Description Returns the text for the last error encountered. Used primarily for synchronous processing.
Parameters None.
50
Return An error code.
Remarks This method is provided to determine the cause of an error when a failure (false) is returned from a method call
while the control is in the synchronous mode.
Events (Asynchronous Mode Only)

DownloadError
Description This event is fired when an error is encountered or the CancelRequest method is called.
Parameters String—An error message, Long—An error code.
Remarks Any code between 100 and 599 are HTTP response codes. The following codes are internal and have the following
definition:
Code Definition
601 Missing property
602 Open connection failure
603 File open failure
604 MSXML failure
605 Download canceled
607 Empty Download List
DownloadComplete
Description This event is fired after the download is complete.
Parameters None.
DownloadProgress
Description This event is fired after each file has downloaded.
51
Example HTML
<html>
<head>
<title>Test Page for DSTHTTPDL</title>
</head>
<script language="javascript">
function GeFileList()
{
HTTPDL_result.value = "";
HTTPDL.Host = "filetransfer.financialtrans.com";
HTTPDL.UseProxy = false;
HTTPDL.LocalDirectory = “c:\temp”;
HTTPDL.UseHttps = true;
<!—- Note: Test System Information -->

HTTPDL.Target = "/tf/FANMail-Test";
HTTPDL.Client = "419041819";
<!—- Note: For testing UserID and Password will be supplied by DST -->
HTTPDL.UserID = UserID.value;
HTTPDL.Password = Password.value;
var list = HTTPDL.GetFileListAsXML();

var dlist = "No file list returned";
var xmldoc = MSXML3;

xmldoc.async = false;
xmldoc.preserveWhiteSpace = true;
xmldoc.loadXML(list);
var docelement = xmldoc.documentElement;
if ( docelement.hasChildNodes() )
52
{
dlist = "<form name=\"Selection\">";
var nodeList = docelement.childNodes;

var node = nodeList.nextNode();
while ( node != null )

{
var file = node.getAttribute("name");
var display = node.getAttribute("short-name");
dlist += "<input type=\"checkbox\" name=\"sfile\" value=\"";

dlist += file;
dlist += "\"> ";
dlist += display;
dlist += "<br>";
node = nodeList.nextNode();
}
dlist += "<br>";
dlist += "<input type=\"button\" value=\"Download Files\" onclick=\"Download()\">";
dlist += " <input type=\"button\" value=\"Cancel\" onclick=\"CancelDownload()\">";
dlist += "<br>";
dlist += "</form>";
}
FileList.innerHTML = dlist;
}
function Download()
{
HTTPDL.LocalDirectory = DestDir.value;
var selection = document.forms[0].sfile;

var flist = "";
53
for ( index=0; index<selection.length; ++index)

{
if ( selection[index].checked )
{
flist += selection[index].value;
flist += ";";
}
}
PostResult( "Begin Download" );

HTTPDL.DownloadFiles( flist );
}
function CancelDownload()
{
HTTPDL.CancelRequest();
}
function TerminateDownload()
{
HTTPDL.Terminate();
}
function PostResult( msg )

{
content = HTTPDL_result.value;
content += msg;
content += "\r\n";
HTTPDL_result.value = content;
}
</script>
<script for="HTTPDL" event="DownloadError( code, msg )" language="javascript">

PostResult( msg );
</script>
54
<script for="HTTPDL" event="DownloadComplete()" language="javascript">

PostResult( "DownloadComplete" );
</script>
<script for="HTTPDL" event="DownloadProgress( msg )" language="javascript">

PostResult( msg );
</script>
<body onunload="TerminateDownload()">
<object id="HTTPDL" height=0 width=0

classid="CLSID:2DEA82A9-7FEF-4F68-8091-B800ECF54C9F"
codeBase="http:DSTHTTPDL.cab#version=1,0,0,2">
</object>
<object id="MSXML3" style="DISPLAY: none"

codeBase="http:msxml3.cab#version=8,00,7820,0"
type="application/x-oleobject"
data="data:application/x-oleobject;base64,EQ/Z9nOc0xGzLgDAT5kLtA=="
classid="clsid:f5078f32-c551-11d3-89b9-0000f81fe221">
</object>
<table>
<tr>
<td style="padding-bottom:20px;vertical-align:top">
<div id="Main">
<p>User ID: <input type="text" id="UserID" size=10>
Password: <input type="password" id="Password" size=10></P>
<p><input type="button" value="Get FileList" onclick="GeFileList()"></p>
</div>
</tr>
<tr>
<td>
<textarea name="HTTPDL_result" rows=10 cols=50 wrap=soft></textarea>
</td>
55
</tr>
<tr>
<td style="padding-top:20px;vertical-align:top">
<p>Destination Directory (local):
<input type="text" id="DestDir" size=30></p>
</td>
</tr>
<tr>
</td>
<td style="padding-left:20px;padding-top:20px;">
<div id="FileList">
</div>
</td>
</tr>
</table>
</body>
</html>
56
Appendix B. Social Codes

Although social codes may vary by Product Company, a list of commonly accepted account type indicators is shown on the
following pages. If additional information regarding the use of a specific social code is needed, contact your product
company wholesaler.
General Social Codes

The following table lists all general social codes.
Code Description
005 Individual—Man, Sole Proprietorship Owned by a Man
006 Individual—Male or Female (gender neutral)
009 Brokerage House Accounts
010 Individual—Woman, Sole Proprietorship Owned by a Woman
011 Do not use
015 Joint Tenants, Tenants in Common, Tenants by Entirety, Community Property
020 Custodian—Uniform Gift to Minors Act
021 Custodian Other—Guardian, Committee, Conservator
024 Transfer on Death
025 Custodian—Bank/Trust Company
030 Estates—Executors, Administrators
038 Limited Liability Company (LLC)
040 Corporate Accounts—Incorporated, Company, Association, Foundation
041 Partnerships
042 Nominee—Committee to Elect
043 Financial Organizations—Banks and Trust Companies
044 Insurance Companies
045 Other Financial Organizations—Savings and Loan, Credit Union
046 Hospitals, Medical Institutions, Rest Homes, Nursing Homes
047 Funeral Homes, Cemeteries
048 Unions
050 Pension Plans
051 Thrift Plans (Salary Savings)
57
Code Description
052 Retirement Plans—Unclassified
053 Miscellaneous Self-Directed IRA
054 Broker Self-Directed IRA
056 401(k) (non-IFTC custodian)
059 Broker/Dealer Custodian
060 Charitable and Welfare Organizations, Foundations
061 Churches and Religious Institutions
062 Colleges and Universities
063 Clubs and Fraternal Organizations
064 Investment Clubs
065 Townships, Cities, and Counties
066 School Districts
067 529 Plan—Scholarship Provider
070 Trusts—Individual and Corporate Trusts Under Agreement or Will
071 Trusts—Charitable Annuity Trusts
072 Trust—Charitable Unit Trusts
073 Trusts—Revisionary Trusts
074 Private Annuity
075 Installment Sales
076 Deferred Compensation Plans
077 Payroll Deduction Plans
080 Foreign Banks or Brokers
090 Networked Accounts
091 Corporate Officers
092 Corporate Directors
093 Corporate Employees—NAV
094 Group Account (Spec Dividend Reporting)
096 Low-Load Account
201 Profit Sharing—Master
202 Profit Sharing—Employee
203 Profit Sharing—Voluntary Contributions
58
Code Description
755 529 Plan—Individual Owner
757 529 Plan—Non-Profit Educational Organization
767 529 Plan—Scholarship
856 529 Plan—Corporation
858 529 Plan—UGMA/UTMA
861 529 Plan - Trust
59
Restricted Social Codes

Restricted social codes are only used when a customer submits a product company’s internal custodian application for a
recognized qualified account type.
Code Description
101 Keogh Master
102 Keogh Employee (Employer Contribution)—Participant
103 Keogh Voluntary Contribution
104 Keogh Master—Custodian
105 Keogh Employer—Custodian
106 Keogh Voluntary—Custodian
111 IFTC Fixed Benefit—Master
112 IFTC Fixed Benefit—Employer
113 IFTC Fixed Benefit—Employee
121 IFTC Money Purchase—Master
122 IFTC Money Purchase—Employer
123 IFTC Money Purchase—Employee
131 IFTC Profit Sharing—Master
132 IFTC Profit Sharing—Employer
133 IFTC Profit Sharing—Employee
141 IFTC Thrift—Master
142 IFTC Thrift—Employer
143 IFTC Thrift—Employee
701 IRA—Individually Established
702 IRA—Employer Established (Simplified Employee Pension Plan)
703 IRA—Rollover from Nonqualified Plan
704 IRA—Spousal Accounts
711 IRA—Individually Established Split Funded
712 IRA—Employer Established Split Funded
713 IRA—Rollover Split Funded
714 IRA—Trade Union Split Funded
733 403(b)—Beneficiary by Death
734 Qualified Plan—Beneficiary by Death
60
Code Description
758 Roth IRA—Beneficiary by Death
759 Education IRA—Beneficiary by Death
761 SIMPLE IRA—Employer (ER) Master Plan
762 SIMPLE IRA—Employee (EE) Contribution Plan
763 SIMPLE IRA—Transfer
770 SIMPLE IRA—Beneficiary by Death
771 403(b)—Individually Established
772 403(b)—Group
773 Salary Reduction Contribution
881 IMF—Individual Single Payment
882 IMF—Group Single Payment
883 IMF—Individual Installment
884 IMF—Group Installment
61
Special Accounts Social Codes

Special account social codes indicate that a customer’s participation within the product company is managed through a
specific process agreed upon between each entity.
Code Description
101 Keogh Master
102 Keogh Employee (Employer Contribution)—Participant
103 Keogh Voluntary Contribution
104 Keogh Master—Custodian
105 Keogh Employer—Custodian
106 Keogh Voluntary—Custodian
111 IFTC Fixed Benefit—Master
112 IFTC Fixed Benefit—Employer
113 IFTC Fixed Benefit—Employee
121 IFTC Money Purchase—Master
122 IFTC Money Purchase—Employer
123 IFTC Money Purchase—Employee
131 IFTC Profit Sharing—Master
132 IFTC Profit Sharing—Employer
133 IFTC Profit Sharing—Employee
141 IFTC Thrift—Master
142 IFTC Thrift—Employer
143 IFTC Thrift—Employee
701 IRA—Individually Established
702 IRA—Employer Established (Simplified Employee Pension Plan)
703 IRA—Rollover from Nonqualified Plan
704 IRA—Spousal Accounts
711 IRA—Individually Established Split Funded
712 IRA—Employer Established Split Funded
713 IRA—Rollover Split Funded
714 IRA—Trade Union Split Funded
733 403(b)—Beneficiary by Death
734 Qualified Plan—Beneficiary by Death
62
Code Description
758 Roth IRA—Beneficiary by Death
759 Education IRA—Beneficiary by Death
761 SIMPLE IRA—Employer (ER) Master Plan
762 SIMPLE IRA—Employee (EE) Contribution Plan
763 SIMPLE IRA—Transfer
770 SIMPLE IRA—Beneficiary by Death
771 403(b)—Individually Established
772 403(b)—Group
773 Salary Reduction Contribution
881 IMF—Individual Single Payment
882 IMF—Group Single Payment
883 IMF—Individual Installment
884 IMF—Group Installment
63
Appendix C. Commission Basis Reason Code

List
Commission basis reason codes indicate compensation, commission, or bonus; the type of transaction (payment, advance,
or adjustment); and its base (premiums, investments, current asset value).
Code Code List For Commission Charges Code Cost List For Commission Payments
Premium Commissions - Gross or Netted
CPP CB for Commission payment for new (initial) premium. PPP Commission payment for new (initial) premium. This
This is associated with a new contract. Paper is associated with a new contract. Paper
CEP CB for Commission payment for new (initial) premium. PEP Commission payment for new (initial) premium. This
This is associated with a new contract. Electronic is associated with a new contract. Electronic
CPA CB for Commission payment add-on (sub pay) premium. PPA Commission payment add-on (sub pay) premium.
Paper Paper
CEA CB for Commission payment add-on (sub pay) premium. PEA Commission payment add-on (sub pay) premium.
Electronic Electronic
CWR CB for policy netted at incorrect rate PWR Commission payment for incorrect netting
CDI CB of Interest Payment for Deferred Commissions PDI Interest Payment for Deferred Commissions
CRP Chargeback for Commission Rider - Asset Based PRP Payment for Commission Rider - Asset Based
CIT Chargeback for Internal Replacement PIT Payment for Internal Replacement
CAI Chargeback on Annualized Decrease PAI Payment on Annualized Increase
CNP Non Standard Chargeback for persistency bonus at the PNP Non-Standard Payout for persistency bonus at the
broker dealers request broker dealers request
Approximate Premium Commissions - Advances
CAN CB for net adjustment for an advance PAN Commission payment for an advance or transfer
CA5 CB for adjustment for a 1035 advance or transfer. This PA5 Commission payment adjustment for a 1035
is generated following the receipt of actual premium. exchange advance or transfer. This is generated
following the receipt of actual premium.
CAP CB for full advanced amount PX5 Commission payment for 1035 or qualified transfer
that was NOT advanced on. This is generated
following the receipt of actual premium.
Asset-Based Commissions - Trails and Renewals
CTA CB for trails PTA Commission payment for full trail (asset based).
This is generated due to the selection of a trail
commission option or related persistency bonus on
a variable product.
64
CBA CB for renewal that was in error. PBA Commission payment for variable asset based
persistency bonus (asset based). This is generated
due to the renewal of a variable product.
CRF CB for Renewal of a Fixed Product PRF Commission payment for Renewal of a Fixed
Product
CTB CB for Commission Only Payment for Trails (asset PTB Commission Only Payment for Trails (asset based)
based)
CCP CB for Commission Only Payment for Trails (premium PPC Commission Only Payment for Trails (premium
based) based)
CAB CB for Commission Pay for Trails (annuity payment PAB Commission Payment for Trails (annuity payment
based) based)
CFB CB for Fee Based Commissions PFB Fee Based Commissions
Direct Firm Comp or Reimbursement
CM0 Chargeback for marketing allowance that was based on PM0 Commission payment for marketing allowance
overall production (not contract specific) based on overall production (not contract specific)
PBP Commission payment for periodic bonus (premium

based)
CFC Chargeback of Firm Level Commission Payment PFC Firm Level Commission Payment
Charge Backs and Reversals
CPC CB for cancel policy PAA Commission payment for payment adjustments or
reversals of chargebacks
CFL CB canceled during free look
CRL CB for inadequate licensing of rep
CPD CB for decrease in policy
COP CB for overpaid
CWA CB for netted incorrectly due to age
CS0 CB due to partial surrender
CS1 CB due to partial surrender 1st 6 months
CS2 CB due to partial surrender 2nd 6 months
CSY CB due to surrender after 1st year
CSF CB due to full surrender
C2P CB due to duplicate payment
CD0 CB due to death claim
CD1 CB due to death claim 1st 6 months
CD2 CB due to death claim 2nd 6 months
65
CDY CB due to death claim after 1st year
C96 CB due to annuitization P96 Commission payment for annuitization
C97 CB due to internal 1035 or transfer P97 Commission payment for internal 1035 or transfer
C98 CB due to conversion P98 Commission payment for conversion
C99 CB due to Manual Adjustment P99 Commission payment for reversal of Surrenders
CWB CB due to wrong BD or BD change PSP Commission payment for special payment to firm
CLI Loan Interest Deduction PLI Reversal of Loan Interest Deduction
Life Products Payments and Chargebacks
CY1 Reversal of commission payment for 1st policy year on PY1 Commission payment for 1st policy year on
premium up to target premium up to target
CE1 Reversal of commission payment for 1st policy year on PE1 Commission payment for 1st policy year on
premium in excess of target premium in excess of target
CY2 Reversal of commission payment for 2nd policy year on PY2 Commission payment for 2nd policy year on
CE2 Reversal of commission payment for 2nd policy year on PE2 Commission payment for 2nd policy year on
CY3 Reversal of commission payment for 3rd policy year on PY3 Commission payment for 3rd policy year on
CE3 Reversal of commission payment for 3rd policy year on PE3 Commission payment for 3rd policy year on
CY4 Reversal of commission payment for 4th policy year on PY4 Commission payment for 4th policy year on
CE4 Reversal of commission payment for 4th policy year on PE4 Commission payment for 4th policy year on
66
(zero) premium up to target premium up to target
(zero) premium in excess of target premium in excess of target
CYX Reversal of commission payment for 11th plus policy PYX Commission payment for 11th plus policy years on
years on premium up to target premium up to target
CEX Reversal of commission payment for 11th plus policy PEX Commission payment for 11th plus policy years on
years on premium in excess of target premium in excess of target
COF Chargeback of commission payment for first year POF Commission payment for first year override
override
COR Chargeback of commission payment for renewal year POR Commission payment for renewal year override
override
CCI Chargeback of commissions paid on Cost of Insurance PCI Commissions paid on Cost of Insurance
transactions transactions
CIR CB due to payment for renewals (premium based) PIR Commission payment for renewals (premium
based)
CMI CB for marketing allowance related to a specific PMI Com payment for marketing allowance related to a
contract specific contract
PTP Commission payment for trails (premium based)
CIL CB due to Lapsed policy PIL Undo or Reversal of Chargeback due to Lapsed
policy
CL1 Chargeback due to Lapsed policy for Target premium in PL1 Undo or Reversal of Chargeback due to Lapsed
year one. policy for Target premium in year one.
CL2 Chargeback due to Lapsed policy for Excess premium in PL2 Undo or Reversal of Chargeback due to Lapsed
year one. policy for Excess premium in year one.
CL3 Chargeback Renewal year policy status Lapsed. PL3 Undo or Reversal Renewal year Chargeback policy
status Lapse.
CFT Chargeback due to full surrender with Target premium in PFT Undo or Reversal of a Chargeback due to Surrender
year one. with Target premium in year one.
CFE Chargeback due to full surrender with Excess premium PFE Undo or Reversal of a Chargeback due to Surrender
in year one. with Excess premium in year one.
CFS Chargeback Renewal year policy status Surrender. PFS Undo or Reversal Renewal year Chargeback policy
status Surrender.
67
CLT Chargeback due to Loan with Target premium in year PLT Undo or Reversal of Chargeback due to Loan with
one. Target premium in year one.
CLE Chargeback due to Loan with Excess Premium in year PLE Undo or Reversal of Chargeback due to Loan with
one. Excess premium in year one.
CLL Chargeback in Renewal year due to loan. PLL Undo or Reversal Renewal year Chargeback due to
loan.
CRT Undo or Reversal of a Loan Repayment with Target PRT Loan Repayment with Target premium in year one.
premium in year one.
CRE Undo or Reversal of a Loan Repayment with Excess PRE Loan Repayment with Excess premium in year one.
premium in year one.
CLR Undo or Reversal of Loan Repayment. PRL Renewal Year Loan Repayment.
CLB Chargeback due to Loan (Combination of Target, Excess PLB Undo or Reversal of Chargeback due to Loan
and Renewal) (Combination of Target, Excess and Renewal)
CRB Chargeback due to Loan Repayment (Combination of PRB Undo or Reversal of Chargeback due to Loan
Target, Excess and Renewal) Repayment (Combination of Target, Excess and
Renewal)
CR1 Reversal of Commission Payment for First Rolling PR1 Commission Payment for First Rolling Target
Target
CR2 Reversal of Commission Payment for Rolling Target 2 PR2 Commission Payment for Rolling Target 2
CRX Reversal of Commission Payment for Rolling Targets PRX Commission Payment for Rolling Targets 11+
11+
Retirement Plan Payments and Chargebacks
CTD CD for Initial Deposit - Transaction Based PTD Initial Deposit - Transaction Based
CAD CB for Initial Deposit - Asset Based PAD Initial Deposit - Assed Based
CST CD for Subsequent Deposit - Transaction Based PST Subsequent Deposit - Transaction Based
CSA CB for Subsequent Deposit - Asset Based PSA Subsequent Deposit - Asset Based
CAF Chargeback of Advisory Fee Payment - Asset Based PAF Advisory Fee Payment - Asset Based
68
CPF Chargeback of Pro-rated Advisory Fee Payment - Asset PPF Pro-rated Advisory Fee Payment - Asset Based
Based
CFF Chargeback of Fiduciary Advisory Fee Payment - Asset PFF Fiduciary Advisory Fee Payment - Asset Based
Based
CTA Chargeback for Trails PTA Compensation payment for full trail (asset based).
This is generated due to the selection of a trail
compensation option or persistency bonus.
69
Appendix D. Product Type Codes

The following is a list of available product type codes.
Code Description Comments
DIS Disability
EIA Equity Indexed Annuity
FIX Fixed Annuity Products
FIA Fixed Immediate Annuity
UL Fixed Universal Life Insurance
WL Fixed Whole Life Insurance
LTC Long Term Care
MVA Market Value Adjustment
MMT Money Market Products
NAP No Associated Product
OIP Offshore Investment Product An insurance product manufactured by an entity headquartered outside the United
States. Generally these products function like an annuity but are not considered an
annuity.
PEN Pension Plan
RET Retirement Plan Retirement and/or other benefit plans/programs offered by a distributor that are
functionally similar to annuities, but not an annuity. The distributor, functioning as an
administrator and/or custodian of the program, offers multiple investment options
(typically mutual funds or annuities) within the “wrap” of the program, for sale to plan
sponsors through distributing broker/dealer intermediaries.
TRM Term Life
VAR Variable Annuity Products
VIA Variable Immediate Annuity
VUL Variable Universal Life

Insurance
VWL Variable Whole Life Insurance Only used when there is no CUSIP for the transaction.
70
Appendix E. Revisions
This guide was last published on June 16, 2017. The following table describes the most recent revisions made to each
chapter or appendix.
Chapter/Appendix Date Details
About This Guide September 12, 2014 Updated the File Name Convention section.
1. Getting Started June 16, 2017 Updated screen shots and field descriptions.
2. Using the IDC Website June 16, 2017 Updated screen shots and field descriptions.
3. Cross-Referencing Customer Registrations May 18, 2006 Added information to the Optional DFA
and Transactions with Commissions Cross-reference Record Redefines (Record 1 of 1) table.
4. IDC Record Layouts June 16, 2017 The following changes were made:
• Modified field names on the Multiple Trailer Fees
Record Redefines (Record 1 of 1) file.
• Modified field names on the Annuity Commission
(Record 1 of 1) file.
• Added 12b-1 (Record 1 of 1) file.
Appendix A: DSTHTTP Download Control March 2, 2004 Added required values for test and production
Download Manager environments.
Appendix B: Social Codes May 18, 2006 Updated with the latest version from the Outbound TIP file
layouts.
Appendix C: Commission Basis Reason Code June 16, 2017 Added Retirement Plan Payments and Chargebacks
List section to file layout.
Appendix D: Product Type Codes February 1, 2010 New appendix.
Glossary May 18, 2006 Updated glossary.
Index May 18, 2006 Updated index.
71
Glossary
Account Number Type Code A code identifying whether the Customer Account Number field on the transaction
represents the external account number, the fund account number, or the plan identification number.
Alpha Code A code developed from the customer registration enabling location of the account without an account number.
Commission Account Type Code A classification of the customer account involved in the commission transaction for
statement purposes, based on classification by social code.
Commission Rate The percent of commission paid to the dealer on a particular transaction.
Cumulative Discount Number (CUMDISC) A value to associate or link accounts to secure reduced sales prices on
purchases.
CUSIP Number (CUSIP) A value assigned by the Committee for Uniform Security ID Procedures. A unique CUSIP number is
assigned to each fund.
Customer Account Number A unique value indicating a particular customer within a product company’s record keeping
system.
Dealer/Branch Number A value to uniquely identify a branch office within a broker-dealer.
Dealer Commission Amount The amount of money paid to a dealer as the dealer’s compensation for investments solicited.
Dealer Number Uniquely identifies a broker-dealer on the management company’s record keeping system. This number
identifies the firm that acts as a principal in a particular trade and varies with each management company.
File Type (Description) A field used in the header and trailer records that describes the type of records being sent.
Fund Sponsor ID Uniquely identifies a particular fund sponsor (product company) on the record keeping system.
Gross Commission Amount The total amount of commission applicable for a transaction. The amount includes both dealer
commission and underwriter commission.
Gross Transaction Amount The dollar amount of a transaction posted to a customer account within the product company.
Letter of Intent Number A number assigned to the contractual agreement between a customer and a product company,
stating the customer will invest a certain dollar amount within a specific time period for a specified reduction in price.
Management Code An alphanumeric code, used in conjunction with the System ID, to uniquely identify the product
company.
72
Mutual Fund Transaction Identifier 1 and 2 Unique numeric identifiers that are attached to all financial transactions
processed into a customer account on the product company’s record keeping platform. Both identifiers must be used to
make them unique. These are unique per platform, which means two different platforms could potentially, though very
unlikely, have the same indicators. With this being understood, it is important to maintain the integrity of the CUSIP and the
customer account number combination as well.
Net Asset Value (NAV) The value of one share of a fund as determined by total assets less total liabilities divided by total
shares outstanding.
Net Commission Amount The amount of commission to pay to the dealer for a transaction.
Plan ID A unique identifier for a defined contribution plan within an investment company unit. This is a system-generated
number.
Reclaim Indicates the net amount being reduced from or added to a firm’s payout amount. Detailed commission history
records are delivered to detail the original commission details that are being adjusted.
Record Type Identifies the type of information contained on the file record.
Representative Name The name of the employee(s) of a broker-dealer acting on the customer’s behalf in transactions
involving a securities account.
Representative Number Identifier of the employee(s) of a broker-dealer acting on the customer’s behalf in transactions
involving a securities account. A commission is usually paid for each trade a representative makes on the behalf of a
customer.
Resident State/Country Code Identifies the state or country in which a customer resides.
Tip: For more information, see the TA2000 State and Country Codes Quick Reference Guide on the TA2000 Customer
Center.
Rights of Accumulation (ROA) An account option enabling a customer to pay a lower sales charge based on accumulated
purchases or on the current account value, whichever is greater. Accounts can be linked for ROA by cumulative discount
(cum disc) numbers.
Social Code A code established to identify a customer’s account type with the management company.
Social Security Number (SSN) A number assigned by the Social Security Administration to uniquely identify an individual or
entity.
Social Security Number Status Code A value indicating the status of the certification of the Social Security number (SSN)
or employer identification number (EIN).
Source Commission Period End Date This field contains the commission period ending date for the statement that
contains the items that are the source of the reclaim if the open item is a reclaim. This date ties a reclaim item back to a
specific commission period.
State/Country Code Identifies the state or country in which a shareholder resides.

Tip: For more information, see the TA2000 State and Country Codes Quick Reference Guide on the DST Customer Center.
System ID The alphabetic identifier assigned to a record keeping system.
73
Total Retirement Accounting Capabilities (TRAC) The product to service defined contribution plans. TRAC interfaces with
the TA2000 system. Facilities in the system provide for the establishment and maintenance of investment company unit
information, plans, model plans, and individual participants. Tax reporting and compliance testing are also provided.
Trade Date The date on which a trade occurs. In addition, the date the system uses to determine share price of the
transaction.
Trailer A commission payout that is based on assets under management with a specific product company.
Trailer Record Count The total number of records contained within a file. This count includes all detail records, plus the
header and trailer.
74
Index
uncompressed files 7
A
Asynchronous property 48 G
GetFileListAsXML method 49
C GetLastErrorCode method 50
CancelRequest method 50 GetLastErrorMessage method 50
changing password 22
Client property 48 H
header record 29
D Host property 48
DeleteSingleFile method 50
Download Manager I
class ID 47
IDC
events 51
administration 5
example HTML code 52
automatic downloads 5
filename 47
downloading files 5
methods 49–51
manual downloads 23
overview 46
manual downloads 5
program ID 47
My Directory page 11, 13
properties 48
My File History page 18
DownloadComplete event 51
overview 5
DownloadError event 51
password 22
DownloadFiles method 49
production files 6
downloading files
removing files 26
automatically 5
resend files 6
manually 23
restoring files 24–25
manually 5
selection criteria 5
DownloadProgress event 51
Sign In page 10
DSTHTTPDL See Download Manager
uncompressed files 7
Internet Dealer Commissions See IDC
E
events L
DownloadComplete 51
LocalDirectory property 48
DownloadError 51
DownloadProgress 51
M
F methods
CancelRequest 50
files
DeleteSingleFile 50
downloading manually 23
DownloadFiles 49
naming convention 6, 7
GetFileListAsXML 49
production 6
GetLastErrorCode 50
removing 26
GetLastErrorMessage 50
resend 6
Terminate 50
restoring 24–25
My Directory page 11, 13
uncompressed 7
My File History page 18
FTP transmissions
file naming convention
production files 6 P
resend files 6 password
75
changing 22 removing files 26

Password property 48 resend files 6
production files 6 restoring files 24–25
properties
Asynchronous 48 S
Client 48
Host 48 selection criteria 5
LocalDirectory 48 Session property 48
Session 48 Sign In page
Target 48 overview 10
UseHTTPS 48
UseProxy 48 T
Properties
Target property 48
Password 48
Terminate method 50
UserID 48
trailer record 29
R
U
record layouts
uncompressed files 7, See data files
field descriptions 7
UseHTTPS property 48
header 29
UseProxy property 48
trailer 29
UserID property 48
REFRESHER
request numbers 29
76

Internet Dealer Commission User Guide-June2017

Uploaded by

Copyright:

Available Formats

Internet Dealer Commission User Guide-June2017

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Internet Dealer Commission User Guide-June2017

Uploaded by

Copyright:

Available Formats

Financial Services

INTERNET DEALER COMMISSIONS

1. Getting Started ....................................................................................................................................................... 9

2. Using the IDC Website ....................................................................................................................................... 20

3. Cross-Referencing Customer Registrations and Transactions with Commissions .............................. 27

4. IDC Record Layouts ............................................................................................................................................ 29

Contractual Record Redefines (Record 1 of 1) .................................................................................................................... 38

Appendix A. DSTHTTPDL Download Manager .................................................................................................. 46

Appendix B. Social Codes ...................................................................................................................................... 57

Appendix C. Commission Basis Reason Code List........................................................................................... 64

Appendix D. Product Type Codes......................................................................................................................... 70

Appendix E. Revisions ............................................................................................................................................ 71

About This Guide

Downloading Internet Dealer Commission Files

Manual Website Download

Automated Website Download

File Naming Convention

6-7 File type

6-7 File type

6-7 File type

8 A – Z = Production data files (except R = Resend data files)

Uncompressed File Names

6-7 File type

8 A – Z = production (except R = resend)

Extension .TXT (indicates an ASCII text file)

Interpreting Record Layouts

Start End Length Data/Type Description

Figure 1 Record Layout diagram

B Indicates the type of record defined (Header, Detail, or Trailer).

G Describes the total number of bytes or length of the field.

H Indicates the type of data in the field (alphabetic, alphanumeric, or numeric).

I Indicates the contents or description of the field.

Locating More Information

Submitting Documentation Comments

Include the following information with your correspondence:

• Title of the guide and date on the cover

• Document section, chapter, and page number

• Your suggestion for how to correct or improve documentation

For more information on the… See…

Sign In Page Page 10

My Directory Page Page 11

My CSV Directory Page Page 13

My PDF Directory Page 15

My File History Page Page 18

Figure 2. Internet Dealer Commissions Sign In page

Password Enter your IDC password in this box.

Enroll Allow Home Office associates to enroll to receive IDC files.

Figure 3. Internet Dealer Commissions My Directory page

User Profile Details

• Software interpreting data feeds

Total Number of files available for retrieval.

Check All Select all available files.

Uncheck All Deselect all available files.

Change Password Allow IDC users to change their password.

My CSV Directory Page

Figure 4. Internet Dealer Commissions My File History page

User Profile Details

• Software interpreting data feeds

Total Number of files available for retrieval.

Records The total number of records within the file.