IBM TIVOLI SC23-8765-00 - Manual (Page 67)

Government Database Tables and Columns 57
PURCHVIEW Table
NEWASSETSTATUS 0 ALN 20
ORGID 1 UPPER 8
PLUSRPROPERTYID 1 INTEGER 12
PLUSRPROPTRANSID 1 INTEGER 12
PLUSRTRANSACTIONID 1 INTEGER 12
PLUSRTRANSEXTSYSID 1 INTEGER 12
PROPERTYCLASS 0 UPPER 25
QUANTITY 1 DECIMAL 15
SITEID 1 UPPER 8
SOURCE 0 UPPER 25
TOPARENT 0 UPPER 12
TOPRICE 0 AMOUNT 10
TOPROPERTYID 0 INTEGER 12
TOSITE 0 UPPER 8
TOSTATUS 0 ALN 20
TOUII 0 ALN 100
TOUIIMARK 0 ALN 256
TRANSACTIONDATE 1 DATETIME 10
TRANSACTIONID 1 INTEGER 12
TRANSACTIONMEMO 0 ALN 254
TRANSACTIONMEMO_LONGDESCRIPTION 0 LONGALN 32000
TRANSACTIONNAME 1 UPPER 25
TRANSPERSONID 1 UPPER 30
USERPERSONID 0 UPPER 30
COLUMN REQUIRED MAXTYPE LENGTH
COLUMN REQUIRED MAXTYPE LENGTH
PLUSRCAPRECEIPTS 1 YORN 1
PLUSRCONTRACTADMIN 0 UPPER 30
PLUSRCONTRACTOR 0 UPPER 12
PLUSRCONTRACTTYPE 0 UPPER 25
PLUSRCUSTOMER 0 UPPER 12
PLUSRGFPRECEIPTS 1 YORN 1