IBM SC23-8765-00 manual

SC23-8765-00 Release 6.1 Maximo User ’ s Guide Addendum IBM Maximo for Government[...]

This edition applies to v ersion 6, release 1 of IBM Maximo for Gover nment and to all subseque nt releases and modifications until otherwise indi cated in new editions. P ortions © 1996-2 005, i-net soft ware GmbH P ortions © 2007 Intrinsyc Softwa re Inc. and its licensors P ortions © 2001-2 003 Pow erT eam, In c. P ortions © 1996-200 3 Visual[...]

© Copyright IBM Corp. 2007 iii About This Publication. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii Intended Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [...]

iv IBM Maximo for Government: Maximo User ’s Guide Addendum Create Property Upload Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 View Property Upload Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[...]

Contents v Companies (Gv) Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Create Property Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 View Property History . .[...]

vi IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 vii About This Publication This section explains how this guide can help you to use IBM ® Maximo ® for Government (Gov ernment). It also pr ovides information about other IBM Corporation resources available to you, such as additional documentation and support. Intended Audience This addendum to th e IBM Maximo User’s[...]

IBM Support viii IBM Maximo for Government: Maximo User ’s Guide Addendum IBM Support IBM Software Support provides as sistance with product defects. Before contacting IBM Software Support, your company must have an activ e IBM softw are maintenance contract, and you mu st be authorized to submit problems to IBM. For information about the types o[...]

IBM Support About This Publication ix b By telephone: For the telephone number to call in your country , go to the Contacts page of the Software Support Handbook : techsupport.services.ibm. com/guides/contacts.html . If the problem you submit is for a software defect or for miss ing or inaccurate documentation, IBM Suppor t creates an Authorized Pr[...]

IBM Support x IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 1 IBM Maximo for Government is a Federal Acquisition Regula tion (F AR) compliant system that can manage go vern ment-furnished property in the hands of contractors for the support of Depa rtment of Defense and NASA contracts. IBM Maximo for Government contain s tw o new applications that are designed specifically for th[...]

2 IBM Maximo for Government: Maximo User ’s Guide Addendum Assets (Gv) ! Associate an asset with a governme nt agency owner and contract. ! Create property trans actions for an asset. ! Display the property hi story of an asset. ! Capture, assign, and mark UII information for an asset. ! Create and view property upload files. Locations (Gv) ! Dis[...]

Government Features 3 The remaining chapters of this guide ex plain where y ou perform these activities. Issues and T ransfers (Gv) ! Associate the issue or transfer of property with a government agency owner and contract. Storerooms (Gv) ! Display property balances for a storeroom. ! Create property transactions for a storeroom. ! Display the prop[...]

4 IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 5 The Administration module has one cloned application. Thi s c ha pte r p ro vid es an overview of new actions in that applica tion. For more information about the application, see the help for the application. For more information about standard Maximo applications, see the IBM Maximo User’s Guide. The Administration[...]

Organizati ons (Gv) Application 6 IBM Maximo for Government: Maximo User ’s Guide Addendum T o access these actions, select Governmen t Options from the Select Action menu. For more information about these actions, see the Organizations (Gv) help. Property T ran saction Definitions Y ou use the Property T ransaction Definitions action to define t[...]

Organizati ons (Gv) Application Administration Module 7 Government Def ault s Y ou use the Government Defaults action to specify criteria to determine whether a UII is required and specif y the format of contract line number s. Government Defaults Dialog Box[...]

Organizati ons (Gv) Application 8 IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 9 The Assets module has tw o cloned applications. This chapter provides an overview of new tabs and ac tions in those applications. For more information about these applications, see the help for the applications. For more information about standa rd Maximo applications, see the IBM Maximo User’s Guide. The Assets modu[...]

Asset s (Gv) Application 10 IBM Maximo for Government: Maximo User ’s Guide Addendum Ta b s The Assets (Gv) application has the following new tab: ! Property Y ou use the Property tab to display proper ty records associated with an asset. For information about a field, place the cursor in the field and pr ess Alt+F1. Property T ab Asset s (Gv) Ac[...]

Locations (Gv ) Application Assets Module 11 Assign / Mark UIIs Y ou use the Assign / Mark UIIs action to generate Unique Item Identifiers ( UIIs) and UII marks. T o access this action, select UIIs > Assign / Mark UIIs from the Select Action menu. Create Property T ransactions Y ou use the Create Property T ransactions action to create tr ans ac[...]

