CFD_TCFDD_ACCT_CYCLIC_TRANSFERS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
3 SEQ_NUM BIGINT 8
4 EFF_STRT_DATE TIMESTAMP 8
5 DPTS_PRDT_HOLDNG_ID BIGINT 8
6 SRC_SYS_CMPY_CODE CHARACTER VARYING(10) 10
7 SRC_ACCT_NUM CHARACTER VARYING(20) 20
8 CDS_TYP_CODE CHARACTER VARYING(10) 10
9 TRGR_FREQ_CODE BIGINT 8
10 TRGR_PERD_CODE CHARACTER VARYING(10) 10
11 LST_CYC_DATE TIMESTAMP 8
12 TRGR_EXCPTN_CODE CHARACTER VARYING(10) 10
13 TRGR_FRST_DATE TIMESTAMP 8
14 TRGR_LST_DATE TIMESTAMP 8
15 TRGR_APPL_NUM CHARACTER VARYING(10) 10
16 TXN_NUM BIGINT 8
17 BSB_NUM CHARACTER VARYING(10) 10
18 TRGR_IND CHARACTER VARYING(3) 3
19 DEST_CMPY_CODE CHARACTER VARYING(10) 10
20 DEST_ACCT_NUM CHARACTER VARYING(20) 20
21 BILLER_CODE CHARACTER VARYING(10) 10
22 DEST_TXN_NUM CHARACTER VARYING(10) 10
23 DEST_APPL_NUM CHARACTER VARYING(10) 10
24 TXN_AMT NUMERIC(18,6) 19
25 ACCT_TITLE CHARACTER VARYING(100) 100
26 LODGE_REF_NUM CHARACTER VARYING(20) 20
27 LST_PAYT_DATE TIMESTAMP 8
28 TRGR_TRY_CNT BIGINT 8
29 TRGR_RETRY_CNT BIGINT 8
30 CNSCTV_FAIL_CNT BIGINT 8
31 INSERT_UID CHARACTER VARYING(20) 20
32 INSERT_DATE TIMESTAMP 8
33 UPDD_UID CHARACTER VARYING(20) 20
34 UPDD_DATE TIMESTAMP 8
35 TRGR_STAT_CODE CHARACTER VARYING(20) 20
36 TRGR_SSPND_CNT BIGINT 8
37 ATHRTY_1 CHARACTER VARYING(50) 50
38 ATHRTY_2 CHARACTER VARYING(50) 50
39 EFF_END_DATE TIMESTAMP 8
40 DATA_LOAD_DATE TIMESTAMP 8
41 SNPSHT_DATE TIMESTAMP 8
42 SRC_SYS_ID CHARACTER VARYING(5) 5
43 LOAD_ID BIGINT 8
44 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
45 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
46 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
47 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
48 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8