Database Field Names

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

• 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.
• zip: 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.) *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

• SmartSimple Tables
• Entity IDs (Object Types)