INT_PI_MOTOR_INCIDENT_QUOTELINE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CCX_SC_PNETQUOTELINE_ID BIGINT 8
2 INCIDENT_ID BIGINT 8
3 CCR_CCX_SC_PNETQUOTEASSESS_ID BIGINT 8
4 CCR_CCX_SC_PNETQUOTEASSESS_OUTCOME BIGINT 8
5 CCR_CCX_SC_PNETQUOTEASSESS_ARCHIVED BIGINT 8
6 CCR_CCX_SC_PNETQUOTEASSESS_SC_LOCATIONABUID CHARACTER VARYING(30) 30
7 INCIDENT_QUOTELINE_RECORD_TYPE CHARACTER VARYING(20) 20
8 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
9 CCR_CCX_SC_PNETQUOTE_AUTHORISED INTEGER 4
10 CCR_CCX_SC_PNETQUOTE_GST NUMERIC(18,2) 19
11 CCR_CCTL_SC_PNETQUOTETYPE_NAME CHARACTER VARYING(256) 256
12 CCR_CCTL_SC_PNETQUOTETYPE_TYPECODE CHARACTER VARYING(50) 50
13 CCR_CCX_SC_PNETQUOTE_QUALITYISSUE CHARACTER VARYING(1) 1
14 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL NUMERIC(18,2) 19
15 CCR_CCX_SC_PNETQUOTE_QUOTSOFTWARE CHARACTER VARYING(20) 20
16 CCR_CCX_SC_PNETQUOTE_SUBTYPE BIGINT 8
17 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
18 CCR_CCX_SC_PNETQUOTE_SUPPQUOTEOUTCOME BIGINT 8
19 CCR_CCX_SC_PNETQUOTE_RULECHECKSUMMARYID BIGINT 8
20 CCR_CCX_SC_PNETQUOTELINE_CHANGEIND CHARACTER VARYING(1) 1
21 CCR_CCX_SC_PNETQUOTELINE_CHECKFLAG CHARACTER VARYING(1) 1
22 CCR_CCX_SC_PNETQUOTELINE_DESCRIPTION CHARACTER VARYING(255) 255
23 CCR_CCX_SC_PNETQUOTELINE_LABOURTYPE BIGINT 8
24 CCR_CCX_SC_PNETQUOTELINE_LINENUMBER BIGINT 8
25 CCR_CCX_SC_PNETQUOTELINE_PARTNUMBER CHARACTER VARYING(20) 20
26 CCR_CCX_SC_PNETQUOTELINE_PARTTYPE BIGINT 8
27 CCR_CCX_SC_PNETQUOTELINE_PAINTWORKTYPE BIGINT 8
28 CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT BIGINT 8
29 CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE BIGINT 8
30 CCR_CCX_SC_PNETQUOTELINE_SUBTYPE BIGINT 8
31 CCR_CCTL_SC_PNETQUOTELINE_TYPECODE CHARACTER VARYING(50) 50
32 CCR_CCX_SC_PNETQUOTELINE_QUANTITY INTEGER 4
33 CCR_CCX_SC_PNETQUOTELINE_AMOUNT NUMERIC(18,2) 19
34 CCR_CCX_SC_PNETQUOTELINE_MARKUPAMOUNT NUMERIC(18,2) 19
35 CCR_CCX_SC_PNETQUOTELINE_ORIGINALAMOUNT NUMERIC(18,2) 19
36 CCR_CCTL_SC_PNETSUBLETOUTCOME_TYPECODE CHARACTER VARYING(50) 50
37 CCR_CCX_SC_PNETQUOTELINE_REPAIRER CHARACTER VARYING(181) 181
38 INCIDENT_QUOTELINE_REPAIRER_NAME CHARACTER VARYING(181) 181
39 INCIDENT_QUOTELINE_REPAIRER_ID BIGINT 8
40 REPAIRER_LOCATION_CONTACT_TYPE_NAME CHARACTER VARYING(256) 256
41 CCR_AB_ABCONTACT_REPAIRER_PREFERRED BIGINT 8
42 INCIDENT_QUOTELINE_REPAIRER_STATE CHARACTER VARYING(256) 256
43 INCIDENT_QUOTELINE_REPAIRER_REGION CHARACTER VARYING(8) 8
44 AUTHORISED_DATE TIMESTAMP 8
45 QUOTE_METHOD CHARACTER VARYING(11) 11
46 QUOTE_LINE_SEQUENCE BIGINT 8
47 MAIN_QUOTE_SEQUENCE BIGINT 8
48 AUTHORISATION_SEQ_ASC BIGINT 8
49 INCIDENT_QUOTELINE_REPAIRER_POSTALCODE CHARACTER VARYING(60) 60
50 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
51 BOOKING_DATE TIMESTAMP 8
52 PRIMARY_BOOKING_DATE DATE 4
53 PRIMARY_BOOKING_PREV_WORKING_DAY_SEQ BIGINT 8
54 BOOKING_LOCATION_ABCONTACTID BIGINT 8
55 BOOKING_LOCATION CHARACTER VARYING(181) 181
56 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
57 BOOKING_STATE CHARACTER VARYING(256) 256
58 BOOKING_REGION CHARACTER VARYING(8) 8
59 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
60 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256