INT_PI_HOME_QUOTE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CCX_SC_QUOTE_ID BIGINT 8
2 CCR_CCX_SC_QUOTE_QUOTENUMBER CHARACTER VARYING(20) 20
3 CCR_CCX_SC_QUOTE_PARENTJOB BIGINT 8
4 CCR_CCX_SC_QUOTE_PARENTEXPOSURE BIGINT 8
5 CLAIM_ID BIGINT 8
6 CCR_CCX_SC_JOB_SC_QUOTETYPE BIGINT 8
7 CCR_CCX_SC_QUOTE_QUOTETYPE BIGINT 8
8 CCR_CCX_SC_QUOTE_QUOTESTATUS BIGINT 8
9 CCR_CCTL_SC_QUOTESTATUS_TYPECODE CHARACTER VARYING(50) 50
10 CCR_CCTL_SC_QUOTESTATUS_NAME CHARACTER VARYING(256) 256
11 VENDOR CHARACTER VARYING(181) 181
12 VENDOR_NAME_ON_QUOTE CHARACTER VARYING(180) 180
13 CONTACT_VENDOR_TRADE_TYPE CHARACTER VARYING(10) 10
14 CCR_CCX_SC_QUOTE_QUOTEREJECTREASONTYPE BIGINT 8
15 CCR_CCX_SC_QUOTE_CREATETIME TIMESTAMP 8
16 CCR_CCX_SC_QUOTE_APPROVALDATE TIMESTAMP 8
17 CCR_CCX_SC_QUOTE_EXPIRYDATE TIMESTAMP 8
18 FIRST_QUOTE_REQUESTED_DATE DATE 4
19 FIRST_QUOTE_RECEIVED_DATE DATE 4
20 QUOTE_LIFE INTEGER 4
21 FIRST_REPORT_REQUEST_DATE DATE 4
22 FIRST_REPORT_SUBMIT_DATE DATE 4
23 REPORT_RETURN_TIME INTEGER 4
24 FIRST_REQUESTED_DATE_WLT TIMESTAMP 8
25 FIRST_RECEIVED_DATE_WLT TIMESTAMP 8
26 QUOTE_LIFE_WLT SMALLINT 2
27 CCR_CCX_SC_QUOTE_CONTACTID BIGINT 8
28 SC_PAYMENTSERVICEVENDORID CHARACTER VARYING(10) 10
29 REPORT_SUBMITTED_STATUS CHARACTER VARYING(11) 11
30 TOTALQUOTEEST NUMERIC(18,2) 19
31 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
32 QUOTE_ID_SEQUENCE_DESC BIGINT 8
33 CATEGORY_TYPE CHARACTER VARYING(256) 256
34 CATEGORY_TYPE_GROUP CHARACTER VARYING(40) 40
35 CATEGORY_SUB_TYPE CHARACTER VARYING(40) 40
36 JOB_FULFILLMENT_PATH CHARACTER VARYING(256) 256
37 CCR_CCTL_SC_FULFILMENTPATH_TYPECODE CHARACTER VARYING(50) 50
38 JOB_CREATE_DATE DATE 4
39 JOB_MAKESAFE_FLAG CHARACTER VARYING(3) 3
40 JOB_RECTIFICATION_WITH_NULL_FLAG CHARACTER VARYING(3) 3
41 LOWEST_QUOTE_FLAG CHARACTER VARYING(3) 3
42 ONE_QUOTE_NO_EST_FLAG CHARACTER VARYING(3) 3
43 JOB_PAYMENT_APPLICATION CHARACTER VARYING(256) 256