Database Field Names
Revision as of 14:58, 16 August 2010 by Cameron (talk | contribs) (Created page with 'The following lists the database field names associated with the Standard Fields ==Companies== * '''isexternal''': Flag (1=external, 0=internal) * '''parentcompanyid''': Par…')
Revision as of 14:58, 16 August 2010 by Cameron (talk | contribs) (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
Contents
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.