SmartConnect - Appendix: Standard Field Names
The following lists the database field names associated with Standard Fields.
These are used in JSON API (SmartConnect).
Contents
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 |
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 |
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 |
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
|
|
Standard Field Name |
Description |
GET Method |
UPDATE Method |
|
1 |
sf_Level One ID |
Tracking ID of level 1 |
Not Updatable | |
|
2 |
sf_Application ID |
UTA ID |
||
|
3 |
sf_Company ID |
Company ID of level 1 company/client field. 0 if empty |
||
|
sf_Customer |
Name of company |
|||
|
4 |
sf_Branch ID |
Company ID of level 1 branch field. 0 if empty |
||
|
5 |
sf_Person ID |
User ID of level 1 people field. 0 if empty |
||
|
6 |
Sf_Person |
Name of Person |
||
|
7 |
sf_Type ID |
ID of level 1 template |
||
|
8 |
sf_Application Type |
Level 1 template type name |
||
|
9 |
sf_Application Name |
Name standard field |
||
|
10 |
sf_Description |
Description standard field |
||
|
11 |
sf_Requirement |
Requirement standard field |
||
|
12 |
sf_Status ID |
Status ID of level 1 status. 0 if empty |
||
|
13 |
sf_Status |
Name of level 1 status |
||
|
14 |
sf_Revenue |
Revenue standard field |
||
|
15 |
sf_Start Date |
Start date standard field |
||
|
16 |
sf_End Date |
End date standard field |
||
|
17 |
sf_Close Date |
Close date standard field |
||
|
18 |
sf_Probability |
Probability standard field |
||
|
41.19 |
sf_Owner ID |
ID of level 1 owner. |
||
|
20 |
sf_Owner |
Name of level 1 owner |
||
|
21 |
sf_Modified By |
Name of user who modified the record |
Not Updatable | |
|
22 |
sf_Modified Date |
Date the record was modified |
Not Updatable | |
|
23 |
sf_Created By |
Name of user who created the record |
Not Updatable
| |
|
24 |
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 | |
|
2 |
sf_Application ID |
UTA ID |
||
|
3 |
sf_Description |
Description standard field |
||
|
4 |
sf_Subject |
Subject standard field |
||
|
5 |
sf_Type ID |
ID of level 2/3 type |
||
|
6 |
sf_Activity Type |
Level 2/3 type name |
||
|
7 |
sf_Parent ID |
Parent object ID |
||
|
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 |
||
|
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 |
||
|
20 |
sf_Last Modified |
Date the record was modified |
Not Updatable | |
|
21 |
sf_Created By |
Name of user who created the record |
||
|
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 |
||
|
2 |
sf_Object ID |
companyid / contactid / providerid / consumerid |
||
|
3 |
sf_Type ID |
Multiple Address Type ID |
||
|
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 |
|
11 |
sf_Last Modified |
date the record was last updated |
||
|
12 |
sf_Primary Address |
Is primary address (1=yes, 0=no) |
||
|
13 |
sf_Updated By |
Last updated user id |