Changes

SmartConnect - Appendix: Standard Field Names

4,673 bytes added, 17:42, 22 June 2018
Level 3
==Level 3==
See Level {| class="wikitable" width="85%" cellpadding="5px" align="center"|-! 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%"|External Notes|-||sf_Activity Type||Returns level 3 type name| style="text-align: center;"|Y| style="text-align: center;"|Y||Update using Type ID as value|-||sf_Subject||Returns level 3 subject| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Status||Returns Status name| style="text-align: center;"|Y| style="text-align: center;"|Y||Update using Status ID as value|-||sf_Location||Location standard field| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Duration||Duration standard field| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Owner||Returns name of level 3 owner standard field| style="text-align: center;"|Y| style="text-align: center;"|Y||Update using Owner ID as value|-||sf_Updated By||Name of user that last updated the record| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Last Modified||Date record was last updated| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Created Date||Date the record was created| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Created By||Name of user that created  the record| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Start Date||Returns Start Date and Time in YYYY-MM-DD HH:MM:SS| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_End Date||Returns End Date and Time in YYYY-MM-DD HH:MM:SS| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Whole Day Event||Flag (Yes, No)| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Reminder Sent||Flag (1=Yes 0=No)| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Follow-up Sent||Flag (1=Yes 0=No)| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Reminder Type||Returns ID of reminder type| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Follow-up Type||Returns Id of follow-up type| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Parent Subject||Returns Subject field from parent level 2| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Associated Parent||Displays level 2ID from soft-linked UTA| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Assign Person||Comma delimited list of user IDs in assigned standard field| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Contact Person||Comma delimited list of user IDs in contact standard field| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Description||Returns value from Description standard field| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Amount||Returns value from Amount standard field| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Longitude||| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Latitude||| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Level Three ID||Returns unique level 3 ID| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable||Mandatory field for updating records|-||sf_Parent ID||Returns level 2 ID from parent record| style="text-align: center;"|Y| style="text-align: center;"|Y||Mandatory field for adding records<br /> <br /> User "objectid" in place of "sf_Parent ID" for new L3 records|-||sf_Type ID||ID of level 3 template| style="text-align: center;"|Y| style="text-align: center;"|Y||Mandatory field for adding records|-||sf_Status ID||Status ID of level 1 status.0 if empty| style="text-align: center;"|Y| style="text-align: center;"|Y||Mandatory field for adding records|-||sf_Owner ID||ID of level 1 owner.| style="text-align: center;"|Y| style="text-align: center;"|Y|||-||sf_Application ID||Returns UTA ID| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable||Mandatory field for updating records|-||sf_Status Caption||Returns Status caption| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||-||sf_Type Caption||Returns level 3 type caption| style="text-align: center;"|Y| style="text-align: center;"|Not Updatable|||}
==Multiple Address==
0
edits