INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'BPC', N'Broker policy cost', N'Frais courtier contrat', NULL, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'BPF', N'Broker policy fees', N'Honoraires courtier contrat', NULL, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'BRC', N'Broker risk cost', N'Frais courtier risque', NULL, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'BRF', N'Broker risk fees', N'Honoraires courtier risque', NULL, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'CPF', N'Company policy accessories fees', N'Frais accessoires compagnie contrat', NULL, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'CRF', N'Company risk accessories fees', N'Frais accessoires compagnie risque', NULL, 1, 1, 0, 1, 0, 0, 0, 0, 1, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'PER', N'Peril', N'Garantie', NULL, 1, 1, 0, 1, 1, 0, 0, 0, 0, 0)
INSERT INTO [dbo].[nm_products_variables_types] ([nmpvt_type_code], [nmpvt_l1], [nmpvt_l2], [nmpvt_l3], [nmpvt_sys], [nmpvt_company], [nmpvt_policy], [nmpvt_risk], [nmpvt_peril], [nmpvt_is_broker_cost], [nmpvt_is_broker_fee], [nmpvt_is_company_cost], [nmpvt_is_company_fee], [nmpvt_frt]) VALUES (N'FRT', N'Fronting', NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1)
