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

From SmartWiki
Jump to: navigation, search
(→‎Companies)
(→‎Users)
Line 422: Line 422:
 
* '''sf_Created Date''': date record was created.
 
* '''sf_Created Date''': date record was created.
 
* '''sf_Created By''': name of user who created the record.
 
* '''sf_Created By''': name of user who created the record.
 +
 +
{|
 +
|-
 +
||
 +
''' '''
 +
 +
||
 +
'''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==
 
==Level 1==

Revision as of 15:23, 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

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

  • 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.

 

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

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