Government Database Tables and Columns 49
PLUSRHEADER Table
PLUSRPROPERTY Table
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
COLUMN REQUIRED MAXTYPE LENGTH
COLUMN REQUIRED MAXTYPE LENGTH
EMAIL 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
COLUMN REQUIRED MAXTYPE LENGTH
ASSETNUM 0 UPPER 12
CONTRACTNUM 0 UPPER 8
CUSTODIANPERSONID 0 UPPER 30
EMAIL 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