OPIC_HST_CUSL

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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