OPIC_ZCUSTTAX

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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