General Insurance,
Data Fields, All Policies, Premium Screen
|
Item |
Durell Table |
Durell Field Name |
Example |
|
IPT rate % |
Policy Details 1 |
PolDets_IPTRate |
5.00 |
|
Gross premium without IPT
£ |
Policy Details 1 |
PolDets_GrossPremium |
500.00 |
|
Gross premium with IPT
£ |
|
N/A |
525.00 |
|
Insurer NCD % |
Policy Details 1 |
PolDets_DiscountPerc |
60.00 |
|
Insurer NCD £ |
Policy Details 1 |
PolDets_DiscountPnd |
-300.00 |
|
Premium after NCD without
IPT £ |
Policy Details 1 |
Premium |
200.00 |
|
IPT amount £ |
Policy Details 1 |
PolDets_IPTAmount |
10.00 |
|
Premium after NCD with IPT
£ |
|
N/A |
210.00 |
|
|
|
|
|
|
Insurer charge £ |
Policy Details 1 |
PolDets_InsurerCharge |
10.00 |
|
Insurer VAT £ |
Policy Details 1 |
PolDets_InsurerVAT |
1.75 |
|
Brokerage charge £ |
Policy Details 1 |
PolDets_BrokerageCharge |
50.00 |
|
Brokerage discount £ |
Policy Details 1 |
PolDets_Adjustment |
-30.00 |
|
Brokerage VAT £ |
Policy Details 1 |
PolDets_VATAmount |
3.50 |
|
Invoice £ |
Policy Details 1 |
PolDets_Invoice |
245.25 |
|
Paid by |
Policy Details 1 |
PolDets_PaidBy |
CHEQ |
|
Method used |
Policy Details 1 |
PolDets_PayMethod |
CH |
|
Invoice date |
Policy Details 1 |
PolDets_InvoiceDate |
01/02/2006 |
|
|
|
|
|
|
Commission % |
Policy Details 1 |
PolDets_CommissionPerc |
20.00 |
|
Commission £ |
Policy Details 1 |
PolDets_CommissionPnd |
40.00 |
|
Nett £ |
Policy Details 1 |
PolDets_Nett |
160.00 |
|
Commission on insurer
charge £ |
Policy Details 1 |
PolDets_InsurerChargeComm |
2.00 |
|
Nett, IPT and insurer
charge £ |
|
N/A |
179.75 |
|
Last policy invoice £ |
Policy Details 1 |
PolDets_LastInvoice |
0.00 |
|
Last MTA £ |
Policy Details 1 |
LastMTAAmount |
49.35 |
|
Total invoice after all MTAs |
Policy Details 1 |
PolDets_InvoiceIncludingMTAs |
294.60 |
|
Sales invoice No |
Policy Details 1 |
PolDets_InvoiceNumber |
0000008 |