Plusrgovcontract table – IBM TIVOLI SC23-8765-00 User Manual

Page 56

Advertising
background image

46

IBM Maximo for Government: Maximo User’s Guide Addendum

PLUSRGOVCONTRACT Table

COLUMN

REQUIRED

MAXTYPE

LENGTH

ACCEPTANCELOSS

1

YORN

1

ACCEPTPERIOD

0

INTEGER

12

AUTOEXTENDPERIOD

0

INTEGER

12

BUYAHEAD

1

YORN

1

BUYOUT

1

YORN

1

CANAUDIT

1

YORN

1

CASUALTYBUYOUT

1

YORN

1

CASUALTYNOTIFY

1

YORN

1

CHANGEBY

0

UPPER

30

CHANGEDATE

1

DATETIME

10

CONDFOREXT

0

ALN

20

CONFIGURENOTIFY

1

YORN

1

CONTACT

0

ALN

50

CONTRACTID

1

INTEGER

12

CONTRACTLEASEID

1

INTEGER

12

CONTRACTNUM

1

UPPER

8

CONTRACTTYPE

1

UPPER

25

CURRENCYCODE

1

UPPER

8

CUSTNOTIFYPERIOD

0

INTEGER

12

CUSTOMERNUM

0

ALN

16

CUSTTERMALLOWED

1

YORN

1

DAYSTONOTIFY

0

INTEGER

12

DESCRIPTION

0

ALN

100

DESCRIPTION_LONGDESCRIPTION

0

LONGALN

32000

ENDDATE

0

DATE

4

ENFORCEBUNDLE

1

YORN

1

EXCHANGEDATE

0

DATE

4

EXCHANGERATE

0

DECIMAL

14

EXCHANGERATE2

0

DECIMAL

14

EXTENDABLE

1

YORN

1

EXTERNALREFID

0

ALN

10

FINANCETYPE

0

ALN

25

Advertising