Locations (Gv) Applicatio n 12 IBM Maximo for Government: Maximo User ’s Guide Addendum Ta b s The Locations (Gv) application has the following new tab: ! Property Y ou use the Property tab to display proper ty records associated with a location. For information about a field, place the cursor in the field and press Alt + F1. Property T ab Locati[...]

Locations (Gv ) Application Assets Module 13 Create Property Upload Files Y ou use the Create Property Upload Files action to search for and select property transactions and create upload files for selected transact ions. T o access this action, select Property Upload Files > Crea te Prop erty Upload Files from the Select Action menu. View Prope[...]

Locations (Gv) Applicatio n 14 IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 15 The Contracts module has one new appl ication. This chapter provides an overview of the tabs and ac tions in that application. For more information about this applicati on, see the help for the application. For more information about standard Maximo applications, see the IBM Maximo User’s Guide. The Contracts module[...]

Governmen t Contract s (Gv) Applic ation 16 IBM Maximo for Government: Maximo User ’s Guide Addendum Ta b s The Government Contracts (Gv) a pplication has the following tabs: ! List ! Contract ! Properties ! Contract Lines ! T erms and Conditions ! Property Summary ! Property The List tab is part of mo st Maximo applications. For more information[...]

Governm ent Contract s (Gv) Application Contracts Module 17 Contract Lines T ab Y ou use the Contract Lines tab to add items to a contract. Contract Lines T ab T erms and Conditions T ab Y ou use the T erm s and Conditions tab to associate terms an d conditions with a contract. The fields on this tab appear on the T erms and Conditions tab of all c[...]

Governmen t Contract s (Gv) Applic ation 18 IBM Maximo for Government: Maximo User ’s Guide Addendum Government Contract s (Gv) Actions The Government Contracts (Gv) application has the following Government-specific actions: ! Capture UIIs ! Assign / Mark UIIs ! Create Property T ransactions ! V iew Property History ! Create Property Upload Files[...]

© Copyright IBM Corp. 2007 19 one The Inven tory module has four cloned a pplications. This chapter provides an overview of new tabs, fie lds, and actions in those applications. For more information about the applications , see the help for the application. For more information about standard Maximo applications, see the IBM Maximo User’s Guide.[...]

Inventory (Gv) Applic ation 20 IBM Maximo for Government: Maximo User ’s Guide Addendum Inventory (Gv) Application Y ou use the Inventory (Gv) application to track stocked, nonstocked, and special order items. Y ou can track item balances , and v endors who supply items, down to the bin and lot level for each storeroom. The Inventory (Gv) applica[...]

Item Master (Gv) Application Inventory Module 21 For more information about these actions, see the Inventory (Gv) help. Add Property Record Y ou use the Add Property Record action to associate an item and storeroom with a government contract and custodian. Create Property T ransactions Y ou use the Create Property T ransactions action to create tr [...]

Item Maste r (Gv) Applicatio n 22 IBM Maximo for Government: Maximo User ’s Guide Addendum Item T ab The Item tab has the followin g Government-specific fields: ! Property Class ! NSN ! Acquisition Cost Property T ab Y ou use the Property tab to display property records associated with an item. For an example of the Property tab, see “L ocation[...]

Issues and T ransfers (Gv) A pplication Inventory Module 23 Issues and T ransfers (Gv) Application Y ou use the Issues and T ransfers (Gv) appl ication to issue, return, and transfer inventory . Ta b s The Issues and T ransfers (Gv) application has the following enhanced tabs: ! Issue ! T ransfer Out ! Tr a n s f e r I n For information about these[...]

Issues and T ransfers (Gv) Applic ation 24 IBM Maximo for Government: Maximo User ’s Guide Addendum T ransfer Out T ab The T ransfer Out tab has the following Government -specific fields: ! Contract ! Source ! Property Class ! From Custodian ! To C u s t o d i a n ! From User ! To U s e r Transfer Out T ab T ransfer In T ab The T ransfer In tab h[...]

Storerooms (Gv) Application Inventory Module 25 Transfer In T ab Issues and T ransfers (Gv) Actions The Issues and T ransfers (Gv) application has no Go vernment-specific actions. S torerooms (Gv) Application Y ou use the Storerooms (Gv) application to add and maintain information about storeroom locations, as well as view the items stocked within [...]

