SC23-8802-00
Release 6.1
Maximo User�s Guide Addendum
IBM Maximo for Service Providers
This edition applies to Release 6.1 of IBM Maximo for Service Providers and to all subsequent releases and modifications until otherwise indicated in new editions.
Third-Party Technology: Certain Maximo products contain technology provided under license from third parties, as noted in the following table:
Open Source: Maximo contains computer software obtained from the public domain, known as "Open Source" ownership of which is attributed as follows: Portions © 2002, Steve Souza ([email protected]). Portions © 2000-2004, Jason Hunter & Brett McLaughlin. Portions © 2004-2005, The Apache Software Foundation (http://www.apache.org/).
© Copyright International Business Machines Corporation 2007. All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
IBM Product Third-Party Information
All Products Portions © 1996-2003 Visual Mining, Inc. Visual Mining� NetCharts Server provided by Visual Mining, Inc.
IBM Maximo Portions © 1995-2004 Actuate Corporation.
Portions © 2005 BEA Systems, Inc. BEA WebLogic Server® provided by BEA Systems, Inc.
Portions © 1996-2005, i-net software GmbH. J-Integra for COM® v2.4. © 2004 Intrinsyc Software International, Inc.
Sentry Spelling-Checker Engine © 2000 Wintertree Software, Inc.
Maximo Discovery MSDE Copyright © Microsoft® Corporation.
Portions © 1998-2005 Centennial Software Limited.
IBM Maximo Asset Navigator Portions © 1993-2002 Snowbound� Software Corporation. RasterMaster� Raster imaging technology provided by Snowbound Software Corporation.
IBM Maximo Mobile Portions © 2005 DataMirror, Inc.
Portions © 2000-2005 Zaval Creative Engineering Group.
IBM Maximo Mobile SE Portions © 1996-2005 Syclo, LLC.
NoteBefore using this information and the product it supports, read the information in �Notices� on page Notices-1.
Contents
About This Publication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiIntended Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiRelated Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiIBM Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .viii
Chapter 1: Administration Module. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1Organizations (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1
Organizations (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1Work Order Options > Edit Rules Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Service Options Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Billing Options Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
Classifications (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4Classifications (SP) Actions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4
Chapter 2: Assets Module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1Locations (SP) Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2Location Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2
Locations (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2
Chapter 3: Configuration Module. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1Escalations (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1Escalations (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-2
Chapter 4: Resources Module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1People (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1People (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1
Chapter 5: Service Desk Module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-1Activities (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-1
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-1Activity Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2Plans Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2Actuals Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2
Activities (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2Apply Response Plan Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3Apply Customer Agreement Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5-3Select/Deselect Price Schedule Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3View Costs and Prices Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3View Billing Status History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3
Changes (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4
Change Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4Plans Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4
© Copyright IBM Corp. 2007 iii
Actuals Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4
Changes (SP) Actions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-5Incidents (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6Incident Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6Activities Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6
Incidents (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6Problems (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8Problem Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8Activities Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8
Problems (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8Releases (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9Release Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9Plans Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9Actuals Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9
Releases (SP) Actions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-10Service Requests (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11Service Request Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11
Service Requests (SP) Actions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11
Chapter 6: Service Management Module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1Service Level Agreements (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1Service Level Agreement Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2Conditions Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2Locations Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2Assets Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2
Service Level Agreements (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2Service Address (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-3
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-3Service Address (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-3
Duplicate Address Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-3Delete Address Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-3
Response Plans (SP) Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-4Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-4
Response Plan Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-4Conditions Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-4Locations Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-4Assets Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-4Response Actions Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5
Response Plans (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5Associate Customer Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5Duplicate Response Plan Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5Delete Response Plan Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5
Chapter 7: Work Orders Module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-1Service Requests (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-1Work Order Tracking (SP) Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-1
iv IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-2Work Order Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-2Plans Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-2Actuals Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-2Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-2
Work Order Tracking (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-3Apply Customer Agreement Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7-3View/Update Price Quote Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-3Select/Deselect Price Schedule Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7-3
Chapter 8: Service Provider (SP) Module. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-1Customer Agreements (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-1
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-2Customer Agreement Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-2Price Schedules Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-2Terms and Conditions Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-3Contacts Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-3Log Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-3
Customer Agreements (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-3Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-3View Status History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-4Revise Agreement Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-4View Revision History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-4Duplicate Agreement Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-4
Customers (SP) Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5
Customer Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5Contacts Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5Log Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5Price Schedules Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5Associated Customers Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-5
Customers (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6View History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Create Communication Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Edit/Delete Customer Log Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Associate SLAs Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Associate Response Plans Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Copy to Business Address Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-6Duplicate Customer Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-7Delete Customer Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-7
Bill Review (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-8Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-8
Bill Review Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-8Terns and Conditions Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-8
Bill Review (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-8Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-8Advance all WAPPR Lines to APPR Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-9View Costs Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-9
Customer Billing (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-10Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-10Customer Billing (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-10
Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-10Advance all WAPPR Lines to APPR Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-10View Bill Batch Status History Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-11Line Status Summary Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-11
Sales Orders (SP) Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12
Contents v
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12Sales Order Tab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12
Sales Orders (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13Select Owner Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13Take Ownership Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13Apply Response Plan Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13Apply Customer Agreement Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13Select/Deselect Price Schedule Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13View Billing Status History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13View Sales Order History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14Edit Sales Order History Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14Duplicate Sales Order Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14Delete Sales Order Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14
Chapter 9: Service Provider Database Tables and Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9-1
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Notices-1
vi IBM Maximo for Service Providers: Maximo User�s Guide Addendum
About This Publication
This section explains how this guide can help you to use IBM® Maximo® for Service Providers (Service Provider). It also provides information about other IBM Corporation resources available to you, such as additional documentation and support.
Intended Audience
This addendum to the IBM Maximo User�s Guide is for people who use Maximo Service Provider. This solution extends certain existing Maximo applications and also provides new Maximo applications designed specifically for Service Providers customers.
Related Information
You can find more information regarding Maximo Service Provider in the following document:
! IBM Maximo for Service Providers Installation Guide
The IBM Maximo for Service Providers Installation Guide is a separate document delivered in Adobe® Systems� Portable Document Format (PDF) with the product software. The guide should be used in conjunction with the standard Maximo documentation set.
For more information about Maximo, refer to the following documentation:
Document Description
IBM Maximo Finance Manager�s Guide
Describes how IBM Maximo completes financial transactions and how to set up general ledger accounts.
IBM Maximo Installation Guide Describes how to install and configure the following software:
! Application server! IBM Maximo! Actuate®
IBM Maximo Multisite Administrator�s Guide
Describes how to configure IBM Maximo for a Multisite implementation.
© Copyright IBM Corp. 2007 vii
IBM Support
IBM Support
IBM Software Support provides assistance with product defects.
Before contacting IBM Software Support, your company must have an active IBM software maintenance contract, and you must be authorized to submit problems to IBM. For information about the types of maintenance contracts available, see "Enhanced Support," in the Software Support Handbook at techsupport.services.ibm.com/guides/services.html.
Complete the following steps to contact IBM Software Support with a problem:
1 Define the problem, gather background information, and determine the severity of the problem. For help, see the "Contacting IBM," in the Software Support Handbook at techsupport.services.ibm.com/guides/beforecontacting.html.
2 Gather diagnostic information.
IBM Maximo Online Help Provides step-by-step procedures for Maximo applications.
IBM Maximo Reconciliation Implementation Guide
Describes how to use the IBM Maximo Reconciliation module to reconcile the two types of information that IBM Maximo maintains about information technology (IT) assets: IT asset data and deployed asset data.
IBM Maximo Report Administration and Development Guide
Describes how to use Actuate to design and administer IBM Maximo reports.
IBM Maximo System Administrator�s Guide
Describes database configuration, security, and other administrative level applications and tasks.
IBM Maximo User�s Guide Provides an overview of the Maximo end user applications. It also describes how the IBM Maximo applications interact with each other.
IBM Maximo Workflow Implementation Guide
Provides information about how to use IBM Maximo to plan, design, build, test, implement, and manage Workflow processes.
IBM Maximo Enterprise Adapter (MEA) System Administrator's Guide
Describes how to configure and use the IBM MEA.
Document Description
viii IBM Maximo for Service Providers: Maximo User�s Guide Addendum
IBM Support
3 Submit your problem to IBM Software Support in one of the following ways:
a Online: Click Submit and track problems on the IBM Software Support site at www.ibm.com/software/support/probsub.html.
b By telephone: For the telephone number to call in your country, go to the Contacts page of the IBM Software Support Handbook at techsupport.services.ibm.com/guides/contacts.html.
If you submit a problem that is a software defect or for missing or inaccurate documentation, IBM Software Support creates an Authorized Program Analysis Report (APAR). The APAR describes the problem in detail.
Whenever possible, IBM Software Support provides a workaround that you can implement until the APAR is resolved and a fix is delivered. IBM publishes resolved APARs on the Software Support Web site daily, so that other users who experience the same problem can benefit from the same resolution.
About This Publication ix
IBM Support
x IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Administration module has two cloned applications. This chapter provides an overview of the new actions and fields in the cloned applications.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Administration module contains the following cloned applications:
Organizations (SP) Application
You use the Organizations (SP) application to set up the organizations and sites to use with Maximo. You must define at least one organization and one site.
Within the Organizations (SP) application you set defaults for a wide variety of options relating to Maximo applications or groups of applications, such as work orders, inventory, purchasing, PMs, assets, and so forth.
Organizations (SP) Actions
The Organizations (SP) application has the following new and enhanced industry-specific actions:
! Work Order Options > Edit Rules ! Service Options (new)! Billing Options (new)
For details about these actions, refer to the Organizations (SP) help.
Administration Module 1Application Service Provider Function
Organizations (SP) Specify whether you require formatted street addresses; the status at which a record can be added to a bill batch; the work order status at which you can edit fees and charges.
Classifications (SP) Specify whether a classification applies to sales orders.
© Copyright IBM Corp. 2007 1-1
Work Order Options > Edit Rules Action
You use the Work Order Options > Edit Rules action to specify the work order properties that you can edit at various statuses. Specify edit rules for the following properties:
! GL account! Asset! Location! Work plan labor! Work plan materials! Work plan services! Work plan tools! Data on the Safety tab! Fees and charges
Work Order Options > Edit Rules
Service Options Action
You use the Service Options action to specify how to enter street address information for a service address. Specify whether street address information is entered in a fixed, structured format, or as text in fields.
If you require street address information to be entered in a structured format, users enter street address information in the Add/Modify Street Address dialog box, which they access from the Service Address tab in various applications.
Organizations (SP) Application
1-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
ns (SP) Application
Service Options
Billing Options Action
You use the Billing Options action to specify the status at which completed work can be added to a bill batch.
You set billing options for the following types of records:
! Service requests ! Incidents! Problems! Work orders (including activities, changes, and releases)! Sales orders
Billing Options
Organizatio
Administration Module 1-3
Classifications (SP) Application
Classifications (SP) Application
You use the Classifications (SP) application to create classifications and build classification hierarchies. Classifications provide you with a means to logically categorized information, and can be used on location, asset, item, work order, ticket, sales order, and solution records. You can classify and then search for things that have been classified.
Classification also is a condition that Maximo uses when searching for matches between customer agreements, service level agreements and response plans, and the records to which they might be applied.
You can associate a classification with a customer. When you make this association, only the associated customer can see this classification.
Tabs
The Classifications (SP) application has the following enhanced tab:
! Classifications
The Classifications tab has the following industry-specific fields:
! Sales Order?! Customer
For information about fields, place the cursor in the field and press Alt + F1.
Classifications (SP) Actions
The Classifications (SP) application has the following industry-specific action:
! Associate a classification with a customer
Associate a Classification with a Customer Action
When you associate a classification with a customer, the classification is available only to records for that customer.
NOTE Unlike most actions, you do not select this action from the Select Action menu. You perform it by clicking the Detail Menu icon next to the Customer field on the Classification tab.
For details about this action, refer to the Classifications (SP) help.
1-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Assets module has one cloned application. This chapter provides an overview of the new and enhanced tabs and the new action in the cloned application.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Assets module contains the following industry-specific application:
Locations (SP) Application
You use the Locations (SP) application to create and maintain locations for assets and locations where you provide services to customers. You can organize these locations into logical hierarchical or network systems.
You use systems of locations and specifying the location for assets on asset records to gather and track valuable information about the history of assets. You can obtain information on asset performance at specific sites.
You also can associate locations with a service address. A service desk typically uses a service address to identify one or more locations where it provides services or performs work. You can organize locations associated with service addresses into a hierarchical address system.
You can associate locations with one or more of your service customers. A system process can match data on the combination of location and customer to apply a response plan, service level agreement, or agreement price schedule to work for that location.
Assets Module 2Application Service Provider Function
Locations (SP) Specify the responsible customer for a location and the charge account and cost center of that customer.
© Copyright IBM Corp. 2007 2-1
Locations (SP) Application
Tabs
The Locations (SP) application has the following new or enhanced tabs:
! Location ! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Location Tab
The Location tab has the following industry-specific fields:
! Customer Charge Account! Customer Cost Center
Service Address Tab
You use the Service Address tab to create or view a service address for the location. The service address for a location typically is different from the bill-to and ship-to address for a location.
Locations (SP) Actions
The Locations (SP) application has the following industry-specific action:
! Associate Customers
Associate Customers Action You use the Associate Customers action to associate one or more customers with a location. You designate one customer as the responsible customer for a location.
For details about this action, refer to the Locations (SP) help.
2-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Configuration module has one cloned application. This chapter provides an overview of the enhanced tab and new action in the cloned application.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Configuration module contains the following industry-specific application:
Escalations (SP) Application
You use the Escalations (SP) application to automatically monitor critical processes across your enterprise. The primary goal of escalation management is to ensure that critical tasks are completed on time, such as those defined for service level agreements. You can also use escalations for events such as notifying you before contracts expire, changing the status of a record, or changing the owner of a record.
Tabs
The Escalations (SP) application has the following enhanced tab:
! Escalation
The Escalation tab has the following industry-specific field:
! Source Application
For information about fields, place the cursor in the field and press Alt + F1.
Configuration Module 3
Application Service Provider Function
Escalations (SP) Identify the application that generated an escalation.
© Copyright IBM Corp. 2007 3-1
Escalations (SP) Application
Escalations (SP) Actions
The Escalations (SP) application has the following industry-specific action:
! Edit External Escalation
Edit External Escalation Action
If you have the proper security authorization, you can use the Edit External Escalation action to edit external escalations. Escalations that are created from an application other than the Escalations (SP) application are external escalations.
For details about this action, refer to the Escalations (SP) help.
3-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Resources module has one cloned application. This chapter provides an overview of the enhanced tab in the cloned application.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Resources module contains the following industry-specific application:
People (SP) Application
You use the People (SP) application to create, modify, view, and delete records of people. This application stores personal and official information on individuals such as Maximo users, labor, asset owners, supervisors, and individuals who receive workflow notifications via email. They can be your employees or employees of customers or vendors with whom you do business.
Tabs
The People (SP) application has the following enhanced tab:
! Person
The Person tab has the following industry-specific fields:
! Cust/Vendor! Cust/Vend Type
For information about fields, place the cursor in the field and press Alt + F1.
People (SP) Actions
The People (SP) application has no industry-specific actions.
Resources Module 4Application Service Provider Function
People (SP) Specify customer or vendor identifier and type.
© Copyright IBM Corp. 2007 4-1
People (SP) Application
4-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Service Desk module has six cloned applications. This chapter provides an overview of new and enhanced tabs and new actions in the cloned applications.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Service Desk module contains the following industry-specific applications:
Activities (SP) Application
You use the Activities (SP) application to plan, review, and manage activities. When you create an activity in Maximo, you initiate the work process and create a historical record of work being performed. Activities are created in the Incidents and Problems (SP) applications. An activity is a type of work order.
Tabs
The Activities (SP) application has the following new or enhanced tabs:
! Activity! Plans! Actuals! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Service Desk Module 5
Application Service Provider Function
Activities (SP)
Changes (SP)
Incidents (SP)
Problems (SP)
Releases (SP)
Service Requests (SP)
Specify customer charge account and cost center; fees and charges; and service address.
Apply customer agreement, price schedules, and response plan.
View and update price quotes; view costs and prices.
© Copyright IBM Corp. 2007 5-1
Activity Tab
The Activity tab has the following industry-specific fields:
! Customer ! Response Plan! Customer Charge Account! Customer Cost Center
Plans Tab
The Plans tab has the following industry-specific subtab:
! Fees and Charges
The Plans tab has the following industry-specific field on each of its subtabs:
! Line Price
Actuals Tab
The Actuals tab has the following industry-specific subtab:
! Fees and Charges
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
Activities (SP) Actions
The Activities (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History
For details about these actions, refer to the Activities (SP) help.
NOTE These actions are also available in the following applications:
! Changes (SP)! Incidents (SP)! Problems (SP)! Releases (SP)! Service Requests (SP)
Activities (SP) Application
5-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
es (SP) Application
To understand how each action applies to other applications, substitute the word activity in the following descriptions with change, incident, and so on.
Apply Response Plan Action
You use the Apply Response Plan action to apply a response plan to an activity. When you apply a response plan, you ensure predictable and repeatable responses to similar activities.
Apply Customer Agreement Action
You use the Apply Customer Agreement action to apply a customer agreement to an activity. When you apply a customer agreement, you also apply the price schedule that matches certain criteria on the activity.
Select/Deselect Price Schedule Action
You use the Select/Deselect Price Schedule action to select a price schedule or deselect a price schedule on a ticket, work order, or sales order. You associate only one price schedule with a record, so you might deselect a price schedule so that you can select a more appropriate one.
View Costs and Prices Action
You use the View Costs and Prices action to view transaction costs and prices, and fees and charges, for a ticket, its activities, and its child activities.
View Billing Status History Action
You use the View Billing Status action to view billing status history for a ticket, work order, or sales order. The dialog box displays billing status history for all billing lines that reference this ticket, work order, or sales order.
Activiti
Service Desk Module 5-3
Changes (SP) Application
You use the Changes (SP) application to plan, review, and report actuals for implementing changes or deploying new, standard configurations to existing assets.
Tabs
The Changes (SP) application has the following new or enhanced tabs:
! Change! Plans! Actuals! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Change Tab
The Change tab has the following industry-specific fields:
! Customer ! Response Plan! Customer Charge Account! Customer Cost Center
Plans Tab
The Plans tab has the following industry-specific subtab:
! Fees and Charges
The Plans tab has the following industry-specific field on each of its subtabs:
! Line Price
Actuals Tab
The Actuals tab has the following industry-specific subtab:
! Fees and Charges
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
Changes (SP) Application
5-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
es (SP) Application
Changes (SP) Actions
The Changes (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History! View/Update Price Quote
For information about the first five actions, see �Activities (SP) Actions,� on page 5-2.
View/Update Price Quote Action
You use the View/Update Price Quote action to add, view or update a price quote. You can add or update a price quote on a change if the associated price schedule allows price quotes and the change is not included in a bill batch. You cannot add a price quote to a task work order.
For details about this action, refer to the Changes (SP) help.
Chang
Service Desk Module 5-5
Incidents (SP) Application
You use the Incidents (SP) application to create, view, delete, and resolve incident records for customers and other users. You create an incident record to capture information about an event that deviates from standard service or an event that might disrupt the quality of that service.
Tabs
The Incidents (SP) application has the following new or enhanced tabs:
! Incident! Activities! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Incident Tab
The Incident tab has the following industry-specific fields:
! Customer! Customer Charge Acct! Customer Cost Center! Response Plan
Activities Tab
The Activities tab has the following industry-specific fields:
! Customer Charge Acct! Customer Cost Center! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
Incidents (SP) Actions
The Incidents (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History! Add/Modify Fees and Charges
For information about the first five actions, see �Activities (SP) Actions,� on page 5-2.
Incidents (SP) Application
5-6 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
ts (SP) Application
Add/Modify Fees and Charges Action
You use the Add/Modify Fees and Charges action to add or modify fees and charges on a ticket. The dialog box also displays fees and charges added with any applied price schedule.
For details about this action, refer to the Incidents (SP) help.
Inciden
Service Desk Module 5-7
Problems (SP) Application
Problems (SP) Application
You use the Problems (SP) application to create and modify problem records. You create a problem record to capture an unknown, underlying cause of one or more incidents.
Tabs
The Problems (SP) application has the following new or enhanced tabs:
! Problem! Activities! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Problem Tab
The Problem tab has the following industry-specific fields:
! Customer! Customer Charge Account! Customer Cost Center! Response Plan
Activities Tab
The Activities tab has the following industry-specific field:
! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
Problems (SP) Actions
The Problems (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History! Add/Modify Fees and Charges
For information about the first five actions, see �Activities (SP) Actions,� on page 5-2.
For information about the Add/Modify Fees and Charges action, see �Add/Modify Fees and Charges Action,� on page 5-7.
5-8 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Releases (SP) Application
Releases (SP) Application
You use the Releases (SP) application to plan, review, and prepare for large batches of changes to assets. You use releases to manage the release of authorized versions or configurations of assets into a production environment; for large or critical hardware roll-outs, for major software roll-outs, and for bundling related sets of changes.
Tabs
The Releases (SP) application has the following new or enhanced tabs:
! Release! Plans! Actuals! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Release Tab
The Release tab has the following industry-specific fields:
! Customer Charge Account! Customer Cost Center! Customer ! Response Plan
Plans Tab
The Plans tab has the following industry-specific subtab:
! Fees and Charges
The Plans tab has the following industry-specific field on each of its subtabs:
! Line Price
Actuals Tab
The Actuals tab has the following industry-specific subtab:
! Fees and Charges
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
Service Desk Module 5-9
Releases (SP) Application
Releases (SP) Actions
The Releases (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History! View/Update Price Quote
For information about the first five actions, see �Activities (SP) Actions,� on page 5-2.
For information about the View/Update Price Quote action, see �View/Update Price Quote Action,� on page 5-5.
5-10 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Service Requests (SP) Application
Service Requests (SP) Application
You use the Service Requests (SP) application to create, view, delete, and resolve service requests from customers or other users. A service desk agent, customer, or other user can create a service request.
Tabs
The Service Requests (SP) application has the following new or enhanced tabs:
! Service Request! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Service Request Tab
The Service Request tab has the following industry-specific fields:
! Customer ! Customer Charge Account! Customer Cost Center! Response Plan! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
Service Requests (SP) Actions
The Service Requests (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History! Add/Modify Fees and Charges
For information about the first five actions, see �Activities (SP) Actions,� on page 5-2.
For information about the Add/Modify Fees and Charges action, see �Add/Modify Fees and Charges Action,� on page 5-7.
Service Desk Module 5-11
Service Requests (SP) Application
5-12 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Service Management module has two new applications and one cloned application. This chapter provides an overview of new tabs and fields in the cloned applications.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Service Management module contains the following industry-specific applications:
Service Level Agreements (SP) Application
You use the Service Level Agreements (SP) application to create and manage service level agreements (SLAs). A service level agreement is a written agreement between a service provider and a customer that documents the agreed-upon levels of service.
Tabs
The Service Level Agreements (SP) application has the following new and enhanced tabs:
! Service Level Agreement! Conditions (new)! Locations (new)! Assets (new)
For information about fields, place the cursor in the field and press Alt + F1.
Service Management Module 6
Application Service Provider Function
Service Level Agreements (SP) Create and manage service level agreements (SLAs).
Service Address (SP) Create, view, modify, and delete service addresses for customers.
Response Plans (SP) Create, view, modify, and delete response plans.
© Copyright IBM Corp. 2007 6-1
Service Level Agreement Tab
The Service Level Agreement tab has the following new fields:
! Calendar Organization! Ticket Site! Ticket Organization
Conditions Tab
You use the Conditions tab to specify conditions under which Maximo applies an SLA to a ticket or work order.
Locations Tab
You use the Locations tab to associate or view organizations, sites, locations, and locations to which the service level agreement applies.
Assets Tab
You use the Assets tab to associate or view assets to which the service level agreement applies.
Service Level Agreements (SP) Actions
The Service Level Agreements (SP) application has the following action:
! Associate Customer
Associate Customer Action You use the Associate Customer action to associate customers with a service level agreement.
For details about this action, refer to the Service Level Agreements (SP) help.
Service Level Agreements (SP) Application
6-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
ss (SP) Application
Service Address (SP) Application
You use the Service Address (SP) application to create, view, modify, and delete service addresses for customers. A service address can represent one or more physical locations for a customer. It contains detailed location information that helps you to assign the correct resources when you provide service or support to a location.
Tabs
The Service Address (SP) application has the following tabs:
! List! Addresses
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Addresses Tab You use the Addresses tab to add, view, modify, or delete service addresses. A service address typically identifies an area where services are provided or where assets are located.
Service Address (SP) Actions
The Service Address (SP) application has the following actions:
! Duplicate Address! Delete Address
For details about these actions, refer to the Service Address (SP) help.
Duplicate Address Action
You use the Duplicate Address action to duplicate a service address.
Delete Address Action
You use the Delete Address action to delete a service address.
Service Addre
Service Management Module 6-3
Response Plans (SP) Application
You use the Response Plans (SP) application to create, view, modify, and delete response plans. A response plan that is applied to a ticket, work order, or sales order ensures predictable and repeatable responses to similar work requests.
Tabs
The Response Plans (SP) application has the following tabs:
! List! Response Plan! Conditions! Locations! Assets! Response Actions
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Response Plan Tab
You use the Response Plan tab to create, view, modify, or delete a response plan. When you create a response plan, you define the class of ticket or work order, or the sales order to which it applies.
Conditions Tab
You use the Conditions tab to specify conditions under which Maximo applies a response plan to a ticket, work order, or sales order. For Maximo to apply the response plan, conditions defined on the response plan must match conditions defined on a ticket, work order, or sales order.
Locations Tab
You use the Locations tab to add organizations, sites, locations, and locations within specified location hierarchies to a response plan. The response plan is applicable to records such as tickets, work orders, or sales orders that reference one of the organizations, sites, locations, or location hierarchies on the response plan.
Assets Tab
You use the Assets tab to add assets and asset types to a response plan. The assets can be within a specified asset hierarchy. When you add assets and asset types to a response plan, it makes the response plan applicable only to tickets, work orders, or sales orders with the same asset criteria.
Response Plans (SP) Application
6-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
ns (SP) Application
Response Actions Tab
You use the Response Actions tab to specify the actions to take and the notifications to make when the response plan is applied to a ticket, work order, or sales order. You can select existing actions or action groups, or create new ones in the Actions application.
Response Plans (SP) Actions
The Response Plans (SP) application has the following actions:
! Change Status! Associate Customer! Duplicate Response Plan! Delete Response Plan
For details about these actions, refer to the Response Plans (SP) help.
Change Status Action
You use the Change Status action to change the status of a response plan. You might need security authorization to perform this action.
Associate Customer Action
You use the Associate Customer action to associate customers with a response plan. Associate customers with a response plan if you want the response plan to apply only to tickets, work orders, or sales orders for these customers. You also use this action to view or remove customers associated with the response plan.
Duplicate Response Plan Action
You use the Duplicate Response Plan action to duplicate a draft or inactive response plan. You might need security authorization to perform this action.
Delete Response Plan Action
You use the Delete Response Plan action to delete a response plan. You might need security authorization to delete a response plan.
Response Pla
Service Management Module 6-5
Response Plans (SP) Application
6-6 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Work Orders module has two cloned applications. This chapter provides an overview of new and enhanced tabs and new actions in the cloned application.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Work Orders module contains the following industry-specific applications:
Service Requests (SP) Application
For information about the Service Requests (SP) application, see "Service Requests (SP) Application," on page 5-11.
Work Order Tracking (SP) Application
You use the Work Order Tracking (SP) application to plan, review, and approve work orders for assets and locations. When you create a work order, you initiate the maintenance process and create a record of performed work.
Work Orders Module 7
Application Service Provider Function
Service Requests (SP) Create, view, delete, and resolve service requests from customers or other users.
Work Order Tracking (SP) Specify customer charge account and cost center; fees and charges; and service address.
Apply customer agreement, price schedules, and response plan.
View and update price quotes; view costs and prices.
© Copyright IBM Corp. 2007 7-1
Work Order Tracking (SP) Application
Tabs
The Work Order Tracking (SP) application has the following new or enhanced tabs:
! Work Order! Plans! Actuals! Service Address (new)
For information about fields, place the cursor in the field and press Alt + F1.
Work Order Tab
The Work Order tab has the following industry-specific fields:
! Charge Account! Cost Center! Customer ! Response Plan
Plans Tab
The Plans tab has the following industry-specific subtab:
! Fees and Charges
The Plans tab has the following industry-specific field on each of its subtabs:
! Line Price
Actuals Tab
The Actuals tab has the following industry-specific subtab:
! Fees and Charges
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
Service Address Tab
You use the Service Address tab to view or add service address information and to view information about the associated customer, customer agreement, price schedule, and billing status.
7-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Work Order Tracking (SP) Application
Work Order Tracking (SP) Actions
The Work Order Tracking (SP) application has the following industry-specific actions:
! Apply Response Plan! Apply Customer Agreement! View/Update Price Quote! Select/Deselect Price Schedule! View Costs and Prices! View Billing Status History
For details about these actions, refer to the Work Order Tracking (SP) help.
Apply Customer Agreement Action
You use the Apply Customer Agreement action to apply a customer agreement to a work order. When you apply a customer agreement, you also apply the price schedule that matches certain criteria on the work order.
View/Update Price Quote Action
You use the View/Update Price Quote action to add, view or update a price quote. You can add or update a price quote on a work order if the associated price schedule allows price quotes and the work order is not included in a bill batch.
Select/Deselect Price Schedule Action
You you the Select/Deselect Price Schedule action to select a price schedule or deselect a price schedule on a ticket, work order, or sales order. You associate only one price schedule with a record, so you might deselect a price schedule so that you can select a more appropriate one.
Work Orders Module 7-3
Work Order Tracking (SP) Application
7-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
The Service Provider (SP) module has five new applications. This chapter provides an overview of the tabs and actions in the applications.
For more information on any application, refer to the application help. You also can refer to the IBM Maximo User�s Guide for more information on any standard Maximo application.
The Preventive Maintenance module contains the following industry-specific application:
Customer Agreements (SP) Application
You use the Customer Agreements (SP) application to create and maintain customer agreements between you and your customers. Customer agreements contain the following information:
! Services you agree to provide ! Assets, asset types, or locations for which you agree to provide services! Price schedules! Billing terms and billing periods! Performance incentives and penalties
Service Provider (SP) Module 8
Application Service Provider Function
Customer Agreements (SP) Create and maintain customer agreements.
Customers (SP) Create and maintain customer records.
Bill Review (SP) Review bills in a bill batch and resolve questions before the final bill is issued.
Customer Billing (SP) Create, modify, and view bill batches for your customers.
Sales Orders (SP) Bill for services that are not directly related to cost.
© Copyright IBM Corp. 2007 8-1
Tabs
The Customer Agreements (SP) application has the following tabs:
! List! Customer Agreement! Price Schedules! Terms and Conditions! Contacts ! Log
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Customer Agreement Tab
You use the Customer Agreement tab to create a customer agreement.
Price Schedules Tab
The Price Schedules tab has the following subtabs:
! Price Schedule ! Conditions ! Locations ! Assets! Pricing Rules
Price Schedule Subtab You use the Price Schedule subtab to create or view billing rules for a price schedule.
Conditions Subtab You use the Conditions subtab to add conditions to a price schedule. You specify structured, header-level conditions and free-form conditions.
Locations Subtab You use the Locations subtab to add sites, locations, and locations within specified location hierarchies to a price schedule. The price schedule is applicable to tickets, work orders, or sales orders that reference one of the sites, locations, or location hierarchies on the price schedule.
Assets Subtab You use the Assets subtab to add assets and asset types to a price schedule. The assets can be within a specified asset hierarchy. When you add assets and asset types to a price schedule makes the price schedule applicable only to tickets, work orders, or sales orders with the same asset criteria.
Pricing Rules Subtab You use the Pricing Rules subtab to specify pricing rules for a customer agreement price schedule. The pricing Rules subtab has five subtabs, as shown in the following table.
Subtab Pricing rules that you can specify
IT Asset ! Asset management! Asset usage! Asset performance
Customer Agreements (SP) Application
8-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
ts (SP) Application
Terms and Conditions Tab
You use the Terms and Conditions tab to add existing terms and conditions to a customer agreement from the library of terms and agreements.
Contacts Tab
You use the Contacts tab to view contact information for a customer on a customer agreement. You add and maintain contact information in the Customers (SP) application.
Log Tab
You use the Log tab to add, view, and modify log entries involving this customer agreement. You can use the log to record communications, reminders, or other data relating to the agreement.
Customer Agreements (SP) Actions
The Customer Agreements (SP) application has the following actions:
! Change Status! View Status History! Revise Agreement! View Revision History! Duplicate Agreement
For details about these actions, refer to the Customer Agreements (SP) help.
Change Status Action
You use the Change Status action to change the status of a customer agreement. Changing the status of an agreement changes the status of all price schedules on the agreement. You might need security authorization to change a status.
Labor ! No charge! Default markup percentage! Specific markup percentage ! Specific rates
Materials ! No charge! Default markup percentage! Markup percentage by commodity group or
commodity
Services ! No charge! Default markup percentage! Markup percentage by service group or service
Tools ! No charge! Default markup percentage! Markup percentage by commodity group or
commodity
Subtab Pricing rules that you can specify
Customer Agreemen
Service Provider (SP) Module 8-3
View Status History Action
You use the View Status History action to view the status history for a customer agreement. You might need security authorization to perform this action.
Revise Agreement Action
You use the Revise Agreement action to create a revision of a customer agreement. You can revise an approved or expired agreement. You also can change pricing rules by creating a revision and updating the pricing rules in the price schedule of the revision.
View Revision History Action
You use the View Revision History action to view revision history for a customer agreement. You might need security authorization to perform this action.
Duplicate Agreement Action
You use the Duplicate Agreement action to duplicate a customer agreement. You might need security authorization to perform this action.
Customer Agreements (SP) Application
8-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
rs (SP) Application
Customers (SP) Application
You use the Customers (SP) application to create, view, modify, and delete customer records.
Customer records contain the following information about your customers:
! Business and billing addresses! Billing details! Internal charge account and cost center! Internal contacts and vendor contacts! Associations with customer agreements and price schedules! Associations with service level agreements (SLAs) and response plans! Associations with parent or child customers
Tabs
The Customers (SP) application has the following tabs:
! List! Customer! Contacts! Log! Price Schedules! Associated Customers
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Customer Tab
You use the Customer tab to add, modify, and view customer records.
Contacts Tab
You use the Contacts tab to add, view, modify, or delete contact people.
Log Tab
You use the Log tab to add, view, and modify log entries involving this customer. You can use the log to record communications, reminders, or other data relating to the customer.
Price Schedules Tab
You use the Price Schedules tab to view agreements and price schedules associated with this customer.
Associated Customers Tab
You use the Associated Customers tab to view associated customers for the customer record. An associated customer typically is a child, or division or subsidiary, of the parent customer. Customers also create associated
Custome
Service Provider (SP) Module 8-5
customers when they have multiple billing addresses and want to create a record for each billing address.
Customers (SP) Actions
The Customers (SP) application has the following actions:
! Change Status! View History! Create Communication! Edit/Deselect Customer Log! Associate SLAs! Associate Response Plans! Copy to Business Address! Duplicate Customer! Delete Customer
For details about these actions, refer to the Customers (SP) help.
Change Status Action
You use the Change Status action to change the status of a customer record. You might need security authorization to change a status.
View History Action
You use the View History action to view the status history for a customer. You might need security authorization to perform this action.
Create Communication Action
You use the Create Communication action to send messages about a record via e-mail.
Edit/Delete Customer Log Action
A customer log documents information about communications with or notes about a customer. You use the Edit/Delete Customer Log action to modify or delete a log entry for a customer. You might need security authorization to perform this action.
Associate SLAs Action
You use the Associate SLAs action to associate an SLA (service level agreement) with a customer.
Associate Response Plans Action
You use the Associate Response Plans action to associate one or more response plans with a customer.
Copy to Business Address Action
You use the Copy to Business Address action to copy an address to the business address for this customer. You can copy either the business address
Customers (SP) Application
8-6 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
rs (SP) Application
of the parent or the billing address of this customer. After copying address elements, you can modify them.
Duplicate Customer Action
You use the Duplicate Customer action to duplicate a customer. You might need security authorization to duplicate a customer.
Delete Customer Action
You use the Delete Customer action to delete a customer record. You might need security authorization to delete a customer.
Custome
Service Provider (SP) Module 8-7
Bill Review (SP) Application
You use the Bill Review (SP) application to review bills in a bill batch and resolve questions before the final bill is issued.
After reviewing price details for a batch line, you approve or dispute the line prices by changing the status of the line. After you review all lines, change the status of the review bill to Reviewed. Approved lines on reviewed bills become part of the next bill statement. Disputed lines are sent to the service provider for further review. All unbilled transactions are carried forward for potential inclusion in the next bill batch.
Tabs
The Bill review (SP) application has the following tabs:
! List! Bill Review! Terms and Conditions
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Bill Review Tab
You use the Bill review tab to review and approve bill batches. You typically change a status from WAPPR (waiting for approval) status to APPR (approved). You also can change the status to DISPUTE (disputed).
Terns and Conditions Tab
You use the Terms and Conditions tab to view terms and conditions from associated customer agreements.
Bill Review (SP) Actions
The Bill review (SP) application has the following actions:
! Change Status! Advance all WAPPR Lines to APPR! View Costs
For details about these actions, refer to the Bill Review (SP) help.
Change Status Action
You use the Change Status action to change the status of the review bill batch from PREBILL to REVIEWED.
Bill Review (SP) Application
8-8 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
w (SP) Application
Advance all WAPPR Lines to APPR Action
After reviewing the lines in the bill batch, you can use the Advance all WAPPR Lines to APPR action to change all WAPPR (waiting for approval) lines to APPR (approved).
View Costs Action
You use the View Costs action to view costs for the transactions if you have security authorization to do so and if the customer agreement enables display of this information.
Bill Revie
Service Provider (SP) Module 8-9
Customer Billing (SP) Application
You use the Customer Billing (SP) application to create, modify, or view bill batches for your customers. For each billing period, create a bill batch for completed work for the customer and agreement. A bill batch includes all revisions of a customer agreement. The agreement price schedules, and their revisions, are applied to the completed work. Price quotes for work orders are considered when Maximo creates the bill batch.
Tabs
The Customer Billing (SP) application has the following tab:
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
! List! Billing Batch
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Billing Batch Tab You use the Billing Batch tab to review the batch lines and change the status of any line as needed.
Customer Billing (SP) Actions
The Customer Billing (SP) application has the following actions:
! Change Status! Advance all WAPPR Lines to APPR! View Bill Batch Status History! Line Status Summary
For details about these actions, refer to the Customer Billing (SP) help.
Change Status Action
You use the Change Status action to change the status of individual bill lines for a bill batch.
Advance all WAPPR Lines to APPR Action
You use the Advance all WAPPR Lines to APPR action to change the status of bill batch lines that have a status of WAPPR (waiting for approval) lines to APPROVED (approved by customer).
Customer Billing (SP) Application
8-10 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
g (SP) Application
View Bill Batch Status History Action
You use the View Bill Batch Status History action to view the status history of a bill batch.
To see billing status for a record, use the View the Billing Status History action on that record. The work order, ticket, or sales order that was billed displays bill status.
Line Status Summary Action
You use the Line Status Summary action to view the status of a line in a bill batch. Typically, you use the action to determine how many lines in the bill batch require review and action before you can change the status of the bill batch.
Customer Billin
Service Provider (SP) Module 8-11
Sales Orders (SP) Application
Sales Orders (SP) Application
You use the Sales Orders (SP) application to bill for services that are not directly related to cost. For example, you bill monthly management fees, trip charges, and several types of IT asset management fees with sales orders. You can bill for IT asset management by count, performance, and usage. If you contract for annual incentive payments, use sales orders to bill any incentive amounts.
You associate a customer with the sales order, then apply a customer agreement and price schedule to the sales order. The customer agreement specifies agreed-to services, terms and conditions. The price schedule can apply fixed fees and the pricing rules for services you provide or procure. You can specify additional fees and charges on the sales order. If you create a sales order to bill for IT asset maintenance, you specify certain information about the assets, apply the agreement and price schedule, and let Maximo calculate billing prices.
Tabs
The Sales Orders (SP) application has the following tabs:
! List! Sales Order! Service Address
The List tab is found throughout Maximo applications. For more information about this tab, refer to the IBM Maximo User�s Guide and the help.
For information about fields, place the cursor in the field and press Alt + F1.
Sales Order Tab
You use the Sales Order tab to:
! Create, view, or modify sales orders! Insert fees and charges.! View fees applied with an applied price schedule! View prices for each line on the sales order
Service Address Tab
You use the Service Address tab to:
! View or add service address information
! View information about the associated customer, customer agreement, price schedule, and billing status
8-12 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Sales Orders (SP) Application
Sales Orders (SP) Actions
The Sales Orders (SP) application has the following actions:
! Change Status! Select Owner! Take Ownership! Apply Response Plan! Apply Customer Agreement! Select/Deselect Price Schedule! View Billing Status History! View Sales Order History! Edit Sales Order History! Duplicate Sales Order! Delete Sales Order
For details about these actions, refer to the Sales Orders (SP) help.
Change Status Action
You use the Change Status action to change the status of a sales order. You might need security authorization to change a status.
Select Owner Action
You use the Select Owner action to assign administrative responsibility for a sales order.
Take Ownership Action
You use the Take Ownership action to take administrative responsibility for a sales order.
Apply Response Plan Action
You use the Apply Response Plan action to apply a response plan to an activity. When you apply a response plan, you ensure predictable and repeatable responses to similar sales orders.
Apply Customer Agreement Action
You use the Apply Customer Agreement action to apply a customer agreement to a sales order. When you apply a customer agreement, you also apply the price schedule that matches certain criteria on the sales order.
Select/Deselect Price Schedule Action
You use the Select/Deselect Price Schedule action to select a price schedule or deselect a price schedule on a ticket, work order, or sales order. You associate only one price schedule with a record, so you might deselect a price schedule so that you can select a more appropriate one.
View Billing Status History Action
You use the View Billing Status action to view billing status history for a ticket, work order, or sales order. The dialog box displays billing status history for all billing lines that reference this ticket, work order, or sales order.
Service Provider (SP) Module 8-13
Sales Orders (SP) Application
View Sales Order History Action
You use the View Sales Order History action to view the status and ownership history of a sales order.
Edit Sales Order History Action
After a sales order is closed, Maximo archives the sales order and it becomes a history record. You use the Edit Sales Order History action to modify an archived sales order.
Duplicate Sales Order Action
You use the Duplicate Sales Order action to duplicate a sales order.
Delete Sales Order Action
You use the Delete Sales Order action to delete a sales order. You cannot delete a sales order that has been extracted to a bill batch.
8-14 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
This chapter lists new industry-specific database tables and their columns. It also lists new columns added to existing Maximo database tables.
CLASSSTRUCTURE Table
ESCALATION Table
INCIDENT Table
Service Provider Database Tables and Columns 9
Column Persistent? Required? Maxtype Length
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPUSEWITHSO 1 1 YORN 1
Column Persistent? Required? Maxtype Length
PLUSPONDEMAND 1 1 YORN 1
PLUSPSOURCEAPP 1 1 UPPER 10
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 12
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
© Copyright IBM Corp. 2007 9-1
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
Column Persistent? Required? Maxtype Length
9-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
LABTRANS Table
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBILLPRICE 1 0 AMOUNT 10
PLUSPCURRBILLPR 1 0 AMOUNT 10
PLUSPCURRLINEPR 1 0 AMOUNT 10
PLUSPCUSTCURCODE 1 0 UPPER 8
PLUSPCUSTCURDATE 1 0 DATE 4
PLUSPCUSTEXRATE 1 0 DECIMAL 14
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPGEOCODE 1 0 ALN 11
PLUSPLINEPRICE 1 0 AMOUNT 10
PLUSPPRICEADJ 1 1 YORN 1
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPREVGLACCT 1 0 GL 23
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSALESTAX 1 0 AMOUNT 10
PLUSPTAX1AMT 1 0 AMOUNT 10
PLUSPTAX1JURIS 1 0 ALN 11
PLUSPTAX2AMT 1 0 AMOUNT 10
PLUSPTAX2JURIS 1 0 ALN 11
PLUSPTAX3AMT 1 0 AMOUNT 10
PLUSPTAX3JURIS 1 0 ALN 11
PLUSPTAX4AMT 1 0 AMOUNT 10
PLUSPTAX4JURIS 1 0 ALN 11
Service Provider Database Tables and Columns 9-3
LOCATIONS Table
LOCSYSTEM Table
MATUSETRANS Table
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPADDFROMLOC 0 0 UPPER 12
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCUSTCHACCT 1 0 UPPER 20
Column Persistent? Required? Maxtype Length
PLUSPADDRESSSYSTEM 1 1 YORN 1
Column Persistent? Required? Maxtype Length
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBILLPRICE 1 0 AMOUNT 10
PLUSPCURRBILLPR 1 0 AMOUNT 10
PLUSPCURRLINEPR 1 0 AMOUNT 10
PLUSPCUSTCURCODE 1 0 UPPER 8
PLUSPCUSTCURDATE 1 0 DATE 4
PLUSPCUSTEXRATE 1 0 DECIMAL 14
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPGEOCODE 1 0 ALN 11
PLUSPLINEPRICE 1 0 AMOUNT 10
PLUSPPRICEADJ 1 1 YORN 1
PLUSPPRICESCHED 1 0 UPPER 10
9-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
MAXVARINPUT Table
PERSON Table
PLUSPREVGLACCT 1 0 GL 23
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSALESTAX 1 0 AMOUNT 10
PLUSPTAX1AMT 1 0 AMOUNT 10
PLUSPTAX1JURIS 1 0 ALN 11
PLUSPTAX2AMT 1 0 AMOUNT 10
PLUSPTAX2JURIS 1 0 ALN 11
PLUSPTAX3AMT 1 0 AMOUNT 10
PLUSPTAX3JURIS 1 0 ALN 11
PLUSPTAX4AMT 1 0 AMOUNT 10
PLUSPTAX4JURIS 1 0 ALN 11
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPBILLSTATINC 0 0 UPPER 10
PLUSPBILLSTATPROB 0 0 UPPER 10
PLUSPBILLSTATSO 0 0 UPPER 8
PLUSPBILLSTATSR 0 0 UPPER 10
PLUSPBILLSTATWO 0 0 UPPER 16
PLUSPSTREETADDRDET 0 1 ALN 254
Column Persistent? Required? Maxtype Length
PLUSPCUSTOMER 1 0 ALN 12
PLUSPCUSTVENDOR 1 0 UPPER 12
PLUSPCUSTVNDNAME 0 0 ALN 50
PLUSPCUSTVNDTYPE 1 1 UPPER 8
Service Provider Database Tables and Columns 9-5
PLUSPAGMTSTATUS Table
PLUSPAGREEMENT Table
Column Persistent? Required? Maxtype Length
AGREEMENT 1 0 UPPER 12
MEMO 1 0 ALN 100
ORGID 1 0 UPPER 8
PLUSPAGMTSTATUSID 1 1 INTEGER 12
REVISIONNUM 1 0 INTEGER 12
STATUS 1 1 UPPER 12
STATUSDATE 1 0 DATETIME 10
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
AGREEMENTMAXIMUM 1 0 AMOUNT 10
AGREEMENTTYPE 1 0 ALN 25
BILLCYCLE 1 0 ALN 12
BILLENDDAY 1 0 INTEGER 12
CHANGEDBY 1 0 UPPER 30
CHANGEDDATE 1 0 DATETIME 10
CUSTOMER 1 0 UPPER 12
CUSTOMERPOREF 1 0 ALN 25
DESCRIPTION 1 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
ENDBILLCYCLE 1 1 YORN 1
ENDDATE 1 0 DATE 4
HASLD 1 1 YORN 1
HISTORYFLAG 1 1 YORN 1
LANGCODE 1 0 UPPER 4
LASTBILLDATE 1 0 DATE 4
ORGID 1 1 UPPER 8
PAYMENTTERMS 1 0 ALN 25
PLUSPAGREEMENTID 1 1 INTEGER 12
9-6 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPAGREESTATUS Table
PLUSPAGREETERMS Table
PRETAXTOTAL 1 0 AMOUNT 10
RENEWALDATE 1 0 DATE 4
REVISIONCOMMENTS 1 0 ALN 50
REVISIONCOMMENTS_LONGDESCRIPTION 0 0 LONGALN 32000
REVISIONNUM 1 1 INTEGER 12
REVPRETAXTOTAL 1 0 AMOUNT 10
SHOWCOST 1 1 YORN 1
STARTDATE 1 0 DATE 4
STATUS 1 1 UPPER 12
STATUSDATE 1 0 DATETIME 10
TOTALBASEBILLED 1 0 AMOUNT 10
TOTALBILLED 1 0 AMOUNT 10
TOTALTAX 1 0 AMOUNT 10
VENDTERMALLOWED 1 1 YORN 1
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEMENT 0 0 ALN 12
AGREESTATUS 0 0 UPPER 15
ASOFDATE 0 0 DATE 4
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
MEMO 0 0 ALN 200
PLUSPAGREEMENTID 0 1 INTEGER 12
STATUS 0 1 ALN 12
Column Persistent? Required? Maxtype Length
AGREEMENT 1 0 UPPER 12
AGREEMENTID 1 0 INTEGER 12
DESCRIPTION 1 0 ALN 50
Service Provider Database Tables and Columns 9-7
PLUSPAPPLASSET Table
PLUSPAPPLCOND Table
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
LANGCODE 1 0 UPPER 4
ORGID 1 0 UPPER 8
PLUSPAGREETERMSID 1 1 INTEGER 12
REVISIONNUM 1 0 INTEGER 12
SENDTOCUSTOMER 1 1 YORN 1
SEQNUM 1 1 INTEGER 12
TERMID 1 0 UPPER 25
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
ASSETNUM 1 0 UPPER 12
ASSETTYPE 1 0 UPPER 15
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
INCLUDECHILDREN 1 1 YORN 1
ORGID 1 0 UPPER 8
OWNERID 1 1 UPPER 18
OWNERTABLE 1 1 UPPER 18
PLUSPAPPLASSETID 1 1 INTEGER 12
SITEID 1 0 UPPER 8
Column Persistent? Required? Maxtype Length
DESCRIPTIVENAME 1 1 ALN 24
EVALUATION 1 1 ALN 14
GROUPANDOR 1 0 ALN 10
GROUPNUM 1 1 INTEGER 12
HASLD 1 1 YORN 1
9-8 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPAPPLFLD Table
PLUSPAPPLLOC Table
INGROUPANDOR 1 0 ALN 10
LINENUM 1 1 INTEGER 12
OWNERID 1 1 UPPER 18
OWNERTABLE 1 1 UPPER 18
PLUSPAPPLCONDID 1 1 INTEGER 12
SUBGROUPNUM 1 1 YORN 1
VALUE 1 0 ALN 25
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
CHILD_1 1 0 UPPER 50
CHILD_2 1 0 UPPER 50
CHILD_3 1 0 UPPER 50
DESCRIPTIVENAME 1 1 ALN 24
HASLD 1 1 YORN 1
OBJECT 1 0 UPPER 18
PARENT_1 1 0 UPPER 18
PARENT_2 1 0 UPPER 18
PARENT_3 1 0 UPPER 18
PLUSPAPPLFLDID 1 1 INTEGER 12
RELATIONSHIP_1 1 0 UPPER 50
RELATIONSHIP_2 1 0 UPPER 50
RELATIONSHIP_3 1 0 UPPER 50
TARGETCOLUMN_1 1 0 UPPER 50
TARGETCOLUMN_2 1 0 UPPER 50
TARGETCOLUMN_3 1 0 UPPER 50
Column Persistent? Required? Maxtype Length
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
Service Provider Database Tables and Columns 9-9
PLUSPAPPLSERV Table
PLUSPBATCHSTATUS Table
HASLD 1 1 YORN 1
INCLUDECHILDREN 1 1 YORN 1
LOCATION 1 0 UPPER 12
ORGID 1 1 UPPER 8
OWNERID 1 1 UPPER 18
OWNERTABLE 1 1 UPPER 18
PLUSPAPPLLOCID 1 1 INTEGER 12
SITEID 1 0 UPPER 8
SYSTEMID 1 0 UPPER 8
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
COMMODITY 1 0 UPPER 8
COMMODITYGROUP 1 1 UPPER 8
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
OWNERID 1 1 UPPER 18
OWNERTABLE 1 1 UPPER 18
PLUSPAPPLSERVID 1 1 INTEGER 12
Column Persistent? Required? Maxtype Length
ASOFDATE 0 0 DATETIME 10
BILLBATCHNUM 0 0 UPPER 12
CURSTATUS 0 0 UPPER 12
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
MEMO 0 0 ALN 200
ORGID 0 1 UPPER 8
PLUSPBILLBATCHID 0 1 INTEGER 12
9-10 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPBATCHSTHIST Table
PLUSPBILLBATCH Table
STATUS 0 1 UPPER 16
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
BILLBATCHNUM 1 1 UPPER 12
CHANGEBY 1 1 UPPER 30
CHANGEDATE 1 1 DATETIME 10
MEMO 1 0 ALN 200
ORGID 1 1 UPPER 8
PLUSPBATCHSTHISTID 1 1 INTEGER 12
STATUS 1 1 UPPER 12
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
BATCHTOTAL 1 1 AMOUNT 10
BILLBATCHNUM 1 1 UPPER 12
BILLDATE 1 0 DATE 4
BILLENDDATE 1 0 DATE 4
BILLTOADDRESSLINE2 1 0 ALN 36
BILLTOADDRESSLINE3 1 0 ALN 36
BILLTOCITY 1 0 UPPER 36
BILLTOCOUNTRY 1 0 UPPER 3
BILLTOCOUNTY 1 0 ALN 36
BILLTOPOSTALCODE 1 0 ALN 12
BILLTOREGION 1 0 ALN 36
BILLTOSTATEPROV 1 0 UPPER 3
BILLTOSTREETADDR 1 0 ALN 56
CHANGEDBY 1 1 UPPER 30
CHANGEDDATE 1 0 DATETIME 10
CUSTOMER 1 1 UPPER 12
Service Provider Database Tables and Columns 9-11
PLUSPBILLLINE Table
DESCRIPTION 1 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
LANGCODE 1 1 UPPER 4
LASTBILLDATE 1 0 DATE 4
ORGID 1 1 UPPER 8
PAYMENTTERMS 1 0 ALN 25
PLUSPBILLBATCHID 1 1 INTEGER 12
PRETAXTOTAL 1 0 AMOUNT 10
REQREVIEWDATE 1 0 DATE 4
REVIEWEDBY 1 0 UPPER 30
REVIEWEDDATE 1 0 DATETIME 10
REVISIONNUM 0 0 INTEGER 12
STATUS 1 1 UPPER 12
STATUSDATE 1 1 DATETIME 10
TOTALTAX 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEDPRICE 1 1 AMOUNT 10
BILLBATCHNUM 1 1 UPPER 12
BILLEDPRICE 1 1 AMOUNT 10
CHANGEDBY 1 1 UPPER 30
CHANGEDDATE 1 1 DATETIME 10
CLASS 0 0 UPPER 16
CUSTCHANGEDBY 1 0 UPPER 30
CUSTCHANGEDDATE 1 0 DATETIME 10
CUSTCHARGEACCT 1 0 UPPER 20
CUSTCOSTCENTER 1 0 UPPER 16
CUSTREMARKS 1 0 ALN 50
DATECOMPLETED 0 0 DATETIME 10
DESCRIPTION 0 0 ALN 100
9-12 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPBILLPRICE Table
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
LANGCODE 1 1 UPPER 4
LINENUM 1 1 INTEGER 12
ORDER 0 0 UPPER 10
ORGID 1 1 UPPER 8
PLUSPBILLLINEID 1 1 INTEGER 12
PRICESCHED 1 1 UPPER 10
QUOTEDPRICE 1 0 AMOUNT 10
QUOTETYPE 1 0 UPPER 8
REFWO 1 0 UPPER 10
REMARKS 1 0 ALN 50
REMARKS_LONGDESCRIPTION 0 0 LONGALN 32000
REVNUM 1 1 INTEGER 12
SALESORDERNUM 1 0 UPPER 10
SITEID 1 0 UPPER 8
STATUS 1 1 UPPER 12
STATUSDATE 1 1 DATETIME 10
TICKETCLASS 1 0 UPPER 16
TICKETID 1 0 UPPER 10
TOTALCOST 1 1 AMOUNT 10
TOTALTRANSTAX 1 0 AMOUNT 10
WOCLASS 1 0 UPPER 16
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
BILLPRICE 0 0 AMOUNT 10
LINECOST 0 0 AMOUNT 10
TRANSACTION 0 0 ALN 20
Service Provider Database Tables and Columns 9-13
PLUSPCUSTCONTACT Table
PLUSPCUSTLOC Table
PLUSPCUSTOMER Table
Column Persistent? Required? Maxtype Length
CUSTOMER 1 1 UPPER 12
PERSONID 1 1 UPPER 30
PLUSPCUSTCONTACTID 1 1 INTEGER 12
TYPE 1 1 ALN 8
Column Persistent? Required? Maxtype Length
CUSTOMER 1 1 UPPER 12
LOCATION 1 1 UPPER 12
ORGID 1 1 UPPER 8
PLUSPCUSTLOCID 1 1 INTEGER 12
RESPONSIBLE 1 1 YORN 1
SITEID 1 1 UPPER 8
TYPE 1 0 UPPER 8
Column Persistent? Required? Maxtype Length
ADDRESSLINE2 1 0 ALN 50
ADDRESSLINE3 1 0 ALN 50
BILLTOADDRESSLINE2 1 0 ALN 50
BILLTOADDRESSLINE3 1 0 ALN 50
BILLTOCITY 1 0 ALN 36
BILLTOCOUNTRY 1 0 UPPER 3
BILLTOCOUNTY 1 0 ALN 36
BILLTOPOSTALCODE 1 0 ALN 12
BILLTOREGION 1 0 ALN 36
BILLTOSTATEPROV 1 0 UPPER 3
BILLTOSTREETADD 1 0 ALN 50
CAGE 1 0 ALN 5
9-14 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
CHANGEBY 1 0 UPPER 30
CHANGEDATE 1 0 DATETIME 10
CITY 1 0 ALN 36
COMPANYFAX 1 0 ALN 20
COMPANYPHONE 1 0 ALN 20
COPYBILLINGADDRESS 0 1 YORN 1
COPYPARENTSBUSADDR 0 1 YORN 1
COUNTRY 1 0 UPPER 3
COUNTY 1 0 ALN 36
CREDITRATING 1 0 ALN 10
CURRENCYCODE 1 0 UPPER 8
CUSTOMER 1 1 UPPER 12
CUSTOMERSINCE 1 0 DATE 4
DUNS 1 0 ALN 9
ELECTRONICBILL 1 1 YORN 1
HASLD 1 1 YORN 1
INSURANCEENDDATE 1 0 DATE 4
INSURANCEREF 1 0 ALN 24
KNOWNTOCUSTAS 1 0 ALN 12
LANGCODE 1 0 UPPER 4
LANGUAGECODE 1 0 UPPER 4
LASTBILLDATE 1 0 DATE 4
NAICS 1 0 ALN 6
NAME 1 0 ALN 50
NAME_LONGDESCRIPTION 0 0 LONGALN 32000
NCAGE 1 0 ALN 5
PARENT 1 0 UPPER 12
PLUSPCUSTOMERID 1 1 INTEGER 12
POSTALCODE 1 0 ALN 12
REGION 1 0 ALN 36
STATEPROV 1 0 UPPER 3
STATUS 1 1 UPPER 8
STATUSDATE 1 0 DATETIME 10
Column Persistent? Required? Maxtype Length
Service Provider Database Tables and Columns 9-15
PLUSPCUSTOMERLOG Table
PLUSPCUSTRP
STOCKSYMBOL 1 0 UPPER 10
STREETADDRESS 1 0 ALN 50
TAXEXEMPTCODE 1 0 ALN 1
TAXEXEMPTNUM 1 0 ALN 16
TAXPAYERID 1 0 ALN 14
TYPE 1 0 UPPER 8
URL 1 0 ALN 50
Column Persistent? Required? Maxtype Length
CONTACT 1 0 UPPER 30
CREATEBY 1 1 UPPER 30
CREATEDATE 1 1 DATETIME 10
CUSTOMER 1 1 UPPER 12
DESCRIPTION 1 1 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
LANGCODE 1 0 UPPER 4
MODIFYBY 1 1 UPPER 30
MODIFYDATE 1 1 DATETIME 10
PLUSPCUSTOMERLOGID 1 1 INTEGER 12
RECORDKEY 1 1 UPPER 12
RECORDTYPE 1 1 ALN 18
TYPE 1 1 ALN 8
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
CUSTOMER 1 1 UPPER 12
PLUSPCUSTRPID 1 1 INTEGER 12
RESPONSEPLAN 1 1 UPPER 10
9-16 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPCUSTSLA Table
PLUSPCUSTSTATUS Table
PLUSPCUSTSTATUSV Table
PLUSPGBTRANS Table
Column Persistent? Required? Maxtype Length
CUSTOMER 1 1 UPPER 12
PLUSPCUSTSLAID 1 1 INTEGER 12
SLANUM 1 1 UPPER 10
Column Persistent? Required? Maxtype Length
ASOFDATE 0 0 DATETIME 10
CHANGEBY 1 1 UPPER 30
CHANGEDATE 1 1 DATETIME 10
CUSTOMER 1 1 UPPER 12
MEMO 1 0 ALN 50
PLUSPCUSTSTATUSID 1 1 INTEGER 12
STATUS 1 1 UPPER 8
Column Persistent? Required? Maxtype Length
ASOFDATE 0 0 DATETIME 10
CHANGEBY 0 1 UPPER 30
CHANGEDATE 0 1 DATETIME 10
CUSTOMER 0 1 UPPER 12
MEMO 0 0 ALN 50
STATUS 0 1 UPPER 8
Column Persistent? Required? Maxtype Length
ADDEDBYPRSCHED 1 1 YORN 1
AGREEMENT 1 0 UPPER 12
BILLPRICE 1 0 AMOUNT 10
Service Provider Database Tables and Columns 9-17
CALCULATION 1 1 UPPER 12
CLASSCOUNT 1 0 DECIMAL 12
CLASSCOUNTTOT 1 0 DECIMAL 12
CLASSSTRUCTUREID 1 0 UPPER 20
CURRBILLPR 1 0 AMOUNT 10
CURRLINEPR 1 0 AMOUNT 10
CUSTCURCODE 1 0 UPPER 8
CUSTCURDATE 1 0 DATE 4
CUSTEXRATE 1 0 DECIMAL 14
CUSTOMER 1 0 UPPER 12
CUSTPONUM 1 0 ALN 25
DESCRIPTION 1 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
ENTEREDASTASK 1 1 YORN 1
EXTERNALREFID 1 0 ALN 10
FINANCIALPERIOD 1 0 ALN 6
FINCNTRLID 1 0 UPPER 8
GEOCODE 1 0 ALN 11
HASLD 1 1 YORN 1
HIERARCHYPATH 0 0 ALN 254
KPIMEASUREMENT 1 0 DECIMAL 10
KPINAME 1 0 UPPER 15
LANGCODE 1 1 UPPER 4
LINEPRICE 1 0 AMOUNT 10
METERNAME 1 0 UPPER 10
METERREADING 1 0 DECIMAL 15
METERREADINGTOT 1 0 DECIMAL 15
ORGID 1 0 UPPER 8
ORIGQUOTEBY 1 0 UPPER 30
ORIGQUOTEDATE 1 0 DATETIME 10
ORIGQUOTEDPRICE 1 0 AMOUNT 10
ORIGQUOTETYPE 1 0 UPPER 8
OWNERSYSID 1 0 ALN 10
Column Persistent? Required? Maxtype Length
9-18 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PARENTGBTRANSID 1 0 INTEGER 12
PLUSPGBTRANSID 1 1 INTEGER 12
PRICEADJ 1 1 YORN 1
PRICESCHED 1 0 UPPER 10
QUOTEDPRICE 1 0 AMOUNT 10
QUOTETYPE 1 0 UPPER 8
REVENUEGLACCT 1 0 GL 23
REVNUM 1 0 INTEGER 12
SALESORDERNUM 1 0 UPPER 10
SALESTAX 1 0 AMOUNT 10
SENDERSYSID 1 0 ALN 50
SITEID 1 0 UPPER 8
SOURCESYSID 1 0 ALN 10
TASKID 0 0 INTEGER 12
TAX1AMT 1 0 AMOUNT 10
TAX1JURIS 1 0 ALN 11
TAX2AMT 1 0 AMOUNT 10
TAX2JURIS 1 0 ALN 11
TAX3AMT 1 0 AMOUNT 10
TAX3JURIS 1 0 ALN 11
TAX4AMT 1 0 AMOUNT 10
TAX4JURIS 1 0 ALN 11
TAX5AMT 1 0 AMOUNT 10
TAX5JURIS 1 0 ALN 11
TAX6AMT 1 0 AMOUNT 10
TAX6JURIS 1 0 ALN 11
TICKETCLASS 1 0 UPPER 16
TICKETID 1 0 UPPER 10
TRANSDATE 1 0 DATETIME 10
TYPE 1 1 UPPER 10
UPDATEDATE 1 0 DATETIME 10
UPDATEDBY 1 0 UPPER 30
WONUM 1 0 UPPER 10
Column Persistent? Required? Maxtype Length
Service Provider Database Tables and Columns 9-19
PLUSPLINESTATUS Table
PLUSPLINESTHIST Table
PLUSPLINESUMMARY Table
Column Persistent? Required? Maxtype Length
ASOFDATE 0 0 DATETIME 10
BILLBATCHNUM 0 0 UPPER 12
CURSTATUS 0 0 UPPER 12
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
LINENUM 0 0 INTEGER 12
MEMO 0 0 ALN 200
ORGID 0 1 UPPER 8
STATUS 0 1 UPPER 16
Column Persistent? Required? Maxtype Length
BATCHSTATUS 1 1 UPPER 12
BILLBATCHNUM 1 1 UPPER 12
CHANGEBY 1 1 UPPER 30
CHANGEDATE 1 1 DATETIME 10
LINENUM 1 1 INTEGER 12
MEMO 1 0 ALN 200
ORGID 1 1 UPPER 8
PLUSPLINESTHISTID 1 1 INTEGER 12
STATUS 1 1 UPPER 12
Column Persistent? Required? Maxtype Length
ITEMCOUNT 0 0 INTEGER 12
LINESTATUS 0 0 UPPER 12
TOTALBILLPRICE 0 0 AMOUNT 10
9-20 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPPREBILLB Table
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
BATCHTOTAL 1 1 AMOUNT 10
BILLBATCHNUM 1 1 UPPER 12
BILLDATE 1 0 DATE 4
BILLENDDATE 1 0 DATE 4
BILLTOADDRESSLINE2 1 0 ALN 36
BILLTOADDRESSLINE3 1 0 ALN 36
BILLTOCITY 1 0 UPPER 36
BILLTOCOUNTRY 1 0 UPPER 3
BILLTOCOUNTY 1 0 ALN 36
BILLTOPOSTALCODE 1 0 ALN 12
BILLTOREGION 1 0 ALN 36
BILLTOSTATEPROV 1 0 UPPER 3
BILLTOSTREETADDR 1 0 ALN 56
CHANGEDBY 1 1 UPPER 30
CHANGEDDATE 1 0 DATETIME 10
CUSTOMER 1 1 UPPER 12
DESCRIPTION 1 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
LANGCODE 1 1 UPPER 4
LASTBILLDATE 1 0 DATE 4
ORGID 1 1 UPPER 8
PAYMENTTERMS 1 0 ALN 25
PLUSPBILLBATCHID 1 1 INTEGER 12
PRETAXTOTAL 1 0 AMOUNT 10
REQREVIEWDATE 1 0 DATE 4
REVIEWEDBY 1 0 UPPER 30
REVIEWEDDATE 1 0 DATETIME 10
REVISIONNUM 0 0 INTEGER 12
STATUS 1 1 UPPER 12
Service Provider Database Tables and Columns 9-21
PLUSPPREBILLO Table
STATUSDATE 1 1 DATETIME 10
TOTALTAX 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEDPRICE 1 1 AMOUNT 10
BILLBATCHNUM 1 1 UPPER 12
BILLEDPRICE 1 1 AMOUNT 10
CHANGEDBY 1 1 UPPER 30
CHANGEDDATE 1 1 DATETIME 10
CLASS 0 0 UPPER 16
CUSTCHANGEDBY 1 0 UPPER 30
CUSTCHANGEDDATE 1 0 DATETIME 10
CUSTCHARGEACCT 1 0 UPPER 20
CUSTCOSTCENTER 1 0 UPPER 16
CUSTREMARKS 1 0 ALN 50
DATECOMPLETED 0 0 DATETIME 10
DESCRIPTION 0 0 ALN 100
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
HASLD 1 1 YORN 1
LANGCODE 1 1 UPPER 4
LINENUM 1 1 INTEGER 12
ORDER 0 0 UPPER 10
ORGID 1 1 UPPER 8
PLUSPBILLLINEID 1 1 INTEGER 12
PRICESCHED 1 1 UPPER 10
QUOTEDPRICE 1 0 AMOUNT 10
QUOTETYPE 1 0 UPPER 8
REFWO 1 0 UPPER 10
REMARKS 1 0 ALN 50
REMARKS_LONGDESCRIPTION 0 0 LONGALN 32000
REVNUM 1 1 INTEGER 12
9-22 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPPRICES Table
SALESORDERNUM 1 0 UPPER 10
SITEID 1 0 UPPER 8
STATUS 1 1 UPPER 12
STATUSDATE 1 1 DATETIME 10
TICKETCLASS 1 0 UPPER 16
TICKETID 1 0 UPPER 10
TOTALCOST 1 1 AMOUNT 10
TOTALTRANSTAX 1 0 AMOUNT 10
WOCLASS 1 0 UPPER 16
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
ALLOWPRICEQUOTE 1 1 YORN 1
CUSTOMER 1 0 UPPER 12
FIXEDAMOUNT 1 0 AMOUNT 10
LASTBILLDATE 1 0 DATE 4
MUEXTERNALLABOR 1 1 DECIMAL 5
MUINTERNALLABOR 1 1 DECIMAL 5
MUMATERIALS 1 1 DECIMAL 5
MUMATERIALSNS 1 1 DECIMAL 5
MUSERVICES 1 1 DECIMAL 5
MUTOOLS 1 1 DECIMAL 5
NOCHARGELABOR 1 1 YORN 1
NOCHARGEMATERIAL 1 1 YORN 1
NOCHARGESERVICE 1 1 YORN 1
NOCHARGETOOL 1 1 YORN 1
ORGID 1 1 UPPER 8
PLUSPPRICESID 1 1 INTEGER 12
POREQUIRED 1 1 YORN 1
PRETAXTOTAL 1 0 AMOUNT 10
PRICEMAXIMUM 1 0 AMOUNT 10
Service Provider Database Tables and Columns 9-23
PLUSPPRICESCHED Table
PRICESCHEDULE 1 1 UPPER 10
REVISIONNUM 1 1 INTEGER 12
SANUM_PS 1 0 UPPER 10
TOTALBASEBILLED 1 0 AMOUNT 10
TOTALBILLED 1 0 AMOUNT 10
TOTALTAX 1 0 AMOUNT 10
TRANSTYPE 1 0 UPPER 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
ACTIVE 1 1 YORN 1
ADMINISTRATOR 1 0 UPPER 30
AGREEMENT 1 1 UPPER 12
ALLOWPRICEQUOTE 1 1 YORN 1
APPLYJOBPLAN 0 0 UPPER 10
APPLYJOBPLANID 1 0 INTEGER 12
APPLYTKTEMPLATE 1 0 UPPER 10
ASSIGNOWNER 1 0 UPPER 30
ASSIGNOWNERGROUP 1 0 UPPER 8
ASSIGNVENDOR 1 0 UPPER 12
CALCCALENDAR 1 0 UPPER 8
CALCORGID 1 0 UPPER 8
CALCSHIFT 1 0 UPPER 8
CALENDAR 1 0 UPPER 8
CALENDARORGID 1 0 UPPER 8
CHANGEBY 1 0 UPPER 30
CHANGEDATE 1 0 DATETIME 10
CLASSSTRUCTUREID 1 0 UPPER 20
CONDITION 1 0 ALN 2000
CREATEBY 1 0 UPPER 30
CREATEDATE 1 0 DATETIME 10
CUSTOMER 1 0 UPPER 12
9-24 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
CUSTVENDORCONTACT 1 0 UPPER 30
DESCRIPTION 1 0 ALN 254
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
ENDDATE 1 0 DATE 4
ESCALATION 1 0 UPPER 10
EXPOBJECT 0 0 UPPER 18
FIXEDAMOUNT 1 0 AMOUNT 10
HASLD 1 1 YORN 1
INTPRIORITYEVAL 1 0 ALN 14
INTPRIORITYVALUE 1 0 INTEGER 12
LANGCODE 1 1 UPPER 4
LASTBILLDATE 1 0 DATE 4
MUEXTERNALLABOR 1 1 DECIMAL 5
MUINTERNALLABOR 1 1 DECIMAL 5
MUMATERIALS 1 1 DECIMAL 5
MUMATERIALSNS 1 1 DECIMAL 5
MUSERVICES 1 1 DECIMAL 5
MUTOOLS 1 1 DECIMAL 5
NOCHARGELABOR 1 1 YORN 1
NOCHARGEMATERIAL 1 1 YORN 1
NOCHARGESERVICE 1 1 YORN 1
NOCHARGETOOL 1 1 YORN 1
OBJECTNAME 1 1 UPPER 18
ORGID 1 1 UPPER 8
PLUSPPRICESID 1 1 INTEGER 12
PLUSPSERVAGREEID 1 1 INTEGER 12
POREQUIRED 1 1 YORN 1
PRETAXTOTAL 1 0 AMOUNT 10
PRICEMAXIMUM 1 0 AMOUNT 10
PRICESCHEDULE 1 1 UPPER 10
RANKING 1 1 INTEGER 12
REFPOINTID 1 0 INTEGER 12
REVIEWDATE 1 0 DATE 4
Column Persistent? Required? Maxtype Length
Service Provider Database Tables and Columns 9-25
PLUSPPRICESCHEDUMMY Table
PLUSPPSASSETMGT Table
REVISIONNUM 1 1 INTEGER 12
SANUM 1 1 UPPER 10
SANUM_PS 1 0 UPPER 10
SERVICETYPE 1 1 UPPER 10
SHIFT 1 0 UPPER 8
SLANUM 1 0 UPPER 8
SLATYPE 1 0 ALN 10
STARTDATE 1 0 DATE 4
STATUS 1 0 UPPER 12
STATUSDATE 1 0 DATETIME 10
TICKETORGID 1 0 UPPER 8
TICKETSITEID 1 0 UPPER 8
TOTALBASEBILLED 1 0 AMOUNT 10
TOTALBILLED 1 0 AMOUNT 10
TOTALTAX 1 0 AMOUNT 10
TRANSTYPE 1 0 UPPER 10
VENDOR 1 0 UPPER 12
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
MEMO 0 0 ALN 200
SANUM 0 0 ALN 12
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
CLASSSTRUCTUREID 1 1 UPPER 20
FIXEDPRICE 1 0 AMOUNT 10
ORGID 1 1 UPPER 8
PLUSPPSASSETMGTID 1 1 INTEGER 12
PRICESCHEDULE 1 1 UPPER 10
9-26 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPPSASSETPERF Table
PLUSPPSASSETUSE Table
RANGEFROM 1 0 DECIMAL 12
RANGETO 1 0 DECIMAL 12
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
TRANSTYPE 1 0 UPPER 10
UNITPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
ALERTPRICE 1 0 AMOUNT 10
CAUTIONPRICE 1 0 AMOUNT 10
KPINAME 1 1 UPPER 15
ORGID 1 1 UPPER 8
PLUSPPSASSETPERFID 1 1 INTEGER 12
PRICESCHEDULE 1 1 UPPER 10
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
TARGETPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
FIXEDPRICE 1 0 AMOUNT 10
METERNAME 1 1 UPPER 10
ORGID 1 1 UPPER 8
PLUSPPSASSETUSEID 1 1 INTEGER 12
PRICESCHEDULE 1 1 UPPER 10
RANGEFROM 1 0 DECIMAL 12
RANGETO 1 0 DECIMAL 12
REVISIONNUM 1 1 INTEGER 12
Service Provider Database Tables and Columns 9-27
PLUSPPSCRAFTMU Table
PLUSPPSCRAFTPRIC Table
SANUM 1 0 UPPER 10
TRANSTYPE 1 0 UPPER 10
UNITPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
CRAFT 1 1 UPPER 8
EXTLABOR 1 1 YORN 1
INTERNAL 1 1 YORN 1
MARKUP 1 1 DECIMAL 5
ORGID 1 1 UPPER 8
PLUSPPSCRAFTMUID 1 1 INTEGER 12
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
SCHEDULE 1 1 UPPER 10
VENDOR 1 0 UPPER 12
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
CRAFT 1 1 UPPER 8
EXTLABOR 1 1 YORN 1
INTERNAL 1 1 YORN 1
ORGID 1 1 UPPER 8
PLUSPPSCRAFTPRICID 1 1 INTEGER 12
PRICESCHEDULE 1 1 UPPER 10
RATE 1 1 DECIMAL 5
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
SKILLLEVEL 1 0 UPPER 15
9-28 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPPSMATMU Table
PLUSPPSSERVMU Table
VENDOR 1 0 UPPER 12
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
COMMODITY 1 0 UPPER 8
COMMODITYDESC 0 0 ALN 100
COMMODITYGROUP 1 1 UPPER 8
MARKUP 1 1 DECIMAL 5
ORGID 1 1 UPPER 8
PLUSPPSMATMUID 1 1 INTEGER 12
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
SCHEDULE 1 1 UPPER 10
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
COMMODITYDESC 0 0 ALN 100
MARKUP 1 1 DECIMAL 5
ORGID 1 1 UPPER 8
PLUSPPSSERVMUID 1 1 INTEGER 12
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
SCHEDULE 1 1 UPPER 10
SERVICE 1 0 UPPER 8
SERVICEGROUP 1 1 UPPER 8
Service Provider Database Tables and Columns 9-29
PLUSPPSTOOLSMU Table
PLUSPRESPDUP Table
PLUSPRESPPLAN Table
Column Persistent? Required? Maxtype Length
AGREEMENT 1 1 UPPER 12
COMMODITY 1 0 UPPER 8
COMMODITYDESC 0 0 ALN 100
COMMODITYGROUP 1 1 UPPER 8
MARKUP 1 1 DECIMAL 5
ORGID 1 1 UPPER 8
PLUSPPSTOOLSMUID 1 1 INTEGER 12
REVISIONNUM 1 1 INTEGER 12
SANUM 1 0 UPPER 10
SCHEDULE 1 1 UPPER 10
Column Persistent? Required? Maxtype Length
NEWDUPSANUM 0 1 UPPER 10
Column Persistent? Required? Maxtype Length
ACTIVE 1 1 YORN 1
ADMINISTRATOR 1 0 UPPER 30
APPLYJOBPLAN 0 0 UPPER 10
APPLYJOBPLANID 1 0 INTEGER 12
APPLYTKTEMPLATE 1 0 UPPER 10
ASSIGNOWNER 1 0 UPPER 30
ASSIGNOWNERGROUP 1 0 UPPER 8
ASSIGNVENDOR 1 0 UPPER 12
CALCCALENDAR 1 0 UPPER 8
CALCORGID 1 0 UPPER 8
CALCSHIFT 1 0 UPPER 8
CALENDAR 1 0 UPPER 8
9-30 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
CALENDARORGID 1 0 UPPER 8
CHANGEBY 1 0 UPPER 30
CHANGEDATE 1 0 DATETIME 10
CLASSSTRUCTUREID 1 0 UPPER 20
CONDITION 1 0 ALN 2000
CREATEBY 1 0 UPPER 30
CREATEDATE 1 0 DATETIME 10
CUSTVENDORCONTACT 1 0 UPPER 30
DESCRIPTION 1 0 ALN 254
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
ENDDATE 1 0 DATE 4
ESCALATION 1 0 UPPER 10
EXPOBJECT 0 0 UPPER 18
HASLD 1 1 YORN 1
INTPRIORITYEVAL 1 0 ALN 14
INTPRIORITYVALUE 1 0 INTEGER 12
LANGCODE 1 1 UPPER 4
OBJECTNAME 1 1 UPPER 18
ORGID 1 0 UPPER 8
PLUSPSERVAGREEID 1 1 INTEGER 12
RANKING 1 1 INTEGER 12
REFPOINTID 1 0 INTEGER 12
REVIEWDATE 1 0 DATE 4
SANUM 1 1 UPPER 10
SERVICETYPE 1 1 UPPER 10
SHIFT 1 0 UPPER 8
SLANUM 1 0 UPPER 8
SLATYPE 1 0 ALN 10
STARTDATE 1 0 DATE 4
STATUS 1 0 UPPER 12
STATUSDATE 1 0 DATETIME 10
TICKETORGID 1 0 UPPER 8
TICKETSITEID 1 0 UPPER 8
Column Persistent? Required? Maxtype Length
Service Provider Database Tables and Columns 9-31
PLUSPREVISION Table
PLUSPRPCHGSTATUS Table
PLUSPRPRECORDS Table
PLUSPRPSTATUSDUMMY Table
VENDOR 1 0 UPPER 12
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
AGREEMENT 0 1 UPPER 12
COMMENTS 0 1 ALN 50
COMMENTS_LONGDESCRIPTION 0 0 LONGALN 32000
REVISIONNUM 0 0 INTEGER 12
Column Persistent? Required? Maxtype Length
CHANGEDATE 0 0 DATETIME 10
STATUS 0 0 UPPER 12
Column Persistent? Required? Maxtype Length
OWNERID 1 1 INTEGER 12
OWNERTABLE 1 1 UPPER 18
PLUSPRPRECORDSID 1 1 INTEGER 12
RESPONSEPLAN 1 1 UPPER 10
Column Persistent? Required? Maxtype Length
MEMO 0 0 ALN 50
RESPONSEPLAN 0 0 UPPER 10
9-32 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PUSPSALESORDER Table
Column Persistent? Required? Maxtype Length
ACTFEEPRICE TRUE FALSE AMOUNT 10
ADDRESSLINE2 TRUE FALSE ALN 36
ADDRESSLINE3 TRUE FALSE ALN 36
ADDRISCHANGED TRUE TRUE YORN 1
AGREEMENT TRUE FALSE UPPER 12
ASSETNUM TRUE FALSE UPPER 12
BBLINEDATE TRUE FALSE DATETIME 10
BBLINENUM TRUE FALSE INTEGER 12
BBLINESTAT TRUE FALSE UPPER 12
BBSTATUS TRUE FALSE UPPER 12
BILLBATCH TRUE FALSE UPPER 12
CHANGEBY TRUE TRUE UPPER 30
CHANGEDATE TRUE TRUE DATETIME 10
CITY TRUE FALSE UPPER 36
CLASSSTRUCTUREID TRUE FALSE UPPER 20
COMMODITY TRUE FALSE UPPER 8
COMMODITYGROUP TRUE FALSE UPPER 8
COUNTRY TRUE FALSE UPPER 3
COUNTY TRUE FALSE ALN 36
CUSTOMER TRUE FALSE UPPER 12
CUSTPONUM TRUE FALSE ALN 25
DESCRIPTION TRUE FALSE ALN 50
DESCRIPTION_LONGDESCRIPTION FALSE FALSE LONGALN 32000
DIRECTIONS TRUE FALSE ALN 50
DIRECTIONS_LONGDESCRIPTION FALSE FALSE LONGALN 32000
ENTERDATE TRUE TRUE DATETIME 10
ENTEREDBY TRUE FALSE UPPER 30
EXTERNALREFID TRUE FALSE ALN 10
FEEBILLPR TRUE FALSE AMOUNT 10
FINCNTRLID TRUE FALSE UPPER 8
GEOCODE TRUE FALSE ALN 11
Service Provider Database Tables and Columns 9-33
GLACCOUNT TRUE FALSE GL 23
HASLD TRUE TRUE YORN 1
HISTORYFLAG TRUE TRUE YORN 1
LANGCODE TRUE TRUE UPPER 4
LATITUDE TRUE FALSE DECIMAL 7
LOCATION TRUE FALSE UPPER 12
LONGITUDE TRUE FALSE DECIMAL 8
MAXPRICE TRUE FALSE AMOUNT 10
ORGID TRUE TRUE UPPER 8
OWNER TRUE FALSE UPPER 30
OWNERGROUP TRUE FALSE UPPER 8
OWNERSYSID TRUE FALSE ALN 10
PLUSPCOSTCENTER TRUE FALSE UPPER 16
PLUSPCUSTCHACCT TRUE FALSE UPPER 20
PLUSPDIRECNP FALSE FALSE ALN 50
PLUSPDIRECNP_LONGDESCRIPTION FALSE FALSE LONGALN 32000
PLUSPSALESORDERID TRUE TRUE INTEGER 12
POREQ TRUE TRUE YORN 1
POSTALCODE TRUE FALSE ALN 12
PRICESCHED TRUE FALSE UPPER 10
PSFILTER FALSE FALSE UPPER 10
REFERENCEPOINT TRUE FALSE ALN 50
REGIONDISTRICT TRUE FALSE ALN 36
RESPONSEPLAN TRUE FALSE UPPER 10
REVNUM TRUE FALSE INTEGER 12
SALESORDERNUM TRUE TRUE UPPER 10
SENDERSYSID TRUE FALSE ALN 50
SITEID TRUE TRUE UPPER 8
SOURCESYSID TRUE FALSE ALN 10
STADDRDIRPRFX TRUE FALSE UPPER 2
STADDRDIRSFX TRUE FALSE UPPER 2
STADDRNUMBER TRUE FALSE ALN 9
STADDRSTREET TRUE FALSE ALN 25
Column Persistent? Required? Maxtype Length
9-34 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPSERVADDR Table
STADDRSTTYPE TRUE FALSE ALN 8
STADDRUNITNUM TRUE FALSE ALN 6
STATEPROVINCE TRUE FALSE UPPER 3
STATUS TRUE TRUE UPPER 8
STATUSDATE TRUE TRUE DATETIME 10
STREETADDRESS TRUE FALSE ALN 56
TIMEZONE TRUE FALSE ALN 28
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
ADDRESSCODE 1 1 UPPER 12
ADDRESSLINE2 1 0 ALN 36
ADDRESSLINE3 1 0 ALN 36
CITY 1 0 UPPER 36
COUNTRY 1 0 UPPER 3
COUNTY 1 0 ALN 36
DESCRIPTION 1 0 ALN 50
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
DIRECTIONS 1 0 ALN 50
DIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
GEOCODE 1 0 ALN 11
HASLD 1 1 YORN 1
LANGCODE 1 0 UPPER 4
LATITUDE 1 0 DECIMAL 7
LOCATION 0 0 UPPER 12
LOCSITEID 0 0 UPPER 8
LONGITUDE 1 0 DECIMAL 8
ORGID 1 1 UPPER 8
PLUSPSERVADDRID 1 1 INTEGER 12
POSTALCODE 1 0 ALN 12
REFERENCEPOINT 1 0 ALN 50
REGIONDISTRICT 1 0 ALN 36
Service Provider Database Tables and Columns 9-35
PLUSPSERVAGREE Table
STADDRDIRPRFX 1 0 UPPER 2
STADDRDIRSFX 1 0 UPPER 2
STADDRNUMBER 1 0 ALN 9
STADDRSTREET 1 0 ALN 25
STADDRSTTYPE 1 0 ALN 8
STADDRUNITNUM 1 0 ALN 6
STATEPROVINCE 1 0 UPPER 3
STREETADDRESS 1 0 ALN 56
TIMEZONE 1 0 ALN 28
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
ACTIVE 1 1 YORN 1
ADMINISTRATOR 1 0 UPPER 30
APPLYJOBPLAN 0 0 UPPER 10
APPLYJOBPLANID 1 0 INTEGER 12
APPLYTKTEMPLATE 1 0 UPPER 10
ASSIGNOWNER 1 0 UPPER 30
ASSIGNOWNERGROUP 1 0 UPPER 8
ASSIGNVENDOR 1 0 UPPER 12
CALCCALENDAR 1 0 UPPER 8
CALCORGID 1 0 UPPER 8
CALCSHIFT 1 0 UPPER 8
CALENDAR 1 0 UPPER 8
CALENDARORGID 1 0 UPPER 8
CHANGEBY 1 0 UPPER 30
CHANGEDATE 1 0 DATETIME 10
CLASSSTRUCTUREID 1 0 UPPER 20
CONDITION 1 0 ALN 2000
CREATEBY 1 0 UPPER 30
CREATEDATE 1 0 DATETIME 10
CUSTVENDORCONTACT 1 0 UPPER 30
9-36 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPSOOWNERHIST Table
DESCRIPTION 1 0 ALN 254
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
ENDDATE 1 0 DATE 4
ESCALATION 1 0 UPPER 10
EXPOBJECT 0 0 UPPER 18
HASLD 1 1 YORN 1
INTPRIORITYEVAL 1 0 ALN 14
INTPRIORITYVALUE 1 0 INTEGER 12
LANGCODE 1 1 UPPER 4
OBJECTNAME 1 1 UPPER 18
ORGID 1 0 UPPER 8
PLUSPSERVAGREEID 1 1 INTEGER 12
RANKING 1 1 INTEGER 12
REFPOINTID 1 0 INTEGER 12
REVIEWDATE 1 0 DATE 4
SANUM 1 1 UPPER 10
SERVICETYPE 1 1 UPPER 10
SHIFT 1 0 UPPER 8
SLANUM 1 0 UPPER 8
SLATYPE 1 0 ALN 10
STARTDATE 1 0 DATE 4
STATUS 1 0 UPPER 12
STATUSDATE 1 0 DATETIME 10
TICKETORGID 1 0 UPPER 8
TICKETSITEID 1 0 UPPER 8
VENDOR 1 0 UPPER 12
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
ORGID 1 1 UPPER 8
OWNDATE 1 1 DATETIME 10
OWNER 1 0 UPPER 30
Service Provider Database Tables and Columns 9-37
PLUSPSOSTATUS Table
PLUSPSOSTATUSV Table
OWNERCHANGEBY 1 1 UPPER 30
OWNERGROUP 1 0 UPPER 8
PLUSPSOOWNERHISTID 1 1 INTEGER 12
SALESORDERNUM 1 1 UPPER 10
SITEID 1 1 UPPER 8
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
CHANGEBY 1 1 UPPER 30
CHANGEDATE 1 1 DATETIME 10
GLACCOUNT 1 0 GL 23
HASLD 1 1 YORN 1
LANGCODE 1 1 UPPER 4
MEMO 1 0 ALN 50
MEMO_LONGDESCRIPTION 0 0 LONGALN 32000
ORGID 1 1 UPPER 8
PLUSPSOSTATUSID 1 1 INTEGER 12
SALESORDERNUM 1 1 UPPER 10
SITEID 1 1 UPPER 8
STATUS 1 1 UPPER 8
Column Persistent? Required? Maxtype Length
ASOFDATE 0 0 DATETIME 10
CHANGEDATE 0 0 DATETIME 10
GLACCOUNT 0 0 GL 23
MEMO 0 0 ALN 50
ORGID 0 0 UPPER 8
SALESORDERNUM 0 1 UPPER 10
SITEID 0 0 UPPER 8
STATUS 0 1 UPPER 8
9-38 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPSRVADD Table
Column Persistent? Required? Maxtype Length
ADDRESSCODE 0 0 UPPER 12
ADDRESSFROMLOC 0 0 UPPER 12
ADDRESSLINE2 0 0 ALN 36
ADDRESSLINE3 0 0 ALN 36
ANCESTORSADDRESS 0 0 UPPER 12
CITY 0 0 UPPER 36
COUNTRY 0 0 UPPER 3
COUNTY 0 0 ALN 36
DESCRIPTION 0 0 ALN 50
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
DIRECTIONS 0 0 ALN 50
DIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
GEOCODE 0 0 ALN 11
LATITUDE 0 0 DECIMAL 7
LONGITUDE 0 0 DECIMAL 8
ORGID 0 0 UPPER 8
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
POSTALCODE 0 0 ALN 12
REFERENCEPOINT 0 0 ALN 50
REGIONDISTRICT 0 0 ALN 36
STADDRDIRPRFX 0 0 UPPER 2
STADDRDIRSFX 0 0 UPPER 2
STADDRNUMBER 0 0 ALN 9
STADDRSTREET 0 0 ALN 25
STADDRSTTYPE 0 0 ALN 8
STADDRUNITNUM 0 0 ALN 6
STATEPROVINCE 0 0 UPPER 3
STREETADDRESS 0 0 ALN 56
TIMEZONE 0 0 ALN 28
Service Provider Database Tables and Columns 9-39
PLUSPSRVADDSO Table
PLUSPSRVADDSTR Table
Column Persistent? Required? Maxtype Length
ADDRESSCODE 0 0 UPPER 12
ADDRESSFROMLOC 0 0 UPPER 12
ADDRESSLINE2 0 0 ALN 36
ADDRESSLINE3 0 0 ALN 36
ANCESTORSADDRESS 0 0 UPPER 12
CITY 0 0 UPPER 36
COUNTRY 0 0 UPPER 3
COUNTY 0 0 ALN 36
DIRECTIONS 0 0 ALN 50
GEOCODE 0 0 ALN 11
LATITUDE 0 0 DECIMAL 7
LONGITUDE 0 0 DECIMAL 8
ORGID 0 0 UPPER 8
POSTALCODE 0 0 ALN 12
REFERENCEPOINT 0 0 ALN 50
REGIONDISTRICT 0 0 ALN 36
STATEPROVINCE 0 0 UPPER 3
STREETADDRESS 0 0 ALN 56
TIMEZONE 0 0 ALN 28
Column Persistent? Required? Maxtype Length
ADDRESSCODE 0 0 UPPER 12
DESCRIPTION 0 0 ALN 50
DESCRIPTION_LONGDESCRIPTION 0 0 ALN 100
ORGID 0 0 UPPER 8
STADDRDIRPRFX 0 0 UPPER 2
STADDRDIRSFX 0 0 UPPER 2
STADDRNUMBER 0 0 ALN 9
STADDRSTREET 0 0 ALN 25
9-40 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPWOGRTOTALS Table
PLUSPWPGENBILL Table
STADDRSTTYPE 0 0 ALN 8
STADDRUNITNUM 0 0 ALN 6
STREETADDRESS 0 0 ALN 56
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
ACTUALCOST 0 0 AMOUNT 10
ACTUALPRICE 0 0 AMOUNT 10
ESTIMATEDCOST 0 0 AMOUNT 10
ESTIMATEDPRICE 0 0 AMOUNT 10
RESOURCE 0 0 ALN 25
ACTUALCOST 0 0 AMOUNT 10
ACTUALPRICE 0 0 AMOUNT 10
ESTIMATEDCOST 0 0 AMOUNT 10
ESTIMATEDPRICE 0 0 AMOUNT 10
RESOURCE 0 0 ALN 25
Column Persistent? Required? Maxtype Length
ADDEDBYPRSCHED 1 1 YORN 1
DESCRIPTION 1 0 ALN 50
DESCRIPTION_LONGDESCRIPTION 0 0 LONGALN 32000
ENTERBY 1 1 UPPER 30
ENTERDATE 1 1 DATETIME 10
HASLD 1 1 YORN 1
LANGCODE 1 1 UPPER 4
LINEPRICE 1 0 AMOUNT 10
PLUSPWPGENBILLID 1 1 INTEGER 12
SITEID 1 0 UPPER 8
SONUM 1 0 UPPER 10
TASKID 0 0 INTEGER 12
Service Provider Database Tables and Columns 9-41
PROBLEM Table
TICKETCLASS 1 0 UPPER 16
TICKETID 1 0 UPPER 10
TRANSDATE 1 1 DATETIME 10
TYPE 1 1 UPPER 10
WONUM 1 0 UPPER 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 12
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
9-42 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
SERVRECTRANS Table
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBILLPRICE 1 0 AMOUNT 10
PLUSPCURRBILLPR 1 0 AMOUNT 10
PLUSPCURRLINEPR 1 0 AMOUNT 10
Service Provider Database Tables and Columns 9-43
SLA Table
PLUSPCUSTCURCODE 1 0 UPPER 8
PLUSPCUSTCURDATE 1 0 DATE 4
PLUSPCUSTEXRATE 1 0 DECIMAL 14
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPGEOCODE 1 0 ALN 11
PLUSPLINEPRICE 1 0 AMOUNT 10
PLUSPPRICEADJ 1 1 YORN 1
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPREVGLACCT 1 0 GL 23
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSALESTAX 1 0 AMOUNT 10
PLUSPTAX1AMT 1 0 AMOUNT 10
PLUSPTAX1JURIS 1 0 ALN 11
PLUSPTAX2AMT 1 0 AMOUNT 10
PLUSPTAX2JURIS 1 0 ALN 11
PLUSPTAX3AMT 1 0 AMOUNT 10
PLUSPTAX3JURIS 1 0 ALN 11
PLUSPTAX4AMT 1 0 AMOUNT 10
PLUSPTAX4JURIS 1 0 ALN 11
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPSERVAGREEID 1 1 INTEGER 12
9-44 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
SR Table
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 12
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
Service Provider Database Tables and Columns 9-45
TICKET Table
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 12
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
9-46 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
Column Persistent? Required? Maxtype Length
Service Provider Database Tables and Columns 9-47
TOOLTRANS Table
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPBILLPRICE 1 0 AMOUNT 10
PLUSPCURRBILLPR 1 0 AMOUNT 10
PLUSPCURRLINEPR 1 0 AMOUNT 10
PLUSPCUSTCURCODE 1 0 UPPER 8
PLUSPCUSTCURDATE 1 0 DATE 4
PLUSPCUSTEXRATE 1 0 DECIMAL 14
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPGEOCODE 1 0 ALN 11
PLUSPLINEPRICE 1 0 AMOUNT 10
PLUSPPRICEADJ 1 1 YORN 1
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPREVGLACCT 1 0 GL 23
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSALESTAX 1 0 AMOUNT 10
PLUSPTAX1AMT 1 0 AMOUNT 10
PLUSPTAX1JURIS 1 0 ALN 11
PLUSPTAX2AMT 1 0 AMOUNT 10
PLUSPTAX2JURIS 1 0 ALN 11
PLUSPTAX3AMT 1 0 AMOUNT 10
PLUSPTAX3JURIS 1 0 ALN 11
PLUSPTAX4AMT 1 0 AMOUNT 10
PLUSPTAX4JURIS 1 0 ALN 11
9-48 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
WOACTIVITY Table
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPACTMATPRICE 1 0 AMOUNT 10
PLUSPACTSRVPRICE 1 0 AMOUNT 10
PLUSPACTTOOLPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPALLOWQUOTE 1 1 YORN 1
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 25
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
PLUSPBILLBATCHID 1 0 INTEGER 12
PLUSPBILLSTATUS 1 0 UPPER 12
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
Service Provider Database Tables and Columns 9-49
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPESTFEEPRICE 1 0 AMOUNT 10
PLUSPESTLABPRICE 1 0 AMOUNT 10
PLUSPESTMATPRICE 1 0 AMOUNT 10
PLUSPESTSRVPRICE 1 0 AMOUNT 10
PLUSPESTTOOLPRICE 1 0 AMOUNT 10
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATDIRECTION 1 0 ALN 40
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLINESTATUS 1 0 UPPER 12
PLUSPLONGDIRECTION 1 0 ALN 40
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMATBILLPR 1 0 AMOUNT 10
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPORIGQPRICE 1 0 AMOUNT 10
PLUSPORIGQTYPE 1 0 UPPER 8
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSRVBILLPR 1 0 AMOUNT 10
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
Column Persistent? Required? Maxtype Length
9-50 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
WOCHANGE Table
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOOLBILLPR 1 0 AMOUNT 10
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPACTMATPRICE 1 0 AMOUNT 10
PLUSPACTSRVPRICE 1 0 AMOUNT 10
PLUSPACTTOOLPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPALLOWQUOTE 1 1 YORN 1
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 25
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
PLUSPBILLBATCHID 1 0 INTEGER 12
PLUSPBILLSTATUS 1 0 UPPER 12
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
Service Provider Database Tables and Columns 9-51
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPESTFEEPRICE 1 0 AMOUNT 10
PLUSPESTLABPRICE 1 0 AMOUNT 10
PLUSPESTMATPRICE 1 0 AMOUNT 10
PLUSPESTSRVPRICE 1 0 AMOUNT 10
PLUSPESTTOOLPRICE 1 0 AMOUNT 10
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATDIRECTION 1 0 ALN 40
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLINESTATUS 1 0 UPPER 12
PLUSPLONGDIRECTION 1 0 ALN 40
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMATBILLPR 1 0 AMOUNT 10
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPORIGQPRICE 1 0 AMOUNT 10
PLUSPORIGQTYPE 1 0 UPPER 8
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
Column Persistent? Required? Maxtype Length
9-52 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
WORELEASE Table
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSRVBILLPR 1 0 AMOUNT 10
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOOLBILLPR 1 0 AMOUNT 10
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPACTMATPRICE 1 0 AMOUNT 10
PLUSPACTSRVPRICE 1 0 AMOUNT 10
PLUSPACTTOOLPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPALLOWQUOTE 1 1 YORN 1
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 25
Service Provider Database Tables and Columns 9-53
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
PLUSPBILLBATCHID 1 0 INTEGER 12
PLUSPBILLSTATUS 1 0 UPPER 12
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPESTFEEPRICE 1 0 AMOUNT 10
PLUSPESTLABPRICE 1 0 AMOUNT 10
PLUSPESTMATPRICE 1 0 AMOUNT 10
PLUSPESTSRVPRICE 1 0 AMOUNT 10
PLUSPESTTOOLPRICE 1 0 AMOUNT 10
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATDIRECTION 1 0 ALN 40
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLINESTATUS 1 0 UPPER 12
PLUSPLONGDIRECTION 1 0 ALN 40
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMATBILLPR 1 0 AMOUNT 10
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPORIGQPRICE 1 0 AMOUNT 10
PLUSPORIGQTYPE 1 0 UPPER 8
Column Persistent? Required? Maxtype Length
9-54 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
WORKORDER Table
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSRVBILLPR 1 0 AMOUNT 10
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOOLBILLPR 1 0 AMOUNT 10
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Column Persistent? Required? Maxtype Length
PLUSPACTFEEPRICE 1 0 AMOUNT 10
PLUSPACTLABPRICE 1 0 AMOUNT 10
PLUSPACTMATPRICE 1 0 AMOUNT 10
PLUSPACTSRVPRICE 1 0 AMOUNT 10
PLUSPACTTOOLPRICE 1 0 AMOUNT 10
PLUSPADDRESSLINE2 1 0 ALN 36
PLUSPADDRESSLINE3 1 0 ALN 36
Service Provider Database Tables and Columns 9-55
PLUSPADDRISCHANGED 1 1 YORN 1
PLUSPAGREEMENT 1 0 UPPER 12
PLUSPALLOWQUOTE 1 1 YORN 1
PLUSPBBLINEDATE 1 0 DATETIME 10
PLUSPBBLINENUM 1 0 INTEGER 12
PLUSPBBLINESTATUS 1 0 UPPER 25
PLUSPBBSTATUS 1 0 UPPER 12
PLUSPBILLBATCH 1 0 UPPER 12
PLUSPBILLBATCHID 1 0 INTEGER 12
PLUSPBILLSTATUS 1 0 UPPER 12
PLUSPCITY 1 0 UPPER 36
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCOUNTRY 1 0 UPPER 3
PLUSPCOUNTY 1 0 ALN 36
PLUSPCUSTCHACCT 1 0 UPPER 20
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPCUSTPONUM 1 0 ALN 25
PLUSPDIRECNP 0 0 ALN 50
PLUSPDIRECNP_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPDIRECTIONS_LONGDESCRIPTION 0 0 LONGALN 32000
PLUSPESTFEEPRICE 1 0 AMOUNT 10
PLUSPESTLABPRICE 1 0 AMOUNT 10
PLUSPESTMATPRICE 1 0 AMOUNT 10
PLUSPESTSRVPRICE 1 0 AMOUNT 10
PLUSPESTTOOLPRICE 1 0 AMOUNT 10
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
PLUSPGRTOTALBILLPR 0 0 AMOUNT 10
PLUSPLABBILLPR 1 0 AMOUNT 10
PLUSPLATDIRECTION 1 0 ALN 40
PLUSPLATITUDE 1 0 DECIMAL 7
PLUSPLINESTATUS 1 0 UPPER 12
Column Persistent? Required? Maxtype Length
9-56 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
PLUSPLONGDIRECTION 1 0 ALN 40
PLUSPLONGITUDE 1 0 DECIMAL 8
PLUSPMATBILLPR 1 0 AMOUNT 10
PLUSPMAXPRICE 1 0 AMOUNT 10
PLUSPORIGQPRICE 1 0 AMOUNT 10
PLUSPORIGQTYPE 1 0 UPPER 8
PLUSPPOREQ 1 1 YORN 1
PLUSPPOSTALCODE 1 0 ALN 12
PLUSPPRICESCHED 1 0 UPPER 10
PLUSPPSFILTER 0 0 UPPER 10
PLUSPQUOTEDPRICE 1 0 AMOUNT 10
PLUSPQUOTETYPE 1 0 UPPER 8
PLUSPREFPOINT 1 0 ALN 50
PLUSPREGIONDISTR 1 0 ALN 36
PLUSPRESPONSEPLAN 1 0 UPPER 10
PLUSPREVNUM 1 0 INTEGER 12
PLUSPSRVBILLPR 1 0 AMOUNT 10
PLUSPSTADDRDIRPRFX 1 0 UPPER 2
PLUSPSTADDRDIRSFX 1 0 UPPER 2
PLUSPSTADDRNUMBER 1 0 ALN 9
PLUSPSTADDRSTREET 1 0 ALN 25
PLUSPSTADDRSTTYPE 1 0 ALN 8
PLUSPSTADDRUNITNUM 1 0 ALN 6
PLUSPSTATEPROVINCE 1 0 UPPER 3
PLUSPSTREETADDRESS 1 0 ALN 56
PLUSPTIMEZONE 1 0 ALN 28
PLUSPTOOLBILLPR 1 0 AMOUNT 10
PLUSPTOTALBILLPR 0 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
Service Provider Database Tables and Columns 9-57
WPEDITSETTING Table
WPITEM Table
WPLABOR Table
WPMATERIAL Table
WPSERVICE Table
WPTOOL Table
Column Persistent? Required? Maxtype Length
PLUSPEDITFEES 1 1 YORN 1
Column Persistent? Required? Maxtype Length
PLUSPLINEPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
PLUSPLINEPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
PLUSPLINEPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
PLUSPLINEPRICE 1 0 AMOUNT 10
Column Persistent? Required? Maxtype Length
PLUSPLINEPRICE 1 0 AMOUNT 10
9-58 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Notices
This information was developed for products and services offered in the U.S.A.
IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.
IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to:
IBM Director of LicensingIBM CorporationNorth Castle DriveArmonk, NY 10504-1785U.S.A.
For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:
IBM World Trade Asia CorporationLicensing2-31 Roppongi 3-chome, Minato-kuTokyo 106-0032, Japan
The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law:
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.
This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.
Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those
© Copyright IBM Corp. 2007 Notices-1
Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.
IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.
Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:
IBM Corporation2Z4A/10111400 Burnet RoadAustin, TX 78758 U.S.A.
Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.
The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement or any equivalent agreement between us.
Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.
All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.
This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.
If you are viewing this information softcopy, the photographs and color illustrations may not appear.
Trademarks
AIX, IBM, IBM Corporation, the IBM logo, Tivoli, and WebSphere are registered trademarks of the International Business Machines Corporation in the United States, other countries, or both.
Intel, the Intel logo, and Pentium are registered trademarks of the Intel Corporation in the United States, other countries, or both.
Microsoft, Windows, and Internet Explorer are registered trademarks of Microsoft Corporation in the United States, other countries, or both.
Notices-2 IBM Maximo for Service Providers: Maximo User�s Guide Addendum
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
Sun, Sun Microsystems, the Sun logo, and Solaris are trademarks of Sun Microsystems, Inc.
Linux is a trademark of Linus Torvalds in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, and service names may be trademarks or service marks of others.
Notices-3
Notices-4 IBM Maximo for Service Providers: Maximo User�s Guide Addendum