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

Page 60

Advertising
background image

50

IBM Maximo for Government: Maximo User’s Guide Addendum

PLUSRPROPTRANS Table

MEMO

0

ALN

254

NP_QUANTITY

0

DECIMAL

15

ORGID

1

UPPER

8

PLUSRPROPERTYID

1

INTEGER

12

PROPERTYCLASS

0

UPPER

25

QUANTITY

1

DECIMAL

15

SITEID

1

UPPER

8

SOURCE

0

UPPER

25

TOCONTRACTNUM

0

UPPER

8

TOCUSTODIAN

0

UPPER

30

TOUSER

0

UPPER

30

TRANSACTIONDATE

0

DATETIME

10

TRANSACTIONNAME

0

UPPER

25

USERPERSONID

0

UPPER

30

COLUMN

REQUIRED

MAXTYPE

LENGTH

COLUMN

REQUIRED

MAXTYPE

LENGTH

ACCEPTANCECODE

0

ALN

6

ACCEPTANCEDATE

0

DATETIME

10

ACQUISITIONCOST

0

AMOUNT

10

ACTION

0

UPPER

3

ACTIONTYPE

0

UPPER

3

ACTIVITYTYPE

0

UPPER

3

ASSETNUM

0

UPPER

12

BAGTAGCODE

0

UPPER

1

BATCHLOT

0

UPPER

30

CATEGORYCODE

0

UPPER

1

COMPLIANTMARK

1

YORN

1

COUNT

1

INTEGER

12

CURRENCYCODE

0

UPPER

8

CURRENTPARTDATE

0

DATETIME

10

CURRENTPARTNUMBER

0

UPPER

30

DIRECTIONFLAG

0

UPPER

1

Advertising