Smartstaff
171
edits
Changes
→No summary
The following lists the database field names associated with [[Standard Fields]]. These are required if updating the database directly (clients with dedicated servers only)<br />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.
* '''city''': City standard field.
* '''state''': Province standard field.
* '''countryidpostalcode''': ID of country Postal code standard field. 0 if empty.* '''postalcodecountry''': postal code standard ID of country field.(0 if empty)
* '''phone''': Phone standard field.
* '''fax''': Fax standard field.
* '''website''': Website standard field.
* '''catlistcatid''': Comma delimited list of category IDs. (Starts and ends with a comma)
* '''istaxable''': Flat (Only applicable to professional services)
==Users==
* '''ustatusid''': Status ID
* '''isexternal''': Flag (1=external, 0=internal)
* '''companyid''': ID of user's company. 0 if empty.
* '''name''': name of user's company.
* '''title''': Title standard field.
* '''uprefix''': Prefix standard field.
* '''uphoneext''': Phone extension field.
* '''rolelist''': Comma delimited list of role IDs. (Starts and ends with a comma)
* '''isactive''': 1 ('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')
==Job Costing fields for users==
* '''isresource''': * '''costunit''': ID number of cost unit cobmocombo-box option.
* '''rmargin''': Margin field of user/resource.
* '''cost''': 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.
* '''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.)<span style="font-size: xx-small;">''*Note: although 18 is the Level 2 Type object type, 8 should be used here.''</span>
* '''objectid''': Parent object ID.
* '''assigned''': Comma delimited list of user IDs in assigned 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 Two2. ==Intersection Tables=====Level 1 Contact===* oprid, opportunityid, contactid, roleid ===Level 1 Company===* opcid, opcopportunityid, opccompanyid, opcroleid ===Level 2/3 Contact===* lnkid, lnkeventid, lnkuserid, lnkroleid ===Level 2/3 Company===* clnkid, clnkeventid, clnkcompanyid, clnkroleid ===Association===* afcid, afccompanyid, afccontactid, afroleid ===UTA Provider/Consumer (Level 1 to Level 1)===* conid, conoppid, provoppid, conroleid* provoppid: provider Level 1 id* conoppid: consumer Level 1 id ===UTA Provider/Consumer (Level 1 to Level 2)===* cevid, cevconoppid, cevprovevtid, cevroleid* cevconoppid: Level 1 id (regardless of whether the Level 1 is the consumer or the provider)* cevprovevtid: Level 2 id (regardless of whether the Level 2 is the consumer or the provider)
==See Also==
* [[Entity IDs]] (Object Types)
[[Category:System Management]][[Category:Pandora]][[Category:Standard Fields]]
