COLUMN | REQUIRED | MAXTYPE | LENGTH |
|
|
|
|
TOTALCOST | 0 | DECIMAL | 10 |
TRANSFERWARRANTY | 1 | YORN | 1 |
VENDNOTIFYPERIOD | 0 | INTEGER | 12 |
VENDOR | 0 | UPPER | 12 |
VENDORREFNUM | 0 | ALN | 12 |
VENDTERMALLOWED | 1 | YORN | 1 |
WARRANTYDURATION | 0 | INTEGER | 12 |
WARRANTYSTART | 0 | DATE | 4 |
|
|
|
|
PLUSRHEADER Table |
|
|
|
|
|
|
|
COLUMN | REQUIRED | MAXTYPE | LENGTH |
|
|
|
|
0 | ALN | 50 | |
INDUSTRYFLAG | 1 | ALN | 1 |
NAME | 1 | UPPER | 30 |
ORGANIZATION | 1 | UPPER | 20 |
PHONE | 1 | ALN | 20 |
PLUSRHEADERID | 1 | INTEGER | 12 |
RECORDCOUNT | 0 | INTEGER | 12 |
REPORTNUM | 1 | UPPER | 12 |
|
|
|
|
PLUSRPROPERTY Table |
|
|
|
|
|
|
|
COLUMN | REQUIRED | MAXTYPE | LENGTH |
|
|
|
|
ASSETNUM | 0 | UPPER | 12 |
CONTRACTNUM | 0 | UPPER | 8 |
CUSTODIANPERSONID | 0 | UPPER | 30 |
0 | ALN | 100 | |
EXTERNALSYSTEM | 0 | UPPER | 25 |
FILEFORMAT | 0 | UPPER | 25 |
FORMNAME | 0 | UPPER | 25 |
ITEMNUM | 1 | UPPER | 30 |
ITEMSETID | 1 | UPPER | 8 |
LOCATION | 0 | UPPER | 12 |
Government Database Tables and Columns | 49 |
