SDW_TSDWF_TRSR_FI_AR_SNPST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWF_TRSR_FI_AR_SNPST

Columns
# Name Data Type Length
1 TRSR_FI_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 CCY_TP_ID BIGINT 8
10 COST_AMT NUMERIC(23,8) 19
11 DCN_AMT NUMERIC(23,8) 19
12 FACE_AMT NUMERIC(23,8) 19
13 PNP_AMT NUMERIC(23,8) 19
14 PROCD_AMT NUMERIC(23,8) 19
15 PREM_AMT NUMERIC(23,8) 19
16 INT_CCY_TP_ID BIGINT 8
17 DCN_RATE NUMERIC(23,8) 19
18 COST_PRC NUMERIC(23,8) 19
19 SPRD_RATE NUMERIC(23,8) 19
20 YLD NUMERIC(23,8) 19
21 PRCH_INT_AMT NUMERIC(23,8) 19
22 SETL_CCY_TP_ID BIGINT 8
23 SETL_AMT NUMERIC(23,8) 19
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8