Tables

The tool modifies a number of tables and attributes.

The following table describes the tables and attributes that are modified. The Property column identifies which properties are required to update the respective table and attribute.

Table 1. Tables and attributes modified by updateTool
Table name Attribute name Description Property
PMSCOFFERINGEXT ITEMSETID Item set for the offering OFFERINGS
PMSCTDOMATTRS ITEMSETID Additional ITEMSPEC table domain attributes OFFERINGS
PMSCOFFDIALOG ITEMSETID Default dialog behavior OFFERINGS
PMSCCATALOGOFFMAP ITEMSETID Offering Map OFFERINGS
ITEM ITEMSETID Item set for the item OFFERINGS
PMSCCATALOGEXT ITEMSETID Catalog Item Extension OFFERINGS
ITEMORGINFO ITEMSETID Item set for the item org info OFFERINGS
  ORGID Organization identifier OFFERINGS
ITEMORGSTATUS ITEMSETID Item set for the item org status OFFERINGS
  ORGID Organization identifier OFFERINGS
ITEMSPEC ITEMSETID Item set for the item spec   OFFERINGS
  ORGID Organization identifier OFFERINGS
ITEMSTATUS ITEMSETID Item set for the item status OFFERINGS
ITEMSTRUCT ITEMSETID Item set for the item struct OFFERINGS
INVBALANCES ORGID Organization identifier OFFERINGS
  SITEID Site identifier OFFERINGS
COMMODITIES ITEMSETID Item set for commodities OFFERINGS
CLASSANCESTOR ORGID Organization identifier CLASSIFICATION
  SITEID Site identifier CLASSIFICATION
CLASSIFICATION ORGID Organization identifier CLASSIFICATION
  SITEID Site identifier CLASSIFICATION
CLASSSPEC ORGID Organization identifier CLASSIFICATION
  SITEID Site identifier CLASSIFICATION
CLASSSPECUSEWITH ORGID Organization identifier CLASSIFICATION
  SITEID Site identifier CLASSIFICATION
CLASSSTRUCTURE ORGID Organization identifier CLASSIFICATION
  SITEID Site identifier CLASSIFICATION
ASSETATTRIBUTE ORGID Organization identifier CLASSIFICATION
  SITEID Site identifier CLASSIFICATION
JOBPLAN ORGID Organization identifier JOBPLAN
  SITEID Site identifier JOBPLAN
JOBTASK ORGID Organization identifier JOBPLAN
  SITEID Site identifier JOBPLAN
AUTOKEY ORGID Organization identifier *
  SITEID Site identifier *
MAXVARS ORGID Organization identifier *
  SITEID Site identifier *
LIMITTOLERANCE ORGID Organization identifier LIMITGROUPS
TKTEMPLATE ORGID Organization identifier TKTEMPLATE
WORKTYPE ORGID Organization identifier WORKTYPE
WPEDITSETTINGS ORGID Organization identifier WPEDITSTATUS
MAXUSER DEFSITE Default site USERID

*This table/attribute gets updated automatically and is not dependent upon a property being set.