INT_PI_MOTOR_INVOICE
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | INCIDENT_ID | BIGINT | 8 |
| 2 | CCR_CCX_SC_PNETQUOTE_ID | BIGINT | 8 |
| 3 | CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE | DATE | 4 |
| 4 | CCR_CCX_SC_PNETQUOTEINVOICE_COLLECTEDEXCESSAMOUNT | NUMERIC(18,2) | 19 |
| 5 | CCR_CCX_SC_PNETQUOTEINVOICE_ID | BIGINT | 8 |
| 6 | CCR_CCX_SC_PNETQUOTEINVOICE_AMOUNTEXCLUDINGGST | NUMERIC(18,2) | 19 |
| 7 | CCR_CCX_SC_PNETQUOTEINVOICE_GST | NUMERIC(18,2) | 19 |
| 8 | CCR_CCX_SC_PNETQUOTEINVOICE_TOTAL | NUMERIC(19,2) | 19 |
| 9 | CCR_CCX_SC_PNETINVOICEITEM_AMOUNT | NUMERIC(38,2) | 19 |