CLL_TCLLF_CHATTEL_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ASSET_ID BIGINT 8
2 BUSINESS_NAME CHARACTER VARYING(100) 100
3 BUSINESS_ADDRESS_ID BIGINT 8
4 CHATTEL_OWNED_PURCHASED CHARACTER VARYING(10) 10
5 BLOODSTOCK_TYPE CHARACTER VARYING(10) 10
6 YEAR_OF_BIRTH SMALLINT 2
7 NAME_OF_HORSE CHARACTER VARYING(100) 100
8 MICROCHIP_NO CHARACTER VARYING(30) 30
9 BRAND CHARACTER VARYING(100) 100
10 MARKING_DESCRIPTION CHARACTER VARYING(100) 100
11 SIRE_DAM CHARACTER VARYING(4) 4
12 DESCRIPTION_OF_STOCK CHARACTER VARYING(300) 300
13 QUANTITY SMALLINT 2
14 DESCRIPTION_OF_GOODS CHARACTER VARYING(300) 300
15 LIQUOR_LICENCE_NO NUMERIC(20,0) 19
16 TAXI_LICENCE_NO CHARACTER VARYING(20) 20
17 TAXI_METER_SERIAL_NO CHARACTER VARYING(20) 20
18 LICENCED_PREMISE_NAME CHARACTER VARYING(100) 100
19 MANUFACTURERS_NAME CHARACTER VARYING(100) 100
20 MANUFACTURERS_MODEL CHARACTER VARYING(50) 50
21 NATIONALITY CHARACTER VARYING(50) 50
22 SERIAL_NO CHARACTER VARYING(100) 100