SDW_TSDWF_TRSR_DEPLN_AR_SNPST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWF_TRSR_DEPLN_AR_SNPST

Columns
# Name Data Type Length
1 TRSR_DEPLN_AR_SNPST_ID BIGINT 8
2 AR_ID BIGINT 8
3 SNPST_DT TIMESTAMP 8
4 SNPST_RCRD_TP_ID BIGINT 8
5 SRC_STM_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 ACR_OTSND_AMT NUMERIC(23,8) 19
10 CCY_TP_ID BIGINT 8
11 CCY_AMT NUMERIC(23,8) 19
12 PREM_DCN_AMZTD_AMT NUMERIC(23,8) 19
13 AR_INCM_EXPN_TP_ID BIGINT 8
14 INT_PRD_STRT_DT TIMESTAMP 8
15 INT_PRD_END_DT TIMESTAMP 8
16 INT_PYMT_DT TIMESTAMP 8
17 INT_AMT NUMERIC(14,2) 19
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8