FCT_CIBSECCS_M021_CMOV

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMNUMBER CHARACTER VARYING(40) 40
2 CLAIMORDER BIGINT 8
3 EXPOSUREID BIGINT 8
4 EXPOSURETYPE BIGINT 8
5 TP_TYPE CHARACTER VARYING(50) 50
6 COSTTYPE BIGINT 8
7 COSTCATEGORY BIGINT 8
8 LINECATEGORY BIGINT 8
9 TRANSACTIONTYPE CHARACTER VARYING(50) 50
10 RECOVERYCATEGORY CHARACTER VARYING(50) 50
11 CLAIMSTATUS CHARACTER VARYING(22) 22
12 EXPOSURETRANSTATUS CHARACTER VARYING(22) 22
13 CHEQUENUMBER CHARACTER VARYING(255) 255
14 CHEQUESTATUS BIGINT 8
15 CREATETIME TIMESTAMP 8
16 UPDATETIME TIMESTAMP 8
17 TRANSACTIONDATE TIMESTAMP 8
18 TRANPOSTEDDATE TIMESTAMP 8
19 BATCHDATE TIMESTAMP 8
20 TRANSACTIONSTATUS CHARACTER VARYING(50) 50
21 ITCEPERCENTAGE BIGINT 8
22 GSTSTATUS CHARACTER VARYING(50) 50
23 PAYMENTTYPE BIGINT 8
24 GL_CHANNEL CHARACTER VARYING(5) 5
25 GL_PRODUCT CHARACTER VARYING(6) 6
26 GL_CLASS CHARACTER VARYING(2) 2
27 GL_ENTITY CHARACTER VARYING(6) 6
28 GL_STATE CHARACTER VARYING(1) 1
29 GL_CATEGORY CHARACTER VARYING(3) 3
30 GL_CENTRE CHARACTER VARYING(4) 4
31 PAIDAMOUNT NUMERIC(20,2) 19
32 RECOVEREDAMOUNT NUMERIC(20,2) 19
33 ITCAMOUNT NUMERIC(20,2) 19
34 DAMAMOUNT NUMERIC(20,2) 19
35 IAMAMOUNT NUMERIC(20,2) 19
36 RESERVEMOVEMENT NUMERIC(20,2) 19
37 RECOVERYRESERVEMOVEMENT NUMERIC(20,2) 19
38 RECOVERYWRITEOFF NUMERIC(20,2) 19
39 OFFSETAMOUNT NUMERIC(20,2) 19
40 EXCESSGST NUMERIC(20,2) 19
41 TRANSACTIONID BIGINT 8
42 RECORDTYPE CHARACTER VARYING(1) 1
43 PAYEEID CHARACTER VARYING(101) 101
44 ISPAYEE_INSCOMP CHARACTER VARYING(1) 1
45 PAYERID CHARACTER VARYING(101) 101
46 ISPAYER_INSCOMP CHARACTER VARYING(1) 1
47 PAYMENTMETHODFORPAYER CHARACTER VARYING(50) 50
48 SC_GSTAMOUNT NUMERIC(20,2) 19
49 ISREVERSED BIGINT 8
50 SC_PAYMENTTYPE BIGINT 8
51 TRANSACTIONLINEITEMID BIGINT 8
52 TRANSACTIONPUBLICID CHARACTER VARYING(64) 64
53 EXCESSAMOUNT NUMERIC(20,2) 19
54 TRANSACTIONPOSTEDDATE TIMESTAMP 8
55 LOSSPARTY BIGINT 8
56 TYPECODE CHARACTER VARYING(50) 50