Chapter 9: government database tables and columns, Asset table, Assetcust table – IBM TIVOLI SC23-8765-00 User Manual
Page 49: Government database tables and columns

© 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