INT_PI_MOTOR_INCIDENT_QR_EXTERNAL_SUBLET

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CCX_SC_PNETQUOTELINE_ID BIGINT 8
2 CCR_CCX_SC_PNETQUOTEREQUEST_VEHICLEINCIDENTID BIGINT 8
3 CCR_CCX_SC_PNETQUOTELINE_AMOUNT NUMERIC(18,2) 19
4 CCR_CCX_SC_PNETQUOTELINE_ORIGINALAMOUNT NUMERIC(18,2) 19
5 CCR_CCX_SC_PNETQUOTELINE_AUTHORITYNUMBER BIGINT 8
6 CCR_CCX_SC_PNETQUOTELINE_CHANGEIND CHARACTER VARYING(1) 1
7 CCR_CCX_SC_PNETQUOTELINE_CHECKFLAG CHARACTER VARYING(1) 1
8 CCR_CCX_SC_PNETQUOTELINE_DESCRIPTION CHARACTER VARYING(255) 255
9 CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT BIGINT 8
10 CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE BIGINT 8
11 CCR_CCX_SC_PNETQUOTELINE_SUBTYPE BIGINT 8
12 CCR_CCX_SC_PNETQUOTELINE_QUALITYISSUE CHARACTER VARYING(1) 1
13 CCR_CCTL_SC_PNETSUBLETOUTCOME_TYPECODE CHARACTER VARYING(50) 50
14 REPAIRER_NAME CHARACTER VARYING(181) 181
15 CCR_AB_ABCONTACT_REPAIRER_ID BIGINT 8
16 REPAIRER_LOCATION_CONTACT_TYPE_NAME CHARACTER VARYING(256) 256
17 CCR_AB_ABCONTACT_REPAIRER_PREFERRED CHARACTER VARYING(1) 1
18 REPAIRER_STATE CHARACTER VARYING(256) 256
19 REPAIRER_REGION CHARACTER VARYING(8) 8
20 AUTHORISED_DATE DATE 4
21 AUTHORISED_FLAG CHARACTER VARYING(3) 3
22 AUTHORISATION_SEQ_ASC BIGINT 8
23 REPAIRER_POSTALCODE CHARACTER VARYING(60) 60
24 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
25 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256