Database Field Names

From SmartWiki
Revision as of 11:48, 12 August 2011 by Chin (talk | contribs) (Level 1)

Jump to: navigation, search

The following lists the database field names associated with Standard Fields.

These are required if updating the database directly (clients with dedicated servers only)
or for Pandora.

Companies

  • companyid: Company id. (0 if new company)
  • parentcompanyid: Parent company id.
  • isexternal: Flag (1=external, 0=internal)
  • 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.
  • postalcode: Postal code standard field.
  • country: ID of country field. (0 if empty)
  • phone: Phone standard field.
  • fax: Fax standard field.
  • website: Website standard field.
  • catid: 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.
  • statusname: Name of level 1 status.
  • 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.) *Note: although 18 is the Level 2 Type object type, 8 should be used here.
  • 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 2.

See Also