SDW_TSDWF_DEP_AR_TXN

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWF_DEP_AR_TXN

SDSNZP02_BANK..EFS_SDW_TSDWF_DEP_AR_TXN

SDSNZP02_BANK..UBAR_SDW_TSDWF_DEP_AR_TXN

Columns
# Name Data Type Length
1 DEP_AR_TXN_ID BIGINT 8
2 PST_DT_TM TIMESTAMP 8
3 SRC_STM_ID BIGINT 8
4 AR_ID BIGINT 8
5 TXN_CODE_ID BIGINT 8
6 LOAD_ST_F CHARACTER VARYING(1) 1
7 ISRT_RUN_AUDT_ID BIGINT 8
8 UDT_RUN_AUDT_ID BIGINT 8
9 SRC_AR_CO_CODE CHARACTER VARYING(6) 6
10 SRC_PD_TP_CODE CHARACTER VARYING(6) 6
11 SRC_AC_NBR_CODE CHARACTER VARYING(20) 20
12 SRC_TXN_CO_CODE CHARACTER VARYING(6) 6
13 SRC_PCS_ENV_CODE CHARACTER VARYING(6) 6
14 SRC_PCS_SRC_CODE CHARACTER VARYING(6) 6
15 SRC_PCS_APL_CODE CHARACTER VARYING(6) 6
16 SRC_TXN_CODE CHARACTER VARYING(6) 6
17 SRC_EFF_DT TIMESTAMP 8
18 SRC_BR_CODE CHARACTER VARYING(6) 6
19 AF_PST_BAL NUMERIC(14,2) 19
20 AMT NUMERIC(14,2) 19
21 NBR_OF_DEP_CHQ BIGINT 8
22 PAID_INTO_ODRWN_F CHARACTER VARYING(1) 1
23 DSC CHARACTER VARYING(64) 64
24 OPR_CODE CHARACTER VARYING(20) 20
25 TRC_NBR CHARACTER VARYING(20) 20
26 TXN_CRT_DT TIMESTAMP 8
27 TRF_FM_AC_NBR_CODE CHARACTER VARYING(20) 20
28 TFR_FM_APL_CODE CHARACTER VARYING(6) 6
29 TFR_FM_TXN_CODE CHARACTER VARYING(6) 6
30 TFR_TO_AC_NBR_CODE CHARACTER VARYING(20) 20
31 TFR_TO_APL_CODE CHARACTER VARYING(6) 6
32 TFR_TO_TXN_CODE CHARACTER VARYING(6) 6
33 SRC_OU_IP_ID BIGINT 8
34 STD_PCS_ENV_CODE CHARACTER VARYING(6) 6
35 STD_PCS_SRC_CODE CHARACTER VARYING(6) 6
36 BSN_LOAD_DT TIMESTAMP 8
37 CHK_NBR BIGINT 8
38 SEQ_NBR BIGINT 8
39 TXN_NBR CHARACTER VARYING(12) 12
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8