SDW_TCLAM_ABS_SECURITISEDLOANS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PCD_ACCT_NBR CHARACTER VARYING(16) 16
2 PCD_ACT_D CHARACTER VARYING(8) 8
3 TRUST_ID CHARACTER VARYING(10) 10
4 FIXED_VARIABLE_FLAG CHARACTER(1) 1
5 COST_CENTRE CHARACTER VARYING(7) 7
6 DEPARTMENT_ID CHARACTER VARYING(4) 4
7 GL_TYPE_CODE CHARACTER VARYING(6) 6
8 PRODUCT_CODE CHARACTER VARYING(5) 5
9 CAP_RELIEF_FLAG CHARACTER(1) 1
10 LOAN_SYSTEM_FLAG CHARACTER VARYING(3) 3
11 BSN_LOAD_DT TIMESTAMP 8
12 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
13 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
14 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
15 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8