INT_MOTOR_QUOTELINE_COMBINED

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RECORD_TYPE INTEGER 4
2 CCR_CCX_SC_PNETQUOTEASSESS_VEHICLEINCIDENTID BIGINT 8
3 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
4 CCR_CCX_SC_PNETQUOTE_VERSIONNUMBER BIGINT 8
5 CCR_CCX_SC_PNETQUOTE_QUOTENUMBER CHARACTER VARYING(13) 13
6 COMPETITIVE_QUOTE_FLAG CHARACTER VARYING(17) 17
7 CCR_CCTL_SC_PNETLOSINGREASON_ID BIGINT 8
8 CCR_CCX_SC_PNETQUOTE_AUTHORITYNUMBER BIGINT 8
9 CCR_CCX_SC_PNETQUOTEASSESS_ID BIGINT 8
10 CCR_CCX_SC_PNETQUOTELINE_ID BIGINT 8
11 CCR_CCTL_SC_PNETQUOTE_NAME CHARACTER VARYING(256) 256
12 CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
13 CCR_CCTL_SC_PNETASSESSOUTCOME_TYPECODE CHARACTER VARYING(50) 50
14 SUPPS_CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
15 CCR_CCTL_SC_PNETQUOTE_ID BIGINT 8
16 AUTHORISED_QUOTE_FLAG CHARACTER VARYING(14) 14
17 AUTHORISED_DATE DATE 4
18 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(64) 64
19 CCR_CCTL_SC_PNETSUBLETOUTCOME_ID BIGINT 8
20 CCR_CCX_SC_PNETQUOTELINE_REPAIRER CHARACTER VARYING(30) 30
21 CCR_CCX_SC_PNETQUOTELINE_SUBTYPE BIGINT 8
22 CCR_CCX_SC_PNETQUOTELINE_PARTTYPE BIGINT 8
23 CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT BIGINT 8
24 CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE BIGINT 8
25 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
26 QUOTE_ONTIME_FLAG INTEGER 4
27 LATE_TIME NUMERIC(36,7) 19
28 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL NUMERIC(18,2) 19
29 INCIDENT_REPAIR_COST_NET_GST NUMERIC(19,2) 19
30 CCR_CCX_SC_PNETQUOTE_ORIGINALQUOTETOTAL NUMERIC(19,2) 19
31 INCIDENT_ORIGINAL_REPAIR_COST_NET_GST NUMERIC(19,2) 19
32 RECORD_COUNT INTEGER 4
33 QUOTE_COUNT INTEGER 4
34 EXTERNAL_SUBLET_COUNT INTEGER 4
35 PNETQUOTELINE_NET_AMOUNT NUMERIC(19,2) 19
36 CCR_CCX_SC_PNETQUOTELINE_GROSSAMOUNT NUMERIC(18,2) 19
37 PNETQUOTELINE_NET_ORIGINALAMOUNT NUMERIC(19,2) 19
38 PNETQUOTELINE_ORIGINALGROSSAMOUNT NUMERIC(19,2) 19
39 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICENUMBER CHARACTER VARYING(20) 20
40 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICE_ID BIGINT 8
41 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
42 CCR_CC_CHECK_INVOICEPAIDDATE TIMESTAMP 8
43 EXCESS_COLLECTED_AMOUNT_GROSS NUMERIC(11,2) 19
44 EXCESS_COLLECTED_AMOUNT_NET NUMERIC(11,2) 19
45 INVOICE_AMOUNT_GROSS NUMERIC(18,2) 19
46 INVOICE_AMOUNT_NET NUMERIC(38,22) 19
47 CCR_CCX_SC_PNETQUOTEASSESS_QUOTEDUETIME TIMESTAMP 8
48 CCR_CCTL_SC_PNETQUOTEASSESSSTATUS_ID BIGINT 8
49 CCR_CCX_SC_PNETQUOTEASSESS_APPOINTMENTDATETIME TIMESTAMP 8
50 CCR_CCX_SC_PNETQUOTEASSESS_REPAIRERARRIVALTIME TIMESTAMP 8