PROPERTY CREATE TABLE Script
Table - Sorted Table - Copybook - Create Table - Load File - Row Size - Back To Table Index

---
---   CREATE TABLE Script For PROPERTY Table
---   Created on: 23-MAY-2020 10:46 AM
---   Created by: +1Copybook (C)
---

CREATE TABLE PROPERTY (
PROPERX_KEY                        	BIGINT,
PROPERX_GRPCD                      	SMALLINT,
PROPERX_DISTRICT                   	SMALLINT,
LOTTYPE_TYPE_LOT                   	SMALLINT,
LOTTYPE_WET_LOT                    	VARCHAR(1),
LOTTYPE_SITE_VALUE                 	INT,
PROPERTYPE                         	VARCHAR(1),
PROPER_NBR                         	VARCHAR(2),
PROPER_CODE1                       	SMALLINT,
PROPER_AMOUNT                      	SMALLINT,
PROPER_CODE2                       	SMALLINT,
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_REAPPRAISAL                 	INT
)
/


To Top - Print - copybook.txt

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