FCT_CTP_RMS_SIRA_TRANSACTIONS_ERROR

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INSURERCODE INTEGER 4
2 INSURERCODE_ERR_IND CHARACTER VARYING(20) 20
3 REGISTRATION CHARACTER VARYING(12) 12
4 REGISTRATION_ERR_IND CHARACTER VARYING(20) 20
5 MAKE CHARACTER VARYING(6) 6
6 MAKE_ERR_IND CHARACTER VARYING(20) 20
7 MODEL CHARACTER VARYING(10) 10
8 MODEL_ERR_IND CHARACTER VARYING(20) 20
9 CLASS CHARACTER VARYING(3) 3
10 CLASS_ERR_IND CHARACTER VARYING(20) 20
11 SHAPE CHARACTER VARYING(4) 4
12 SHAPE_ERR_IND CHARACTER VARYING(20) 20
13 ENGINETYPE CHARACTER VARYING(7) 7
14 ENGINECAPACITY INTEGER 4
15 ENGINECAPACITY_ERR_IND CHARACTER VARYING(20) 20
16 VEHICLEUSE CHARACTER VARYING(4) 4
17 VEHICLEUSE_ERR_IND CHARACTER VARYING(20) 20
18 YEARMANUFACTURED INTEGER 4
19 YEARMANUFACTURED_ERR_IND CHARACTER VARYING(20) 20
20 VIN CHARACTER VARYING(25) 25
21 VIN_ERR_IND CHARACTER VARYING(20) 20
22 OWNERTYPE CHARACTER VARYING(12) 12
23 OWNERTYPE_ERR_IND CHARACTER VARYING(20) 20
24 OWNERBIRTHDATE DATE 4
25 OWNERBIRTHDATE_ERR_IND CHARACTER VARYING(20) 20
26 FIRSTNAME CHARACTER VARYING(40) 40
27 FIRSTNAME_ERR_IND CHARACTER VARYING(20) 20
28 LASTNAME CHARACTER VARYING(40) 40
29 LASTNAME_ERR_IND CHARACTER VARYING(20) 20
30 OWNERNAME CHARACTER VARYING(40) 40
31 OWNERNAME_ERR_IND CHARACTER VARYING(20) 20
32 UNDER25INDICATOR CHARACTER VARYING(1) 1
33 YOUNGESTBIRTHDATE DATE 4
34 YOUNGESTBIRTHDATE_ERR_IND CHARACTER VARYING(20) 20
35 POLICYNUMBER CHARACTER VARYING(40) 40
36 POLICYNUMBER_ERR_IND CHARACTER VARYING(20) 20
37 RMSNUMBER CHARACTER VARYING(12) 12
38 RMSNUMBER_ERR_IND CHARACTER VARYING(20) 20
39 TRANSACTIONTYPE CHARACTER VARYING(4) 4
40 TRANSACTIONTYPE_ERR_IND CHARACTER VARYING(20) 20
41 TRANSACTIONID CHARACTER VARYING(40) 40
42 TRANSACTIONID_ERR_IND CHARACTER VARYING(20) 20
43 TRANSACTIONDATE DATE 4
44 TRANSACTIONDATE_ERR_IND CHARACTER VARYING(20) 20
45 PROTECTTRANDATE DATE 4
46 PROTECT_TRANSACTION_DATE_ERR_IND CHARACTER VARYING(20) 20
47 POLICYDURATION INTEGER 4
48 POLICYDURATION_ERR_IND CHARACTER VARYING(20) 20
49 POLICYLOADING NUMERIC(38,2) 19
50 POLICYLOADING_ERR_IND CHARACTER VARYING(20) 20
51 BONUS_MALUS NUMERIC(38,2) 19
52 BONUS_MALUS_ERR_IND CHARACTER VARYING(20) 20
53 ATFAULTINDICATOR CHARACTER VARYING(1) 1
54 ATFAULTINDICATOR_ERR_IND CHARACTER VARYING(20) 20
55 CTPREGION CHARACTER VARYING(1) 1
56 CTPREGION_ERR_IND CHARACTER VARYING(20) 20
57 RMSUSED CHARACTER VARYING(1) 1
58 RMSUSED_ERR_IND CHARACTER VARYING(20) 20
59 RMSEFFECTIVEDATE DATE 4
60 RMSEFFECTIVEDATE_ERR_IND CHARACTER VARYING(20) 20
61 INSUREREFFECTIVEDATE DATE 4
62 INSUREREFFECTIVEDATE_ERR_IND CHARACTER VARYING(20) 20
63 RMSEXPIRYDATE DATE 4
64 RMSEXPIRYDATE_ERR_IND CHARACTER VARYING(20) 20
65 DISTRIBUTIONCHANNEL CHARACTER VARYING(2) 2
66 DISTRIBUTIONCHANNEL_ERR_IND CHARACTER VARYING(20) 20
67 GARAGEDSUBURB CHARACTER VARYING(40) 40
68 GARAGEDSUBURB_ERR_IND CHARACTER VARYING(20) 20
69 GARAGEDPOSTCODE NUMERIC(6,0) 19
70 GARAGEDPOSTCODE_ERR_IND CHARACTER VARYING(20) 20
71 MAILPOSTCODE NUMERIC(6,0) 19
72 MAILPOSTCODE_ERR_IND CHARACTER VARYING(20) 20
73 IRC CHARACTER VARYING(6) 6
74 IRC_ERR_IND CHARACTER VARYING(20) 20
75 PREMIUMTAXABLE NUMERIC(38,2) 19
76 PREMIUMTAXABLE_ERR_IND CHARACTER VARYING(20) 20
77 PREMIUMTOTAL NUMERIC(38,6) 19
78 PREMIUMTOTAL_ERR_IND CHARACTER VARYING(20) 20
79 COMMISSION NUMERIC(38,6) 19
80 COMMISSION_ERR_IND CHARACTER VARYING(20) 20
81 MCISLEVY NUMERIC(38,6) 19
82 MCISLEVY_ERR_IND CHARACTER VARYING(20) 20
83 GST NUMERIC(38,6) 19
84 GST_ERR_IND CHARACTER VARYING(20) 20
85 INPUTTAXCREDITENTITLEMENTS CHARACTER VARYING(1) 1
86 INPUTTAXCREDITENTITLEMENTS_ERR_IND CHARACTER VARYING(20) 20
87 CHASSISNO CHARACTER VARYING(25) 25