SmartConnect - Appendix: Standard Field Names

The following lists the database field names associated with Standard Fields.

These are used in JSON API (SmartConnect).

Field List Syntax

Field List Syntax	Example
Separate values with ";;"	sf_Name;;cf_MyFieldName;;cf_MyFieldssid
Prefix Standard fields with "sf_"	sf_Name

Companies

	Standard Field Name	Description	Allow GET	Allow UPDATE
1	sf_Company ID	Company id. (0 if new company)	✓	Not Updatable Mandatory field for updating records
2	sf_Parent Company	Parent company name	✓	✓
3	sf_Parent Company ID	Parent company id	✓	✓ Mandatory field for adding records
4	sf_Status ID	Status id	✓	✓
5	sf_Status	Status	✓	✓
6	sf_Is External	Flag (1=external, 0=internal)	✓	✓ Mandatory field for adding records
7	sf_Owner ID	user who created the company	✓	✓
8	sf_Primary Contact ID	Primary Contact ID (0 if empty)	✓	✓
9	sf_Primary Contact	Primary contact name	✓	✓
10	sf_Name	Name standard field	✓	✓
11	sf_Address	Address standard field	✓	✓
12	sf_Address 2	Address 2 standard field	✓	✓
13	sf_City	City standard field	✓	✓
14	sf_State / Province	Province standard field	✓	✓
15	sf_Zip / Postal Code	Postal code standard field	✓	✓
16	sf_Country	Country name	✓             Displays country name	✓ Update using country id or country name
17	sf_Phone	Phone standard field	✓	✓
18	sf_Fax	Fax standard field	✓	✓
19	sf_Web Site	Website standard field	✓	✓
20	sf_Category ID List	Comma delimited list of category IDs. (Starts and ends with a comma)	✓	✓
21	sf_Last Updated	date the record was last updated on SmartSimple	✓	Not Updatable
22	sf_Updated By	Last updated user name	✓	Not Updatable
23	sf_Created Date	date the record was last created on SmartSimple	✓	Not Updatable
24	sf_Created By	Created by user name	✓	Not Updatable

Users

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_User ID	User ID (0 if new user)	✓	Not Updatable Mandatory field for updating records
2	sf_Is External	Flag (1=external, 0=internal)	✓	✓ Mandatory field for adding records
3	sf_Company ID	ID of user's company. 0 if empty.	✓	✓ Mandatory field for adding records
4	sf_Company	name of user's company	✓	✓
5	sf_Title	Title standard field.	✓	✓
6	sf_Prefix	Prefix standard field	✓	✓
7	sf_Suffix	Suffix standard field	✓	✓
8	sf_First Name	First name standard field	✓	✓
9	sf_Last Name	Last name standard field	✓	✓
10	sf_Middle Name	Middle name standard field	✓	✓
11	sf_Email	Email standard field	✓	✓
12	sf_Address	Address standard field	✓	✓
13	sf_Address 2	Address 2 standard field	✓	✓
14	sf_City	City standard field	✓	✓
15	sf_State / Province	Province standard field	✓	✓
16	sf_Country	Name of country field.	✓                Displays country name	✓ Update using country id or country name
17	sf_Zip / Postal Code	Postal code standard field	✓	✓
18	sf_Phone	Phone standard field	✓	✓
19	sf_Phone Ext.	Phone extension field. (includes period at the end)	✓	✓
20	sf_Role ID List	Comma delimited list of role IDs. (Starts and ends with a comma)	✓	✓
21	sf_Access Type	1 ('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')	✓                        Displays id	✓                    Update using id
22	sf_User Type	10 (‘User’), 30 (‘Local User Administrator’), 50 (‘Global User Administrator’)	✓                     Displays name	✓                     Update using id
23	sf_Status*	status name of user	✓                      Displays name	✓                     Update using id
24	sf_Status ID*	status ID of user	✓	✓'
25	sf_Updated By	name of user who updated the record	✓	Not Updatable
	sf_Last Updated	date record was last updated	✓	Not Updatable
27	sf_Created Date	date record was created	✓	Not Updatable
28	sf_Created By	user who created the user	✓	Not Updatable

