COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

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

 

 

 

 

PLUSRFORM Table

 

 

 

 

 

 

 

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

 

 

 

 

PLUSRFORMTRANS Table

 

 

 

 

 

 

 

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

 

 

 

 

Government Database Tables and Columns

45

Page 55
Image 55
IBM SC23-8765-00 manual Plusrform Table, Plusrformtrans Table