COLUMN | REQUIRED | MAXTYPE | LENGTH |
|
|
|
|
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 |
|
|
|
|
PURCHVIEW Table |
|
|
|
|
|
|
|
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 |
Government Database Tables and Columns | 57 |
