FIELDDBF

Field_name Field_type Field_len Table
Addressid N 17 ADDRESS
Contactid N 17 ADDRESS
Def C 1 ADDRESS
Postalcode C 10 ADDRESS
Addr_l1 C 40 ADDRESS
Addr_l2 C 40 ADDRESS
Addr_l3 C 40 ADDRESS
Addr_type C 21 ADDRESS
Incl_flds C 1 ADDRESS
City C 28 ADDRESS
State C 28 ADDRESS
Country C 28 ADDRESS
Tzoffset C 2 ADDRESS
Create_dt C 18 ADDRESS
Edit_dt C 18 ADDRESS
Userid N 6 ADDRESS
Pub C 30 ADDRESS
Agenttype N 6 AGENT
Agentkey N 17 AGENT
Agentid N 17 AGENT
Pub C 30 AGENT
Event_id N 17 ALARM
Alarm_date C 10 ALARM
Alarm_time N 6 ALARM
Status N 3 ALARM
Disp_date C 10 ALARM
Disp_time N 6 ALARM
Userid N 6 ALARM
Create_dt C 18 ALARM
Edit_dt C 18 ALARM
Pub C 30 ALARM
Sawgid N 6 ALARM
Idtype N 4 ALIASID
Oldid N 17 ALIASID
Newid N 17 ALIASID
Actioncode N 17 CAMPAIGNACTIONS
Descr C 60 CAMPAIGNACTIONS
Status N 6 CAMPAIGNACTIONS
Cat_desc C 30 CATEGORY
Create_dt C 18 CATEGORY
Edit_dt C 18 CATEGORY
Pub C 30 CATEGORY
Contactid N 17 CMNOTES
Linenbr N 5 CMNOTES
Datafld C 254 CMNOTES
Datalen N 5 CMNOTES
Create_dt C 18 CMNOTES
Edit_dt C 18 CMNOTES
Userid N 6 CMNOTES
Pub C 30 CMNOTES
Contactid N 17 CONTACT
Lastname C 21 CONTACT
Company C 42 CONTACT
Firstname C 21 CONTACT
Middlename C 21 CONTACT
Nickname C 21 CONTACT
Title C 42 CONTACT
Salutation C 21 CONTACT
Name2use C 42 CONTACT
Userid N 6 CONTACT
Createuser N 6 CONTACT
Edituserid N 6 CONTACT
Create_dt C 18 CONTACT
Edit_dt C 18 CONTACT
Pub C 30 CONTACT
Companyid N 17 CONTACT
Descrid N 17 CONTACTDESCRIPTION
Descr C 60 CONTACTDESCRIPTION
Edit_dt C 18 CONTACTDESCRIPTION
Pub C 30 CONTACTDESCRIPTION
Setid N 17 CUSTDATA
Fieldid N 17 CUSTDATA
Contactid N 17 CUSTDATA
Datafld C 30 CUSTDATA
Len N 4 CUSTDATA
Create_dt C 18 CUSTDATA
Edit_dt C 18 CUSTDATA
Userid N 6 CUSTDATA
Pub C 30 CUSTDATA
Setid N 17 CUSTDEF
Fieldid N 17 CUSTDEF
Fldnbr N 6 CUSTDEF
Name C 30 CUSTDEF
Type N 4 CUSTDEF
Autopop C 1 CUSTDEF
Memorize C 1 CUSTDEF
Popid N 17 CUSTDEF
Create_dt C 18 CUSTDEF
Edit_dt C 18 CUSTDEF
Userid N 6 CUSTDEF
Pub C 30 CUSTDEF
Descr C 30 CUSTPOP
Disp_ind C 1 CUSTPOP
Popid N 17 CUSTPOP
Create_dt C 18 CUSTPOP
Edit_dt C 18 CUSTPOP
Pub C 30 CUSTPOP
Setid N 17 CUSTSETS
Name C 30 CUSTSETS
Codecnt N 5 CUSTSETS
Maxcode N 5 CUSTSETS
Userid N 6 CUSTSETS
Create_dt C 18 CUSTSETS
Edit_dt C 18 CUSTSETS
Pub C 30 CUSTSETS
Adminonly I 4 CUSTSETS
Settype I 4 CUSTSETS
Descr C 30 DESCR
Create_dt C 18 DESCR
Edit_dt C 18 DESCR
Pub C 30 DESCR
Event_id N 17 EVENT
Event_type N 3 EVENT
Descr C 60 EVENT
Event_dt C 10 EVENT
Priority N 3 EVENT
Status N 3 EVENT
Disp_order N 11 EVENT
Event_time N 6 EVENT
Event_dur N 6 EVENT
Contactid N 17 EVENT
Listid N 17 EVENT
Recur_ind N 17 EVENT
Creep_ind N 3 EVENT
Notes_ind N 3 EVENT
Alarm_ind N 3 EVENT
Create_dt C 18 EVENT
Edit_dt C 18 EVENT
Userid N 6 EVENT
Original_d C 10 EVENT
Pub C 30 EVENT
Sawgid N 6 EVENT
Goalid N 17 GOALSTEMP
Seqnum N 5 GOALSTEMP
Descr C 60 GOALSTEMP
Timeafters N 6 GOALSTEMP
Type N 3 GOALSTEMP
Edit_dt C 18 GOALSTEMP
Wgid N 6 GOALSTEMP
Pub C 30 GOALSTEMP
Priority N 3 GOALSTEMP
Assignto N 6 GOALSTEMP
Contingenc N 6 GOALSTEMP
Groupid N 17 GROUPS
Descr C 40 GROUPS
Primary_id N 17 GROUPS
Userid N 6 GROUPS
Create_dt C 18 GROUPS
Edit_dt C 18 GROUPS
Pub C 30 GROUPS
Contactid N 17 HISTDATA
Historyid C 1 HISTDATA
Commentid N 17 HISTDATA
Linenbr N 4 HISTDATA
Historydat C 18 HISTDATA
Datafld C 254 HISTDATA
Datalen N 5 HISTDATA
Createuser N 6 HISTDATA
Edituserid N 6 HISTDATA
Create_dt C 18 HISTDATA
Edit_dt C 18 HISTDATA
Userid N 6 HISTDATA
Pub C 30 HISTDATA
Id N 17 ID3
Rowid N 11 ID3
Id N 17 ID4
Rowid N 11 ID4
Id N 17 ID5
Rowid N 11 ID5
Id N 17 ID6
Rowid N 11 ID6
Id N 17 ID7
Rowid N 11 ID7
Id N 17 ID9
Rowid N 11 ID9
Identifier N 6 IDENTIFI
Pub C 30 IDENTIFI
Key_desc C 30 KEYWORD
Create_dt C 18 KEYWORD
Edit_dt C 18 KEYWORD
Pub C 30 KEYWORD
Listid N 17 LIST
Contactid N 17 LIST
Create_dt C 18 LIST
Edit_dt C 18 LIST
Userid N 6 LIST
Pub C 30 LIST
Startdt C 18 LOGCALL
Stopdt C 18 LOGCALL
Phonenbr C 21 LOGCALL
Contactid N 17 LOGCALL
Listid N 17 LOGCALL
Eventid N 17 LOGCALL
History1 N 4 LOGCALL
History2 N 4 LOGCALL
History3 N 4 LOGCALL
Appts N 4 LOGCALL
Calls N 4 LOGCALL
Todos N 4 LOGCALL
Status C 2 LOGCALL
Code C 1 LOGCALL
Eventfrm C 1 LOGCALL
Eventorg C 1 LOGCALL
Eventtype C 1 LOGCALL
Desced C 1 LOGCALL
Detailed C 1 LOGCALL
Moved C 1 LOGCALL
Userid N 6 LOGCALL
Create_dt C 18 LOGCALL
Edit_dt C 18 LOGCALL
Pub C 30 LOGCALL
Userid N 6 LOGIN
Appid N 6 LOGIN
Connectid C 18 LOGIN
Groupid N 6 LOGIN
Pub C 30 LOGIN
Event_id N 17 NOTES
Disp_ord N 5 NOTES
Note_text C 240 NOTES
Text_len N 5 NOTES
Create_dt C 18 NOTES
Edit_dt C 18 NOTES
Userid N 6 NOTES
Pub C 30 NOTES
Sawgid N 6 NOTES
Objectid N 17 OBJECT
Field N 5 OBJECT
Fieldid N 17 OBJECT
Type N 3 OBJECT
File C 254 OBJECT
Userid N 6 OBJECT
Create_dt C 18 OBJECT
Edit_dt C 18 OBJECT
Pub C 30 OBJECT
Opptyid N 17 OPPTY
Projectid C 60 OPPTY
Company C 42 OPPTY
Descr C 60 OPPTY
Dollarvalu N 17 OPPTY
Dateopened D 8 OPPTY
Datetoclos D 8 OPPTY
Statusid N 17 OPPTY
Rollntime N 6 OPPTY
Buyerid N 17 OPPTY
Repid N 17 OPPTY
Opptytype N 17 OPPTY
Wgid N 6 OPPTY
Edit_dt C 18 OPPTY
Pub C 30 OPPTY
Itemized N 6 OPPTY
Opptyid N 17 OPPTYCONTACTS
Contactid N 17 OPPTYCONTACTS
Descr C 60 OPPTYCONTACTS
Edit_dt C 18 OPPTYCONTACTS
Wgid N 6 OPPTYCONTACTS
Pub C 30 OPPTYCONTACTS
Opptyid N 17 OPPTYGOALS
Activityid N 17 OPPTYGOALS
Edit_dt C 18 OPPTYGOALS
Wgid N 6 OPPTYGOALS
Pub C 30 OPPTYGOALS
Opptyid N 17 OPPTYITEMIZE
Descr C 60 OPPTYITEMIZE
Seqnum N 6 OPPTYITEMIZE
Month1 N 17 OPPTYITEMIZE
Month2 N 17 OPPTYITEMIZE
Month3 N 17 OPPTYITEMIZE
Month4 N 17 OPPTYITEMIZE
Month5 N 17 OPPTYITEMIZE
Month6 N 17 OPPTYITEMIZE
Month7 N 17 OPPTYITEMIZE
Month8 N 17 OPPTYITEMIZE
Month9 N 17 OPPTYITEMIZE
Month10 N 17 OPPTYITEMIZE
Month11 N 17 OPPTYITEMIZE
Month12 N 17 OPPTYITEMIZE
Edit_dt C 18 OPPTYITEMIZE
Pub C 30 OPPTYITEMIZE
Wgid N 6 OPPTYITEMIZE
Opptyid N 17 OPPTYSALESCYCLE
Completed N 3 OPPTYSALESCYCLE
Seqnum N 5 OPPTYSALESCYCLE
Descr C 60 OPPTYSALESCYCLE
Targetdate D 8 OPPTYSALESCYCLE
Weight N 5 OPPTYSALESCYCLE
Completion D 8 OPPTYSALESCYCLE
Edit_dt C 18 OPPTYSALESCYCLE
Wgid N 6 OPPTYSALESCYCLE
Pub C 30 OPPTYSALESCYCLE
Level N 3 OPPTYSALESCYCLE
Opptyid N 17 OPPTYSALESPLAN
Issue C 254 OPPTYSALESPLAN
Notes M 4 OPPTYSALESPLAN
Seqnum N 5 OPPTYSALESPLAN
Edit_dt C 18 OPPTYSALESPLAN
Wgid N 6 OPPTYSALESPLAN
Pub C 30 OPPTYSALESPLAN
Opptyid N 17 OPPTYSTAFF
Contactid N 17 OPPTYSTAFF
Descr C 60 OPPTYSTAFF
Edit_dt C 18 OPPTYSTAFF
Wgid N 6 OPPTYSTAFF
Pub C 30 OPPTYSTAFF
Userid N 6 OPPTYSTAFF
Opptytype N 17 OPPTYTEMP
Descr C 60 OPPTYTEMP
Pcdescr C 60 OPPTYTEMP
Repdescr C 60 OPPTYTEMP
Wgid N 6 OPPTYTEMP
Edit_dt C 18 OPPTYTEMP
Pub C 30 OPPTYTEMP
Barchive N 6 OPPTYTEMP
Descr C 40 PADDRTYPE
Create_dt C 18 PADDRTYPE
Edit_dt C 18 PADDRTYPE
Pub C 30 PADDRTYPE
Descr C 40 PCNTRYCODE
Create_dt C 18 PCNTRYCODE
Edit_dt C 18 PCNTRYCODE
Pub C 30 PCNTRYCODE
Phoneid N 17 PHONE
Contactid N 17 PHONE
Ph_def C 1 PHONE
Ph_num C 60 PHONE
Ph_type C 21 PHONE
Ph_ext C 5 PHONE
Cc C 5 PHONE
Create_dt C 18 PHONE
Edit_dt C 18 PHONE
Userid N 6 PHONE
Pub C 30 PHONE
Event_id N 17 POPUP
Type N 3 POPUP
Pop_desc C 30 POPUP
Create_dt C 18 POPUP
Edit_dt C 18 POPUP
Userid N 6 POPUP
Pub C 30 POPUP
Sawgid N 6 POPUP
Descr C 40 PPHONETYPE
Create_dt C 18 PPHONETYPE
Edit_dt C 18 PPHONETYPE
Pub C 30 PPHONETYPE
Descrid N 17 PRODUCTDESCRIPTION
Descr C 60 PRODUCTDESCRIPTION
Edit_dt C 18 PRODUCTDESCRIPTION
Pub C 30 PRODUCTDESCRIPTION
Id N 17 PROFNAME
Name C 30 PROFNAME
Type C 1 PROFNAME
Create_dt C 18 PROFNAME
Edit_dt C 18 PROFNAME
Pub C 30 PROFNAME
Profileid N 17 PROFSETS
Questionid N 17 PROFSETS
Disporder N 5 PROFSETS
Categoryid N 17 PROFSETS
Important C 1 PROFSETS
Text C 254 PROFSETS
Len N 5 PROFSETS
Create_dt C 18 PROFSETS
Edit_dt C 18 PROFSETS
Pub C 30 PROFSETS
Descr C 40 PSAL
Create_dt C 18 PSAL
Edit_dt C 18 PSAL
Pub C 30 PSAL
Descr C 40 PTITLE
Create_dt C 18 PTITLE
Edit_dt C 18 PTITLE
Pub C 30 PTITLE
Id N 17 QUOTE
Quotedate C 10 QUOTE
Counter N 4 QUOTE
Text C 254 QUOTE
Disporder N 4 QUOTE
Author C 30 QUOTE
Pub C 30 QUOTE
Recid N 17 RECEVENT
Event_id N 17 RECEVENT
Create_dt C 18 RECEVENT
Edit_dt C 18 RECEVENT
Userid N 6 RECEVENT
Pub C 30 RECEVENT
Lockid N 17 RECLOCK
Tname C 254 RECLOCK
Cname C 254 RECLOCK
Cvalue C 254 RECLOCK
Userid N 6 RECLOCK
Pub C 30 RECLOCK
Recid N 17 RECPROF
Incr N 11 RECPROF
Recurtype C 1 RECPROF
Occurrence C 254 RECPROF
Startdate C 10 RECPROF
Untilflag C 1 RECPROF
Untildate C 10 RECPROF
Forincr N 11 RECPROF
Fortype C 1 RECPROF
Weekends C 1 RECPROF
Event_type N 3 RECPROF
Descr C 60 RECPROF
Priority N 3 RECPROF
Status N 3 RECPROF
Event_time N 6 RECPROF
Event_dur N 6 RECPROF
Contactid N 17 RECPROF
Listid N 17 RECPROF
Creep_ind N 3 RECPROF
Alarm_time N 6 RECPROF
Category C 30 RECPROF
Userid N 6 RECPROF
Create_dt C 18 RECPROF
Edit_dt C 18 RECPROF
Pub C 30 RECPROF
Descrid N 17 REPDESCRIPTION
Descr C 60 REPDESCRIPTION
Edit_dt C 18 REPDESCRIPTION
Pub C 30 REPDESCRIPTION
Salescycle N 17 SALESCYCLETEMP
Seqnum N 5 SALESCYCLETEMP
Descr C 60 SALESCYCLETEMP
Timeafters N 6 SALESCYCLETEMP
Weight N 5 SALESCYCLETEMP
Edit_dt C 18 SALESCYCLETEMP
Wgid N 6 SALESCYCLETEMP
Pub C 30 SALESCYCLETEMP
Level N 3 SALESCYCLETEMP
Salesplani N 17 SALESPLANTEMP
Issue C 254 SALESPLANTEMP
Seqnum N 5 SALESPLANTEMP
Edit_dt C 18 SALESPLANTEMP
Wgid N 6 SALESPLANTEMP
Pub C 30 SALESPLANTEMP
Salesteami N 17 SALESTEAMS
Descr C 60 SALESTEAMS
Edit_dt C 18 SALESTEAMS
Wgid N 6 SALESTEAMS
Pub C 30 SALESTEAMS
Opptytype N 17 SALESTEAMTEMP
Roledescr C 60 SALESTEAMTEMP
Seqnum N 6 SALESTEAMTEMP
Edit_dt C 18 SALESTEAMTEMP
Wgid N 6 SALESTEAMTEMP
Pub C 30 SALESTEAMTEMP
Statusid N 17 STATUSTEXT
Descr C 60 STATUSTEXT
Pub C 30 STATUSTEXT
Forecast N 3 STATUSTEXT
Edit_dt C 18 STATUSTEXT
Text C 254 STDRESP
Create_dt C 18 STDRESP
Edit_dt C 18 STDRESP
Pub C 30 STDRESP
Bookmarkli N 17 SWBOOKMARKLISTS
Bookmarkid N 17 SWBOOKMARKLISTS
Foreignid N 17 SWBOOKMARKLISTS
Type N 6 SWBOOKMARKLISTS
Userid N 6 SWBOOKMARKLISTS
Pub C 30 SWBOOKMARKLISTS
Type N 6 SWBOOKMARKLISTTYPES
Descr C 60 SWBOOKMARKLISTTYPES
Bookmarkid N 17 SWBOOKMARKS
Bookmark M 4 SWBOOKMARKS
Descr M 4 SWBOOKMARKS
Type N 6 SWBOOKMARKS
Daterecord T 8 SWBOOKMARKS
Userid N 6 SWBOOKMARKS
Pub C 30 SWBOOKMARKS
Type N 6 SWBOOKMARKTYPES
Descr C 60 SWBOOKMARKTYPES
Companyid N 17 SWCOMPANY
Companynam M 4 SWCOMPANY
Parentid N 17 SWCOMPANY
Primarycon N 17 SWCOMPANY
Userid N 6 SWCOMPANY
Pub C 30 SWCOMPANY
Userid N 6 SWCONDUITFLDTRANS
Address C 21 SWCONDUITFLDTRANS
Workph C 21 SWCONDUITFLDTRANS
Home C 21 SWCONDUITFLDTRANS
Fax C 21 SWCONDUITFLDTRANS
Other C 21 SWCONDUITFLDTRANS
Email C 21 SWCONDUITFLDTRANS
Main C 21 SWCONDUITFLDTRANS
Pager C 21 SWCONDUITFLDTRANS
Mobile C 21 SWCONDUITFLDTRANS
Custom1 N 17 SWCONDUITFLDTRANS
Custom2 N 17 SWCONDUITFLDTRANS
Custom3 N 17 SWCONDUITFLDTRANS
Custom4 N 17 SWCONDUITFLDTRANS
Create_dt C 18 SWCONDUITFLDTRANS
Edit_dt C 18 SWCONDUITFLDTRANS
Pub C 30 SWCONDUITFLDTRANS
Pilotname M 4 SWCONDUITFLDTRANS
Pilottosw N 6 SWCONDUITFLDTRANS
Pilotwins N 3 SWCONDUITFLDTRANS
Pilotgroup C 40 SWCONDUITFLDTRANS
Datefrom C 10 SWCONDUITFLDTRANS
Datethru C 10 SWCONDUITFLDTRANS
Inctodo N 3 SWCONDUITFLDTRANS
Incappt N 3 SWCONDUITFLDTRANS
Inccall N 3 SWCONDUITFLDTRANS
Sharkid N 17 SWCONDUITRECXREF
Hhid N 17 SWCONDUITRECXREF
Userid N 6 SWCONDUITRECXREF
Type N 3 SWCONDUITRECXREF
Create_dt C 18 SWCONDUITRECXREF
Edit_dt C 18 SWCONDUITRECXREF
Pub C 30 SWCONDUITRECXREF
Bdelete N 3 SWCONDUITRECXREF
Reportid N 17 SWREPORTID
Id N 17 SWREPORTID
Rowid N 17 SWREPORTID
Addressid N 17 TADDRESS
Contactid N 17 TADDRESS
Def C 1 TADDRESS
Postalcode C 10 TADDRESS
Addr_l1 C 40 TADDRESS
Addr_l2 C 40 TADDRESS
Addr_l3 C 40 TADDRESS
Addr_type C 21 TADDRESS
Incl_flds C 1 TADDRESS
City C 28 TADDRESS
State C 28 TADDRESS
Country C 28 TADDRESS
Tzoffset C 2 TADDRESS
Create_dt C 18 TADDRESS
Edit_dt C 18 TADDRESS
Setid N 17 TCUSTDEF
Fieldid N 17 TCUSTDEF
Fldnbr N 6 TCUSTDEF
Name C 30 TCUSTDEF
Type N 4 TCUSTDEF
Autopop C 1 TCUSTDEF
Memorize C 1 TCUSTDEF
Popid N 17 TCUSTDEF
Create_dt C 18 TCUSTDEF
Edit_dt C 18 TCUSTDEF
Setid N 17 TCUSTSETS
Name C 30 TCUSTSETS
Codecnt N 5 TCUSTSETS
Maxcode N 5 TCUSTSETS
Userid N 6 TCUSTSETS
Create_dt C 18 TCUSTSETS
Edit_dt C 18 TCUSTSETS
Adminonly I 4 TCUSTSETS
Settype I 4 TCUSTSETS
Salesteami N 17 TEAMMEMBERS
Roledescr C 60 TEAMMEMBERS
Contactid N 17 TEAMMEMBERS
Userid N 6 TEAMMEMBERS
Keyrep N 3 TEAMMEMBERS
Edit_dt C 18 TEAMMEMBERS
Wgid N 6 TEAMMEMBERS
Pub C 30 TEAMMEMBERS
Userid N 6 USERACCESS
Groupid N 6 USERACCESS
Name_add_p N 3 USERACCESS
Activities N 3 USERACCESS
Histories N 3 USERACCESS
Notes N 3 USERACCESS
Cust_field N 3 USERACCESS
Mackay N 3 USERACCESS
Wgtransfer N 3 USERACCESS
Create_dt C 18 USERACCESS
Edit_dt C 18 USERACCESS
Oppty N 3 USERACCESS
Contacts N 3 USERACCESS
Salescycle N 3 USERACCESS
Opptyactiv N 3 USERACCESS
Salesteam N 3 USERACCESS
Salesplan N 3 USERACCESS
Opptynotes N 3 USERACCESS
Templates N 3 USERACCESS
Forecast N 3 USERACCESS
Pub C 30 USERACCESS
Bookmarks N 3 USERACCESS
Contactgro N 3 USERACCESS
Descr C 60 USERNOTE
Userid N 6 USERNOTE
Create_dt C 18 USERNOTE
Edit_dt C 18 USERNOTE
Datafld M 4 USERNOTE
Pub C 30 USERNOTE
Userid N 6 USERPROFILE
Password M 4 USERPROFILE
Name M 4 USERPROFILE
Longname M 4 USERPROFILE
Custutil C 1 USERPROFILE
Maintutil C 1 USERPROFILE
Admin C 1 USERPROFILE
Privatecon C 1 USERPROFILE
Timeout N 11 USERPROFILE
Create_dt C 18 USERPROFILE
Edit_dt C 18 USERPROFILE
Pub C 30 USERPROFILE
Groupid N 6 WORKGROUP
Groupname C 30 WORKGROUP
Create_dt C 18 WORKGROUP
Edit_dt C 18 WORKGROUP
Pub C 30 WORKGROUP
Groupid N 6 WORKGROUPACCESS
Subgroupid N 6 WORKGROUPACCESS
Create_dt C 18 WORKGROUPACCESS
Edit_dt C 18 WORKGROUPACCESS
Pub C 30 WORKGROUPACCESS

FIELDDBF - 06/16/03