Difference between revisions of "SmartConnect - Appendix: Standard Field Names"
(→Level 1) |
(→Level 2) |
||
| Line 1,378: | Line 1,378: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| − | '''Not Updatable''' | + | ''' Not Updatable''' |
| + | |||
| + | Mandatory field for updating records | ||
|- | |- | ||
| Line 1,393: | Line 1,396: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
| + | |||
| + | Mandatory field for updating records | ||
|- | |- | ||
| Line 1,407: | Line 1,414: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,421: | Line 1,430: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,435: | Line 1,446: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
| + | |||
| + | Mandatory field for adding records | ||
|- | |- | ||
| Line 1,449: | Line 1,464: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,463: | Line 1,480: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
| + | |||
| + | Mandatory field for adding records | ||
| + | |||
User "objectid" in place of "sf_Parent ID" for new L2 records | User "objectid" in place of "sf_Parent ID" for new L2 records | ||
| Line 1,478: | Line 1,500: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,492: | Line 1,516: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,506: | Line 1,532: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,520: | Line 1,548: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,534: | Line 1,564: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,548: | Line 1,580: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,562: | Line 1,596: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,576: | Line 1,612: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
| + | |||
| + | Mandatory field for adding records | ||
|- | |- | ||
| Line 1,590: | Line 1,630: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,604: | Line 1,646: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,618: | Line 1,662: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| + | ✓ | ||
|- | |- | ||
| Line 1,632: | Line 1,678: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| − | '''Not Updatable''' | + | ''' Not Updatable''' |
|- | |- | ||
| Line 1,647: | Line 1,694: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| − | '''Not Updatable''' | + | ''' Not Updatable''' |
|- | |- | ||
| Line 1,662: | Line 1,710: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| − | '''Not Updatable''' | + | ''' Not Updatable''' |
|- | |- | ||
| Line 1,677: | Line 1,726: | ||
|| | || | ||
| + | ✓ | ||
|| | || | ||
| − | '''Not Updatable''' | + | ''' Not Updatable''' |
|} | |} | ||
Revision as of 16:57, 5 March 2018
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 |
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 |
||
|
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 or country name |
|
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 |
See Also
JSON API (SmartConnect)
JSON API (SmartConnect) Prerequisite
