© Copyright IBM Corp. 2007 39
This chapter lists Government-specific database tables and their columns. It also
lists Government-specific columns added to existing Maximo database tables.
ASSET Table
ASSETCUST Table
Government Database
Tables and Columns
9
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
COLUMN REQUIRED MAXTYPE LENGTH
PLUSRUII 0 ALN 100
PLUSRUIIAFFIXDATE 0 DATETIME 10
PLUSRUIIAFFIXED 1 YORN 1
PLUSRUIIAFFIXEDBY 0 UPPER 30