Level 1

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Level One ID	Tracking ID of level 1	✓	Not Updatable Mandatory field for updating records
2	sf_Application ID	UTA ID	✓	✓ Mandatory field for updating records
3	sf_Company ID	Company ID of level 1 company/client field. 0 if empty	✓	✓
4	sf_Customer	Name of company	✓	✓
5	sf_Branch ID	Company ID of level 1 branch field. 0 if empty	✓	✓
6	sf_Person ID	User ID of level 1 people field. 0 if empty	✓	✓
7	Sf_Person	Name of Person	✓	✓
8	sf_Type ID	ID of level 1 template	✓	✓ Mandatory field for adding records
9	sf_Application Type	Level 1 template type name	✓	✓
10	sf_Application Name	Name standard field	✓	✓
11	sf_Description	Description standard field	✓	✓
12	sf_Requirement	Requirement standard field	✓	✓
13	sf_Status ID	Status ID of level 1 status. 0 if empty	✓	✓ Mandatory field for adding records
14	sf_Status	Name of level 1 status	✓	✓
15	sf_Revenue	Revenue standard field	✓	✓
16	sf_Start Date	Start date standard field	✓	✓
17	sf_End Date	End date standard field	✓	✓
18	sf_Close Date	Close date standard field	✓	✓
19	sf_Probability	Probability standard field	✓	✓
20	sf_Owner ID	ID of level 1 owner.	✓	✓
21	sf_Owner	Name of level 1 owner	✓	✓
22	sf_Modified By	Name of user who modified the record	✓	Not Updatable
23	sf_Modified Date	Date the record was modified	✓	Not Updatable
24	sf_Created By	Name of user who created the record	✓	Not Updatable
25	sf_Created Date	Date record was created	✓	Not Updatable

Level 2

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Level Two ID	Activity ID of level 2	✓	Not Updatable Mandatory field for updating records
2	sf_Application ID	UTA ID	✓	✓ Mandatory field for updating records
3	sf_Description	Description standard field	✓	✓
4	sf_Subject	Subject standard field	✓	✓
5	sf_Type ID	ID of level 2/3 type	✓	✓ Mandatory field for adding records
6	sf_Activity Type	Level 2/3 type name	✓	✓
7	sf_Parent ID	Parent object ID	✓	✓ Mandatory field for adding records User "objectid" in place of "sf_Parent ID" for new L2 records
8	sf_Assign Person	Comma delimited list of user IDs in assigned standard field	✓	✓
9	sf_Contact Person	Comma delimited list of user IDs in contact standard field	✓	✓
10	sf_Location	Location standard field	✓	✓
11	sf_Start Date	Start date standard field	✓	✓
12	sf_End Date	End date standard field	✓	✓
13	sf_Duration	Duration standard field	✓	✓
14	sf_Amount	Amount standard field	✓	✓
15	sf_Status ID	Status ID of status. 0 if empty	✓	✓ Mandatory field for adding records
16	sf_Status	Status name	✓	✓
17	sf_Owner ID	User ID of owner. 0 if empty	✓	✓
18	sf_Owner	Name of owner. 0 if empty	✓	✓
19	sf_Updated By	Name of user who updated the record	✓	Not Updatable
20	sf_Last Modified	Date the record was modified	✓	Not Updatable
21	sf_Created By	Name of user who created the record	✓	Not Updatable
22	sf_Created Date	Date record was created	✓	Not Updatable

Level 3

See Level 2.

Multiple Address

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Address ID	Unique id in Multiple Address table	✓	Not Updatable Mandatory field for updating records
2	sf_Object ID	companyid / contactid / providerid / consumerid	✓	✓ Mandatory field for adding records
3	sf_Type ID	Multiple Address Type ID	✓	✓ Mandatory field for adding records
4	sf_Type	Type name	✓	✓
5	sf_Address	Address standard field	✓	✓
6	sf_Address 2	Address 2 standard field	✓	✓
7	sf_City	City standard field	✓	✓
8	sf_State / Province	Province standard field	✓	✓
9	sf_Zip / Postal Code	Postal code standard field	✓	✓
10	sf_Country	Country name	✓              Displays country name	✓ Update using country id or country name
11	sf_Last Modified	date the record was last updated	✓	Not Updatable
12	sf_Primary Address	Is primary address (1=yes, 0=no)	✓	✓ Mandatory field for adding records
13	sf_Updated By	Last updated user id	✓	Not Updatable

See Also

JSON API (SmartConnect)
JSON API (SmartConnect) Prerequisite