Detail Record Specifications for FTP files in TrackMyMail

Detail record specifications for TrackMyMail jobs created via FTP
Products affected: TrackMyMail™

Detail records are individual mail records. There is 1 detail record per IMb.

ColumnTypeMax SizeRequired / Optional
Record TypeChar1Required
Value must be "D" (Detail)
CustomerUniqueIdentifierChar20Required
PostnetChar11Required
IMbChar20Required
Leftmost 20 characters, excludes Postnet
GreetingChar10Optional
FirstNameChar10Optional
MIChar2Optional
LastNameChar50Optional
SuffixChar10Optional
FullNameChar100Optional
CompanyChar50Optional
TitleChar50Optional
Address1Char128 Optional
Address2Char128Optional
CityChar50Optional
StateChar2Optional
ZipChar11Optional
UserDefined1Char100Optional
UserDefined2Char100Optional
UserDefined3Char100Optional
TMM JobIDNumeric8Optional
Required for special FTP uploads only
UserDefinedNum1Numeric (Decimal)12Optional
Max length may include up to 3 decimal places
UserDefinedNum2Numeric (Decimal)12Optional
Max length may include up to 3 decimal places
UserDefinedDate1Char10Optional (YYYY/MM/DD)
OriginIMbChar31Optional
InboundPostnetChar11Optional

Sample Detail Records

D,193784380,93401714021,00311000311012996179,,First,,Last 1,,First Last 1,,,123 BULLOCK LN,,SAN LUIS OBISPO,CA,93401714021,193784380,20 Group,,,,,,, D,193330902,90813272001,00311000311012996180,,First,,Last 2,,First Last 2,,,456 W 12TH ST,,LONG BEACH,CA,90813272001,193330902,20 Group,,,,,,, D,193338854,92504210010,00311000311012996181,,First,,Last 3,,First Last 3,,,789 STREETER AVE,,RIVERSIDE,CA,92504210010,193338854,20 Group,,,,,,, D,193344090,60618441943,00311000311012996182,,First,,Last 4,,First Last 4,,,321 N KIMBALL AVE,,CHICAGO,IL,60618441943,193344090,BOGO,,,,,,, D,193344672,28504,00311000311012996183,,First,,Last 5,,First Last 5,,,654 SPENCE TAYLOR RD,,KINGSTON,NC,28504,193344672,BOGO,,,,,,, D,193347152,30805342567,00311000311012996184,,First,,Last 6,,First Last 6,,,987 MURROW RD,,BLYTHE,GA,30805342567,193347152,BOGO,,,,,,, D,193347513,44108192363,00311000311012996185,,First,,Last 7,,First Last 7,,,123 SAINT CLAIR AVE,,CLEVELAND,OH,44108192363,193347513,BOGO,,,,,,, D,193349647,91403554762,00311000311012996186,,First,,Last 8,,First Last 8,,,456 DICKENS ST,,SHERMAN OAKS,CA,91403554762,193349647,20 Group,,,,,,,

UPDATED: November 22, 2022