Email Marking Additional Fields

For: Jonas Club Management Clients

Field Selection:

The following page will outline the additional available fields that can be uploaded from your Jonas system onto the email marketing server. By default 23 Jonas fields (in addition to email address) will already be selected to upload onto your email marketing website and have been highlighted in red. Contact your email marketing representative if you would like to remove some of the default fields. You may also refer to the email marketing readiness form for a listing of these 23 Jonas fields.

You can choose up to 26 additional fields from the listing below. If in the future you decide that you would want to have additional fields added, documentation will be provided to outline this process. Using the list below, take note of the field Code and enter it on the email marketing readiness form in the indicated area. Fields highlighted in Red are fields that we have already included

Only the Field Code is necessary.

Email implementation@jonasclub.com for any questions or concerns.

Roster Information - back to top
000 Email Address Type A01 Member # A02 Surname A03 1st Name A04 1st Initial A05 Familiar Name A06 Title A07 Name (1st,Last) A08 Name (Familiar, Last) A09 Name (Title, 1st, Last) A10 Sex A11 Name (Last, 1st) A12 Peerage Title Code A13 Peerage Title in Person A14 Peerage Title Formal Ltr A15 Peerage Title Social Ltr A16 Peerage Title Formal Env. A17 Peerage Title Social Env. A18 Address Line 4 A19 Address Line 5 A20 Address line 1 A21 Address Line 2 A22 Address Line 3 A23 Postal / Zip Code A24 Telephone A25 Alternate A26 Fax # A27 Yrs member has belonged A28 Cell Number A29 Birthdate (raw CCYYMMDD) A32 Year of Birth (CCYY) A33 Month of Birth	A34 Birthdate (raw MMDD) A36 Date Joined (CCYYMMDD) A37 Year Joined (CCYY) A38 Month Joined A39 Age of Member A40 Last Dues A41 Last Chit A42 Last Payment A43 Last Statement A44 Last Minimum A45 Last Payment Amount A46 On Leave From A47 On Leave To A48 On Leave Status A50 Member Card # A51 Credit Card Type A52 Credit Card Type Desc. A53 Credit Card # A54 Credit Card Expiry Date A55 GST Exempt ? A56 PST Exempt ? A57 SVC Chg Exempt ? A58 Interest Exempt A60 Current Balance A61 Credit Limit A70 Member # to Bill A71 Name of Member to Bill A72 Affiliation Type A73 Affiliation Description A77 Statement Format A78 Email Format A79 Email Address	A80 Member Status A81 Status-Description A82 Status-Signing? A83 Status-Apply Dues ? A84 Status-Statements? A85 Status-Club Usage? A86 Status-Member Count? A87 Status-Apply Minimums? A88 Status Type A90 Minimum Billing Type A91 Minimum Billing Desc. A92 First Letter of Surname A93 Suffix A94 VIP Message Code A95 Marital Status A96 Date Resigned (CCYYMMDD) ABA Statement Bin - assigned ABB Stmt Bin - assign.desc ABF Statement Bin - forced ABG Stmt Bin - forced desc AFE Indicate if Female (1/0) AGC Golfer Classification AGR Age range (eg 20-24) AIN Internet NT Account AIP Internet PIN No ALB Member Loyalty Balance AMA Indicate if Male (1/0) AMC Alternate Member Card# AMD Member Discount % APB Photo image ASB Signature Image
Member Billing Information (for non-Athletic Clubs) - back to top
B01 Activity #1 B02 Activity #1 Description B03 Category #1 B04 Category #1 Description B05 Discount #1 B06 Billing Arrangement #1 B07 Arrangement Description#1 B08 Fee Schedule1 Total Amt B11 Activity #2 B12 Activity #2 Description B13 Category #2 B14 Category #2 Description B15 Discount #2 B16 Billing Arrangement #2 B17 Arrangement Description#2 B18 Fee Schedule2 Total Amt B21 Activity #3 B22 Activity #3 Description B23 Category #3 B24 Category #3 Description B25 Discount #3 B26 Billing Arrangement #3 B27 Arrangement Description#3 B28 Fee Schedule3 Total Amt B31 Activity #4 B32 Activity #4 Description B33 Category #4 B34 Category #4 Description B35 Discount #4 B36 Billing Arrangement #4 B37 Arrangement Description#4 B38 Fee Schedule4 Total Amt B41 Activity #5 B42 Activity #5 Description B43 Category #5 B44 Category #5 Description B45 Discount #5 B46 Billing Arrangement #5 B47 Arrangement Description#5 B48 Fee Schedule5 Total Amt B51 Activity #6 B52 Activity #6 Description B53 Category #6 B54 Category #6 Description B55 Discount #6 B56 Billing Arrangement #6 B57 Arrangement Description#6 B58 Fee Schedule6 Total Amt B61 Activity #7 B62 Activity #7 Description B63 Category #7 B64 Category #7 Description B65 Discount #7 B66 Billing Arrangement #7 B67 Arrangement Description#7 B68 Fee Schedule7 Total Amt B71 Activity #8 B72 Activity #8 Description B73 Category #8 B74 Category #8 Description B75 Discount #8 B76 Billing Arrangement #8 B77 Arrangement Description#8 B78 Fee Schedule8 Total Amt B81 Activity #9 B82 Activity #9 Description B83 Category #9 B84 Category #9 Description B85 Discount #9 B86 Billing Arrangement #9 B87 Arrangement Description#9 B88 Fee Schedule9 Total Amt B91 Activity #10 B92 Activity #10 Description B93 Category #10 B94 Category #10 Description B95 Discount #10 B96 Billing Arrangement #10 B97 ArrangementDescription#10 B98 Fee Schedule10 Total Amt B99 Cycle Billing Code	BA1 Activity #11 BA2 Activity #11 Description BA3 Category #11 BA4 Category #11 Description BA5 Discount #11 BA6 Billing Arrangement #11 BA7 ArrangementDescription#11 BA8 Fee Schedule11 Total Amt BB1 Activity #12 BB2 Activity #12 Description BB3 Category #12 BB4 Category #12 Description BB5 Discount #12 BB6 Billing Arrangement #12 BB7 ArrangementDescription#12 BB8 Fee Schedule12 Total Amt BC1 Activity #13 BC2 Activity #13 Description BC3 Category #13 BC4 Category #13 Description BC5 Discount #13 BC6 Billing Arrangement #13 BC7 ArrangementDescription#13 BC8 Fee Schedule13 Total Amt BD1 Activity #14 BD2 Activity #14 Description BD3 Category #14 BD4 Category #14 Description BD5 Discount #14 BD6 Billing Arrangement #14 BD7 ArrangementDescription#14 BD8 Fee Schedule14 Total Amt BE1 Activity #15 BE2 Activity #15 Description BE3 Category #15 BE4 Category #15 Description BE5 Discount #15 BE6 Billing Arrangement #15 BE7 ArrangementDescription#15 BE8 Fee Schedule15 Total Amt BF1 Activity #16 BF2 Activity #16 Description BF3 Category #16 BF4 Category #16 Description BF5 Discount #16 BF6 Billing Arrangement #16 BF7 ArrangementDescription#16 BF8 Fee Schedule16 Total Amt BG1 Activity #17 BG2 Activity #17 Description BG3 Category #17 BG4 Category #17 Description BG5 Discount #17 BG6 Billing Arrangement #17 BG7 ArrangementDescription#17 BG8 Fee Schedule17 Total Amt BH1 Activity #18 BH2 Activity #18 Description BH3 Category #18 BH4 Category #18 Description BH5 Discount #18 BH6 Billing Arrangement #18 BH7 ArrangementDescription#18 BH8 Fee Schedule18 Total Amt BI1 Activity #19 BI2 Activity #19 Description BI3 Category #19 BI4 Category #19 Description BI5 Discount #19 BI6 Billing Arrangement #19 BI7 ArrangementDescription#19 BI8 Fee Schedule19 Total Amt BJ1 Activity #20 BJ2 Activity #20 Description BJ3 Category #20 BJ4 Category #20 Description BJ5 Discount #20 BJ6 Billing Arrangement #20 BJ7 ArrangementDescription#20 BJ8 Fee Schedule20 Total Amt	BK1 Activity #21 BK2 Activity #21 Description BK3 Category #21 BK4 Category #21 Description BK5 Discount #21 BK6 Billing Arrangement #21 BK7 ArrangementDescription#21 BK8 Fee Schedule21 Total Amt BL1 Activity #22 BL2 Activity #22 Description BL3 Category #22 BL4 Category #22 Description BL5 Discount #22 BL6 Billing Arrangement #22 BL7 ArrangementDescription#22 BL8 Fee Schedule22 Total Amt BM1 Activity #23 BM2 Activity #23 Description BM3 Category #23 BM4 Category #23 Description BM5 Discount #23 BM6 Billing Arrangement #23 BM7 ArrangementDescription#23 BM8 Fee Schedule23 Total Amt BN1 Activity #24 BN2 Activity #24 Description BN3 Category #24 BN4 Category #24 Description BN5 Discount #24 BN6 Billing Arrangement #24 BN7 ArrangementDescription#24 BN8 Fee Schedule24 Total Amt BO1 Fixed Bill#1 BO2 Fixed Bill#2 BO3 Fixed Bill#3 BO4 Fixed Bill#4 BO5 Fixed Bill#5 BO6 Fixed Bill#6 BO7 Fixed Bill#7 BO8 Fixed Bill#8 BO9 Fixed Bill#9 BP1 Fixed Bill#10 BP2 Fixed Bill#11 BP3 Fixed Bill#12 BP4 Fixed Bill#13 BP5 Fixed Bill#14 BP6 Fixed Bill#15 BP7 Fixed Bill#16 BP8 Fixed Bill#17 BP9 Fixed Bill#18 BQ1 Fixed Bill#19 BQ2 Fixed Bill#20 BQ3 Fixed Bill#21 BQ4 Fixed Bill#22 BQ5 Fixed Bill#23 BQ6 Fixed Bill#24 BR1 Fee Billing Bill-To Ln 1 BR2 Fee Billing Bill-To Ln 2 BR3 Fee Billing Bill-To Ln 3 BR4 Fee Billing Bill-To Ln 4 BR5 Fee Billing Bill-To Ln 5 BR6 Fee Billing Bill-To Ln 6 BR7 Fee Billing Bill-To Ln 7 BR8 Fee Billing Bill-To Ln 8 BR9 Fee Billing Bill-To Ln 9 BS1 Fee Billing Bill-To Ln 10 BS2 Fee Billing Bill-To Ln 11 BS3 Fee Billing Bill-To Ln 12 BS4 Fee Billing Bill-To Ln 13 BS5 Fee Billing Bill-To Ln 14 BS6 Fee Billing Bill-To Ln 15 BS7 Fee Billing Bill-To Ln 16 BS8 Fee Billing Bill-To Ln 17 BS9 Fee Billing Bill-To Ln 18 BT1 Fee Billing Bill-To Ln 19 BT2 Fee Billing Bill-To Ln 20 BT3 Fee Billing Bill-To Ln 21 BT4 Fee Billing Bill-To Ln 22 BT5 Fee Billing Bill-To Ln 23 BT6 Fee Billing Bill-To Ln 24
Member Notes - back to top
C01 Note Field #1 C02 Note Field #2 C03 Note Field #3 C04 Note Field #4 C05 Note Filed #5	C06 Note Field #6 C07 Note Field #7 C08 Note Field #8 C09 Note Field #9 C10 Note Field #10	C11 Note Field #11 C12 Note Field #12 CRA Credit Book 'A' Balance CRB Credit Book 'B' Balance CRC Credit Book 'C' Balance
Relationship Information - back to top
D01 No.of Relationships D1M Relationship 1 Member# D1N Relationship 1 Name D1R Relationship 1 Descriptn D2M Relationship 2 Member# D2N Relationship 2 Name D2R Relationship 2 Descriptn D3M Relationship 3 Member# D3N Relationship 3 Name D3R Relationship 3 Descriptn D4M Relationship 4 Member# D4N Relationship 4 Name D4R Relationship 4 Descriptn D5M Relationship 5 Member# D5N Relationship 5 Name D5R Relationship 5 Descriptn	D6M Relationship 6 Member# D6N Relationship 6 Name D6R Relationship 6 Descriptn D7M Relationship 7 Member# D7N Relationship 7 Name D7R Relationship 7 Descriptn D8M Relationship 8 Member# D8N Relationship 8 Name D8R Relationship 8 Descriptn D9M Relationship 9 Member# D9N Relationship 9 Name D9R Relationship 9 Descriptn DAM Relationship 10 Member# DAN Relationship 10 Name DAR Relationship 10 Descriptn	DBM Relationship 11 Member# DBN Relationship 11 Name DBR Relationship 11 Descriptn DCM Relationship 12 Member# DCN Relationship 12 Name DCR Relationship 12 Descriptn DDM Relationship 13 Member# DDN Relationship 13 Name DDR Relationship 13 Descriptn DEM Relationship 14 Member# DEN Relationship 14 Name DER Relationship 14 Descriptn DFM Relationship 15 Member# DFN Relationship 15 Name DFR Relationship 15 Descriptn
Member Billing Information (for Athletic Clubs ONLY) - back to top
F11 Activity Description 1 F12 Category Description 1 F13 From Date 1 F14 To Date 1 F15 Renew 1 F16 Discount 1 F17 Billing Arrangement 1 F18 Subsidy member 1 F19 Subsidy Amt/Pct 1 F1A Subsidy value 1 F1B Activity Code 1 F1C Category Code 1 F1D Contract Amount 1 F1E Contract Period 1 F1F Future Contract Amt 1 F1G Contract Bill Amount 1 F1H Unbilled Contract 1 F1I Deposit Remaining 1 F1J Contract Remaining 1 F21 Activity Description 2 F22 Category Description 2 F23 From Date 2 F24 To Date 2 F25 Renew 2 F26 Discount 2 F27 Billing Arrangement 2 F28 Subsidy member 2 F29 Subsidy Amt/Pct 2 F2A Subsidy value 2 F2B Activity Code 2 F2C Category Code 2 F2D Contract Amount 2 F2E Contract Period 2 F2F Future Contract Amt 2 F2G Contract Bill Amount 2 F2H Unbilled Contract 2 F2I Deposit Remaining 2 F2J Contract Remaining 2 F31 Activity Description 3 F32 Category Description 3 F33 From Date 3 F34 To Date 3 F35 Renew 3 F36 Discount 3 F37 Billing Arrangement 3 F38 Subsidy member 3 F39 Subsidy Amt/Pct 3 F3A Subsidy value 3 F3B Activity Code 3 F3C Category Code 3 F3D Contract Amount 3	F3E Contract Period 3 F3F Future Contract Amt 3 F3G Contract Bill Amount 3 F3H Unbilled Contract 3 F3I Deposit Remaining 3 F3J Contract Remaining 3 F41 Activity Description 4 F42 Category Description 4 F43 From Date 4 F44 To Date 4 F45 Renew 4 F46 Discount 4 F47 Billing Arrangement 4 F48 Subsidy member 4 F49 Subsidy Amt/Pct 4 F4A Subsidy value 4 F4B Activity Code 4 F4C Category Code 4 F4D Contract Amount 4 F4E Contract Period 4 F4F Future Contract Amt 4 F4G Contract Bill Amount 4 F4H Unbilled Contract 4 F4I Deposit Remaining 4 F4J Contract Remaining 4 F51 Activity Description 5 F52 Category Description 5 F53 From Date 5 F54 To Date 5 F55 Renew 5 F56 Discount 5 F57 Billing Arrangement 5 F58 Subsidy member 5 F59 Subsidy Amt/Pct 5 F5A Subsidy value 5 F5B Activity Code 5 F5C Category Code 5 F5D Contract Amount 5 F5E Contract Period 5 F5F Future Contract Amt 5 F5G Contract Bill Amount 5 F5H Unbilled Contract 5 F5I Deposit Remaining 5 F5J Contract Remaining 5 F61 Activity Description 6 F62 Category Description 6 F63 From Date 6 F64 To Date 6 F65 Renew 6 F66 Discount 6 F67 Billing Arrangement 6	F68 Subsidy member 6 F69 Subsidy Amt/Pct 6 F6A Subsidy value 6 F6B Activity Code 6 F6C Category Code 6 F6D Contract Amount 6 F6E Contract Period 6 F6F Future Contract Amt 6 F6G Contract Bill Amount 6 F6H Unbilled Contract 6 F6I Deposit Remaining 6 F6J Contract Remaining 6 F71 Activity Description 7 F72 Category Description 7 F73 From Date 7 F74 To Date 7 F75 Renew 7 F76 Discount 7 F77 Billing Arrangement 7 F78 Subsidy member 7 F79 Subsidy Amt/Pct 7 F7A Subsidy value 7 F7B Activity Code 7 F7C Category Code 7 F7D Contract Amount 7 F7E Contract Period 7 F7F Future Contract Amt 7 F7G Contract Bill Amount 7 F7H Unbilled Contract 7 F7I Deposit Remaining 7 F7J Contract Remaining 7 F81 Activity Description 8 F82 Category Description 8 F83 From Date 8 F84 To Date 8 F85 Renew 8 F86 Discount 8 F87 Billing Arrangement 8 F88 Subsidy member 8 F89 Subsidy Amt/Pct 8 F8A Subsidy value 8 F8B Activity Code 8 F8C Category Code 8 F8D Contract Amount 8 F8E Contract Period 8 F8F Future Contract Amt 8 F8G Contract Bill Amount 8 F8H Unbilled Contract 8 F8I Deposit Remaining 8 F8J Contract Remaining 8 FL1 Fitness LOA Depart. Date FL2 Fitness LOA Return Date
Golf Reporting - back to top
G01 Golf Rounds #1 G02 Golf Rounds #2 G03 Golf Rounds #3	G04 Golf Rounds #4 G05 Golf Rounds #5 GA1 Gate Sec: Neighbourhood	GA2 Neighbourhood Description GA3 Gate Sec: Lot Code GA4 Lot Description
Gift Certificate Balances - back to top
GCA Gift Cert 'A' Balance	GCB Gift Cert 'B' Balance	GCC Gift Cert 'C' Balance
Member Mailing Information - back to top
I01 Regular Title I02 Proper Title I03 Family Title I11 General Address I12 General Title I21 Statement Address I22 Statement Title	I31 Overdue Address I32 Overdue Title I41 Mailing Category1 Address I42 Mailing Category1 Title I51 Mailing Category2 Address I52 Mailing Category2 Title I61 Mailing Category3 Address	I62 Mailing Category3 Title I71 Mailing Category4 Address I72 Mailing Category4 Title I81 Mailing Category5 Address I82 Mailing Category5 Title
Levies - back to top
LEB Levies Balance
Custom Fields - back to top
M01 Custom Field 1 M02 Custom Field 2 M03 Custom Field 3 M04 Custom Field 4 M05 Custom Field 5 M06 Custom Field 6 M07 Custom Field 7 M08 Custom Field 8 M09 Custom Field 9 M10 Custom Field 10 M11 Custom Field 11 M12 Custom Field 12 M13 Custom Field 13 M14 Custom Field 14 M15 Custom Field 15 M16 Custom Field 16 M17 Custom Field 17 M18 Custom Field 18 M19 Custom Field 19 M20 Custom Field 20 M21 Custom Field 21 M22 Custom Field 22 M23 Custom Field 23 M24 Custom Field 24 M25 Custom Field 25 M26 Custom Field 26 M27 Custom Field 27 M28 Custom Field 28 M29 Custom Field 29 M30 Custom Field 30 M31 Custom Field 31 M32 Custom Field 32 M33 Custom Field 33 M34 Custom Field 34 M35 Custom Field 35 M36 Custom Field 36 M37 Custom Field 37 M38 Custom Field 38 M39 Custom Field 39 M40 Custom Field 40 M41 Custom Field 41 M42 Custom Field 42 M43 Custom Field 43 M44 Custom Field 44 M45 Custom Field 45 M46 Custom Field 46 M47 Custom Field 47 M48 Custom Field 48 M49 Custom Field 49 M50 Custom Field 50 M51 Custom Field 51 M52 Custom Field 52 M53 Custom Field 53 M54 Custom Field 54 M55 Custom Field 55 M56 Custom Field 56 M57 Custom Field 57 M58 Custom Field 58 M59 Custom Field 59 M60 Custom Field 60 M61 Custom Field 61 M62 Custom Field 62 M63 Custom Field 63 M64 Custom Field 64 M65 Custom Field 65 M66 Custom Field 66 M67 Custom Field 67 M68 Custom Field 68 M69 Custom Field 69 M70 Custom Field 70 M71 Custom Field 71 M72 Custom Field 72 M73 Custom Field 73 M74 Custom Field 74 M75 Custom Field 75 M76 Custom Field 76 M77 Custom Field 77 M78 Custom Field 78 M79 Custom Field 79 M80 Custom Field 80 M81 Custom Field 81 M82 Custom Field 82 M83 Custom Field 83 M84 Custom Field 84 M85 Custom Field 85 M86 Custom Field 86 M87 Custom Field 87 M88 Custom Field 88 M89 Custom Field 89 M90 Custom Field 90 M91 Custom Field 91 M92 Custom Field 92 M93 Custom Field 93 M94 Custom Field 94 M95 Custom Field 95 M96 Custom Field 96 M97 Custom Field 97 M98 Custom Field 98 M99 Custom Field 99 MA0 Custom Field 100	MA1 Custom Field 101 MA2 Custom Field 102 MA3 Custom Field 103 MA4 Custom Field 104 MA5 Custom Field 105 MA6 Custom Field 106 MA7 Custom Field 107 MA8 Custom Field 108 MA9 Custom Field 109 MB0 Custom Field 110 MB1 Custom Field 111 MB2 Custom Field 112 MB3 Custom Field 113 MB4 Custom Field 114 MB5 Custom Field 115 MB6 Custom Field 116 MB7 Custom Field 117 MB8 Custom Field 118 MB9 Custom Field 119 MC0 Custom Field 120 MC1 Custom Field 121 MC2 Custom Field 122 MC3 Custom Field 123 MC4 Custom Field 124 MC5 Custom Field 125 MC6 Custom Field 126 MC7 Custom Field 127 MC8 Custom Field 128 MC9 Custom Field 129 MD0 Custom Field 130 MD1 Custom Field 131 MD2 Custom Field 132 MD3 Custom Field 133 MD4 Custom Field 134 MD5 Custom Field 135 MD6 Custom Field 136 MD7 Custom Field 137 MD8 Custom Field 138 MD9 Custom Field 139 ME0 Custom Field 140 ME1 Custom Field 141 ME2 Custom Field 142 ME3 Custom Field 143 ME4 Custom Field 144 ME5 Custom Field 145 ME6 Custom Field 146 ME7 Custom Field 147 ME8 Custom Field 148 ME9 Custom Field 149 MF0 Custom Field 150 MF1 Custom Field 151 MF2 Custom Field 152 MF3 Custom Field 153 MF4 Custom Field 154 MF5 Custom Field 155 MF6 Custom Field 156 MF7 Custom Field 157 MF8 Custom Field 158 MF9 Custom Field 159 MG0 Custom Field 160 MG1 Custom Field 161 MG2 Custom Field 162 MG3 Custom Field 163 MG4 Custom Field 164 MG5 Custom Field 165 MG6 Custom Field 166 MG7 Custom Field 167 MG8 Custom Field 168 MG9 Custom Field 169 MH0 Custom Field 170 MH1 Custom Field 171 MH2 Custom Field 172 MH3 Custom Field 173 MH4 Custom Field 174 MH5 Custom Field 175 MH6 Custom Field 176 MH7 Custom Field 177 MH8 Custom Field 178 MH9 Custom Field 179 MI0 Custom Field 180 MI1 Custom Field 181 MI2 Custom Field 182 MI3 Custom Field 183 MI4 Custom Field 184 MI5 Custom Field 185 MI6 Custom Field 186 MI7 Custom Field 187 MI8 Custom Field 188 MI9 Custom Field 189 MJ0 Custom Field 190 MJ1 Custom Field 191 MJ2 Custom Field 192 MJ3 Custom Field 193 MJ4 Custom Field 194 MJ5 Custom Field 195 MJ6 Custom Field 196 MJ7 Custom Field 197 MJ8 Custom Field 198 MJ9 Custom Field 199 MK0 Custom Field 200	MK1 Custom Field 201 MK2 Custom Field 202 MK3 Custom Field 203 MK4 Custom Field 204 MK5 Custom Field 205 MK6 Custom Field 206 MK7 Custom Field 207 MK8 Custom Field 208 MK9 Custom Field 209 ML0 Custom Field 210 ML1 Custom Field 211 ML2 Custom Field 212 ML3 Custom Field 213 ML4 Custom Field 214 ML5 Custom Field 215 ML6 Custom Field 216 ML7 Custom Field 217 ML8 Custom Field 218 ML9 Custom Field 219 MM0 Custom Field 220 MM1 Custom Field 221 MM2 Custom Field 222 MM3 Custom Field 223 MM4 Custom Field 224 MM5 Custom Field 225 MM6 Custom Field 226 MM7 Custom Field 227 MM8 Custom Field 228 MM9 Custom Field 229 MN0 Custom Field 230 MN1 Custom Field 231 MN2 Custom Field 232 MN3 Custom Field 233 MN4 Custom Field 234 MN5 Custom Field 235 MN6 Custom Field 236 MN7 Custom Field 237 MN8 Custom Field 238 MN9 Custom Field 239 MO0 Custom Field 240 MO1 Custom Field 241 MO2 Custom Field 242 MO3 Custom Field 243 MO4 Custom Field 244 MO5 Custom Field 245 MO6 Custom Field 246 MO7 Custom Field 247 MO8 Custom Field 248 MO9 Custom Field 249 MP0 Custom Field 250 MP1 Custom Field 251 MP2 Custom Field 252 MP3 Custom Field 253 MP4 Custom Field 254 MP5 Custom Field 255 MP6 Custom Field 256 MP7 Custom Field 257 MP8 Custom Field 258 MP9 Custom Field 259 MQ0 Custom Field 260 MQ1 Custom Field 261 MQ2 Custom Field 262 MQ3 Custom Field 263 MQ4 Custom Field 264 MQ5 Custom Field 265 MQ6 Custom Field 266 MQ7 Custom Field 267 MQ8 Custom Field 268 MQ9 Custom Field 269 MR0 Custom Field 270 MR1 Custom Field 271 MR2 Custom Field 272 MR3 Custom Field 273 MR4 Custom Field 274 MR5 Custom Field 275 MR6 Custom Field 276 MR7 Custom Field 277 MR8 Custom Field 278 MR9 Custom Field 279 MS0 Custom Field 280 MS1 Custom Field 281 MS2 Custom Field 282 MS3 Custom Field 283 MS4 Custom Field 284 MS5 Custom Field 285 MS6 Custom Field 286 MS7 Custom Field 287 MS8 Custom Field 288 MS9 Custom Field 289 MT0 Custom Field 290 MT1 Custom Field 291 MT2 Custom Field 292 MT3 Custom Field 293 MT4 Custom Field 294 MT5 Custom Field 295 MT6 Custom Field 296 MT7 Custom Field 297 MT8 Custom Field 298 MT9 Custom Field 299 MU0 Custom Field 300
Member Other Address Information - back to top
O11 Other Addr. #1-Location O12 Other Addr. #1-Address #1 O13 Other Addr. #1-Address #2 O14 Other Addr. #1-Address #3 O15 Other Addr. #1-Postl Code O16 Other Addr. #1-Telephone# O17 Other Addr. #1-Address #4 O18 Other Addr. #1-Address #5 O21 Other Addr. #2-Location O22 Other Addr. #2-Address #1 O23 Other Addr. #2-Address #2 O24 Other Addr. #2-Address #3 O25 Other Addr. #2-Postl Code O26 Other Addr. #2-Telephone# O27 Other Addr. #2-Address #4 O28 Other Addr. #2-Address #5	O31 Other Addr. #3-Location O32 Other Addr. #3-Address #1 O33 Other Addr. #3-Address #2 O34 Other Addr. #3-Address #3 O35 Other Addr. #3-Address #4 O36 Other Addr. #3-Address #5 O37 Other Addr. #3-Postl Code O38 Other Addr. #3-Telephone# O41 Other Addr. #4-Location O42 Other Addr. #4-Address #1 O43 Other Addr. #4-Address #2 O44 Other Addr. #4-Address #3 O45 Other Addr. #4-Address #4 O46 Other Addr. #4-Address #5 O47 Other Addr. #4-Postl Code O48 Other Addr. #4-Telephone#	O51 Other Addr. #5-Location O52 Other Addr. #5-Address #1 O53 Other Addr. #5-Address #2 O54 Other Addr. #5-Address #3 O55 Other Addr. #5-Address #4 O56 Other Addr. #5-Address #5 O57 Other Addr. #5-Postl Code O58 Other Addr. #5-Telephone# O61 Other Addr. #6-Location O62 Other Addr. #6-Address #1 O63 Other Addr. #6-Address #2 O64 Other Addr. #6-Address #3 O65 Other Addr. #6-Address #4 O66 Other Addr. #6-Address #5 O67 Other Addr. #6-Postl Code O68 Other Addr. #6-Telephone#
Member Prepaid Minimum - back to top
Q01 Date PrePaid Received Q02 Amount of PrePaid Minimum Q03 Last PrePaid Applied Q04 PrePaid Minimum Applied Q05 PrePaid Minimum Unapplied Q06 PrePaid Minimum Released Q10 Minimum Spent/Applied	Q11 Minimum Billed Q12 Minimum Req'd Q13 Minimum Unspent Q21 Incl. Mins of Member1 Q22 Incl. Mins of Member2 Q23 Incl. Mins of Member3 Q24 Incl. Mins of Member4	Q25 Incl. Mins of Member5 Q26 Incl. Mins of Member6 Q27 Incl. Mins of Member7 Q28 Incl. Mins of Member8 Q29 Incl. Mins of Member9 Q30 Incl. Mins of Member10
Accounts Receivable Balances - back to top
R01 A/R Total Outstanding R02 A/R Current Balance R03 A/R 31-60 Day Balance R04 A/R 31 Days & Over	R05 A/R 61-90 Day Balance R06 A/R 61 Days & Over R07 A/R 91-120 Day Balance R08 A/R 91 Days & Over	R09 A/R 121 Days & Over RGR Revenue Group
Member Business Information - back to top
U10 Occupation Code U11 Occupation Description U12 Business Title & Name U20 Corporate Code U31 Company Name U32 Business Address #1	U33 Business Address #2 U34 Business Address #3 U35 Business ZIP/Postal Code U36 Business Telephone # U37 Business Ph # Extension U38 Business Fax #	U39 Business Alternate # U40 Business Email Address U41 Business Administrator U42 Business Address #4 U43 Business Address #5
Activity Tracking - back to top
V01 Date of First Visit	V02 Date of Last Visit	V03 Number of Visits
Voting Share - back to top
VTG Voting Group (Lampton)

