PRT_HST_AGENT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

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