OBP24_HST_FLX_LM_CROP_DETAILS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_LM_CROP_DETAILS

Columns
# Name Data Type Length
1 COLLATERAL_ID CHARACTER VARYING(18) 18
2 SERIAL_NUM INTEGER 4
3 CROP_NAME CHARACTER VARYING(250) 250
4 CROP_TYPE CHARACTER VARYING(50) 50
5 DESCRIPTION CHARACTER VARYING(250) 250
6 AREA_UNIT CHARACTER VARYING(50) 50
7 CULTIVATION_AREA DOUBLE PRECISION 8
8 YIELD_UNIT CHARACTER VARYING(50) 50
9 AVG_YIELD DOUBLE PRECISION 8
10 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8