Government Database Tables and Columns | IBM SC23-8765-00 guide

Government Database	9
Government Database
Tables and Columns

This chapter lists Government-specific database tables and their columns. It also lists Government-specific columns added to existing Maximo database tables.

ASSET Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRUII	0	ALN	100
PLUSRUIIAFFIXDATE	0	DATETIME	10
PLUSRUIIAFFIXED	1	YORN	1
PLUSRUIIAFFIXEDBY	0	UPPER	30
PLUSRUIIASSETUID	0	UPPER	30
PLUSRUIIBAGGTAGG	0	UPPER	1
PLUSRUIIEID	0	UPPER	25
PLUSRUIIIAC	0	UPPER	25
PLUSRUIILOTBATCH	0	UPPER	30
PLUSRUIIMARK	0	ALN	256
PLUSRUIIORIITEMNUM	0	UPPER	30
PLUSRUIIRENDERDATE	0	DATETIME	10
PLUSRUIIRENDERED	1	YORN	1
PLUSRUIIRENDEREDBY	0	UPPER	30
PLUSRUIIREQUIRED	1	YORN	1
PLUSRUIITEMPLATE	0	UPPER	25
PLUSRUIITYPE	0	UPPER	25

ASSETCUST Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRUII	0	ALN	100
PLUSRUIIAFFIXDATE	0	DATETIME	10
PLUSRUIIAFFIXED	1	YORN	1
PLUSRUIIAFFIXEDBY	0	UPPER	30

© Copyright IBM Corp. 2007

39

Image 49

IBM SC23-8765-00 manual Government Database Tables and Columns, Asset Table, Assetcust Table

Contents

Maximo User’s Guide Addendum Page Contents Inventory Module Resources Module IBM Maximo for Government Maximo User’s Guide Addendum Intended Audience About This PublicationRelated Information Document Description IBM Support About This Publication IBM Support Government-specific Functions Government Features Application Government-specific Functions Government Features IBM Maximo for Government Maximo User’s Guide Addendum Government Application in the Administration Module Administration ModuleOrganizations Gv Application Tabs UII Templates Property Transaction DefinitionsProperty Transaction Definitions Dialog Box UII Templates Dialog Box Government Defaults Dialog Box Government Defaults Organizations Gv Application Assets Gv Application Assets ModuleGovernment Applications in the Assets Module Add Property Record Assets Gv ActionsCapture UIIs Property Tab Locations Gv Application Locations Gv Actions Create Property Upload Files Locations Gv Application Government Contracts Gv Application Contracts ModuleGovernment Application in the Contracts Module Properties Tab Contract TabContract Tab Terms and Conditions Tab Contract Lines TabProperty Summary Tab Property Tab Government Contracts Gv Actions Government Applications in the Inventory Module Inventory one Module5 Inventory Gv Actions Inventory Gv ApplicationInventory Tab Item Master Gv Application Item Tab Item Master Gv Actions Issue Tab Issues and Transfers Gv ApplicationIssue Tab Transfer In Tab Transfer Out TabTransfer Out Tab Storerooms Gv Application Issues and Transfers Gv ActionsTransfer In Tab Storerooms Gv Actions Personal Property Gv Application Personal Property Gv ModuleGovernment Application in the Personal Property Gv Module Personal Property Gv Actions Create Property Transaction Reports Minus Property TransactionView Property Transaction Reports Run Property Transaction Reports Edit Property Transaction Reports Companies Gv Application Purchasing ModuleGovernment Applications in the Purchasing Module Company Tab Company Tab Companies Gv Actions Receiving Gv Application Material Receipts Tab Receiving Actions Assign / Mark UIIs Receiving Gv Application People Gv Application Resources ModuleGovernment Application in the Resources Module People Gv Actions Asset Table Government Database Tables and ColumnsAssetcust Table Contract Table Companies Table Contractline Table Issuecurrentitem TableInventory Table Item Table Leaseview Table Laborview Table Masterview Table Leaseviewline TableMatrectrans Table Maxvarinput Table Matusetrans TablePlusrcontsumhead Table Plusrcontsummary Table Plusrformtrans Table Plusrform Table Plusrgovcontract Table FOB ALN Freightterms Freighttermslongdescription Longaln Revcommentslongdescription Longaln Plusrproperty Table Plusrheader Table Plusrproptrans Table Fromuiimark ALN Touiimark ALN Plusrtransextsys Table Plusrtransaction TablePlusrtransform Table Plusruiitemplate Table Plusruploadfile Table Plusrupload TablePlusruploadtrans Table Plusrvproperty Table Plusrvheader Table Plusrvupload Table Purchview Table Toolinv Table Serviceitems TableToolitem Table Transfercuritem Table Warrantyviewline Table Warrantyview Table IBM Maximo for Government Maximo User’s Guide Addendum Copyright IBM Corp IBM Maximo for Government Maximo User’s Guide Addendum IBM AIX Trademarks IBM Maximo for Government Maximo User’s Guide Addendum