OBP24_HST_FLX_NP_ACCT_WRITTENOFF_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 WRITTENOFF_DATE TIMESTAMP 8
3 WRITENOFF_REASON CHARACTER VARYING(255) 255
4 SECONDARY_WRITENOFF_REASON CHARACTER VARYING(255) 255
5 CURRENCY_CODE CHARACTER VARYING(3) 3
6 MAKER_NAME CHARACTER VARYING(12) 12
7 MAKER_DATE TIMESTAMP 8
8 CHECKER_NAME CHARACTER VARYING(12) 12
9 CHECKER_DATE TIMESTAMP 8
10 RECORD_STATUS_TYPE CHARACTER VARYING(1) 1
11 VERSION_NUM DOUBLE PRECISION 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