SLN_FACILITY_MARGINS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_SLN_FACILITY_MARGINS

SDSNZP02_BANK..UBAR_SLN_FACILITY_MARGINS

Columns
# Name Data Type Length
1 SLN_FACILITY_MARGINS_HIID BIGINT 8
2 ACTION_CODE CHARACTER(1) 1
3 FACILITY_ID CHARACTER VARYING(20) 20
4 MARGIN_CODE CHARACTER VARYING(60) 60
5 MARGIN_SUB_CODE CHARACTER VARYING(60) 60
6 MARGIN_START CHARACTER VARYING(20) 20
7 MARGIN_END CHARACTER VARYING(20) 20
8 MARGIN_RATE NUMERIC(6,3) 19
9 AGGREGATE_AMOUNT NUMERIC(13,2) 19
10 MARGIN_AUTHORITY CHARACTER VARYING(12) 12
11 DELTA_TYPE CHARACTER VARYING(1) 1
12 EFFECTIVE_STRT_DT TIMESTAMP 8
13 EFFECTIVE_END_DT TIMESTAMP 8
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8