Difference between revisions of "Database Field Names"

Revision as of 14:23, 19 January 2012

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.
• typename: Level 1 template type name.
• 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.
• typename: Level 2 type name.
• 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.
• statusname: Status name.
• eownerid: User ID of owner. 0 if empty.

Level 3

See Level 2.

See Also

• Entity IDs (Object Types)