PROPERTY Table
Table - Sorted Table - Copybook - Create Table - Format File - Bulk Insert - Row Size - Back To Table Index
PROPERX_KEY                        	BIGINT
PROPERX_GRPCD                      	TINYINT
PROPERX_DISTRICT                   	TINYINT
LOTTYPE_TYPE_LOT                   	TINYINT
LOTTYPE_WET_LOT                    	VARCHAR(1)
LOTTYPE_SITE_VALUE                 	INT
PROPERTYPE                         	VARCHAR(1)
PROPER_NBR                         	VARCHAR(2)
PROPER_CODE1                       	TINYINT
PROPER_AMOUNT                      	SMALLINT
PROPER_CODE2                       	TINYINT
PROPER_PERCENT2                    	DECIMAL(4,2)
PROPER_VALUE                       	INT
PROPERX_ZONE                       	VARCHAR(4)
PROPER_AGRI_CODE                   	VARCHAR(1)
PROPER_AGRI_YEAR                   	SMALLINT
PROPER_EXCESS_FLAG                 	VARCHAR(1)
PROPER_EFF_YEAR                    	SMALLINT
PROPER_REAPPRAISAL1                	SMALLINT
PROPER_REAPPRAISAL2                	SMALLINT
PROPER_INSPECT_CODE                	TINYINT

21 columns are defined.

To Top - Print

Output Generated By +1DataElements From +1 Software Engineering LLC.
Created on: 23-MAY-2020 11:22 AM