SDW_TSDMD_PORTFOLIO_OPEN_MOVEMENT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_OPENING_MOVEMENT_DIM BIGINT 8
2 GL_PRODUCT_MOVEMENT CHARACTER VARYING(12) 12
3 GL_CC_MOVEMENT CHARACTER VARYING(12) 12
4 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
5 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
6 UPDATE_RUN_AUDIT_ID NUMERIC(38,0) 19
7 GL_PRODUCT_SEQUENCE NUMERIC(38,0) 19
8 GL_CC_SEQUENCE NUMERIC(38,0) 19
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8