INT_PCSRCPN_PRT_CLIENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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