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 |
|
|
|
|
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 |