Changes

Jump to: navigation, search

SmartConnect - Appendix: Standard Field Names

139 bytes removed, 17:00, 22 June 2018
Level 1
==Level 1==
{| class="wikitable" cellpadding="5px" align="center"|- style="font-weight: bold; text-align: center;"| style="border: 1px solid gray;" width="585%"|''' ''' | stylecellpadding="border: 1px solid gray;5px" widthalign="25%"|'''Standard Field Name''' | style="border: 1px solid gray;" width="25%"|'''Description''' | style="border: 1px solid gray;" width="25%"|'''GET Method''' | style="border: 1px solid gray;" width="20%center"|'''UPDATE Method''' 
|-
! width="20%"|API Field Reference
! width="25%"|Field Description
! style="text-align: center;" width="15%"|Allow Get/List
! style="text-align: center;" width="15%"|Allow Update
! width="25%"|Notes External
|-
||sf_Application Type
||Returns level 1 template name
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||Update using Type ID as value
|-
||sf_Application Name
||Returns value of Name standard field
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
1|-||sf_Customer||Name of company on Client standard field|style="text-align: center;"|sf_Level One | style="text-align: center;"|✓||Update using Company IDas value|-||sf_Person||Name of contact attached to Person standard field|style="text-align: center;"|Tracking | style="text-align: center;"|✓||Update using User ID of level 1as value|-||sf_Status||Returns Status name| style="text-align: center;"|✓| style="text-align: center;"|✓||Update using Status ID as value|-||sf_Revenue||Revenue standard field                              | style="text-align: center;"|| style="text-align: center;"|✓
||
'''                  Not Updatable'''
 
Mandatory field for updating records
 
|-
||sf_Currency
||Currency standard field
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
2
 
||
sf_Application ID
 
||
UTA ID
 
||
                              ✓
 
||
                              ✓
 
Mandatory field for updating records
 
|-
||sf_Close Date
||Close Date standard field
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
3
 
||
sf_Company ID
 
||
Company ID of level 1 company/client field. 0 if empty
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Modified Date
||Date record was last updated
| style="text-align: center;"|✓
| style="text-align: center;"|Not Updatable
||
4
 
||
sf_Customer
 
||
Name of company
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Modified By
||Name of user that last updated the record
| style="text-align: center;"|✓
| style="text-align: center;"|Not Updatable
||
5
 
||
sf_Branch ID
 
||
Company ID of level 1 branch field. 0 if empty
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Created Date
||Date the record was created
| style="text-align: center;"|✓
| style="text-align: center;"|Not Updatable
||
6
 
||
sf_Person ID
 
||
User ID of level 1 people field. 0 if empty
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Created By
||Name of user that created  the record
| style="text-align: center;"|✓
| style="text-align: center;"|Not Updatable
||
7
 
||
Sf_Person
 
||
Name of Person
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Probability
||Probability standard field
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
8
 
||
sf_Type ID
 
||
ID of level 1 template
 
||
                              ✓
 
||
                              ✓
 
Mandatory field for adding records
 
|-
||sf_Description
||Returns value from Description standard field
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
9
 
||
sf_Application Type
 
||
Level 1 template type name
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Requirement
||Requirement standard field
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
10
 
||
sf_Application Name
 
||
Name standard field
 
||
                              ✓
 
||
                              ✓
 
|-
||11 ||sf_Descriptionsf_Owner||Description Returns name of level 1 owner standard field |style="text-align: center;"|                              ✓ |style="text-align: center;"|                              ||Update using Owner ID as value
|-
||12 ||sf_Requirementsf_Branch||Requirement Returns company name on Branch standard field |style="text-align: center;"|                              ✓ |style="text-align: center;"|                              ||Update using Branch ID as value
|-
||sf_End Date
||Returns End Date and Time in YYYY-MM-DD HH:MM:SS
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
13
 
||
sf_Status ID
 
||
Status ID of level 1 status. 0 if empty
 
||
                              ✓
 
||
                              ✓
 
Mandatory field for adding records
 
|-
||sf_Start Date
||Returns Start Date and Time in YYYY-MM-DD HH:MM:SS
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
14
 
||
sf_Status
 
||
Name of level 1 status
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Archived
||Flag (1=Archived, 0=Not Archived)
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
15
 
||
sf_Revenue
 
||
Revenue standard field
 
||
                              ✓
 
||
                              ✓
 
|-
||16sf_Level One ID||sf_Start DateReturns unique Level 1 tracking ID|style="text-align: center;"|Start date standard field|style="text-align: center;"|                              ✓Not Updatable||                              ✓Mandatory field for updating records
|-
||sf_Company ID
||Company ID of level 1 company/client field. 0 if empty
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
17
 
||
sf_End Date
 
||
End date standard field
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Person ID
||User ID of level 1 people field. 0 if empty
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
18
 
||
sf_Close Date
 
||
Close date standard field
 
||
                              ✓
 
||
                              ✓
 
|-
||sf_Branch ID
||Company ID of level 1 branch field. 0 if empty
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
19
 
||
sf_Probability
 
||
Probability standard field
 
||
                              ✓
 
||
                              ✓
 
|-
||20 ||sf_Owner sf_Type ID ||ID of level 1 owner.template|style="text-align: center;"|                              ✓ |style="text-align: center;"|                              ||Mandatory field for adding records<br /> Update using Type ID as value
|-
||21 ||sf_Ownersf_Status ID||Name Status ID of level 1 ownerstatus. 0 if empty|style="text-align: center;"|                              ✓ |style="text-align: center;"|                              ||Mandatory field for adding records<br /> Update using Status ID as value
|-
||sf_Owner ID
||ID of level 1 owner.
| style="text-align: center;"|✓
| style="text-align: center;"|✓
||
22
 
||
sf_Modified By
 
||
Name of user who modified the record
 
||
                              ✓
 
||
'''                  Not Updatable'''
 
|-
||23 ||sf_Modified Datesf_Application ID||Date the record was modifiedReturns UTA ID|style="text-align: center;"|                              ✓ |style="text-align: center;"|'''                  Not Updatable'''||Mandatory field for updating records
|-
||sf_Status Caption
||Returns Status caption
| style="text-align: center;"|✓
| style="text-align: center;"|Not Updatable
||
24
 
||
sf_Created By
 
||
Name of user who created the record
 
||
                              ✓
 
||
'''                  Not Updatable'''
 
|-
||sf_Type Caption
||Returns level 1 template caption
| style="text-align: center;"|✓
| style="text-align: center;"|Not Updatable
||
25
 
||
sf_Created Date
 
||
Date record was created
 
||
                              ✓
 
||
'''                  Not Updatable'''
 
|}
0
edits

Navigation menu