CREATE TABLE [dbo].[vir_virtual_fields]
(
[virvf_id] [int] NOT NULL,
[virvf_parent_id] [int] NULL,
[virvf_variable_id] [int] NULL,
[virvf_policy_number] [dbo].[ais_code_long] NULL,
[virvf_invoice_start_date] [date] NULL,
[virvf_invoice_end_date] [date] NULL,
[virvf_invoice_tf] [dbo].[ais_decimal2] NULL,
[virvf_invoice_taxes] [dbo].[ais_decimal2] NULL,
[virvf_invoice_taxes_not_included_in_net] [dbo].[ais_decimal2] NULL,
[virvf_invoice_ti] [dbo].[ais_decimal2] NULL,
[virvf_invoice_commission_tf] [dbo].[ais_decimal2] NULL,
[virvf_invoice_commission_taxes] [dbo].[ais_decimal2] NULL,
[virvf_invoice_commission_taxes_not_included_in_net] [dbo].[ais_decimal2] NULL,
[virvf_invoice_commission_ti] [dbo].[ais_decimal2] NULL,
[virvf_policy_or_risk_number] [nvarchar] (128) COLLATE French_CI_AS NULL,
[virvf_policy_situation_id] [int] NULL,
[virvf_risk_situation_id] [int] NULL,
[virvf_invoice_variable_tf] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_taxes] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_taxes_not_included_in_net] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_ti] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_commission_tf] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_commission_taxes] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_commission_taxes_not_included_in_net] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_commission_ti] [dbo].[ais_decimal2] NULL,
[virvf_invoice_variable_commission_percent] [dbo].[ais_decimal4] NULL,
[virvf_tax_id] [int] NULL,
[virvf_tax_value] [dbo].[ais_decimal2] NULL,
[virvf_tax_not_included_in_net_value] [dbo].[ais_decimal2] NULL,
[virvf_is_principal_renewal] [bit] NOT NULL CONSTRAINT [DF__vir_virtual_fields__virvf_is_principal_renewal] DEFAULT ((0)),
[virvf_invoice_unit_rate_policy_situation_id] [int] NULL,
[virvf_invoice_unit_rate_copy_from_invoice_id] [int] NULL,
[virvf_invoice_unit_rate_copy_invoice] [bit] NOT NULL CONSTRAINT [DF__vir_virtual_fields__virvf_invoice_unit_rate_copy_invoice] DEFAULT ((0)),
[virvf_combo_display_field] [nvarchar] (256) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
