CFD_TCFDR_BILLER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BILLER_ID BIGINT 8
2 BILLER_CODE CHARACTER VARYING(10) 10
3 SERV_CODE BIGINT 8
4 PAYT_METH_CODE BIGINT 8
5 ACTVT_DATE TIMESTAMP 8
6 DEACTIVATE_DATE TIMESTAMP 8
7 REVISION_DATE TIMESTAMP 8
8 CLOSE_DATE TIMESTAMP 8
9 CLOSE_RSN_CODE BIGINT 8
10 BILLER_SHRT_NAM CHARACTER VARYING(50) 50
11 BILLER_LONG_NAM CHARACTER VARYING(100) 100
12 MCC_CODE CHARACTER VARYING(10) 10
13 VARIABLE_CRN_IND CHARACTER VARYING(3) 3
14 BILLER_INSTU_CODE CHARACTER VARYING(10) 10
15 MIN_PAYT_AMT NUMERIC(18,6) 19
16 UPR_LIM_PAYT_AMT NUMERIC(18,6) 19
17 CRN_NAM CHARACTER VARYING(50) 50
18 CRN_LOCN_CODE CHARACTER VARYING(100) 100
19 EFF_STRT_DATE TIMESTAMP 8
20 EFF_END_DATE TIMESTAMP 8
21 SNPSHT_DATE TIMESTAMP 8
22 DATA_LOAD_DATE TIMESTAMP 8
23 SRC_SYS_ID CHARACTER VARYING(5) 5
24 LOAD_ID BIGINT 8
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8