OPC_HST_ZCUSTTAX

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_ZCUSTTAX

Columns
# Name Data Type Length
1 ID BIGINT 8
2 IOPER CHARACTER VARYING(4) 4
3 LSTMNTDATE CHARACTER VARYING(10) 10
4 LSTMNTTIME CHARACTER VARYING(8) 8
5 ZCUSTCNO CHARACTER VARYING(11) 11
6 ZCUSTCNOID CHARACTER VARYING(5) 5
7 ZCUSTTAXID CHARACTER VARYING(5) 5
8 TAXITEMDESC CHARACTER VARYING(40) 40
9 TAXNUMBER CHARACTER VARYING(20) 20
10 TAXNUMBERENCRYPT CHARACTER VARYING(1024) 1024
11 TEXT1 CHARACTER VARYING(50) 50
12 TEXT2 CHARACTER VARYING(50) 50
13 DELETEDATE CHARACTER VARYING(10) 10
14 DELTA_TYPE CHARACTER VARYING(1) 1
15 EFFECTIVE_STRT_DT TIMESTAMP 8
16 EFFECTIVE_END_DT TIMESTAMP 8
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8