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