Difference between revisions of "SmartConnect - Appendix: Standard Field Names"

From SmartWiki
Jump to: navigation, search
(→‎Companies)
Line 20: Line 20:
  
 
==Companies==
 
==Companies==
−
* '''sf_Company ID''': Company id. (0 if new company)
+
{| class="wikitable" style="text-align: center; width: 700px; height: 200px;"
−
* '''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)
+
'''Standard Field Name'''
−
* '''sf_Primary Contact''': Primary contact name of company.
+
 
−
* '''sf_Name''': Name standard field.
+
||
−
* '''sf_Address''': Address standard field.
+
'''Description'''
−
* '''sf_Address 2''': Address2 standard field.
+
 
−
* '''sf_City''': City standard field.
+
||
−
* '''sf_State / Province''': Province standard field.
+
'''GET Method'''
−
* '''sf_Zip / Postal Code''': Postal code standard field.
+
 
−
* '''sf_Country''': ID of country field. (0 if empty)
+
||
−
* '''sf_Phone''': Phone standard field.
+
'''UPDATE Method'''
−
* '''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
+
1
−
* '''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_Company ID
−
* '''sf_Status Caption''': Status caption of the company.
+
 
 +
||
 +
Company id. (0 if new company)
 +
 
 +
||
 +
 
 +
||
 +
'''X'''
 +
 
 +
|-
 +
||
 +
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
 +
 
 +
||
 +
 
 +
||
 +
'''X'''
 +
 
 +
|-
 +
||
 +
23
 +
 
 +
||
 +
sf_Last Updated By
 +
 
 +
||
 +
Last updated user name
 +
 
 +
||
 +
 
 +
||
 +
 
 +
|-
 +
||
 +
24
 +
 
 +
||
 +
sf_Created Date
 +
 
 +
||
 +
date the record was last created on SmartSimple
 +
 
 +
||
 +
 
 +
||
 +
'''X'''
 +
 
 +
|-
 +
||
 +
25
 +
 
 +
||
 +
sf_Created By
 +
 
 +
||
 +
Created by user name
 +
 
 +
||
 +
 
 +
||
 +
'''X'''
 +
 
 +
|}
  
 
==Users==
 
==Users==

Revision as of 16:17, 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)

X

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

X

23

sf_Last Updated By

Last updated user name

24

sf_Created Date

date the record was last created on SmartSimple

X

25

sf_Created By

Created by user name

X

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

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=SmartConnect_-_Appendix:_Standard_Field_Names&oldid=29408’