Storer ooms (Gv) Application 26 IBM Maximo for Government: Maximo User ’s Guide Addendum S torerooms (Gv) Actions The Storerooms (Gv) application has the following Government-specific actions: ! Create Property T ransactions ! V iew Property History ! Create Property Upload Files ! View Property Upload Files For more information about these actio[...]

© Copyright IBM Corp. 2007 27 The P ersonal Property (Gv) module has one new Government-specific application. This chapter provides an ov erview of the tabs and actions in that application. For more information about the application, see the help for the application. For more information about standard Maximo applications, see the IBM Maximo User?[...]

Personal Property (Gv) Application 28 IBM Maximo for Government: Maximo User ’s Guide Addendum Ta b s The P ersonal Property (Gv) appl ication has the following tabs: ! List ! Property The List tab is part of mo st Maximo applications. For more information about this tab, see the IBM Maximo User’s Guide and the P ersonal Property (Gv) help. Y o[...]

Personal Property (Gv) Application Personal Property (Gv) Module 29 Capture UIIs Y ou use the Capture UIIs action to capture UID information for an asset. T o access this action, select UIIs > Capture UIIs from the Select Action menu. Assign / Mark UIIs Y ou use the Assign / Mark UIIs action to generate Unique Item Identifiers ( UIIs) and genera[...]

Personal Property (Gv) Application 30 IBM Maximo for Government: Maximo User ’s Guide Addendum Edit Property T ransaction Reports Y ou use the Edit Property T ransaction Reports action to add or remov e transactions from a UID report and edit th e details of transactions in a UID report. T o access this action, select Property T ransaction Re por[...]

© Copyright IBM Corp. 2007 31 The Purchasing module has two cloned ap plicat ions. This chapter describes the new tabs, fields, and actions in those applications. For more information about these applications, see the help for the applications. For more information about standa rd Maximo applications, see the IBM Maximo User’s Guide. The Purchas[...]

Companies (Gv) Application 32 IBM Maximo for Government: Maximo User ’s Guide Addendum Ta b s The Companies (Gv) application has th e following new or enhanced tabs: ! Company ! Property (new) For information about a field, place the cursor in the field and press Alt + F1. Comp any T ab The Company tab has the followin g Government-specific field[...]

Receiving (Gv) Application Purchasing Module 33 Comp anies (Gv) Actions The Companies (Gv) application has the foll owing Government-specific actions : ! Create Property T ransactions ! V iew Property History ! Create Property Upload Files ! View Property Upload Files For more information about these actions, see the Companies (Gv) help. Create Pro[...]

Receiving (Gv) Application 34 IBM Maximo for Government: Maximo User ’s Guide Addendum Ta b s The Receiving (Gv) application has the following enhanced tab: ! Material Receipts The Material Recei pts tab has the fo llowing Gov ernment-specific fields: ! Contract ! Source ! Property Class ! To C u s t o d i a n ! To U s e r For information about a[...]

Receiving (Gv) Application Purchasing Module 35 Assign / Mark UIIs Y ou use the Assign / Mark UIIs action to generate Unique Item Identifiers ( UIIs) and generate UII marks. T o access this action, select UIIs > Assign / Mark UIIs from the Select Action menu.[...]

Receiving (Gv) Application 36 IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 37 The Resources module has one cloned applic ation. This chapter describes the new tab and actions in that application. For more information about the application, see the help for the application. For more information about standard Maximo applications, see the IBM Maximo User’s Guide. The Resources module contains t[...]

People (Gv) Application 38 IBM Maximo for Government: Maximo User ’s Guide Addendum People (Gv) Actions The P eople (Gv) application has the following Government-specific acti ons: ! Create Property T ransactions ! V iew Property History ! Create Property Upload Files ! View Property Upload Files For more information about these actions, see the [...]

© Copyright IBM Corp. 2007 39 This chapter lists Government-specific data base tables and their columns. It also lists Government-specific columns added to existing Maximo database tables. ASSET T able ASSETCUST T able Government Dat abase T ables and Columns 9 COLUMN REQUIRED MAXTYPE LENG TH PLUSRUII 0 ALN 100 PLUSRUIIAFFIXDA TE 0 DA TETI ME 10 P[...]

