PROPERTY Create Table
Table - Sorted Table - Copybook - Control File - Create Table - Sorted Create Table - Row Size - Back To Table Index
/*
   CREATE TABLE Script For PROPERTY Table
   Created on: 23-MAY-2020 3:50 PM
   Created by: +1DataElements (C)
*/

CREATE TABLE PROPERTY (
PROPERX_KEY                        	NUMBER(13),
PROPERX_GRPCD                      	NUMBER(2),
PROPERX_DISTRICT                   	NUMBER(2),
LOTTYPE_TYPE_LOT                   	NUMBER(2),
LOTTYPE_WET_LOT                    	VARCHAR2(1),
LOTTYPE_SITE_VALUE                 	NUMBER(9),
PROPERTYPE                         	VARCHAR2(1),
PROPER_NBR                         	VARCHAR2(2),
PROPER_CODE1                       	NUMBER(1),
PROPER_AMOUNT                      	NUMBER(4),
PROPER_CODE2                       	NUMBER(1),
PROPER_PERCENT2                    	NUMBER(3,2),
PROPER_VALUE                       	NUMBER(9),
PROPERX_ZONE                       	VARCHAR2(4),
PROPER_AGRI_CODE                   	VARCHAR2(1),
PROPER_AGRI_YEAR                   	NUMBER(4),
PROPER_EXCESS_FLAG                 	VARCHAR2(1),
PROPER_EFF_YEAR                    	NUMBER(4),
PROPER_REAPPRAISAL1                	NUMBER(3),
PROPER_REAPPRAISAL2                	NUMBER(4),
PROPER_INSPECT_CODE                	NUMBER(2)
)

To Top - Print

Output Generated By +1DataElements From +1 Software Engineering LLC.
Created on: 23-MAY-2020 03:50 PM