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

Revision as of 12:34, 22 June 2018

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;;cf_MyFieldssid
Prefix Standard fields with "sf_"	sf_Name

Companies

API Field Reference	Field Description	Allow Get/List	Allow Update	Notes External
sf_Name	Name of current company	✓	✓
sf_Phone		✓	✓
sf_Fax		✓	✓
sf_Address		✓	✓
sf_Address 2		✓	✓
sf_City		✓	✓
sf_State / Province		✓	✓
sf_Country		✓	✓	Update using Country ID or Country name as value
sf_Zip / Postal Code		✓	✓
sf_Web Site		✓	✓
sf_Longitude		✓	✓
sf_Latitude		✓	✓
sf_Primary Contact	Primary Contact name	✓	Not Updatable
sf_Parent Company	Parent company name	✓	Not Updatable
sf_Owner	Name of User in Owner Standard Field	✓	Not Updatable
sf_Company Workflow	ID of Company workflow standard field	✓	✓
sf_User Workflow	ID of User workflow standard field	✓	✓
sf_Updated By	Name of user that last updated the record	✓	Not Updatable
sf_Last Updated	Date record was last updated	✓	Not Updatable
sf_Created By	Name of user that created the record	✓	Not Updatable
sf_Created Date	Date the record was created	✓	Not Updatable
sf_Status	Returns Status name	✓	✓	Update using Status ID as value
sf_Company ID	Company id. (0 if new company)	✓	Not Updatable	Mandatory field for updating records
sf_Owner ID	ID of User in Owner Standard Field	✓	✓
sf_Parent Company ID	ID of Parent Company	✓	✓	Mandatory field for adding records
sf_Primary Contact ID	Primary Contact ID (0 if empty)	✓	✓
sf_Category ID List	Comma delimited list of category IDs. (Starts and ends with a comma)	✓	✓
sf_Status ID	Returns Status ID	✓	✓	Update using Status ID as value
sf_Is External	Flag (1=external, 0=internal)	✓	✓	Mandatory field for adding records
sf_Status Caption	Returns Status Caption	✓	Not Updatable

Users

API Field Reference	Field Description	Allow Get/List	Allow Update	Notes External
sf_First Name		✓	✓
sf_Last Name		✓	✓
sf_Email		✓	✓
sf_Title		✓	✓
sf_Prefix		✓	✓
sf_Suffix		✓	✓
sf_Phone		✓	✓
sf_Phone Ext.		✓	✓
sf_Address		✓	✓
sf_Address 2		✓	✓
sf_City		✓	✓
sf_State / Province		✓	✓
sf_Country		✓	✓
sf_Zip / Postal Code		✓	✓
sf_Company	Name of user's company	✓	✓	When updating, use Country ID or Country name as value
sf_Middle Name		✓	✓
sf_Longitude		✓	✓
sf_Latitude		✓	✓
sf_User Role	Comma delimited list of role IDs. (Starts and ends with a comma)	✓	✓	sf_User Role and sf_Role ID List are interchangable.
sf_Access Type	1 ('User'), 3 ('Applicant Interface'), 5 ('API'), 0 ('No Access')	✓	✓	Update using ID as value
sf_User Type	10 (‘User’), 30 (‘Local User Administrator’), 50 (‘Global User Administrator’)	✓	✓	Update using ID as value
sf_Updated By	Name of user that last updated the record	✓	Not Updatable
sf_Last Updated	Date record was last updated	✓	Not Updatable
sf_Created By	Name of user that created the record	✓	Not Updatable
sf_Created Date	Date the record was created	✓	Not Updatable
sf_Status	Returns Status name	✓	✓	Update using Status ID as value
sf_User ID	User ID (0 if new user)	✓	Not Updatable	Mandatory field for updating records
sf_Company ID	ID of user's company. 0 if empty.	✓	✓	Mandatory field for adding records
sf_Status ID	Returns Status ID	✓	✓	Update using Status ID as value
sf_Role ID List	Comma delimited list of role IDs. (Starts and ends with a comma)	✓	✓	sf_User Role and sf_Role ID List are interchangable.
sf_Is External	Flag (1=external, 0=internal)	✓	✓	Mandatory field for adding records
sf_Status Caption	Returns Status Caption	✓	Not Updatable

