PRT_CTPEXCLG

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

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