CLL_TCLLF_ASSETLOTDETAILS
Description
Synonyms
SDSNZP02_BANK..QRMCGN_CLL_TCLLF_ASSETLOTDETAILS
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 |