PRT_ACCJRNL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 DOCUMENT INTEGER 4
3 SEQUENCE INTEGER 4
4 AGENT INTEGER 4
5 PRODUCT CHARACTER(3) 3
6 POLICY INTEGER 4
7 TRANDATE INTEGER 4
8 TRANTIME INTEGER 4
9 REINSURER INTEGER 4
10 RIBROKER INTEGER 4
11 CLAIMNO NUMERIC(11,0) 19
12 INVOICE INTEGER 4
13 SYSTYPE CHARACTER(1) 1
14 JRNLTYPE CHARACTER(1) 1
15 AMTTYPE CHARACTER(1) 1
16 ACCTCODE INTEGER 4
17 AREARESP SMALLINT 2
18 TTYYRMTH INTEGER 4
19 RIACCT CHARACTER(4) 4
20 AMOUNT NUMERIC(13,2) 19
21 COMMENT CHARACTER(40) 40
22 CREATEDTE INTEGER 4
23 USERID CHARACTER(8) 8
24 AUTHORBY1 CHARACTER(8) 8
25 AUTHORBY2 CHARACTER(8) 8
26 AUTHCOMP CHARACTER(1) 1
27 REASONCDE CHARACTER(3) 3
28 UPDATED CHARACTER(1) 1
29 FROMTOIND CHARACTER(1) 1
30 LOCKUSER CHARACTER(8) 8
31 LOCKDATE INTEGER 4
32 LOCKTIME INTEGER 4
33 CLIENT INTEGER 4
34 ORIGATRN CHARACTER(2) 2
35 CUSTREF CHARACTER(14) 14
36 GRSNETIND CHARACTER(1) 1
37 PARTJRNL CHARACTER(1) 1
38 SEQPOLICY INTEGER 4
39 SEQCLIENT INTEGER 4
40 GLJNLTYP CHARACTER(2) 2
41 RECEIPT INTEGER 4
42 RCPTSEQ SMALLINT 2
43 COSTCNTR CHARACTER(4) 4
44 GST NUMERIC(13,2) 19
45 GSTEXCLUD CHARACTER(2) 2
46 JRNLCODE CHARACTER(4) 4
47 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
48 RECORD_TYPE CHARACTER VARYING(16) 16
49 COMMIT_TIMESTAMP TIMESTAMP 8
50 EXTRACT_TIMESTAMP TIMESTAMP 8