Level 1

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Level One ID	Tracking ID of level 1	✓	Not Updatable Mandatory field for updating records
2	sf_Application ID	UTA ID	✓	✓ Mandatory field for updating records
3	sf_Company ID	Company ID of level 1 company/client field. 0 if empty	✓	✓
4	sf_Customer	Name of company	✓	✓
5	sf_Branch ID	Company ID of level 1 branch field. 0 if empty	✓	✓
6	sf_Person ID	User ID of level 1 people field. 0 if empty	✓	✓
7	Sf_Person	Name of Person	✓	✓
8	sf_Type ID	ID of level 1 template	✓	✓ Mandatory field for adding records
9	sf_Application Type	Level 1 template type name	✓	✓
10	sf_Application Name	Name standard field	✓	✓
11	sf_Description	Description standard field	✓	✓
12	sf_Requirement	Requirement standard field	✓	✓
13	sf_Status ID	Status ID of level 1 status. 0 if empty	✓	✓ Mandatory field for adding records
14	sf_Status	Name of level 1 status	✓	✓
15	sf_Revenue	Revenue standard field	✓	✓
16	sf_Start Date	Start date standard field	✓	✓
17	sf_End Date	End date standard field	✓	✓
18	sf_Close Date	Close date standard field	✓	✓
19	sf_Probability	Probability standard field	✓	✓
20	sf_Owner ID	ID of level 1 owner.	✓	✓
21	sf_Owner	Name of level 1 owner	✓	✓
22	sf_Modified By	Name of user who modified the record	✓	Not Updatable
23	sf_Modified Date	Date the record was modified	✓	Not Updatable
24	sf_Created By	Name of user who created the record	✓	Not Updatable
25	sf_Created Date	Date record was created	✓	Not Updatable

Level 2

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Level Two ID	Activity ID of level 2	✓	Not Updatable Mandatory field for updating records
2	sf_Application ID	UTA ID	✓	✓ Mandatory field for updating records
3	sf_Description	Description standard field	✓	✓
4	sf_Subject	Subject standard field	✓	✓
5	sf_Type ID	ID of level 2/3 type	✓	✓ Mandatory field for adding records
6	sf_Activity Type	Level 2/3 type name	✓	✓
7	sf_Parent ID	Parent object ID	✓	✓ Mandatory field for adding records User "objectid" in place of "sf_Parent ID" for new L2 records
8	sf_Assign Person	Comma delimited list of user IDs in assigned standard field	✓	✓
9	sf_Contact Person	Comma delimited list of user IDs in contact standard field	✓	✓
10	sf_Location	Location standard field	✓	✓
11	sf_Start Date	Start date standard field	✓	✓
12	sf_End Date	End date standard field	✓	✓
13	sf_Duration	Duration standard field	✓	✓
14	sf_Amount	Amount standard field	✓	✓
15	sf_Status ID	Status ID of status. 0 if empty	✓	✓ Mandatory field for adding records
16	sf_Status	Status name	✓	✓
17	sf_Owner ID	User ID of owner. 0 if empty	✓	✓
18	sf_Owner	Name of owner. 0 if empty	✓	✓
19	sf_Updated By	Name of user who updated the record	✓	Not Updatable
20	sf_Last Modified	Date the record was modified	✓	Not Updatable
21	sf_Created By	Name of user who created the record	✓	Not Updatable
22	sf_Created Date	Date record was created	✓	Not Updatable

Level 3

See Level 2.

Multiple Address

	Standard Field Name	Description	GET Method	UPDATE Method