40 IBM Maximo for Government: Maximo User ’s Guide Addendum COMP ANIES Table CONTRACT T able PLUSRUIIASSETU ID 0 UPPER 30 PLUSRUIIBAGGT AGG 0 UPPER 1 PLUSRUIIEID 0 UPPER 25 PLUSRUIIIAC 0 UPPER 25 PLUSRUIILOTBA TCH 0 UPPER 30 PLUSRUIIMARK 0 ALN 256 PLUSRUIIORIITEMNUM 0 UPPER 30 PLUSRUIIRENDERDA TE 0 DA TETIME 10 PLUSRUII RENDERED 1 YORN 1 PLUSRUII[...]

Government Database T ables and Columns 41 CONTRACTLINE Ta ble INVENTORY T able ISSUECURRENTITEM Ta ble ITEM T able PLUSRPROPERTY ADMIN 0 UPPER 30 PLUSRSCHEDENDDA TE 0 DA TE 4 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH PLUSRCLIN 0 UPPER 12 COLUMN REQUIRED MAXTYPE LENG TH PLUSRGOVBALANCE 1 DECIMAL 15 COLUMN REQUIRED MAXTYPE LENG[...]

42 IBM Maximo for Government: Maximo User ’s Guide Addendum LABORVIEW T able LEASEVIEW T able COLUMN REQUIRED MAXTYPE LENG TH PLUSRCAPRECEIP TS 1 YORN 1 PLUSRCONTRACT ADMIN 0 UPPER 30 PLUSRCONTRACTOR 0 UPPER 12 PLUSRCONTRACTTYPE 0 UPPER 25 PLUSRCUSTOMER 0 UPPER 12 PLUSRGFPRECEIP TS 1 YORN 1 PLUSRP ARCONTRACT 0 UPPER 8 PLUSRP ARCONTRACTOR 0 U PPER[...]

Government Database T ables and Columns 43 LEASEVIEWLINE T able MASTERVIEW T able MA TRECTRANS T able COLUMN REQUIRED MAXTYPE LENG TH PLUSRCLIN 0 UPPER 12 COLUMN REQUIRED MAXTYPE LENG TH PLUSRCAPRECEIP TS 1 YORN 1 PLUSRCONTRACT ADMIN 0 UPPER 30 PLUSRCONTRACTOR 0 UPPER 12 PLUSRCONTRACTTYPE 0 UPPER 25 PLUSRCUSTOMER 0 UPPER 12 PLUSRGFPRECEIP TS 1 YORN[...]

44 IBM Maximo for Government: Maximo User ’s Guide Addendum MA TUSETRANS T able MAXV ARINPUT Table PLUSRCONTSUMHEAD T able PLUSRCONTSUMMARY T able COLUMN REQUIRED MAXTYPE LENG TH PLUSRCONTRACTNUM 0 UPPER 8 PLUSRCUSTODIAN PERSONID 0 UPPER 30 PLUSRPROPERTYCLA SS 0 U PPER 25 PLUSRSOURCE 0 UPPER 25 PLUSRTOCUSTODIAN PERSONID 0 UPPER 30 PLUSRTOUSERP ER[...]

Government Database T ables and Columns 45 PLUSRFORM T able PLUSRFORMTRANS T able DELETIONS 1 DECIMAL 15 ENDINGACQCOST 1 DECIMAL 15 ENDINGQUANTITY 1 INTEGER 12 MISSINGUIIACQCOST 1 DECIMAL 15 MISSINGUIIQUANTITY 1 INTEGER 12 ORGID 1 UPPER 8 PLUSRCONTSUMMARYID 1 INTEGER 12 PROPERTYCLASS 1 UPPER 25 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYP[...]

46 IBM Maximo for Government: Maximo User ’s Guide Addendum PLUSRGOVCONTRACT T able COLUMN REQUIRED MAXTYPE LENG TH ACCEPT ANCELOSS 1 YORN 1 ACCEPTPERIOD 0 INTEGER 12 AUTOEXTENDPERIOD 0 INTEGER 12 BUY AHEAD 1 YORN 1 BUYOUT 1 YORN 1 CANAUDIT 1 YORN 1 CASUAL TYBUYOUT 1 YORN 1 CASUAL TYNOTIFY 1 YORN 1 CHANGEBY 0 UPPER 30 CHANGEDA TE 1 DA TETIME 10 C[...]

