Bookmark this page Print this page

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