Difference between revisions of "SmartConnect - Appendix: Standard Field Names"
(→Companies) |
(→Companies) |
||
| Line 50: | Line 50: | ||
|| | || | ||
| − | ''' | + | '''Not Updatable''' |
|- | |- | ||
| Line 346: | Line 346: | ||
|| | || | ||
| − | ''' | + | '''Not Updatable''' |
|- | |- | ||
| Line 375: | Line 375: | ||
|| | || | ||
| − | ''' | + | '''Not Updatable''' |
|- | |- | ||
| Line 390: | Line 390: | ||
|| | || | ||
| − | ''' | + | '''Not Updatable''' |
|} | |} | ||
Revision as of 16:21, 20 April 2017
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
- 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
