CLL_TCLLF_REALPROPERTY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..QRMCGN_CLL_TCLLF_REALPROPERTY

Columns
# Name Data Type Length
1 ASSET_ID BIGINT 8
2 INSTRUMENT_NO CHARACTER VARYING(20) 20
3 REGD_COVANENT_NO CHARACTER VARYING(100) 100
4 RESTRICT_MINING_RIGHTS_TFR CHARACTER VARYING(100) 100
5 DEVELOPMENT_ACT_DETAIL CHARACTER VARYING(100) 100
6 FREEHOLD_OVERLEASE_NO CHARACTER VARYING(10) 10
7 STATE_LEASE_NO CHARACTER VARYING(10) 10
8 LEASE_DATE TIMESTAMP 8
9 LEASE_MATURITY_DATE TIMESTAMP 8
10 SUBTO_LAND_TAX_FLAG CHARACTER VARYING(1) 1
11 LAND_SIZE BIGINT 8
12 BASEL_USE CHARACTER VARYING(10) 10
13 USE CHARACTER VARYING(10) 10
14 REVALUATION_PERIOD BYTEINT 1
15 PROP_UNDER_CONSTRUCT_FLAG CHARACTER VARYING(1) 1
16 ENVIRONMENT_RISK_FLAG CHARACTER VARYING(1) 1
17 DISPOSAL_COSTPCT NUMERIC(5,2) 19
18 TITLE_REFERENCE BIGINT 8
19 FOLIO_IDENTIFIER CHARACTER VARYING(15) 15
20 VOLUME INTEGER 4
21 FOLIO CHARACTER VARYING(4) 4
22 DWELLING_IND CHARACTER VARYING(1) 1
23 OCCUPANCY CHARACTER VARYING(15) 15