0
edits
Changes
Created page with 'The following lists the database field names associated with the Standard Fields ==Companies== * '''isexternal''': Flag (1=external, 0=internal) * '''parentcompanyid''': Par…'
The following lists the database field names associated with the [[Standard Fields]]
==Companies==
* '''isexternal''': Flag (1=external, 0=internal)
* '''parentcompanyid''': Parent company id.
* '''ownerid''': Owner ID of company.
* '''contactuserid''': Primary contact ID of company. 0 if empty.
* '''name''': Name standard field.
* '''address''': Address standard field.
* '''address2''': Address2 standard field.
* '''city''': City standard field.
* '''state''': Province standard field.
* '''countryid''': ID of country field. 0 if empty.
* '''postalcode''': postal code standard field.
* '''phone''': Phone standard field.
* '''fax''': Fax standard field.
* '''website''': Website standard field.
* '''catlist''': Comma delimited list of category IDs. (Starts and ends with a comma)
* '''istaxable''': Flat (Only applicable to professional services)
==Users==
* '''isexternal''': Flag (1=external, 0=internal)
* '''companyid''': ID of user's company. 0 if empty.
* '''title''': Title standard field.
* '''uprefix''': Prefix standard field.
* '''usuffix''': Suffix standard field.
* '''firstname''': First name standard field.
* '''lastname''': Last name standard field.
* '''email''': Email standard field.
* '''uaddress''': Address standard field.
* '''uaddress2''': Address 2 standard field.
* '''ucity''': City standard field.
* '''ustate''': Province standard field.
* '''ucountryid''': ID of country field. 0 if empty.
* '''upostalcode''': Postal code standard field.
* '''phone''': Phone standard field.
* '''uphoneext''': Phone extension field.
* '''rolelist''': Comma delimited list of role IDs. (Starts and ends with a comma)
==Job Costing fields for users==
* '''isresource''':
* '''costunit''': ID number of cost unit cobmo-box option.
* '''rmargin''': Margin field of user/resource.
* '''cost''': Cost field of user/resource.
* '''allcost''': Cost field of user/resource.
* '''rbillrate''': Bill rate field of user/resource
* '''resourcetypeid''': Resource type ID of user.
==Level 1==
* '''companyid''': Company ID of level 1 company/client field, 0 if empty.
* '''branchid''': Company ID of level 1 branch field. 0 if empty.
* '''oppeopleid''': User ID of level 1 people field. 0 if empty.
* '''opportunitytype''': ID of level 1 template.
* '''name''': Name standard field.
* '''description''': Description standard field.
* '''requirements''': Requirement standard field.
* '''stageid''': Status ID of level 1 status. 0 if empty.
* '''revenue''': Revenue standard field.
* '''ostartdate''': Start date standard field.
* '''oenddate''': End date standard field.
* '''closedate''': Close date standard field.
* '''probability''': Probability standard field.
* '''updatedby''': ID of level 1 owner.
==Level 2==
* '''description''': Description standard field.
* '''subject''': Subject standard field.
* '''eventtype''': ID of level 2/3 type.
* '''objecttype''': Parent [[object type]] (23=parent object is level 1. 8=parent object is level 2.)
* '''objectid''': Parent object ID.
* '''assigned''': Comma delimited list of user IDs in assigned standard field.
* '''contact''': Comma delimited list of user IDs in contact standard field.
* '''location''': Location standard field.
* '''startdate''': Start date standard field.
* '''enddate''': End date standard field.
* '''span''': Duration standard field.
* '''eamount''': Amount standard field.
* '''statusid''': Status ID of status. 0 if empty.
* '''eownerid''': User ID of owner. 0 if empty.
==Level 3==
See Level Two.
[[Category:System Management]]
==Companies==
* '''isexternal''': Flag (1=external, 0=internal)
* '''parentcompanyid''': Parent company id.
* '''ownerid''': Owner ID of company.
* '''contactuserid''': Primary contact ID of company. 0 if empty.
* '''name''': Name standard field.
* '''address''': Address standard field.
* '''address2''': Address2 standard field.
* '''city''': City standard field.
* '''state''': Province standard field.
* '''countryid''': ID of country field. 0 if empty.
* '''postalcode''': postal code standard field.
* '''phone''': Phone standard field.
* '''fax''': Fax standard field.
* '''website''': Website standard field.
* '''catlist''': Comma delimited list of category IDs. (Starts and ends with a comma)
* '''istaxable''': Flat (Only applicable to professional services)
==Users==
* '''isexternal''': Flag (1=external, 0=internal)
* '''companyid''': ID of user's company. 0 if empty.
* '''title''': Title standard field.
* '''uprefix''': Prefix standard field.
* '''usuffix''': Suffix standard field.
* '''firstname''': First name standard field.
* '''lastname''': Last name standard field.
* '''email''': Email standard field.
* '''uaddress''': Address standard field.
* '''uaddress2''': Address 2 standard field.
* '''ucity''': City standard field.
* '''ustate''': Province standard field.
* '''ucountryid''': ID of country field. 0 if empty.
* '''upostalcode''': Postal code standard field.
* '''phone''': Phone standard field.
* '''uphoneext''': Phone extension field.
* '''rolelist''': Comma delimited list of role IDs. (Starts and ends with a comma)
==Job Costing fields for users==
* '''isresource''':
* '''costunit''': ID number of cost unit cobmo-box option.
* '''rmargin''': Margin field of user/resource.
* '''cost''': Cost field of user/resource.
* '''allcost''': Cost field of user/resource.
* '''rbillrate''': Bill rate field of user/resource
* '''resourcetypeid''': Resource type ID of user.
==Level 1==
* '''companyid''': Company ID of level 1 company/client field, 0 if empty.
* '''branchid''': Company ID of level 1 branch field. 0 if empty.
* '''oppeopleid''': User ID of level 1 people field. 0 if empty.
* '''opportunitytype''': ID of level 1 template.
* '''name''': Name standard field.
* '''description''': Description standard field.
* '''requirements''': Requirement standard field.
* '''stageid''': Status ID of level 1 status. 0 if empty.
* '''revenue''': Revenue standard field.
* '''ostartdate''': Start date standard field.
* '''oenddate''': End date standard field.
* '''closedate''': Close date standard field.
* '''probability''': Probability standard field.
* '''updatedby''': ID of level 1 owner.
==Level 2==
* '''description''': Description standard field.
* '''subject''': Subject standard field.
* '''eventtype''': ID of level 2/3 type.
* '''objecttype''': Parent [[object type]] (23=parent object is level 1. 8=parent object is level 2.)
* '''objectid''': Parent object ID.
* '''assigned''': Comma delimited list of user IDs in assigned standard field.
* '''contact''': Comma delimited list of user IDs in contact standard field.
* '''location''': Location standard field.
* '''startdate''': Start date standard field.
* '''enddate''': End date standard field.
* '''span''': Duration standard field.
* '''eamount''': Amount standard field.
* '''statusid''': Status ID of status. 0 if empty.
* '''eownerid''': User ID of owner. 0 if empty.
==Level 3==
See Level Two.
[[Category:System Management]]
