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

Page 55

Advertising
background image

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

EMAIL

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

Advertising