Government Database T ables and Columns 47 FOB 0 ALN 20 FREIGHTTER MS 0 ALN 50 FREIGHTTERMS _LONGDESCRIPTION 0 LONGALN 32000 HASINSURANCE 1 YORN 1 HASLD 1 YORN 1 HISTORYFLAG 1 YORN 1 INCLUDESMAINT 1 YORN 1 INCLUSIVE1 1 YORN 1 INCLUSIVE2 1 YORN 1 INCLUSIVE3 1 YORN 1 INCLUSIVE4 1 YORN 1 INCLUSIVE5 1 YORN 1 INSPECTIONREQUIRED 1 YORN 1 INSURANCEEXPDA T[...]

48 IBM Maximo for Government: Maximo User ’s Guide Addendum PERIODICP A YMNT 0 AMOUNT 10 PLUSRCAPRECEIP TS 1 YORN 1 PLUSRCONTRACT ADMIN 0 UPPER 30 PLUSRCONTRACTOR 0 UPPER 12 PLUSRCONTRACTTYPE 0 UPPER 25 PLUSRCUSTOMER 0 UPPER 12 PLUSRGFPRECEIP TS 1 YORN 1 PLUSRP ARCONTRACT 0 UPPER 8 PLUSRP ARCONTRACTOR 0 U PPER 12 PLUSRPRICONTRACTOR 0 UPPER 12 PLU[...]

Government Database T ables and Columns 49 PLUSRHEADER Ta ble PLUSRPROPERTY T able TOT ALCOST 0 DECIMAL 10 TRANSFERW ARRANTY 1 YORN 1 VENDNOTIFYPERIOD 0 INTEGER 12 VENDOR 0 UPPER 12 VENDORREFNUM 0 ALN 12 VENDTERMALLOWED 1 YORN 1 W ARRANTYDURA TION 0 INTEGER 12 W ARRANTYST ART 0 DA TE 4 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH[...]

50 IBM Maximo for Government: Maximo User ’s Guide Addendum PLUSRPROPTRANS T able MEMO 0 ALN 254 NP_QUANTITY 0 DECIMAL 15 ORGID 1 UPPER 8 PLUSRPROPERTYID 1 INTEGER 12 PROPERTYCLASS 0 UPPER 25 QUANTITY 1 DECIMAL 15 SITEID 1 UPPER 8 SOURCE 0 U PPER 25 TOCONTRACTNUM 0 UPPER 8 TOCUSTODIAN 0 UPPER 30 TOUSER 0 UPPER 30 TRANSACTIONDA TE 0 DA TETIME 10 T[...]

Government Database T ables and Columns 51 ENTERPRISEID 0 UPPER 25 FROMP ARENT 0 UPPE R 12 FROMPRICE 0 AMOUNT 10 FROMPROPERTYID 0 INTEGER 12 FROMSITE 0 UPPER 8 FROMST A TUS 0 ALN 20 FROMUII 0 ALN 100 FROMUIIMARK 0 ALN 256 GFPCONTRACTNUMBER 0 UPPER 8 GFPPRICONTRACTCAGE 0 ALN 9 GFPPRICONTRACTDUNS 0 ALN 9 GFPPRICONTRDODAAC 0 ALN 6 HASLD 1 YORN 1 ISSUE[...]

52 IBM Maximo for Government: Maximo User ’s Guide Addendum PA R E N T U I I 0 A L N 8 PLUSRPROPTRANSID 1 INTEGER 12 PLUSRUPLOADFILEID 0 INTEGER 12 POLINE 0 A LN 8 PONUM 0 UPPER 8 POPTYPE 0 UPPER 15 PRIMECONTRACTOR 0 ALN 9 PRINTED 1 YORN 1 QUANTITY 1 DECIMAL 15 RDYPRINT 1 YORN 1 RECEIVEDDA TE 0 DA TETIME 10 REPORTNUM 0 UPPER 12 SENTDA TE 0 DA TET[...]

Government Database T ables and Columns 53 PLUSRTRANSACTION T able PLUSRTRANSEXTSYS T able PLUSRTRANSFORM T able PLUSRUIITEMPLA TE Table UIITYPE 0 UPPER 25 UNITOFMEASURE 0 UPPER 8 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH NEW ASSETST A TUS 0 ALN 20 ORGID 1 UPPER 8 PLUSRTRANSACTIONID 1 INTEGER 12 TRANSACTIONNAME 1 UPPER 25 COLU[...]

