[VtigerCRM]フィールドの属性情報について

自分たちでカスタマイズする場合にはぜひ押さえておきたいのがフィールドの属性情報についてです。下記の表は、VtigerCRMの標準フィールドとカスタムフィールドの属性情報のサンプルになります。

カスタムフィールドの属性情報
UIタイプ別の標準フィールドの属性情報

カスタムフィールドの属性情報

フィールドタイプ	長さ	小数点桁数	UIタイプ	typeofdata	DBカラムタイプ	必須項目
テキスト	100	—	1	V~O~LE~100	varchar(100)	No
テキスト	100	—	1	V~M~LE~100	varchar(100)	YES
テキスト	25	—	1	V~O~LE~25	varchar(25)	No
テキスト	25	—	1	V~M~LE~25	varchar(25)	YES
整数	10	0	7	NN~O~10,0	decimal(11,0)	No
整数	10	0	7	NN~M~10,0	decimal(11,0)	YES
少数付き整数	7	3	7	NN~O~7,3	decimal(11,3)	No
少数付き整数	7	3	7	NN~M~7,3	decimal(11,3)	YES
パーセント	—	—	9	N~O~2~2	decimal(5,2)	No
パーセント	—	—	9	N~M~2~2	decimal(5,2)	YES
通貨	10	2	71	N~O~10,2	decimal(13,2)	No
通貨	10	0	71	N~M~10,0	decimal(11,0)	YES
日付	—	—	5	D~O	date	No
日付	—	—	5	D~M	date	YES
メール	—	—	13	E~O	varchar(50)	No
メール	—	—	13	E~M	varchar(50)	YES
電話	—	—	11	V~O	varchar(30)	No
電話	—	—	11	V~M	varchar(30)	YES
定義リスト（Picklist）	—	—	15	V~O	varchar(255)	No
定義リスト（Picklist）	—	—	15	V~M	varchar(255)	YES
URL	—	—	17	V~O	varchar(255)	No
URL	—	—	17	V~M	varchar(255)	YES
チェックボックス	—	—	56	C~O	varchar(3)	No
チェックボックス	—	—	56	C~M	varchar(3)	YES
テキストエリア	—	—	21	V~O	text	No
テキストエリア	—	—	21	V~M	text	YES
複数選択コンボボックス	—	—	33	V~O	text	No
複数選択コンボボックス	—	—	33	V~M	text	YES
Skype	—	—	85	V~O	varchar(255)	No
Skype	—	—	85	V~M	varchar(255)	YES

UIタイプ別の標準フィールドの属性情報

