PROPERTY Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Row Size - Back To Table Index

Column NameData TypeBytes Used
PROPERX_KEY BIGINT8
PROPERX_GRPCD BYTEINT10
PROPERX_DISTRICT BYTEINT12
LOTTYPE_TYPE_LOT BYTEINT14
LOTTYPE_WET_LOT CHAR(1)15
LOTTYPE_SITE_VALUE INTEGER19
PROPERTYPE CHAR(1)20
PROPER_NBR CHAR(2)22
PROPER_CODE1 BYTEINT24
PROPER_AMOUNT SMALLINT26
PROPER_CODE2 BYTEINT28
PROPER_PERCENT2 DECIMAL(4,2)32
PROPER_VALUE INTEGER36
PROPERX_ZONE CHAR(4)40
PROPER_AGRI_CODE CHAR(1)41
PROPER_AGRI_YEAR SMALLINT43
PROPER_EXCESS_FLAG CHAR(1)44
PROPER_EFF_YEAR SMALLINT46
PROPER_REAPPRAISAL INTEGER50

19 columns are defined.

To Top - Print

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