IBM Maximo For Service Providers: Maximo User's Guide Addendum
IBM Maximo For Service Providers: Maximo User's Guide Addendum
IBM Maximo For Service Providers: Maximo User's Guide Addendum
Release 6.1
SC23-8802-00
Note
Before using this information and the product it supports, read the information in “Notices” on page Notices-1.
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/).
US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule
Contract with IBM Corp.
Contents
Contents v
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12
Sales Order Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12
Service Address Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-12
Sales Orders (SP) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
Change Status Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
Select Owner Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
Take Ownership Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
Apply Response Plan Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
Apply Customer Agreement Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
Select/Deselect Price Schedule Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
View Billing Status History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-13
View Sales Order History Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14
Edit Sales Order History Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14
Duplicate Sales Order Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14
Delete Sales Order Action. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8-14
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Notices-1
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:
Document Description
! Application server
! IBM Maximo
! Actuate®
Document Description
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.
viii IBM Maximo for Service Providers: Maximo User’s Guide Addendum
IBM Support
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.
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.
For details about these actions, refer to the Organizations (SP) help.
! GL account
! Asset
! Location
! Work plan labor
! Work plan materials
! Work plan services
! Work plan tools
! Data on the Safety tab
! Fees and charges
1-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Organizations (SP) Application
Service Options
! Service requests
! Incidents
! Problems
! Work orders (including activities, changes, and releases)
! Sales orders
Billing Options
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
! Sales Order?
! Customer
For information about fields, place the cursor in the field and press Alt + F1.
Associate a Classification When you associate a classification with a customer, the classification is
with a Customer Action 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
Assets Module
2
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.
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.
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:
! 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
Configuration Module
3
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.
Tabs
The Escalations (SP) application has the following enhanced tab:
! Escalation
! Source Application
For information about fields, place the cursor in the field and press Alt + F1.
Edit External Escalation If you have the proper security authorization, you can use the Edit External
Action 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
Resources Module
4
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.
Tabs
The People (SP) application has the following enhanced tab:
! Person
! Cust/Vendor
! Cust/Vend Type
For information about fields, place the cursor in the field and press Alt + F1.
4-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Service Desk Module
5
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.
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.
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:
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:
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
For details about these actions, refer to the Activities (SP) help.
! Changes (SP)
! Incidents (SP)
! Problems (SP)
! Releases (SP)
! Service Requests (SP)
5-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Activities (SP) Application
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:
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:
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
5-4 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Changes (SP) Application
For information about the first five actions, see “Activities (SP) Actions,” on
page 5-2.
View/Update Price Quote You use the View/Update Price Quote action to add, view or update a price
Action 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.
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:
For information about the first five actions, see “Activities (SP) Actions,” on
page 5-2.
5-6 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Incidents (SP) Application
Add/Modify Fees and You use the Add/Modify Fees and Charges action to add or modify fees and
Charges Action 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.
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
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
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:
Plans Tab
The Plans tab has the following industry-specific subtab:
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:
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
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
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.
! Customer
! Customer Charge Account
! Customer Cost Center
! Response Plan
! Line Price
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-12 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Service Management
Module
6
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.
Tabs
The Service Level Agreements (SP) application has the following new and
enhanced tabs:
For information about fields, place the cursor in the field and press Alt + F1.
! 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.
! 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.
6-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Service Address (SP) Application
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.
! Duplicate Address
! Delete Address
For details about these actions, refer to the Service Address (SP) help.
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.
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.
6-4 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Response Plans (SP) Application
! Change Status
! Associate Customer
! Duplicate Response Plan
! Delete Response Plan
For details about these actions, refer to the Response Plans (SP) help.
6-6 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Work Orders Module
7
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.
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.
! Charge Account
! Cost Center
! Customer
! Response Plan
Plans Tab
The Plans tab has the following industry-specific subtab:
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:
The Actuals tab has the following industry-specific field on each of its subtabs:
! Line Price
7-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Work Order Tracking (SP) Application
For details about these actions, refer to the Work Order Tracking (SP) help.
7-4 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Service Provider (SP)
Module
8
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.
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.
! 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.
8-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Customer Agreements (SP) Application
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
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.
! Change Status
! View Status History
! Revise Agreement
! View Revision History
! Duplicate Agreement
For details about these actions, refer to the Customer Agreements (SP) help.
8-4 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Customers (SP) Application
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.
customers when they have multiple billing addresses and want to create a
record for each billing address.
! 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.
8-6 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Customers (SP) Application
of the parent or the billing address of this customer. After copying address
elements, you can modify them.
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.
! Change Status
! Advance all WAPPR Lines to APPR
! View Costs
For details about these actions, refer to the Bill Review (SP) help.
8-8 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Bill Review (SP) Application
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.
! 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.
8-10 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Customer Billing (SP) Application
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.
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.
8-12 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Sales Orders (SP) Application
! 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.
8-14 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Service Provider Database
Tables and Columns
9
This chapter lists new industry-specific database tables and their columns. It
also lists new columns added to existing Maximo database tables.
CLASSSTRUCTURE Table
PLUSPCUSTOMER 1 0 UPPER 12
PLUSPUSEWITHSO 1 1 YORN 1
ESCALATION Table
PLUSPONDEMAND 1 1 YORN 1
PLUSPSOURCEAPP 1 1 UPPER 10
INCIDENT Table
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
PLUSPDIRECTIONS 1 0 ALN 50
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
9-2 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
LABTRANS Table
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
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
LOCATIONS Table
PLUSPADDFROMLOC 0 0 UPPER 12
PLUSPCOSTCENTER 1 0 UPPER 16
PLUSPCUSTCHACCT 1 0 UPPER 20
LOCSYSTEM Table
PLUSPADDRESSSYSTEM 1 1 YORN 1
MATUSETRANS Table
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
Column Persistent? Required? Maxtype Length
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
MAXVARINPUT Table
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
PERSON Table
PLUSPCUSTOMER 1 0 ALN 12
PLUSPCUSTVENDOR 1 0 UPPER 12
PLUSPCUSTVNDNAME 0 0 ALN 50
PLUSPCUSTVNDTYPE 1 1 UPPER 8
AGREEMENT 1 0 UPPER 12
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
PLUSPAGREEMENT Table
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
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
Column Persistent? Required? Maxtype Length
PRETAXTOTAL 1 0 AMOUNT 10
RENEWALDATE 1 0 DATE 4
REVISIONCOMMENTS 1 0 ALN 50
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
PLUSPAGREESTATUS Table
AGREEMENT 0 0 ALN 12
AGREESTATUS 0 0 UPPER 15
ASOFDATE 0 0 DATE 4
PLUSPAGREEMENTID 0 1 INTEGER 12
STATUS 0 1 ALN 12
PLUSPAGREETERMS Table
AGREEMENT 1 0 UPPER 12
AGREEMENTID 1 0 INTEGER 12
DESCRIPTION 1 0 ALN 50
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
PLUSPAPPLASSET Table
ASSETNUM 1 0 UPPER 12
ASSETTYPE 1 0 UPPER 15
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
PLUSPAPPLCOND Table
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
Column Persistent? Required? Maxtype Length
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
PLUSPAPPLFLD Table
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
PLUSPAPPLLOC 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
PLUSPAPPLSERV Table
COMMODITY 1 0 UPPER 8
COMMODITYGROUP 1 1 UPPER 8
HASLD 1 1 YORN 1
OWNERID 1 1 UPPER 18
OWNERTABLE 1 1 UPPER 18
PLUSPAPPLSERVID 1 1 INTEGER 12
PLUSPBATCHSTATUS Table
ASOFDATE 0 0 DATETIME 10
BILLBATCHNUM 0 0 UPPER 12
CURSTATUS 0 0 UPPER 12
ORGID 0 1 UPPER 8
PLUSPBILLBATCHID 0 1 INTEGER 12
9-10 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
STATUS 0 1 UPPER 16
PLUSPBATCHSTHIST Table
BILLBATCHNUM 1 1 UPPER 12
CHANGEBY 1 1 UPPER 30
CHANGEDATE 1 1 DATETIME 10
ORGID 1 1 UPPER 8
PLUSPBATCHSTHISTID 1 1 INTEGER 12
STATUS 1 1 UPPER 12
PLUSPBILLBATCH Table
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
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
PLUSPBILLLINE Table
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
9-12 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
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
PLUSPBILLPRICE Table
BILLPRICE 0 0 AMOUNT 10
LINECOST 0 0 AMOUNT 10
TRANSACTION 0 0 ALN 20
CUSTOMER 1 1 UPPER 12
PERSONID 1 1 UPPER 30
PLUSPCUSTCONTACTID 1 1 INTEGER 12
TYPE 1 1 ALN 8
PLUSPCUSTLOC Table
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
PLUSPCUSTOMER Table
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
Column Persistent? Required? Maxtype Length
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
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
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
PLUSPCUSTOMERLOG Table
CONTACT 1 0 UPPER 30
CREATEBY 1 1 UPPER 30
CREATEDATE 1 1 DATETIME 10
CUSTOMER 1 1 UPPER 12
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
PLUSPCUSTRP
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
CUSTOMER 1 1 UPPER 12
PLUSPCUSTSLAID 1 1 INTEGER 12
SLANUM 1 1 UPPER 10
PLUSPCUSTSTATUS Table
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
PLUSPCUSTSTATUSV Table
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
PLUSPGBTRANS Table
ADDEDBYPRSCHED 1 1 YORN 1
AGREEMENT 1 0 UPPER 12
BILLPRICE 1 0 AMOUNT 10
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
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
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
9-18 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
ASOFDATE 0 0 DATETIME 10
BILLBATCHNUM 0 0 UPPER 12
CURSTATUS 0 0 UPPER 12
LINENUM 0 0 INTEGER 12
ORGID 0 1 UPPER 8
STATUS 0 1 UPPER 16
PLUSPLINESTHIST Table
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
ORGID 1 1 UPPER 8
PLUSPLINESTHISTID 1 1 INTEGER 12
STATUS 1 1 UPPER 12
PLUSPLINESUMMARY Table
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
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
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
PLUSPPREBILLO Table
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
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
REVNUM 1 1 INTEGER 12
9-22 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
PLUSPPRICES Table
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
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
PLUSPPRICESCHED Table
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
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
Column Persistent? Required? Maxtype Length
CUSTVENDORCONTACT 1 0 UPPER 30
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
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
PLUSPPRICESCHEDUMMY Table
SANUM 0 0 ALN 12
PLUSPPSASSETMGT Table
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
Column Persistent? Required? Maxtype Length
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
PLUSPPSASSETPERF Table
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
PLUSPPSASSETUSE Table
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
SANUM 1 0 UPPER 10
TRANSTYPE 1 0 UPPER 10
UNITPRICE 1 0 AMOUNT 10
PLUSPPSCRAFTMU Table
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
PLUSPPSCRAFTPRIC Table
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
Column Persistent? Required? Maxtype Length
VENDOR 1 0 UPPER 12
PLUSPPSMATMU Table
AGREEMENT 1 1 UPPER 12
COMMODITY 1 0 UPPER 8
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
PLUSPPSSERVMU Table
AGREEMENT 1 1 UPPER 12
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
AGREEMENT 1 1 UPPER 12
COMMODITY 1 0 UPPER 8
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
PLUSPRESPDUP Table
NEWDUPSANUM 0 1 UPPER 10
PLUSPRESPPLAN Table
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
Column Persistent? Required? Maxtype Length
CALENDARORGID 1 0 UPPER 8
CHANGEBY 1 0 UPPER 30
CHANGEDATE 1 0 DATETIME 10
CLASSSTRUCTUREID 1 0 UPPER 20
CREATEBY 1 0 UPPER 30
CREATEDATE 1 0 DATETIME 10
CUSTVENDORCONTACT 1 0 UPPER 30
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
PLUSPREVISION Table
AGREEMENT 0 1 UPPER 12
COMMENTS 0 1 ALN 50
REVISIONNUM 0 0 INTEGER 12
PLUSPRPCHGSTATUS Table
CHANGEDATE 0 0 DATETIME 10
STATUS 0 0 UPPER 12
PLUSPRPRECORDS Table
OWNERID 1 1 INTEGER 12
OWNERTABLE 1 1 UPPER 18
PLUSPRPRECORDSID 1 1 INTEGER 12
RESPONSEPLAN 1 1 UPPER 10
PLUSPRPSTATUSDUMMY Table
MEMO 0 0 ALN 50
RESPONSEPLAN 0 0 UPPER 10
9-32 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
PUSPSALESORDER Table
9-34 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
PLUSPSERVADDR Table
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
DIRECTIONS 1 0 ALN 50
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
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
PLUSPSERVAGREE Table
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
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
Column Persistent? Required? Maxtype Length
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
PLUSPSOOWNERHIST Table
ORGID 1 1 UPPER 8
OWNDATE 1 1 DATETIME 10
OWNER 1 0 UPPER 30
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
PLUSPSOSTATUS Table
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
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
PLUSPSOSTATUSV Table
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
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
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
PLUSPDIRECNP 0 0 ALN 50
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
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
PLUSPSRVADDSTR Table
ADDRESSCODE 0 0 UPPER 12
DESCRIPTION 0 0 ALN 50
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
Column Persistent? Required? Maxtype Length
STADDRSTTYPE 0 0 ALN 8
STADDRUNITNUM 0 0 ALN 6
STREETADDRESS 0 0 ALN 56
PLUSPWOGRTOTALS Table
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
PLUSPWPGENBILL Table
ADDEDBYPRSCHED 1 1 YORN 1
DESCRIPTION 1 0 ALN 50
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
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
PROBLEM Table
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
PLUSPDIRECTIONS 1 0 ALN 50
PLUSPFEEBILLPR 1 0 AMOUNT 10
PLUSPGEOCODE 1 0 ALN 11
9-42 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
SERVRECTRANS Table
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
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
SLA Table
PLUSPSERVAGREEID 1 1 INTEGER 12
9-44 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
SR Table
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
PLUSPDIRECTIONS 1 0 ALN 50
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
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
TICKET Table
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
Column Persistent? Required? Maxtype Length
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
PLUSPDIRECTIONS 1 0 ALN 50
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
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
TOOLTRANS Table
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
Column Persistent? Required? Maxtype Length
PLUSPTAX5AMT 1 0 AMOUNT 10
PLUSPTAX5JURIS 1 0 ALN 11
PLUSPTAX6AMT 1 0 AMOUNT 10
PLUSPTAX6JURIS 1 0 ALN 11
WOACTIVITY Table
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
PLUSPDIRECTIONS 1 0 ALN 50
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
9-50 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
WOCHANGE Table
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
PLUSPDIRECTIONS 1 0 ALN 50
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
9-52 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
WORELEASE Table
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
PLUSPDIRECTIONS 1 0 ALN 50
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
9-54 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
WORKORDER Table
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
PLUSPDIRECTIONS 1 0 ALN 50
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
9-56 IBM Maximo for Service Providers: Maximo User’s Guide Addendum
Column Persistent? Required? Maxtype Length
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
PLUSPEDITFEES 1 1 YORN 1
WPITEM Table
PLUSPLINEPRICE 1 0 AMOUNT 10
WPLABOR Table
PLUSPLINEPRICE 1 0 AMOUNT 10
WPMATERIAL Table
PLUSPLINEPRICE 1 0 AMOUNT 10
WPSERVICE Table
PLUSPLINEPRICE 1 0 AMOUNT 10
WPTOOL Table
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:
The following paragraph does not apply to the United Kingdom or any other
country where such provisions are inconsistent with local law:
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
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 Corporation
2Z4A/101
11400 Burnet Road
Austin, TX 78758 U.S.A.
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.
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.
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.
Notices-3
Notices-4 IBM Maximo for Service Providers: Maximo User’s Guide Addendum