| Field Name |
Description |
Data Type |
| Cust_ShortName |
last, firstname |
varchar(50) |
| Cust_FirstName |
first name |
varchar(100) |
| Cust_LastName |
last name |
varchar(100) |
| Cust_Opened |
date account opened |
smalldatetime |
| Cust_Closed |
date account closed |
smalldatetime |
| CA_FormalName |
firstname last name |
varchar(50) |
| CA_Contact |
main contact on account |
varchar(50) |
| CA_Address |
main address |
varchar(255) |
| CA_City |
city |
varchar(50) |
| CA_State |
state |
varchar(20) |
| CA_Zip |
zip code |
varchar(15) |
| CA_Email |
email address |
varchar(60) |
| CA_Phone1 |
phone number |
varchar(15) |
| CA_Extension1 |
phone extension |
varchar(5) |
| CA_Phone2 |
phone number 2 |
varchar(15) |
| CA_Extension2 |
phone 2 extension |
varchar(5) |
| CA_Fax |
fax |
varchar(15) |
| CA_WebAddress |
website address |
varchar(50) |
| Cust_TypeDescription |
customer type |
text |
| Cust_LastModified |
customer last modified |
smalldatetime |
We also have additional fields, attach additional data using other column names and we can map the additional data into a particular column in your IMERCHANT database. |