PRT_CTPEXCPT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 RUNNO INTEGER 4
6 TRANSEQ INTEGER 4
7 INTERTYP CHARACTER(3) 3
8 CLASS CHARACTER(3) 3
9 RUNDATE INTEGER 4
10 TRANDATE INTEGER 4
11 PROCSTATUS CHARACTER(2) 2
12 TRANCODE CHARACTER(3) 3
13 MVREG CHARACTER(12) 12
14 CTPNO CHARACTER(12) 12
15 REPLYBYDATE INTEGER 4
16 SEQPOLICY INTEGER 4
17 REPLYCODE CHARACTER(1) 1
18 REPLYREASON CHARACTER(2) 2
19 RERUNTRAN CHARACTER(1) 1
20 MANUALMATCH CHARACTER(1) 1
21 REPLYCTPNO CHARACTER(12) 12
22 REPLYSENT CHARACTER(1) 1
23 TAPEDATE INTEGER 4
24 LASTUSER CHARACTER(8) 8
25 UPDATEDATE INTEGER 4
26 UPDATETIME INTEGER 4
27 TRANDATA CHARACTER VARYING(2000) 2000
28 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 RECORD_TYPE CHARACTER VARYING(16) 16
30 COMMIT_TIMESTAMP TIMESTAMP 8
31 EXTRACT_TIMESTAMP TIMESTAMP 8
32 VEHID NUMERIC(15,0) 19
33 REGOID NUMERIC(10,0) 19
34 EXTREFID CHARACTER(15) 15
35 TRANSUBSEQ SMALLINT 2
36 ACTIONCODE CHARACTER(4) 4
37 COMMENTS CHARACTER VARYING(250) 250