FIELDDBF

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

FIELDDBF - 06/16/03