OPC_HST_CUSL

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_CUSL

Columns
# Name Data Type Length
1 ID BIGINT 8
2 BR CHARACTER VARYING(2) 2
3 CUST CHARACTER VARYING(11) 11
4 PHONECI CHARACTER VARYING(1) 1
5 NETSI CHARACTER VARYING(1) 1
6 NOVIND CHARACTER VARYING(1) 1
7 CPHONE CHARACTER VARYING(20) 20
8 CFAXNO CHARACTER VARYING(20) 20
9 LSTMNTDTE CHARACTER VARYING(10) 10
10 BRTYPE CHARACTER VARYING(1) 1
11 ACCTRELMGR CHARACTER VARYING(3) 3
12 DELAGPAYIND CHARACTER VARYING(1) 1
13 TAXEXEMPTIONCODE CHARACTER VARYING(2) 2
14 TAXEXEMPTIONDATE CHARACTER VARYING(10) 10
15 STATUS CHARACTER VARYING(1) 1
16 STATUSREASONCODE CHARACTER VARYING(2) 2
17 STATUSCHANGEDATE CHARACTER VARYING(10) 10
18 TEXT1 CHARACTER VARYING(20) 20
19 TEXT2 CHARACTER VARYING(20) 20
20 DATE1 CHARACTER VARYING(10) 10
21 DATE2 CHARACTER VARYING(10) 10
22 AMT1 NUMERIC(19,4) 19
23 AMT2 NUMERIC(19,4) 19
24 REGDTE CHARACTER VARYING(10) 10
25 TAXID CHARACTER VARYING(15) 15
26 TAXEXEMPT CHARACTER VARYING(1) 1
27 MANSETTLEIND CHARACTER VARYING(1) 1
28 PRIFIDEX CHARACTER VARYING(1) 1
29 CONFIDEX CHARACTER VARYING(1) 1
30 STATECODE CHARACTER VARYING(5) 5
31 CLSSTARTDATE CHARACTER VARYING(10) 10
32 FIEQACCTNGTYPE CHARACTER VARYING(10) 10
33 BRACCTNGTYPE CHARACTER VARYING(10) 10
34 FINCAL CHARACTER VARYING(15) 15
35 STAMPDUTYIND CHARACTER VARYING(1) 1
36 CHARGESETTIND CHARACTER VARYING(1) 1
37 TAXSTMTFREQ CHARACTER VARYING(1) 1
38 CUTOFFDAYS CHARACTER VARYING(2) 2
39 CUTOFFTIME CHARACTER VARYING(8) 8
40 CLSCONFIRMIND CHARACTER VARYING(1) 1
41 TAXREGNO CHARACTER VARYING(23) 23
42 TAXRETENTIONIND CHARACTER VARYING(1) 1
43 TAXCOMPOUNDIND CHARACTER VARYING(1) 1
44 DELTA_TYPE CHARACTER VARYING(1) 1
45 EFFECTIVE_STRT_DT TIMESTAMP 8
46 EFFECTIVE_END_DT TIMESTAMP 8
47 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
48 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
49 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
50 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8