Here is the record layout for the contributing member A/R file. The record length is 350.
|1||1||1||Record Code ("C")|
|8||11||4||*KOB (Business Category Code)|
|158||197||40||*City/State (Include state here)|
|198||202||5||*Zip - 5 digits|
|208||213||6||*Extract Date (MMDDYY)|
|214||225||12||*AR Number (Acct/Customer #)|
|246||247||2||Bureau ID Number|
|249||250||2||Year Opened (YY)|
|251||254||4||Date Last Activity|
|289||295||7||* 1 -30 days past due|
|297||303||7||*31 -60 days past due|
|305||311||7||*61 -90 days past due|
|313||319||7||*Over 90 days past due|
|321||322||2||Experian Comment Code|
|329||337||9||Zip - 9 digits|
* = Required Fields
All dollar amounts are in WHOLE DOLLARS.
Media we can accept:
• Mag tape – 9 track reel 1600 or 6250 BPI
• Mag tape – 3480/3490/3490e
• Mag tape – 1/4 inch qic cartridge 120, 525meg, 1.2, 2.5, or 30 gig
• C/D or DVD
‘zip’ the file or files, using a zip program such as winzip . The zipped file should be named Arxxzzzz where xx is the bureau #, such as 90 and zzzz is the member #, such as 0990.
Send the zipped file as an ‘attachment’. The e-mail address for media contributions is firstname.lastname@example.org
In the transmittal, please identify the member # and the member name. Also, if the submittal is new, please include the business category.
If the member cannot write a program to create the file in the enclosed layout, we need to have files with the same information.
It is preferable to get the data in a standard format. For example, we would prefer a standard txt format rather than an excel format.
Feel free to contact us if you have any questions or problems.