INT_MOTOR_COMBINED_COST_REPAIRER_INCIDENT_DRILLTHRU

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 INCIDENT_ID BIGINT 8
3 PNETQUOTEREQUEST_NUMBER CHARACTER VARYING(13) 13
4 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(64) 64
5 GROSSAMOUNT NUMERIC(18,2) 19
6 NETAMOUNT NUMERIC(19,2) 19
7 ORIGINALGROSSAMOUNT NUMERIC(19,2) 19
8 ORIGINALNETAMOUNT NUMERIC(19,2) 19
9 COMBINED_COST_SUBTYPE CHARACTER VARYING(10) 10
10 AUTHORISED_DATE DATE 4
11 CLAIM_ID BIGINT 8
12 LOSS_PARTY_TYPE_ID BIGINT 8
13 CCR_CC_VEHICLE_ID BIGINT 8
14 VEHICLE_STYLE_ID BIGINT 8
15 VEHICLE_DETAIL_HIERARCHY CHARACTER VARYING(162) 162
16 VEHICLE_YEAR CHARACTER VARYING(20) 20
17 VEHICLE_MAKE CHARACTER VARYING(60) 60
18 VEHICLE_MODEL CHARACTER VARYING(80) 80
19 SC_NVIC CHARACTER VARYING(15) 15
20 CCR_CCX_SC_ASSESSMENTBOOKING_SC_ASSESSMENTPROCESSTYPE BIGINT 8
21 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
22 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
23 CCR_CCX_SC_PNETQUOTEREQUEST_STATUS BIGINT 8
24 CCR_CCX_SC_PNETQUOTEREQUEST_QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
25 ASSESSOR_CCR_CC_USER_CONTACTID BIGINT 8
26 POLICY_COVERAGE_TYPE_ID BIGINT 8
27 FLEET_IND CHARACTER VARYING(9) 9
28 CAS_IND CHARACTER VARYING(7) 7
29 VOLUME_COUNT INTEGER 4
30 COMBINED_TYPE CHARACTER VARYING(6) 6
31 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
32 ASSESSMENT_PROCESS_GROUP_NAME CHARACTER VARYING(13) 13
33 ALIGNED_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
34 ALIGNED_REPAIRER_ASSESSMENT_CC_ID BIGINT 8
35 REPAIRER_NAME CHARACTER VARYING(120) 120
36 ASSESSOR_NAME CHARACTER VARYING(181) 181
37 ASSESSMENT_CENTRE_NAME CHARACTER VARYING(120) 120
38 ASSESSMENT_CENTRE_STATE_NAME CHARACTER VARYING(256) 256
39 ASSESSMENT_CENTRE_REGION_NAME CHARACTER VARYING(15) 15
40 VEHICLE_ARRIVE_DATE TIMESTAMP 8
41 BOOKING_CREATE_DATE TIMESTAMP 8
42 COMBINED_COST_COMPLETED_DATE TIMESTAMP 8