CLMS_ARLBALSINST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_CLMS_ARLBALSINST

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 ACCOUNT INTEGER 4
3 INSTALMENT_FLAG INTEGER 4
4 INSTALMENT_DATE TIMESTAMP 8
5 INSTALMENT_AMNT NUMERIC(12,2) 19
6 GST_AMNT NUMERIC(12,2) 19
7 STAMP_DUTY NUMERIC(12,2) 19
8 DATA_DATE TIMESTAMP 8
9 LOAD_ID INTEGER 4
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8