PRT_CLIENT_CTP

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLIENT INTEGER 4
3 POSTNREF1 INTEGER 4
4 POSTNREF2 INTEGER 4
5 POSTALREF INTEGER 4
6 CLTMSGIND CHARACTER(1) 1
7 MARKTMAIL CHARACTER(1) 1
8 REFERDECL CHARACTER(1) 1
9 CONCAGREE CHARACTER(1) 1
10 NONAMES SMALLINT 2
11 CREATEDTE INTEGER 4
12 MAINTDATE INTEGER 4
13 LOCKDATE INTEGER 4
14 LOCKTIME INTEGER 4
15 NOPOLICY SMALLINT 2
16 NOCLAIMS INTEGER 4
17 LASTAGENT INTEGER 4
18 TRDNGREF INTEGER 4
19 SEQUENCE INTEGER 4
20 EREGIND CHARACTER(1) 1
21 CLTGRPTYP CHARACTER(1) 1
22 EMAILADD CHARACTER VARYING(120) 120
23 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 RECORD_TYPE CHARACTER VARYING(16) 16
25 COMMIT_TIMESTAMP TIMESTAMP 8
26 EXTRACT_TIMESTAMP TIMESTAMP 8
27 CDC_ID BIGINT 8
28 COMPANY_CDC SMALLINT 2
29 DW_TIMESTAMP TIMESTAMP 8
30 CONTACT CHARACTER(80) 80
31 CLNTTYPE CHARACTER(2) 2
32 TELPRIV CHARACTER(10) 10
33 STDPRIV CHARACTER(10) 10
34 TELBUS CHARACTER(10) 10
35 STDBUS CHARACTER(10) 10
36 FAXNO CHARACTER(10) 10
37 INTROTYPE CHARACTER(4) 4
38 INTROCODE CHARACTER(4) 4
39 BULKPAYMT CHARACTER(2) 2
40 CHEQUENME CHARACTER(40) 40
41 USERID CHARACTER(8) 8
42 LOCKUSER CHARACTER(8) 8
43 STDFAX CHARACTER(4) 4
44 TELMOB CHARACTER(12) 12
45 CORPID CHARACTER(4) 4