CLL_TCLLF_ASSETLOTDETAILS_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ASSETLOTDETAILS_ID BIGINT 8
2 LOT CHARACTER VARYING(6) 6
3 PLAN_TYPE CHARACTER VARYING(10) 10
4 PLAN_NO CHARACTER VARYING(12) 12
5 LOCATION CHARACTER VARYING(50) 50
6 DISTRICT_DIVISION CHARACTER VARYING(50) 50
7 SECTION INTEGER 4
8 BLOCK INTEGER 4
9 UNIT INTEGER 4
10 EXTENT_OF_LAND CHARACTER VARYING(10) 10
11 COUNTY CHARACTER VARYING(50) 50
12 PARISH CHARACTER VARYING(30) 30
13 ASSET_ID BIGINT 8
14 CREATED_BY CHARACTER VARYING(7) 7
15 CREATED_DATE TIMESTAMP 8
16 MODIFIED_BY CHARACTER VARYING(7) 7
17 MODIFIED_DATE TIMESTAMP 8
18 DELETED_FLAG CHARACTER VARYING(1) 1
19 VERSION_NO INTEGER 4