FCT_MOTOR_QUOTE_REPAIRER_ALLOCATION

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
2 MAIN_REPAIRER_ID BIGINT 8
3 MAIN_REPAIRER_NAME CHARACTER VARYING(120) 120
4 COMPETING_REPAIRER_NAME CHARACTER VARYING(120) 120
5 CCR_CC_CLAIM_ID BIGINT 8
6 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
7 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_NAME CHARACTER VARYING(256) 256
8 CCR_CCTL_SC_BRAND_ID BIGINT 8
9 CCR_CCTL_SC_BRAND_TYPECODE CHARACTER VARYING(50) 50
10 CCR_CCTL_SC_BRAND_NAME CHARACTER VARYING(256) 256
11 ASSESSMENT_CENTER_NAME CHARACTER VARYING(120) 120
12 ASSESSMENT_CENTER_STATE_NAME CHARACTER VARYING(256) 256
13 ASSESSMENT_CENTER_REGION_NAME CHARACTER VARYING(15) 15
14 ALIGNED_REPAIRER_STATE CHARACTER VARYING(256) 256
15 ALIGNED_REPAIRER_REGION CHARACTER VARYING(15) 15
16 ALIGNED_ASSESSMENT_CENTER_ID BIGINT 8
17 ALIGNED_ASSESSMENT_CENTER_NAME CHARACTER VARYING(612) 612
18 CCR_CCTL_VEHICLESTYLE_NAME CHARACTER VARYING(256) 256
19 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
20 REPAIRER_LOCATIONTYPE_TYPECODE CHARACTER VARYING(256) 256
21 ASSESSMENT_COMPLETED_DATE DATE 4
22 ALIGNED_REPAIRER_FLAG CHARACTER VARYING(1) 1
23 VALET_QUOTES_SUBMITTED NUMERIC(38,0) 19
24 VALET_QUOTES_AUTHORIZED NUMERIC(38,0) 19
25 DRIVEWAY_QUOTES_SUBMITTED NUMERIC(38,0) 19
26 DRIVEWAY_QUOTES_AUTHORIZED NUMERIC(38,0) 19
27 NON_DRIVEABLE_QUOTES_SUBMITTED NUMERIC(38,0) 19
28 NON_DRIVEABLE_QUOTES_AUTHORIZED NUMERIC(38,0) 19
29 ON_ROAD_QUOTES_SUBMITTED NUMERIC(38,0) 19
30 ON_ROAD_QUOTES_AUTHORIZED NUMERIC(38,0) 19
31 TOTAL_QUOTES_SUBMITTED NUMERIC(38,0) 19
32 TOTAL_QUOTES_AUTHORIZED NUMERIC(38,0) 19