OBP24_CZ_SC_OR_CTR_BIZ_INCM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_CZ_SC_OR_CTR_BIZ_INCM

Columns
# Name Data Type Length
1 BIZ_INCOME_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 AUTO_APPLICANT_ID CHARACTER VARYING(40) 40
4 INCM_SOURCE CHARACTER VARYING(50) 50
5 INCM_ISNET CHARACTER VARYING(1) 1
6 INCM_E_STATUS CHARACTER VARYING(50) 50
7 INCM_AMT DOUBLE PRECISION 8
8 INCM_PERIOD CHARACTER VARYING(50) 50
9 ACT_INCM_M DOUBLE PRECISION 8
10 ACT_INCM_Y DOUBLE PRECISION 8
11 ALL_INCM_M DOUBLE PRECISION 8
12 ALL_INCM_Y DOUBLE PRECISION 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8