INT_MOTOR_INCIDENT_QUOTELINE_MAIN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 RECORD_TYPE INTEGER 4
3 CCR_CC_INCIDENT_CLAIMID BIGINT 8
4 CCR_CC_INCIDENT_ID BIGINT 8
5 CCR_CC_INCIDENT_SC_INSUREDVEHICLE BIGINT 8
6 CCR_CCTL_LOSSPARTYTYPE_ID BIGINT 8
7 CCR_CC_INCIDENT_SC_EXTERNALASSESSOR BIGINT 8
8 CCR_CC_VEHICLE_ID BIGINT 8
9 CCR_CC_VEHICLE_STYLE BIGINT 8
10 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
11 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
12 CCR_CC_VEHICLE_YEAR BIGINT 8
13 CCR_CC_VEHICLE_SC_NVIC CHARACTER VARYING(15) 15
14 CCR_CCX_SC_TOWING_VEHICLEINCIDENTFK BIGINT 8
15 INTRO_CALL_COMPLETED_DATE TIMESTAMP 8
16 VEHICLE_ARRIVAL_DATE TIMESTAMP 8
17 HIRE_CAR_DATE TIMESTAMP 8
18 VEHICLE_RETURNED_DATE TIMESTAMP 8
19 VEHICLE_COLLECTED_BY_OWNER_DATE TIMESTAMP 8
20 ORIGINAL_ECD TIMESTAMP 8
21 ASSESSMENT_OUTCOME_CALL_COMPLETED_DATE TIMESTAMP 8
22 VEHICLE_COLLECTED_DATE TIMESTAMP 8
23 REPAIR_ACTUAL_COMPLETION_DATE TIMESTAMP 8
24 FINAL_ECD_DATE TIMESTAMP 8
25 ECD_CHANGES_ON_DUE_DATE_COUNT BIGINT 8
26 ECD_CHANGES_COUNT BIGINT 8
27 REPAIR_COMPLETED_INDICATOR CHARACTER VARYING(20) 20
28 CCR_CCX_SC_ASSESSMENTBOOKING_SC_ASSESSMENTPROCESSTYPE BIGINT 8
29 ASSESSOR_CCR_CC_USER_CONTACTID BIGINT 8
30 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
31 ABLOCATION_CCR_AB_ADDRESS_STATE BIGINT 8
32 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
33 CCR_CCX_SC_PNETQUOTEREQUEST_ID BIGINT 8
34 CCR_CCX_SC_PNETQUOTEREQUEST_ASSESSCOMPLETEDTE TIMESTAMP 8
35 REPAIR_START_DATETIME TIMESTAMP 8
36 CCR_CCX_SC_PNETQUOTEREQUEST_STATUS BIGINT 8
37 CCR_CCX_SC_ASSESSMENTBOOKING_CHOICEOFREPAIRER CHARACTER VARYING(1) 1
38 QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
39 CCR_CCX_SC_PNETQUOTEREQUEST_QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
40 CCR_CCX_SC_PNETQUOTEASSESS_ID BIGINT 8
41 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
42 CCR_CCX_SC_PNETQUOTE_VERSIONNUMBER BIGINT 8
43 CCR_CCX_SC_PNETQUOTE_QUOTENUMBER CHARACTER VARYING(13) 13
44 CCR_CCTL_SC_PNETLOSINGREASON_ID BIGINT 8
45 CCR_CCTL_SC_PNETQUOTE_NAME CHARACTER VARYING(256) 256
46 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
47 QUOTE_ONTIME_FLAG INTEGER 4
48 LATE_TIME NUMERIC(36,7) 19
49 CCR_CCX_SC_PNETQUOTE_AUTHORITYNUMBER BIGINT 8
50 CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
51 CCR_CCTL_SC_PNETASSESSOUTCOME_TYPECODE CHARACTER VARYING(50) 50
52 SUPPS_CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
53 COMPETITIVE_QUOTE_FLAG CHARACTER VARYING(17) 17
54 CCR_CCTL_SC_PNETQUOTE_ID BIGINT 8
55 AUTHORISED_QUOTE_FLAG CHARACTER VARYING(14) 14
56 AUTHORISED_DATE DATE 4
57 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL NUMERIC(18,2) 19
58 INCIDENT_REPAIR_COST_NET_GST NUMERIC(19,2) 19
59 CCR_CCX_SC_PNETQUOTE_ORIGINALQUOTETOTAL NUMERIC(19,2) 19
60 INCIDENT_ORIGINAL_REPAIR_COST_NET_GST NUMERIC(19,2) 19
61 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(64) 64
62 RECORD_COUNT INTEGER 4
63 QUOTE_COUNT INTEGER 4
64 EXTERNAL_SUBLET_COUNT INTEGER 4
65 CCR_CCX_SC_PNETQUOTEASSESS_QUOTEDUETIME TIMESTAMP 8
66 CCR_CC_VEHICLE_LICENSEPLATE CHARACTER VARYING(10) 10
67 CCR_CCTL_SC_PNETSUBLETOUTCOME_ID BIGINT 8
68 CCR_CCX_SC_PNETQUOTELINE_ID BIGINT 8
69 CCR_CCX_SC_PNETQUOTELINE_REPAIRER CHARACTER VARYING(30) 30
70 CCR_CCX_SC_PNETQUOTELINE_SUBTYPE BIGINT 8
71 CCR_CCX_SC_PNETQUOTELINE_PARTTYPE BIGINT 8
72 CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT BIGINT 8
73 CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE BIGINT 8
74 PNETQUOTELINE_NET_AMOUNT NUMERIC(19,2) 19
75 CCR_CCX_SC_PNETQUOTELINE_GROSSAMOUNT NUMERIC(18,2) 19
76 PNETQUOTELINE_NET_ORIGINALAMOUNT NUMERIC(19,2) 19
77 PNETQUOTELINE_ORIGINALGROSSAMOUNT NUMERIC(19,2) 19
78 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICENUMBER CHARACTER VARYING(20) 20
79 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICE_ID BIGINT 8
80 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
81 CCR_CC_CHECK_INVOICEPAIDDATE TIMESTAMP 8
82 EXCESS_COLLECTED_AMOUNT_GROSS NUMERIC(11,2) 19
83 EXCESS_COLLECTED_AMOUNT_NET NUMERIC(11,2) 19
84 INVOICE_AMOUNT_GROSS NUMERIC(18,2) 19
85 INVOICE_AMOUNT_NET NUMERIC(38,22) 19
86 CCR_CCTL_SC_PNETQUOTEASSESSSTATUS_ID BIGINT 8
87 REPAIRER_APPOINTMENT_TIME TIMESTAMP 8
88 REPAIRER_ARRIVAL_TIME TIMESTAMP 8
89 TOTAL_QUALITY_ISSUES BIGINT 8
90 TOTAL_QUALITY_ISSUES_ITEMS BIGINT 8
91 REWORK_INDICATOR CHARACTER VARYING(20) 20
92 QUALITY_ISSUES_INDICATOR CHARACTER VARYING(28) 28
93 QUALITY_ISSUE_CREATETIME TIMESTAMP 8