INT_PI_MOTOR_PNETQUOTELINE

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 CHARACTER VARYING(1) 1
6 CCR_CCX_SC_PNETQUOTEASSESS_SC_LOCATIONID BIGINT 8
7 CCR_CCX_SC_PNETQUOTEASSESS_SC_LOCATIONABUID CHARACTER VARYING(30) 30
8 CCR_CCX_SC_PNETQUOTE_QUOTETYPE BIGINT 8
9 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
10 CCR_CCX_SC_PNETQUOTE_AUTHORISED CHARACTER VARYING(1) 1
11 CCR_CCX_SC_PNETQUOTE_GST NUMERIC(18,2) 19
12 CCR_CCTL_SC_PNETQUOTETYPE_NAME CHARACTER VARYING(256) 256
13 CCR_CCTL_SC_PNETQUOTETYPE_TYPECODE CHARACTER VARYING(50) 50
14 CCR_CCX_SC_PNETQUOTE_QUALITYISSUE CHARACTER VARYING(1) 1
15 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL NUMERIC(18,2) 19
16 CCR_CCX_SC_PNETQUOTE_QUOTSOFTWARE CHARACTER VARYING(20) 20
17 CCR_CCX_SC_PNETQUOTE_SUBTYPE BIGINT 8
18 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
19 CCR_CCX_SC_PNETQUOTE_SUPPQUOTEOUTCOME BIGINT 8
20 CCR_CCX_SC_PNETQUOTE_RULECHECKSUMMARYID BIGINT 8
21 CCR_CCX_SC_PNETQUOTELINE_SC_LOCATIONID BIGINT 8
22 CCR_CCX_SC_PNETQUOTELINE_CHANGEIND CHARACTER VARYING(1) 1
23 CCR_CCX_SC_PNETQUOTELINE_CHECKFLAG CHARACTER VARYING(1) 1
24 CCR_CCX_SC_PNETQUOTELINE_DESCRIPTION CHARACTER VARYING(255) 255
25 CCR_CCX_SC_PNETQUOTELINE_LABOURTYPE BIGINT 8
26 CCR_CCX_SC_PNETQUOTELINE_LINENUMBER BIGINT 8
27 CCR_CCX_SC_PNETQUOTELINE_PARTNUMBER CHARACTER VARYING(20) 20
28 CCR_CCX_SC_PNETQUOTELINE_PARTTYPE BIGINT 8
29 CCR_CCX_SC_PNETQUOTELINE_PAINTWORKTYPE BIGINT 8
30 CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT BIGINT 8
31 CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE BIGINT 8
32 CCR_CCX_SC_PNETQUOTELINE_SUBTYPE BIGINT 8
33 CCR_CCX_SC_PNETQUOTELINE_QUANTITY INTEGER 4
34 CCR_CCX_SC_PNETQUOTELINE_AMOUNT NUMERIC(18,2) 19
35 CCR_CCX_SC_PNETQUOTELINE_MARKUPAMOUNT NUMERIC(18,2) 19
36 CCR_CCX_SC_PNETQUOTELINE_ORIGINALAMOUNT NUMERIC(18,2) 19
37 CCR_CCTL_SC_PNETSUBLETOUTCOME_TYPECODE CHARACTER VARYING(50) 50
38 AUTHORISED_DATE TIMESTAMP 8
39 QUOTE_METHOD CHARACTER VARYING(11) 11
40 QUOTE_LINE_SEQUENCE BIGINT 8
41 MAIN_QUOTE_SEQUENCE BIGINT 8
42 CCR_CCTL_SC_PNETQUOTELINE_TYPECODE CHARACTER VARYING(50) 50