例）カラム名 / テーブル	フィールド名	フィールドラベル	UIタイプ	TYPEOFDATA	DBカラムタイプ	必須項目
Text box
tickersymbol / vtiger_account	tickersymbol	Ticker Symbol	1	V~O	varchar(30)	No
noofemployees / vtiger_leaddetails	noofemployees	No Of Employees	1	I~O (??? text)	int(50)	No
qtyinstock / vtiger_products	qtyinstock	Qty In Stock	1	NN~O (??? text)	decimal(25,3)	No
qty_per_unit / vtiger_service	qty_per_unit	No of Units	1	N~O (??? text)	decimal(11,2)	No
subject / vtiger_servicecontracts	subject	Subject	1	V~M	varchar(100)	YES
Text box, mandatory entry
time_start / vtiger_activity	time_start	Time Start	2	T~M	varchar(50)	YES
time_end / vtiger_activity	time_end	End Time	2	T~O	varchar(50)	No
accountname / vtiger_account	accountname	Account Name	2	V~M	varchar(100)	YES
activitytype / vtiger_activity	activitytype	Activtiy Type	2	V~O	varchar(200)	No
Text box with Inheritance
accesskey / vtiger_users	accesskey	Webservice Access Key	3	V~O	varchar(36)	No
Text box with Inheritance, mandatory entry
account_no / vtiger_account	account_no	Account No	4	V~O	varchar(100)	No
Date
enddate / vtiger_projecttask	enddate	End Date	5	D~0~OTH~GE~startdate~Start Date [0 Null is a possible typo]	date	No
dateinservice / vtiger_assets	dateinservice	Date in Service	5	D~M~OTH~GE~dateinservice~Date in Service	date	YES
datesold / vtiger_assets	datesold	Date Sold	5	D~M~OTH~GE~datesold~Date Sold	date	YES
sales_start_date / vtiger_service	sales_start_date	Sales Start Date	5	D~O	date	No
sales_end_date / vtiger_service	sales_end_date	Sales End Date	5	D~O~OTH~GE~sales_start_date~Sales Start Date	date	No
expiry_date / vtiger_service	expiry_date	Support Expiry Date	5	D~O~OTH~GE~start_date~Start Date	date	No
support_end_date / vtiger_customerdetails	support_end_date	Support End Date	5	D~O~OTH~GE~support_start_date~Support Start Date	date	No
end_period / vtiger_invoice_recurring_info	end_period	End Period	5	D~O~OTH~G~start_period~Start Period	date	No
Date, default to currenttime
date_start / vtiger_activity	date_start	Start Date & Time	6	DT~M~time_start	date	YES
date_start / vtiger_activity	date_start	Date & Time Sent	6	DT~M~time_start~Time Start	date	YES
Number box
employees / vtiger_account	employees	Employees	7	I~O	int(10)	No
total_units / vtiger_servicecontracts	total_units	Total Units	7	V~O	decimal(5,2)	No
json encoded string
to_email / vtiger_emaildetails	saved_toid	To	8	V~M	text	YES
cc_email / vtiger_emaildetails	ccemail	Cc	8	V~O	text	No
Percent
probability / vtiger_potential	probability	Probability	9	N~O	decimal(7,3)	No
progress / vtiger_servicecontracts	progress	Progress	9	N~O~2~2	decimal(5,2)	No
general relate field, for relating entities
sc_related_to / vtiger_servicecontracts	sc_related_to	Related to	10	V~O	int(11)	No
product / vtiger_assets	product	Product Name	10	V~M	int(19)	YES
Phone
phone / vtiger_account	phone	Phone	11	V~O	varchar(30)	No
OrgUnit pickbox / Organization multiselect pickbox
from_email / vtiger_emaildetails	from_email	From	12	V~M	varchar(50)	YES
EMail
email / vtiger_contactdetails	email	Email	13	E~O	varchar(100)	No
Picklist
activitytype / vtiger_activity	activitytype	Activity Type	15	V~M	varchar(200)	YES
industry / vtiger_account	industry	industry	15	V~O	varchar(200)	No
Picklist, mandatory entry ???
recurringtype / vtiger_activity	recurringtype	Recurrence	16	O~O	varchar(200)	No
duration_minutes / vtiger_activity	duration_minutes	Duration Minutes	16	T~O	varchar(200)	No
reminder_interval / vtiger_users	reminder_interval	Reminder Interval	16	V~O	varchar(100)	No
URL
website / vtiger_account	website	Website	17	V~O	varchar(100)	No
Textarea with colspan=2
commentcontent / vtiger_modcomments	commentcontent	Comment	19	V~M	text	YES
description / vtiger_crmentity	description	Description	19	V~O	text	No
Textarea with colspan=2, mandatory entry
question / vtiger_faq	question	Question	20	V~M	text	YES
Textarea
message / vtiger_smsnotifier	message	message	21	V~M	text	YES
bill_street / vtiger_accountbillads	bill_street	Billing Address	21	V~O	varchar(250)	No
Textarea, mandatory entry
title / vtiger_troubletickets	ticket_title	Title	22	V~M	varchar(255)	YES
Date
closingdate / vtiger_potential	closingdate	Expected Close Date	23	D~M	date	YES
due_date / vtiger_activity	due_date	Due Date	23	D~M~OTH~GE~date_start~Start Date & Time	date	YES
due_date / vtiger_servicecontracts	due_date	Due Date	23	D~O	date	No
targetenddate / vtiger_project	targetenddate	Target End Date	23	D~0~OTH~GE~startdate~Start Date [0 Null is a possible typo]	date	No
Textarea, mandatory entry
bill_street / vtiger_quotesbillads	bill_street	Billing Address	24	V~M	varchar(250)	YES
25, 26, 27,28 ??? missing entries at http://wiki.vtiger.com/index.php/Ui_types
access_count / vtiger_email_track	access_count	Access Count	25	V~O	int(11)	No
folderid / vtiger_notes	folderid	Folder Name	26	V~O	int(19)	No
filelocationtype / vtiger_notes	filelocationtype	Download Type	27	V~O	varchar(5)	No
filename / vtiger_notes	filename	File Name	28	V~O	varchar(200)	No
Time left
reminder_time / vtiger_activity_reminder	reminder_time	Send Reminder	30	I~O	int(11)	No
No sample for UITYPE 31-50 in the SQL table: vtiger_field
Popup select box for account and contact addresses
accountid / vtiger_contactdetails	accountid	Account Name	51	I~O	int(19)	No
Picklist for username entries
handler / vtiger_service	assigned_user_id	Owner	52	I~O	int(11)	No
smcreatorid / vtiger_crmentity	creator	Creator	52	V~O	int(19)	No
User picklist
smownerid / vtiger_crmentity	assigned_user_id	Assigned To	53	V~M	int(19)	YES
Salutation type picklist
salutation / vtiger_leaddetails	salutationtype	Salutation	55	V~O	varchar(200)	No
firstname / vtiger_leaddetails	firstname	First Name	55	V~O	varchar(40)	No
Salutation (for last name)
lastname / vtiger_leaddetails	lastname	Last Name	255	V~M	varchar(80)	YES
Checkbox
donotcall / vtiger_contactdetails	donotcall	Do Not Call	56	C~O	varchar(3)	No
discontinued / vtiger_products	discontinued	Product Active	56	V~O	int(1)	No
Contacts popup select box
contactid / vtiger_salesorder	contact_id	Contact Name	57	I~O	int(19)	No
Campaign popup select box
campaignid / vtiger_potential	campaignid	Campaign Source	58	N~O	int(19)	No
Product non-editable capture, popup picklist
product_id / vtiger_campaign	product_id	Product	59	I~O	int(19)	No
Attachments, file selection box
name / vtiger_attachments	filename	Attachment	61	V~O	varchar(255)	No
Duration minutes picklist – different typeofdata for the tab_id: 9 and 16 ???
duration_hours / vtiger_activity (16)	duration_hours	Duration	63	I~M	varchar(200)	No
duration_hours / vtiger_activity (9)	duration_hours	Duration	63	T~O	varchar(200)	No
Names out of entities popup picklist
crmid / vtiger_seactivityrel	parent_id	Related To	66	I~O	int(19)	No
Names out of entities popup picklist
parent_id / vtiger_troubletickets	parent_id	Related To	68	I~O	varchar(100)	No
Products attachments
imagename / vtiger_products	vtiger_products	Product Image	69	V~O	text	No
Date (for the created and modified date & time)
createdtime / vtiger_crmentity	createdtime	Created Time	70	T~O	datetime	No
createdtime / vtiger_crmentity	createdtime	Created Time	70	V~O (??? for tab_id: 32 – ServiceContracts)	datetime	No
Currency
annualrevenue / vtiger_account	annual_revenue	Annual Revenue	71	I~O	int(19)	No
unit_price / vtiger_service	unit_price	Price	71	N~O	decimal(25,2)	No
Popup select box for Accounts, mandatory entry [Calls JS function to auto fill billing and shipping address fields. Contact pop-up limited to only contacts related to the selected Account]
accountid / vtiger_quotes	account_id	Account Name	73	I~M	int(19)	YES
Vendor name
vendor_id / vtiger_products	vendor_id	Vendor Name	75	I~O	int(11)	No
Potential popup picklist
potentialid / vtiger_quotes	potential_id	Potential Name	76	I~O	int(19)	No
Picklist for secondary username entries
inventorymanager / vtiger_quotes	assigned_user_id1	Inventory Manager	77	I~O	int(19)	No
Quote popup picklist
quoteid / vtiger_salesorder	quote_id	Quote Name	78	I~O	int(19)	No
Sales order popup picklist
salesorderid / vtiger_invoice	salesorder_id	Sales Order	80	I~O	int(19)	No
Vendor name, mandatory entry
vendorid / vtiger_purchaseorder	vendor_id	Vendor Name	81	I~M	int(19)	YES
Tax in Inventory
taxclass / vtiger_products	taxclass	Tax Class	83	V~O	varchar(200)	No
Role name popup picklist, mandatory entry
roleid / vtiger_user2role	roleid	Role	98	V~M	varchar(255)	YES
Password, mandatory entry
user_password / vtiger_users	user_password	Password	99	P~M	varchar(30)	YES
User capture popup picklist
reports_to_id / vtiger_users	reports_to_id	Reports To	101	V~O	varchar(36)	No
EMail, mandatory entry
email1 / vtiger_users	email1	Email	104	E~M	varchar(100)	YES
User image
imagename / vtiger_users	imagename	User Image	105	V~O	varchar(250)	No
Text box, mandatory entry
user_name / vtiger_users	user_name	User Name	106	V~M	varchar(255)	YES
Non editable picklist
status / vtiger_users	status	Status	115	V~O	varchar(25)	No
Currency in user details
currency_id / vtiger_users	currency_id	Currency	116	I~O	int(19)	No
hour_format / vtiger_users	hour_format	Calendar Hour Format	116	V~O	varchar(30)	No
??? – Currency in modules – missing entries at http://wiki.vtiger.com/index.php/Ui_types
currency_id / vtiger_pricebook	currency_id	Currency	117	I~M	int(19)	YES
currency_id / vtiger_invoice	currency_id	Currency	117	I~O	int(19)	No
Admin toggle, checkbox
is_admin / vtiger_users	is_admin	Admin	156	V~O	varchar(3)	No
Email, Popup picklist
idlistsi / vtiger_emaildetails	parent_id	Parent ID	357	V~O	text	No