SDW_TSDWF_MRGN_LOAN_AR_SNPST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWF_MRGN_LOAN_AR_SNPST

Columns
# Name Data Type Length
1 MRGN_LOAN_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 MSR_PRD_ID BIGINT 8
10 CRN_BAL NUMERIC(14,2) 19
11 AV_BAL NUMERIC(14,2) 19
12 ACR_INT NUMERIC(23,8) 19
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8