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
Prefix Standard fields with "sf_"	sf_Name

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Company ID	Company id. (0 if new company)		X
2	sf_Parent Company	Parent company name
3	sf_Parent Company ID	Parent company id
4	sf_Status ID	Status id
5	sf_Status Caption	Status Caption
6	sf_Status	Status
7	sf_Is External	Flag (1=external, 0=internal)
8	sf_Owner ID	user who created the company
9	sf_Primary Contact ID	Primary contact ID. (0 if empty)
10	sf_Primary Contact	Primary contact name
11	sf_Name	Name 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_Zip / Postal Code	Postal code standard field
17	sf_Country	Country name	Displays country name	Update using country id
18	sf_Phone	Phone standard field
19	sf_Fax	Fax standard field
20	sf_Web Site	Website standard field
21	sf_Category List	Comma delimited list of category IDs. (Starts and ends with a comma)
22	sf_Last Updated	date the record was last updated on SmartSimple		X
23	sf_Last Updated By	Last updated user name
24	sf_Created Date	date the record was last created on SmartSimple		X
25	sf_Created By	Created by user name		X

sf_User ID: User ID (0 if new user)
sf_Is External: Flag (1=external, 0=internal)
sf_Company ID: ID of user's company. 0 if empty.
sf_Company: name of user's company.
sf_Title: Title standard field.
sf_Prefix: Prefix standard field.
sf_Suffix: Suffix standard field.
sf_First Name: First name standard field.
sf_Last Name: Last name standard field.
sf_Email: Email standard field.
sf_Address: Address standard field.
sf_Address 2: Address 2 standard field.
sf_City: City standard field.
sf_State / Province: Province standard field.
sf_Country: name of country field. 0 if empty.
sf_Country ID: ID of country field. 0 if empty.
sf_Zip / Postal Code: Postal code standard field.
sf_Phone: Phone standard field.
sf_Phone Ext: Phone extension field.
sf_User Role: Comma delimited list of role IDs. (Starts and ends with a comma)
sf_Active Type: 1 ('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')
sf_User Type: 10 ('User'), 30 ('Local User Administrator'), 40 ('Global User Administrator')
sf_Status: status ID of user
sf_Updated By: name of user who updated the record.
sf_Last Updated: date record was last updated.
sf_Created Date: date record was created.
sf_Created By: name of user who created the record.

sf_Level Two ID: Activity ID of level 2.
sf_Application ID: UTA ID.
sf_Description: Description standard field.
sf_Subject: Subject standard field.
sf_Type ID: ID of level 2/3 type.
sf_Activity Type: Level 2 type name.
sf_Parent ID: Parent object ID.
sf_Assign Person: Comma delimited list of user IDs in assigned standard field.
sf_Contact Person: Comma delimited list of user IDs in contact standard field.
sf_Location: Location standard field.
sf_Start Date: Start date standard field.
sf_End Date: End date standard field.
sf_Duration: Duration standard field.
sf_Amount: Amount standard field.
sf_Status ID: Status ID of status. 0 if empty.
sf_Status: Status name.
sf_Owner ID: User ID of owner. 0 if empty.
sf_Owner: Name of owner.
sf_Updated By: Name of user who updated the record.
sf_Last Modified: Date the record was modified.
sf_Created By: Name of user who created the record.
sf_Created Date: Date the record was created.

See Level 2.