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.* '''zipcountry''': postal code standard ID of country field.(0 if empty)
* '''phone''': Phone standard field.
* '''fax''': Fax standard field.
==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="1: xx-small;">''*Note: although 18 is the Level 2 Type object type, 8 should be used here.''</fontspan>
* '''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 2.
==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]]
