| 1 |
SOURCE_SYSTEM_CODE |
CHARACTER VARYING(3) |
3 |
| 2 |
CCR_CCX_SC_PNETQUOTELINE_SC_PNETQUOTEID |
BIGINT |
8 |
| 3 |
CCR_CCX_SC_PNETQUOTELINE_ID |
BIGINT |
8 |
| 4 |
CCR_CCTL_SC_PNETQUOTELINE_TYPECODE |
CHARACTER VARYING(50) |
50 |
| 5 |
REPAIRER_CCR_AB_ABCONTACT_PUBLICID |
CHARACTER VARYING(64) |
64 |
| 6 |
CCR_CCTL_SC_PNETSUBLETMANAGEMENT_TYPECODE |
CHARACTER VARYING(50) |
50 |
| 7 |
CCR_CCX_SC_PNETQUOTELINE_OUTCOME |
BIGINT |
8 |
| 8 |
CCR_CCX_SC_PNETQUOTELINE_AUTHORITYNUMBER |
BIGINT |
8 |
| 9 |
AUTHORISED_DATE |
DATE |
4 |
| 10 |
AUTHORISED_FLAG |
CHARACTER VARYING(14) |
14 |
| 11 |
DIM_PNETQUOTE_ID |
INTEGER |
4 |
| 12 |
QUOTE_TYPE |
CHARACTER VARYING(19) |
19 |
| 13 |
CCR_CCX_SC_PNETQUOTELINE_REPAIRER |
CHARACTER VARYING(30) |
30 |
| 14 |
CCR_CCX_SC_PNETQUOTELINE_SUBTYPE |
BIGINT |
8 |
| 15 |
CCR_CCX_SC_PNETQUOTELINE_PARTTYPE |
BIGINT |
8 |
| 16 |
CCR_CCX_SC_PNETQUOTELINE_SUBLETMANAGEMENT |
BIGINT |
8 |
| 17 |
CCR_CCX_SC_PNETQUOTELINE_SUBLETTYPE |
BIGINT |
8 |
| 18 |
PNETQUOTELINE_NET_AMOUNT |
NUMERIC(19,2) |
19 |
| 19 |
CCR_CCX_SC_PNETQUOTELINE_GROSSAMOUNT |
NUMERIC(18,2) |
19 |
| 20 |
PNETQUOTELINE_NET_ORIGINALAMOUNT |
NUMERIC(19,2) |
19 |
| 21 |
PNETQUOTELINE_ORIGINALGROSSAMOUNT |
NUMERIC(19,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(18,2) |
19 |
| 27 |
INVOICE_AMOUNT_NET |
NUMERIC(38,22) |
19 |