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

Companies

• sf_Company ID: Company id. (0 if new company)
• sf_Parent Company: Parent company name.
• sf_Parent Company ID: Parent company id.
• sf_Is External: Flag (1=external, 0=internal)
• sf_Owner ID: Owner ID of company.
• sf_Owner: Owner name of company.
• sf_Primary Contact ID: Primary contact ID of company. (0 if empty)
• sf_Primary Contact: Primary contact name of company.
• sf_Name: Name standard field.
• sf_Address: Address standard field.
• sf_Address 2: Address2 standard field.
• sf_City: City standard field.
• sf_State / Province: Province standard field.
• sf_Zip / Postal Code: Postal code standard field.
• sf_Country: ID of country field. (0 if empty)
• sf_Phone: Phone standard field.
• sf_Fax: Fax standard field.
• sf_Web Site: Website standard field.
• sf_Category List: Comma delimited list of category IDs. (Starts and ends with a comma)
• sf_Last Updated: date the record was last updated on SmartSimple
• sf_Created Dated: date the record was created on SmartSimple
• sf_Status ID: Status ID of the company.
• sf_Status: Status name of the company.
• sf_Status Caption: Status caption of the company.

Users

• 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.

Level 1

• sf_Level One ID: Tracking ID of level 1.
• sf_Application ID: UTA ID.
• sf_Company ID: Company ID of level 1 company/client field. 0 if empty.
• sf_Branch ID: Company ID of level 1 branch field. 0 if empty.
• sf_Person ID: User ID of level 1 people field. 0 if empty.
• sf_Person: name of User for level 1 people field.
• sf_Type ID: ID of level 1 template.
• sf_Application Template Type: Level 1 template type name.
• sf_Application Name: Name standard field.
• sf_Description: Description standard field.
• sf_Requirement: Requirement standard field.
• sf_Status ID: Status ID of level 1 status. 0 if empty.
• sf_Status: Name of level 1 status.
• sf_Revenue: Revenue standard field.
• sf_Start Date: Start date standard field.
• sf_End Date: End date standard field.
• sf_Close Date: Close date standard field.
• sf_Probability: Probability standard field.
• sf_Owner ID: ID of level 1 owner.
• sf_Owner: Name of level 1 owner.
• sf_Modified By: Name of user who modified the record.
• sf_Modified Date: Date the record was modified.
• sf_Created By: Name of user who created the record.
• sf_Created Date: Date the record was created.

Level 2

• 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.

Level 3

See Level 2.

See Also

JSON API (SmartConnect)
JSON API (SmartConnect) Prerequisite