Plusrform table, Plusrformtrans table – IBM TIVOLI SC23-8765-00 User Manual
Page 55

Government Database Tables and Columns
45
PLUSRFORM Table
PLUSRFORMTRANS Table
DELETIONS
1
DECIMAL
15
ENDINGACQCOST
1
DECIMAL
15
ENDINGQUANTITY
1
INTEGER
12
MISSINGUIIACQCOST
1
DECIMAL
15
MISSINGUIIQUANTITY
1
INTEGER
12
ORGID
1
UPPER
8
PLUSRCONTSUMMARYID
1
INTEGER
12
PROPERTYCLASS
1
UPPER
25
COLUMN
REQUIRED
MAXTYPE
LENGTH
COLUMN
REQUIRED
MAXTYPE
LENGTH
CREATEDDATE
1
DATETIME
10
CREATEDPERSONID
1
UPPER
30
FILENAME
1
UPPER
25
FORMNAME
1
UPPER
25
ORGID
1
UPPER
8
PATHNAME
0
ALN
500
PLUSRFORMID
1
INTEGER
12
PROPERTYTRANSID
1
INTEGER
12
SITEID
1
UPPER
8
COLUMN
REQUIRED
MAXTYPE
LENGTH
0
ALN
100
FORMID
1
INTEGER
12
ORGID
1
UPPER
8
PLUSRFORMTRANSID
1
INTEGER
12
SITEID
1
UPPER
8
STATUS
1
UPPER
25
TRANSACTIONDATE
1
DATETIME
10
TRANSPERSONID
1
UPPER
30