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

Advertising
background image

© 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

Advertising