54 IBM Maximo for Government: Maximo User ’s Guide Addendum PLUSRUPLOAD Ta ble PLUSRUPLOADFILE T able PLUSRUPLOADTRANS T able TEMPLA TENAME 1 UPPER 25 UIITYPE 1 UPPER 25 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH ORGID 1 UPPER 8 PLUSRUPLOA DID 1 INTEGER 12 PROPERTYTRANSID 1 INTEGER 12 SITEID 1 UPPER 8 UPLOADFILEID 1 INTEGER 1[...]

Government Database T ables and Columns 55 PLUSRVHEADER Ta ble PLUSRVPROPERTY T able TRANSPERSONID 1 UPPER 30 UPLOADFILEID 1 INTEGER 12 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH EMAIL 0 ALN 50 INDUSTRYFLAG 1 ALN 1 NAME 1 UPPER 30 ORGANIZA TION 1 UPPER 20 PHONE 1 ALN 20 RECORDCOUNT 0 INTEGER 12 REPORTNUM 1 UPPER 12 REPORTNUMNP [...]

56 IBM Maximo for Government: Maximo User ’s Guide Addendum PLUSRVUPLOAD Ta ble TOCUSTODIAN 0 UPPER 30 TOUSER 0 UPPER 30 TRANSACTIONDA TE 0 DA TETIME 10 TRANSACTIONMEMO 0 ALN 254 TRANSACTIONMEMO_LONGDESCRIPTION 0 LONGALN 32000 TRANSACTIONNAME 0 UPPER 25 USERPERSONID 0 UPPER 30 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH ASSETN[...]

Government Database T ables and Columns 57 PURCHVIEW Table NEW ASSETST A TUS 0 ALN 20 ORGID 1 UPPER 8 PLUSRPROPERTYID 1 INTEGER 12 PLUSRPROPTRANSID 1 INTEGER 12 PLUSRTRANSACTIONID 1 INTEGER 12 PLUSRTRANSEXTSYSID 1 INTEGER 12 PROPERTYCLASS 0 UPPER 25 QUANTITY 1 DECIMAL 15 SITEID 1 UPPER 8 SOURCE 0 U PPER 25 TOP ARENT 0 UPPER 12 TOPRICE 0 AMOUNT 10 T[...]

58 IBM Maximo for Government: Maximo User ’s Guide Addendum SERVICEITEMS T able TOO LI NV Tab le TOOLITEM T able TRANSFERCURITEM T able PLUSRP ARCONTRACT 0 UPPER 8 PLUSRP ARCONTRACTOR 0 U PPER 12 PLUSRPRICONTRACTOR 0 UPPER 12 PLUSRPRIMECON TRACT 0 UPPER 8 PLUSRPROPERTY ADMIN 0 UPPER 30 PLUSRSCHEDENDDA TE 0 DA TE 4 COLUMN REQUIRED MAXTYPE LENG TH [...]

Government Database T ables and Columns 59 W ARRANTYVIEW T able W ARRANTYVIEWLINE T able PLUSRSOURCE 0 UPPER 25 PLUSRTOCUSTODIAN PERSONID 0 UPPER 30 PLUSRTOUSERP ERSONID 0 UPPER 30 PLUSRUSE RPERSONID 0 UPPER 30 COLUMN REQUIRED MAXTYPE LENG TH COLUMN REQUIRED MAXTYPE LENG TH PLUSRCAPRECEIP TS 1 YORN 1 PLUSRCONTRACT ADMIN 0 UPPER 30 PLUSRCONTRACTOR 0[...]

60 IBM Maximo for Government: Maximo User ’s Guide Addendum[...]

© Copyright IBM Corp. 2007 61 Notices This information was developed for produc ts and services offered in the U.S.A. IBM may not offer the products, services, or feature s discussed in this document in other countries. Consult y our local IBM representative for information on the products and services currently available in your area. Any referen[...]

62 IBM Maximo for Government: Maximo User ’s Guide Addendum IBM may use or distribute any of the information you supply in any way it believes appropriate without in curring any obligation to you. Licensees of this program who wish to ha ve information about it for the purpose of enabling: (i) the exchange of info rmation betw een independently c[...]

63 T rademarks The following terms are trademarks of International Business Machines Corporation in the United States, other countr ies, or both: IBM AIX DB2 Everyplace ibm.com Lotus Maximo Notes QuickPlace Tivoli We b S p h e r e Adobe, the Adobe logo, P ostScript, and the P ostScript logo are either registered trademarks or trademarks of Adobe Sy[...]

64 IBM Maximo for Government: Maximo User ’s Guide Addendum[...]