LAND CREATE TABLE Script
Table - Sorted Table - Copybook - Create Table - Row Size - Back To Table Index

/*
   CREATE TABLE Script For LAND Table
   Created on: 23-MAY-2020 10:29 AM
   Created by: +1Copybook (C)
*/

CREATE TABLE LAND (
PROPERX_KEY                        	BIGINT,
PROPERX_GRPCD                      	BYTEINT,
PROPERX_DISTRICT                   	BYTEINT,
LOTTYPE_TYPE_LOT                   	BYTEINT,
LOTTYPE_WET_LOT                    	CHAR(1),
LOTTYPE_SITE_VALUE                 	INTEGER,
PROPERTYPE                         	CHAR(1),
PROPER_NBR                         	CHAR(2),
O_UNPACKED                         	VARCHAR(30),
PROPER_CODE1                       	BYTEINT,
PROPER_AMOUNT1                     	SMALLINT,
PROPER_CODE2                       	BYTEINT,
PROPER_PERCENT2                    	DECIMAL(4,2),
PROPER_VALUE                       	INTEGER,
PROPERX_ZONE                       	CHAR(4),
PROPER_AGRI_CODE                   	CHAR(1),
PROPER_AGRI_YEAR                   	SMALLINT,
PROPER_EXCESS_FLAG                 	CHAR(1),
PROPER_EFF_YEAR                    	SMALLINT,
PROPER_REAPPRAISAL                 	INTEGER
)
/


To Top - Print - copybook.txt

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