1	sf_Address ID	Unique id in Multiple Address table	✓	Not Updatable Mandatory field for updating records
2	sf_Object ID	companyid / contactid / providerid / consumerid	✓	✓ Mandatory field for adding records
3	sf_Type ID	Multiple Address Type ID	✓	✓ Mandatory field for adding records
4	sf_Type	Type name	✓	✓
5	sf_Address	Address standard field	✓	✓
6	sf_Address 2	Address 2 standard field	✓	✓
7	sf_City	City standard field	✓	✓
8	sf_State / Province	Province standard field	✓	✓
9	sf_Zip / Postal Code	Postal code standard field	✓	✓
10	sf_Country	Country name	✓ Displays country name	✓ Update using country id or country name
11	sf_Last Modified	date the record was last updated	✓	Not Updatable
12	sf_Primary Address	Is primary address (1=yes, 0=no)	✓	✓ Mandatory field for adding records
13	sf_Updated By	Last updated user id	✓	Not Updatable

Associations

not implemented at the moment.

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

Revision as of 12:34, 22 June 2018

Contents

Field List Syntax

Companies

Users

Level 1

Level 2

Level 3

Multiple Address

Associations

See Also

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

@@ Line 19: / Line 19: @@
 ==Companies==
-{| class="wikitable" cellpadding="5px" align="center"
+{| class="wikitable" width="85%" cellpadding="5px" align="center"
-|- style="font-weight: bold; text-align: center;"
+|-
-| style="border: 1px solid gray;" width="5%"|
+! width="20%"|API Field Reference
-''' '''
+! width="25%"|Field Description
+! style="text-align: center;" width="15%"|Allow Get/List
-| style="border: 1px solid gray;" width="25%"|
+! style="text-align: center;" width="15%"|Allow Update
-'''Standard Field Name'''
+! width="25%"|Notes External
-| style="border: 1px solid gray;" width="25%"|
-'''Description'''
-| style="border: 1px solid gray;" width="25%"|
-'''Allow GET'''
-| style="border: 1px solid gray;" width="20%"|
-'''Allow UPDATE'''
 |-
+||sf_Name
+||Name of current company
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
+|-
+||sf_Phone
 ||
-sf_Company ID
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Company id. (0 if new company)
+|-
+||sf_Fax
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||
+|-
+||sf_Address
+||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-'''                  Not Updatable'''
-Mandatory field for updating records
 |-
+||sf_Address 2
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
-||
-sf_Parent Company
 ||
-Parent company name
+|-
+||sf_City
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_State / Province
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-sf_Parent Company ID
+|-
+||sf_Country
 ||
-Parent company id
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using Country ID or Country name as value
+|-
+||sf_Zip / Postal Code
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
-Mandatory field for adding records
 |-
+||sf_Web Site
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||
+|-
+||sf_Longitude
 ||
-sf_Status ID
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Status id
+|-
+||sf_Latitude
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Primary Contact
+||Primary Contact name
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
+|-
+||sf_Parent Company
+||Parent company name
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-sf_Status
+|-
+||sf_Owner
+||Name of User in Owner Standard Field
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-Status
+|-
+||sf_Company Workflow
+||ID of Company workflow standard field
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
+|-
+||sf_User Workflow
+||ID of User workflow standard field
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Updated By
+||Name of user that last updated the record
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
+|-
+||sf_Last Updated
+||Date record was last updated
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-sf_Is External
+|-
+||sf_Created By
+||Name of user that created  the record
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-Flag (1=external, 0=internal)
+|-
+||sf_Created Date
+||Date the record was created
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-                              ✓
+|-
+||sf_Status
+||Returns Status name
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using Status ID as value
+|-
+||sf_Company ID
+||Company id. (0 if new company)
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
+||Mandatory field for updating records
+|-
+||sf_Owner ID
+||ID of User in Owner Standard Field
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
-Mandatory field for adding records
 |-
+||sf_Parent Company ID
+||ID of Parent Company
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Mandatory field for adding records
+|-
+||sf_Primary Contact ID
+||Primary Contact ID (0 if empty)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
+|-
+||sf_Category ID List
+||Comma delimited list of category IDs. (Starts and ends with a comma)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-sf_Owner ID
+|-
+||sf_Status ID
+||Returns Status ID
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using Status ID as value
+|-
+||sf_Is External
+||Flag (1=external, 0=internal)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Mandatory field for adding records
+|-
+||sf_Status Caption
+||Returns Status Caption
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-user who created the company
+|}
+==Users==
+{| 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%"|Notes External
+|-
+||sf_First Name
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Last Name
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||
+|-
+||sf_Email
 ||
-sf_Primary Contact ID
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Primary Contact ID (0 if empty)
+|-
+||sf_Title
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Prefix
+||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
+|-
+||sf_Suffix
 ||
-sf_Primary Contact
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Primary contact name
+|-
+||sf_Phone
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Phone Ext.
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||
+|-
+||sf_Address
 ||
-sf_Name
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Name standard field
+|-
+||sf_Address 2
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_City
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||
+|-
+||sf_State / Province
 ||
-sf_Address
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Address standard field
+|-
+||sf_Country
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Zip / Postal Code
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-sf_Address 2
+|-
+||sf_Company
+||Name of user's company
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||When updating, use Country ID or Country name as value
+|-
+||sf_Middle Name
+||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-Address 2 standard field
+|-
+||sf_Longitude
 ||
-                              ✓
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-                              ✓
 |-
+||sf_Latitude
 ||
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
 ||
-sf_City
+|-
+||sf_User Role
+||Comma delimited list of role IDs. (Starts and ends with a comma)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||sf_User Role and sf_Role ID List are interchangable.
+|-
+||sf_Access Type
 ||
-City standard field
+('User'), 3 ('Applicant Interface'), 5 ('API'), 0 ('No Access')
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using ID as value
+|-
+||sf_User Type
+||10 (‘User’), 30 (‘Local User Administrator’), 50 (‘Global User Administrator’)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using ID as value
+|-
+||sf_Updated By
+||Name of user that last updated the record
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-                              ✓
+|-
+||sf_Last Updated
+||Date record was last updated
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-                              ✓
 |-
+||sf_Created By
+||Name of user that created  the record
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
+|-
+||sf_Created Date
+||Date the record was created
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
-sf_State / Province
-||
-Province standard field
-||
-                              ✓
-||
-                              ✓
 |-
+||sf_Status
+||Returns Status name
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using Status ID as value
+|-
+||sf_User ID
+||User ID (0 if new user)
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
+||Mandatory field for updating records
+|-
+||sf_Company ID
+||ID of user's company. 0 if empty.
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Mandatory field for adding records
+|-
+||sf_Status ID
+||Returns Status ID
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Update using Status ID as value
+|-
+||sf_Role ID List
+||Comma delimited list of role IDs. (Starts and ends with a comma)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||sf_User Role and sf_Role ID List are interchangable.
+|-
+||sf_Is External
+||Flag (1=external, 0=internal)
+| style="text-align: center;"|✓
+| style="text-align: center;"|✓
+||Mandatory field for adding records
+|-
+||sf_Status Caption
+||Returns Status Caption
+| style="text-align: center;"|✓
+| style="text-align: center;"|Not Updatable
 ||
+|}
-||
-sf_Zip / Postal Code
-||
-Postal code standard field
-||
-                              ✓
-||
-                              ✓
-|-
-||
-||
-sf_Country
-||
-Country name
-||
-''                              ✓''
-''            Displays country name''
-||
-''                              ✓''
-''Update using country id or country name<br />''
-|-
-||
-||
-sf_Phone
-||
-Phone standard field
-||
-                              ✓
-||
-                              ✓
-|-
-||
-||
-sf_Fax
-||
-Fax standard field
-||
-                              ✓
-||
-                              ✓
-|-
-||
-||
-sf_Web Site
-||
-Website standard field
-||
-                              ✓
-||
-                              ✓
-|-
-||
-||
-sf_Category ID List
-||
-Comma delimited list of category IDs. (Starts and ends with a comma)
-||
-                              ✓
-||
-                              ✓
-|-
-||
-||
-sf_Last Updated
-||
-date the record was last updated on SmartSimple
-||
-                              ✓
-||
-'''                  Not Updatable'''
-|-
-||
-||
-sf_Updated By
-||
-Last updated user name
-||
-                              ✓
-||
-'''                  Not Updatable'''
-|-
-||
-||
-sf_Created Date
-||
-date the record was last created on SmartSimple
-||
-                              ✓
-||
-'''                  Not Updatable'''
-|-
-||
-||
-sf_Created By
-||
-Created by user name
-||
-                              ✓
-||
-'''                  Not Updatable'''
-|}
-==Users==
-{| class="wikitable" cellpadding="5px" align="center"
-|- style="font-weight: bold; text-align: center;"
-| style="border: 1px solid gray;" width="5%"|
-''' '''
-| style="border: 1px solid gray;" width="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%"|
-'''UPDATE Method'''
-|-
-||
-||
-sf_User ID
-||
-User ID (0 if new user)
-||
-                              ✓
-||
-'''                  Not Updatable'''
-Mandatory field for updating records
-|-
-||
-||
-sf_Is External
-||
-Flag (1=external, 0=internal)
-||
-                              ✓
-||
-                              ✓
-''Mandatory field for adding records''
-|-
-||
-||
-sf_Company ID
-||
-ID of user's company. 0 if empty.
-||
-                              ✓
-||
-''                              ✓''
-''Mandatory field for adding records''
-|-
-||
-||
-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_Middle Name
-||
-Middle 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.
-||
-''                              ✓''
-''               Displays country name''
-||
-''                              ✓''
-''Update using country id or country name<br />''
-|-
-||
-||
-sf_Zip / Postal Code
-||
-Postal code standard field
-||
-                              ✓
-||
-''                              ✓''
-|-
-||
-||
-sf_Phone
-||
-Phone standard field
-||
-                              ✓
-||
-''                              ✓''
-|-
-||
-||
-sf_Phone Ext.
-||
-Phone extension field. (includes period at the end)
-||
-                              ✓
-||
-''                              ✓''
-|-
-||
-||
-sf_Role ID List
-||
-Comma delimited list of role IDs. (Starts and ends with a comma)
-||
-                              ✓
-||
-''                              ✓''
-|-
-||
-||
-sf_Access Type
-||
-('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')
-||
-''                              ✓''
-''                       Displays id''
-||
-''                              ✓''
-''                   Update using id''
-|-
-||
-||
-sf_User Type
-||
-(‘User’), 30 (‘Local User Administrator’), 50 (‘Global User Administrator’)
-||
-''                              ✓''
-''                    Displays name''
-||
-''                              ✓''
-''                    Update using id''
-|-
-||
-||
-sf_Status*
-||
-status name of user
-||
-''                              ✓''
-''                     Displays name''
-||
-''                              ✓''
-''                    Update using id''
-|-
-||
-||
-sf_Status ID*
-||
-status ID of user
-||
-''                               ✓''
-||
-''                              ✓'''' ''
-|-
-||
-||
-sf_Updated By
-||
-name of user who updated the record
-||
-''                              ✓''
-||
-'''                  Not Updatable'''
-|-
-||
-||
-sf_Last Updated
-||
-date record was last updated
-||
-''                              ✓''
-||
-'''                  Not Updatable'''
-|-
-||
-||
-sf_Created Date
-||
-date record was created
-||
-''                              ✓''
-||
-'''                  Not Updatable'''
-|-
-||
-||
-sf_Created By
-||
-user who created the user
-||
-''                              ✓''
-||
-'''                  Not Updatable'''
-|}
 ==Level 1==
@@ Line 1,978: / Line 1,470: @@
 ==Associations==
+not implemented at the moment.
-not implemented at the moment.