SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW [dbo].[vw___pol_policies_situations_without_rowver_and_computed]
 AS 
 select 
	  [pols_policy_situation_id] 
	, [pols_policy_id] 
	, [pols_number] 
	, [pols_sequence_code] 
	, [pols_mvt_date] 
	, [pols_mvt_code] 
	, [pols_end_date] 
	, [pols_period_code] 
	, [pols_act_code] 
	, [pols_operation_code] 
	, [pols_operation_utc_date] 
	, [pols_renew_type_code] 
	, [pols_renew_split_code] 
	, [pols_term_date] 
	, [pols_policy_situation_id_old] 
	, [pols_next_renewal_date] 
	, [pols_next_principal_renewal_date] 
	, [pols_last_principal_renewal_date] 
	, [pols_user_code] 
	, [pols_batch_id] 
	, [pols_quotation_expiration_date] 
	, [pols_ann_tf] 
	, [pols_ann_taxes] 
	, [pols_ann_ti] 
	, [pols_bonus_value] 
	, [pols_bonus50_years] 
	, [pols_index_code] 
	, [pols_index_previous_value] 
	, [pols_index_current_value] 
	, [pols_monthly_ti] 
	, [pols_quaterly_ti] 
	, [pols_biannual_ti] 
	, [pols_incomplete] 
	, [pols_endorsmentpattern_code] 
	, [pols_input_data_dump_header_id] 
	, [pols_custom_number] 
	, [pols_period_number] 
	, [pols_endorsment_description] 
	, [pols_monthly_payments] 
	, [pols_do_not_generate_policy_fees] 
 from [dbo].[pol_policies_situations]
GO
