PRT_GLTRNDTL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 BRANCH SMALLINT 2
5 TRANDATE INTEGER 4
6 TRANTIME INTEGER 4
7 BATCHNO NUMERIC(9,0) 19
8 ACCTCODE INTEGER 4
9 AREARESP SMALLINT 2
10 TRANTYPE CHARACTER(2) 2
11 DOCUMENT INTEGER 4
12 GLDAY SMALLINT 2
13 GLMONTH SMALLINT 2
14 GLYEAR SMALLINT 2
15 AMOUNT NUMERIC(13,2) 19
16 USERID CHARACTER(8) 8
17 PROGID CHARACTER(8) 8
18 EXTRDATE INTEGER 4
19 EXTRTIME INTEGER 4
20 DEFERIND CHARACTER(1) 1
21 PRODUCT CHARACTER(3) 3
22 CLASS CHARACTER(3) 3
23 SUBCLASS CHARACTER(3) 3
24 AGTACCTYP CHARACTER(1) 1
25 REP SMALLINT 2
26 MISCTYPE CHARACTER(2) 2
27 MISCDATA CHARACTER(10) 10
28 POLICY INTEGER 4
29 CLAIMNO NUMERIC(11,0) 19
30 BRCHRESP SMALLINT 2
31 RECEIPT INTEGER 4
32 SEQUENCE INTEGER 4
33 RECTTOT NUMERIC(13,2) 19
34 CHQRUN INTEGER 4
35 CHEQUENO INTEGER 4
36 PAYMENTNO INTEGER 4
37 INVOICE INTEGER 4
38 AGENT INTEGER 4
39 REINSURER INTEGER 4
40 RIBROKER INTEGER 4
41 RIACCT CHARACTER(4) 4
42 EFTNO CHARACTER(10) 10
43 BPAYREC CHARACTER(21) 21
44 ENTRSTAT CHARACTER(1) 1
45 TIDDREC CHARACTER(8) 8
46 VOUCHTRC CHARACTER(16) 16
47 MERCHNO INTEGER 4
48 BSBNO CHARACTER(6) 6
49 DEBITACCT CHARACTER(9) 9
50 CREDCARDID CHARACTER(20) 20
51 BANKACCT CHARACTER(10) 10
52 BANKTRNS SMALLINT 2
53 COMMENT CHARACTER(60) 60
54 OGLENTITY CHARACTER(6) 6
55 OGLCENTRE CHARACTER(4) 4
56 OGLACCT CHARACTER(8) 8
57 OGLCATGORY CHARACTER(3) 3
58 OGLSTATE CHARACTER(1) 1
59 OGLPRODUCT CHARACTER(6) 6
60 OGLCLASS CHARACTER(2) 2
61 OGLCHANNEL CHARACTER(5) 5
62 OGLPROJECT CHARACTER(3) 3
63 OGLINTRCOY CHARACTER(6) 6
64 OGLSPARE CHARACTER(4) 4
65 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
66 RECORD_TYPE CHARACTER VARYING(16) 16
67 COMMIT_TIMESTAMP TIMESTAMP 8
68 EXTRACT_TIMESTAMP TIMESTAMP 8
69 CDC_ID INTEGER 4
70 CHANNEL CHARACTER(2) 2
71 MVREG CHARACTER(12) 12
72 CTPNO CHARACTER(12) 12