INT_PCSRCPN_AGENT

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 AGENT INTEGER 4
10 EFFECTDTE INTEGER 4
11 AGTSTATUS CHARACTER(1) 1
12 ABBRADDR CHARACTER(50) 50
13 AGENTTYPE CHARACTER(1) 1
14 REP SMALLINT 2
15 COMAUTCHQ CHARACTER(1) 1
16 COMSCALE SMALLINT 2
17 ORIDEAGNT INTEGER 4
18 ORIDESCAL SMALLINT 2
19 PREMRESP CHARACTER(1) 1
20 CREDTERMS SMALLINT 2
21 NTCETO CHARACTER(1) 1
22 NTCEFREQ CHARACTER(1) 1
23 INDXORIDE CHARACTER(1) 1
24 REPWORDNG CHARACTER(1) 1
25 AGENCYGRP SMALLINT 2
26 STATE SMALLINT 2
27 BRANCH SMALLINT 2
28 CLNTSTMT CHARACTER(1) 1
29 RENEWLIST CHARACTER(1) 1
30 STATIONRY CHARACTER(2) 2
31 OLDAGENT INTEGER 4
32 PREVCUTOF INTEGER 4
33 DATAINPUT CHARACTER(1) 1
34 PROCESS CHARACTER(1) 1
35 RECONTYPE CHARACTER(1) 1
36 RECEIPTPR CHARACTER(1) 1
37 RECEIPTNO INTEGER 4
38 SEQUENCE SMALLINT 2
39 BFSTMT CHARACTER(1) 1
40 INSTALFLG CHARACTER(1) 1
41 BFAMOUNT NUMERIC(11,2) 19
42 INCEPTION CHARACTER(1) 1
43 AGTACCTYP CHARACTER(1) 1
44 INSTALPD NUMERIC(11,2) 19
45 COMDEDUCT NUMERIC(11,2) 19
46 INSTALBF NUMERIC(11,2) 19
47 INSTALNB NUMERIC(11,2) 19
48 INSTALEP NUMERIC(11,2) 19
49 INSTALRP NUMERIC(11,2) 19
50 INSTALCRE NUMERIC(11,2) 19
51 INSTALNRE NUMERIC(11,2) 19
52 INSTALVAR NUMERIC(11,2) 19
53 INSTALCOM NUMERIC(11,2) 19
54 FRECONDTE INTEGER 4
55 FRECONTME INTEGER 4
56 PRECONDTE INTEGER 4
57 PRECONTME INTEGER 4
58 CREATEDTE INTEGER 4
59 MAINTDTE INTEGER 4
60 USERID CHARACTER(8) 8
61 COMGROSIN CHARACTER(1) 1
62 AGTMSGIND CHARACTER(1) 1
63 ADDRNOTIC CHARACTER(1) 1
64 AUTORENWL CHARACTER(1) 1
65 DEFLTRATE CHARACTER(1) 1
66 EXCEPTCLS CHARACTER(30) 30
67 LOCKUSER CHARACTER(8) 8
68 LOCKDATE INTEGER 4
69 LOCKTIME INTEGER 4
70 USEAGTREP CHARACTER(1) 1
71 SEQAGENT INTEGER 4
72 GSTCOMMEX CHARACTER(2) 2
73 AGTGROUP INTEGER 4