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
|
|
Standard Field Name |
Description |
GET Method |
UPDATE Method |
|
1 |
sf_Company ID |
Company id. (0 if new company) |
Not Updatable | |
|
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 |
|
||
|
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 |
Not Updatable | |
|
23 |
sf_Last Updated By |
Last updated user name |
||
|
24 |
sf_Created Date |
date the record was last created on SmartSimple |
Not Updatable | |
|
25 |
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
| |
|
2 |
sf_Is External |
Flag (1=external, 0=internal) |
||
|
3 |
sf_Company ID |
ID of user's company. 0 if empty. |
||
|
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 |
|
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_User Role |
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_Status Caption |
Status caption |
|
|
|
26 |
sf_Updated By |
name of user who updated the record |
||
|
27 |
sf_Last Updated |
date record was last updated |
Not Updatable
| |
|
28 |
sf_Created Date |
date record was created |
Not Updatable
| |
|
29 |
sf_Created By |
user who created the user |
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
