INT_PI_MOTOR_QUOTE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 CCR_CCX_SC_PNETQUOTEASSESS_ID BIGINT 8
3 CCR_CCX_SC_PNETQUOTEASSESS_VEHICLEINCIDENTID BIGINT 8
4 CCR_CCTL_SC_PNETLOSINGREASON_ID BIGINT 8
5 CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
6 CCR_CCTL_SC_PNETASSESSOUTCOME_TYPECODE CHARACTER VARYING(50) 50
7 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL NUMERIC(18,2) 19
8 CCR_CCX_SC_PNETQUOTE_GST NUMERIC(18,2) 19
9 CCR_CCX_SC_PNETQUOTE_ORIGINALQUOTETOTAL NUMERIC(18,2) 19
10 CCR_CCX_SC_PNETQUOTE_ORIGINALGST NUMERIC(18,2) 19
11 CCR_CCTL_SC_PNETQUOTE_ID BIGINT 8
12 CCR_CCTL_SC_PNETQUOTE_NAME CHARACTER VARYING(256) 256
13 CCR_CCX_SC_PNETQUOTE_AUTHORISED CHARACTER VARYING(1) 1
14 CCR_CCX_SC_PNETQUOTE_VERSIONNUMBER BIGINT 8
15 CCR_CCX_SC_PNETQUOTE_QUOTENUMBER CHARACTER VARYING(13) 13
16 AUTHORISED_DATE DATE 4
17 SUPPS_CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
18 SUPPS_CCR_CCTL_SC_PNETASSESSOUTCOME_TYPECODE CHARACTER VARYING(50) 50
19 REPAIRER_CCR_AB_ADDRESS_STATE BIGINT 8
20 REPAIRER_CCR_AB_ABCONTACT_ID BIGINT 8
21 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(30) 30
22 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
23 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
24 QUOTE_ONTIME_FLAG INTEGER 4
25 LATE_TIME NUMERIC(36,7) 19
26 CCR_CCX_SC_PNETQUOTE_AUTHORITYNUMBER BIGINT 8
27 COMPETITIVE_QUOTE_FLAG CHARACTER VARYING(17) 17
28 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICENUMBER CHARACTER VARYING(20) 20
29 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICE_ID BIGINT 8
30 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
31 CCR_CC_CHECK_INVOICEPAIDDATE TIMESTAMP 8
32 EXCESS_COLLECTED_AMOUNT_GROSS NUMERIC(9,2) 19
33 EXCESS_COLLECTED_AMOUNT_NET NUMERIC(9,2) 19
34 INVOICE_AMOUNT_GROSS NUMERIC(9,2) 19
35 INVOICE_AMOUNT_NET NUMERIC(9,2) 19
36 CCR_CCX_SC_PNETQUOTEASSESS_QUOTEDUETIME TIMESTAMP 8
37 CCR_CCTL_SC_PNETQUOTEASSESSSTATUS_ID BIGINT 8
38 CCR_CCX_SC_PNETQUOTEASSESS_REPAIRERARRIVALTIME TIMESTAMP 8
39 CCR_CCX_SC_PNETQUOTEASSESS_APPOINTMENTDATETIME TIMESTAMP 8