Roster Information - back to top

000 Email Address Type
A01 Member #
A02 Surname
A03 1st Name
A04 1st Initial
A05 Familiar Name
A06 Title
A07 Name (1st,Last)
A08 Name (Familiar, Last)
A09 Name (Title, 1st, Last)
A10 Sex
A11 Name (Last, 1st)
A12 Peerage Title Code
A13 Peerage Title in Person
A14 Peerage Title Formal Ltr
A15 Peerage Title Social Ltr
A16 Peerage Title Formal Env.
A17 Peerage Title Social Env.
A18 Address Line 4
A19 Address Line 5
A20 Address line 1
A21 Address Line 2
A22 Address Line 3
A23 Postal / Zip Code
A24 Telephone
A25 Alternate
A26 Fax #
A27 Yrs member has belonged
A28 Cell Number
A29 Birthdate (raw CCYYMMDD)
A32 Year of Birth (CCYY)
A33 Month of Birth

A34 Birthdate (raw MMDD)
A36 Date Joined (CCYYMMDD)
A37 Year Joined (CCYY)
A38 Month Joined
A39 Age of Member
A40 Last Dues
A41 Last Chit
A42 Last Payment
A43 Last Statement
A44 Last Minimum
A45 Last Payment Amount
A46 On Leave From
A47 On Leave To
A48 On Leave Status
A50 Member Card #
A51 Credit Card Type
A52 Credit Card Type Desc.
A53 Credit Card #
A54 Credit Card Expiry Date
A55 GST Exempt ?
A56 PST Exempt ?
A57 SVC Chg Exempt ?
A58 Interest Exempt
A60 Current Balance
A61 Credit Limit
A70 Member # to Bill
A71 Name of Member to Bill
A72 Affiliation Type
A73 Affiliation Description
A77 Statement Forma
A78 Email Forma
A79 Email Address

A80 Member Status
A81 Status-Description
A82 Status-Signing?
A83 Status-Apply Dues ?
A84 Status-Statements?
A85 Status-Club Usage?
A86 Status-Member Count?
A87 Status-Apply Minimums?
A88 Status Type
A90 Minimum Billing Type
A91 Minimum Billing Desc.
A92 First Letter of Surname
A93 Suffix
A94 VIP Message Code
A95 Marital Status
A96 Date Resigned (CCYYMMDD)
ABA Statement Bin - assigned
ABB Stmt Bin - assign.desc
ABF Statement Bin - forced
ABG Stmt Bin - forced desc
AFE Indicate if Female (1/0)
AGC Golfer Classification
AGR Age range (eg 20-24)
AIN Internet NT Account
AIP Internet PIN No
ALB Member Loyalty Balance
AMA Indicate if Male (1/0)
AMC Alternate Member Card#
AMD Member Discount %
APB Photo image
ASB Signature Image