INT_MOTOR_QR_EXTERNAL_SUBLET_T

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CCR_CC_INCIDENT_ID BIGINT 8
3 CCR_CCX_SC_PNETQUOTEREQUEST_QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
4 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
5 CCR_CCX_SC_PNETQUOTELINE_ID BIGINT 8
6 EXTERNAL_ASSESSOR_CCR_CC_CONTACT_ID BIGINT 8
7 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(64) 64
8 CCR_CCTL_SC_PNETSUBLETOUTCOME_ID BIGINT 8
9 CCR_CCX_SC_PNETQUOTELINE_AUTHORITYNUMBER BIGINT 8
10 AUTHORISED_DATE DATE 4
11 AUTHORISED_FLAG CHARACTER VARYING(14) 14
12 DIM_PNETQUOTE_ID INTEGER 4
13 QUOTE_TYPE CHARACTER VARYING(15) 15
14 CCR_CCX_SC_PNETQUOTELINE_REPAIRER CHARACTER VARYING(30) 30
15 CCR_CCX_SC_PNETQUOTELINE_SUBTYPE BIGINT 8
16 CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT BIGINT 8
17 CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE BIGINT 8
18 PNETQUOTELINE_NET_AMOUNT NUMERIC(9,2) 19
19 CCR_CCX_SC_PNETQUOTELINE_GROSSAMOUNT NUMERIC(9,2) 19
20 PNETQUOTELINE_NET_ORIGINALAMOUNT NUMERIC(9,2) 19
21 PNETQUOTELINE_ORIGINALGROSSAMOUNT NUMERIC(9,2) 19
22 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICENUMBER CHARACTER VARYING(20) 20
23 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICE_ID BIGINT 8
24 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
25 CCR_CC_CHECK_INVOICEPAIDDATE TIMESTAMP 8
26 INVOICE_AMOUNT_GROSS NUMERIC(9,2) 19
27 INVOICE_AMOUNT_NET NUMERIC(9,2) 19