SpitFire Help Desk :: Listmaker Clients Table structure

Listmaker Clients Table structure

Field	Type (character limit)	Can import into this field via Listmaker?	Field visible in Agent window?
ClientID	11	no	no
Status	6	no	no
LastResult	255	no	no
Name	50	yes	yes
Company	255	yes	yes
Address	50	yes	yes
City	60	yes	yes
State	20	yes	yes
ZipCode	15	yes	yes
VoicePhone	20	yes	yes
SecVoicePhone	20	yes	no
Email	60	yes	yes
Website	60	yes	yes
HomePhone	20	yes	no
CellPhone	20	yes	no
Pager	20	no	no
DialResult	60	no	no
Hit	3	no	no
Points	6	no	no
Script	128	no	no
Message	128	no	no
NeedsEdit	3	no	no
MailBox	20	no	no
MailBoxPassword	20	no	no
MailBoxGreeting1	longblob	no	no
MailBoxGreeting2	longblob	no	no
SearchFlag	3	no	no
Group	20	yes	no
Target	20	no	no
Spare1	128	yes	yes
Spare2	128	yes	yes
Spare3	128	yes	yes
Spare4	128	yes	yes
Spare5	128	yes	yes
Spare6	128	yes	yes
Spare7	128	yes	yes
Spare8	128	yes	yes
Spare9	128	yes	yes
Spare10	128	yes	yes
Spare11	128	no	no
Spare12	128	no	no
Spare13	128	no	no
Spare14	128	no	no
Spare15	128	no	no
Spare16	128	no	no
Country	20	no	no
SelectField	10	no	no
Note	longtext	no	yes
Msg1	longblob	no	no
LastName	50	yes	no
FirstName	50	yes	no
CallCount	11	no	no
DateEdited	timestap	no	no
DateEntered	timestap	no	no