Asset Insurance

Table Owner	Table Name	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	ains_	timestamp	int	Time Stamp	No	No
		guid	sql_variant	Guid
		company_name		Company Name
		report_date	datetime	Report Date
		fb_id	sql_variant	Finance Book Id
		asset_class_code		Asset Class Code
		asset_group_code		Asset Group Code
		asset_number		Asset Number
		tag_number	int	Tag Number
		tag_cost	bigint	Tag Cost
		policy_type	sql_variant	Policy Type
		policy_number		Policy Number
		insurable_value	bigint	Insurable Value
		premium_amount		Premium Amount
		outstanding_claim		Outstanding Claim
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
		insurance_company	sql_variant	Insurance Company
		effective_from	datetime	Effective From
		effective_to		Effective To
		policy_amount	bigint	Policy Amount
		due_date	datetime	Due Date
	ains_accounting_info_dtl	timestamp	int	Time Stamp
		ou_id		Organization Unit Id
		tran_number	sql_variant	Transaction Number
		asset_number		Asset Number
		tag_number	int	Tag Number
		tran_type	sql_variant	Transaction Type
		tran_date	datetime	Transaction Date
		posting_date		Posting Date
		account_code	sql_variant	Account Code
		drcr_flag		Debit Credit Flag
		currency_code		Currency Code
		tran_amount	bigint	Transaction Amount
		fb_id	sql_variant	Finance Book Id
		base_amount	bigint	Base Amount
		exchange_rate		Exchange Rate
		analysis_code	sql_variant	Analysis Code
		subanalysis_code		Subanalysis Code
		cost_center		Cost Center
		par_base_amount	bigint	Parallel Base Amount
		par_exchange_rate		Parallel Exchange Rate
		company_code	sql_variant	Company Code
		bu_id		Business Unit Id
		account_type		Account Type
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_accounting_info_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		tran_number	sql_variant	Transaction Number
		asset_number		Asset Number
		tag_number	int	Tag Number
		tran_type	sql_variant	Transaction Type
		tran_date	datetime	Transaction Date
		posting_date		Posting Date
		account_code	sql_variant	Account Code
		drcr_flag		Debit Credit Flag
		currency_code		Currency Code
		tran_amount	bigint	Transaction Amount
		fb_id	sql_variant	Finance Book Id
		base_amount	bigint	Base Amount
		exchange_rate		Exchange Rate
		analysis_code	sql_variant	Analysis Code
		subanalysis_code		Subanalysis Code
		cost_center		Cost Center
		par_base_amount	bigint	Parallel Base Amount
		par_exchange_rate		Parallel Exchange Rate
		company_code	sql_variant	Company Code
		bu_id		Business Unit Id
		account_type		Account Type
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_asset_policy_rpt	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ason_date	datetime	As On Date
		company_name	sql_variant	Company Name
		policy_type		Policy Type
		policy_number		Policy Number
		inscompany_name		Instance Company Name
		effective_from_date	datetime	Effective From Date
		effective_to_date		Effective To Date
		policy_amount	bigint	Policy Amount
		premium_amount		Premium Amount
		due_date	datetime	Due Date
		outstanding_amount	bigint	Outstanding Amount
		fb_id	sql_variant	Finance Book Id
		asset_class		Asset Class
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_claims_dtl	ou_id	int	Organization Unit Id	Yes
		claim_number	sql_variant	Claim Number
		asset_number		Asset Number
		timestamp	int	Time Stamp	No
		policy_number	sql_variant	Policy Number
		asset_desc		Asset Description
		tag_number	int	Tag Number
		tag_desc	sql_variant	Tag Description
		tag_status		Tag Status
		insurable_value	bigint	Insurable Value
		loss_incurred		Loss Incurred
		claim_amount		Claim Amount
		reason	sql_variant	Reason
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_claims_hdr	ou_id	int	Organization Unit Id	Yes
		claim_number	sql_variant	Claim Number
		timestamp	int	Time Stamp	No
		policy_number	sql_variant	Policy Number
		num_type		Numbering Type
		claim_status		Claim Status
		ref_number		Reference Number
		tot_claim_amount	bigint	Total Claim Amount
		claim_date	datetime	Claim Date
		renewal_number	sql_variant	Renewal Number
		policy_type		Policy Type
		reversal_number		Reversal Number
		fb_id		Finance Book Id
		unsettled_amount	bigint	Unsettled Amount
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_claims_hdr_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		claim_number	sql_variant	Claim Number
		policy_number		Policy Number
		num_type		Numbering Type
		claim_status		Claim Status
		ref_number		Reference Number
		tot_claim_amount	bigint	Total Claim Amount
		claim_date	datetime	Claim Date
		renewal_number	sql_variant	Renewal Number
		policy_type		Policy Type
		reversal_number		Reversal Number
		settlement_number		Settlement Number
		unsettled_amount	bigint	Unsettled Amount
		settled_amount		Settled Amount
		settled_date	datetime	Settled Date
		reversal_date		Reversal Date
		incr_settled_amount	bigint	Increased Settled Amount
		incr_receipt_amount		Increased Receipt Amount
		asset_number	sql_variant	Asset Number
		tag_number	int	Tag Number
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_company_mst	ou_id	int	Organization Unit Id	Yes
		company_code	sql_variant	Company Code
		timestamp	int	Time Stamp	No
		company_name	sql_variant	Company Name
		contact_person		Contact Person
		address_1		Address 1
		address_2		Address 2
		address_3		Address 3
		city		City
		state		State
		country		Country
		zip		Zip
		telex		Telex
		phone		Phone
		fax		Fax
		url		Universal Resource Locator
		email		Email
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_fbpostings_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		company_code		Company Code
		component_name		Component Name
		bu_id		Business Unit Id
		fb_id		Finance Book Id
		tran_ou	int	Transaction Organization Unit
		fb_voucher_no	sql_variant	Finance Book Voucher Number
		fb_voucher_date	datetime	Finance Book Voucher Date
		document_no	sql_variant	Document Number
		tran_type		Transaction Type
		tran_date	datetime	Transaction Date
		posting_date		Posting Date
		account_code	sql_variant	Account Code
		drcr_flag		Debit Credit Flag
		currency_code		Currency Code
		tran_amount	bigint	Transaction Amount
		base_amount		Base Amount
		exchange_rate		Exchange Rate
		ou_id	int	Organization Unit Id
		analysis_code	sql_variant	Analysis Code
		subanalysis_code		Subanalysis Code
		cost_center		Cost Center
		par_base_amount	bigint	Parallel Base Amount
		par_exchange_rate		Parallel Exchange Rate
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_filter_rpt	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		policy_type		Policy Type
		ason_date	datetime	As On Date
		asset_class	sql_variant	Asset Class
		fb_id		Finance Book Id
		asset_group		Asset Group
		inscompany_code		Instance Company Code
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_index_tmp	timestamp	int	Time Stamp
		ains_indexyear	sql_variant	Asset Insurance Index Year
		ains_indexes	bigint	Asset Insurance Indexes
		ains_start_date	datetime	Asset Insurance Start Date
		ains_end_date		Asset Insurance End Date
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_is_snp_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		tran_ou	int	Transaction Organization Unit
		fb_id	sql_variant	Finance Book Id
		tran_date	datetime	Transaction Date
		tran_amount	bigint	Transaction Amount
		currency	sql_variant	Currency
		voucher_type		Voucher Type
		no_type		Numbering Type
		usage_id		Usage Id
		payee		Payee
		line_no	int	Line Number
		pay_date	datetime	Pay Date
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
		cost_center	sql_variant	Cost Center
		account_line	int	Account Line
	ains_notes_dtl	timestamp		Time Stamp
		ouid		Organization Unit Id
		policy_number	sql_variant	Policy Number
		reversal_number		Reversal Number
		claim_number		Claim Number
		settlement_number		Settlement Number
		note_id		Note Id
		notes_desc		Note Description
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_notes_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		notes_id		Notes Id
		notes_desc		Notes Description
		notes		Notes
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_payment_info_dtl	renewal_number	sql_variant	Renewal Number	Yes
		ou_id	int	Organization Unit Id
		policy_number	sql_variant	Policy Number
		due_date	datetime	Due Date
		amend_flag	sql_variant	Amendment Flag
		timestamp	int	Time Stamp	No
		due_amount	bigint	Due Amount
		pay_date	datetime	Pay Date
		voucher_number	sql_variant	Voucher Number
		request_date	datetime	Request Date
		pay_amount	bigint	Pay Amount
		unadjusted_amount		Unadjusted Amount
		voucher_status	sql_variant	Voucher Status
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_payment_info_hdr	ou_id	int	Organization Unit Id	Yes
		policy_number	sql_variant	Policy Number
		renewal_number		Renewal Number
		timestamp	int	Time Stamp	No
		policy_type	sql_variant	Policy Type
		start_date	datetime	Start Date
		end_date		End Date
		frequency	sql_variant	Frequency
		flat_amount	bigint	Flat Amount
		tot_due_amount		Total Due Amount
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_payment_info_tmp	guid	sql_variant	Guid	Yes
		ou_id	int	Organization Unid Id
		policy_number	sql_variant	Policy Number
		due_date	datetime	Due Date
		timestamp	int	Time Stamp	No
		due_amount	bigint	Due Amount
		pay_date	datetime	Pay Date
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_cnt_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		asset_number	sql_variant	Asset Number
		tag_number	int	Tag Number
		policy_number	sql_variant	Policy Number
		renewal_number		Renewal Number
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_compute_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		asset_number	sql_variant	Asset Number
		tag_number	int	Tag Number
		policy_number	sql_variant	Policy Number
		asset_desc		Asset Description
		tag_desc		Tag Description
		tag_status		Tag Status
		premium_amount	bigint	Premium Amount
		insurable_value		Insurable Value
		valuation_rule_num	sql_variant	Valuation Rule Number
		bu_id		Business Unit Id
		asset_class		Asset Class
		asset_location		Asset Location
		asset_grp		Asset Group
		cost_center		Cost Center
		flag		Flag
		renewal_number		Renewal Number
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_dtl	ou_id	int	Organization Unit Id	Yes
		policy_number	sql_variant	Policy Number
		asset_number		Asset Number
		tag_number	int	Tag Number
		renewal_number	sql_variant	Renewal Number
		timestamp	int	Time Stamp	No
		asset_desc	sql_variant	Asset Description
		tag_desc		Tag Description
		tag_status		Tag Status
		premium_amount	bigint	Premium Amount
		insurable_value		Insurable Value
		valuation_rule_num	sql_variant	Valuation Rule Number
		bu_id		Business Unit Id
		asset_class		Asset Class
		asset_location		Asset Location
		asset_grp		Asset Group
		cost_center		Cost Center
		claim_status		Claim Status
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_dtl_his	timestamp	int	Time Stamp
		asset_number	sql_variant	Asset Number
		tag_number	int	Tag Number
		asset_desc	sql_variant	Asset Description
		tag_desc		Tag Description
		tag_status		Tag Status
		premium_amount	bigint	Premium Amount
		insurable_value		Insurable Value
		valuation_rule_num	sql_variant	Valuation Rule Number
		bu_id		Business Unit Id
		asset_class		Asset Class
		asset_location		Asset Location
		asset_grp		Asset Group
		cost_center		Cost Center
		createdby		Create By
		createddate	datetime	Create Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_hdr	ou_id	int	Organization Unit Id	Yes
		policy_number	sql_variant	Policy Number
		renewal_number		Renewal Number
		timestamp	int	Time Stamp	No
		policy_type	sql_variant	Policy Type
		policy_desc		Policy Description
		company_code		Company Code
		bpayment_type		Base Payment Type
		policy_amount	bigint	Policy Amount
		premium_amount		Premium Amount
		risk_per		Risk Per
		eff_date_from	datetime	Effective Date From
		eff_date_to		Effective Date To
		policy_status	sql_variant	Policy Status
		notes		Notes
		bu_id		Business Unit Id
		premium_paid	bigint	Premium Paid
		adjustable_amount		Adjustable Amount
		voucher_number	sql_variant	Voucher Number
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_hdr_his	timestamp	int	Time Stamp
		ou_id		Organization Unit Id
		policy_number	sql_variant	Policy Number
		renewal_number		Renewal Number
		policy_type		Policy Type
		policy_desc		Policy Description
		company_code		Company Code
		bpayment_type		Base Payment Type
		policy_amount	bigint	Policy Amount
		premium_amount		Premium Amount
		risk_per		Risk Per
		eff_date_from	datetime	Effective Date From
		eff_date_to		Effective Date To
		policy_status	sql_variant	Policy Status
		notes		Notes
		bu_id		Business Unit Id
		premium_paid	bigint	Premium Paid
		adjustable_amount		Adjustable Amount
		voucher_number	sql_variant	Voucher Number
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_rpt	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ason_date	datetime	As On Date
		company_name	sql_variant	Company Name
		policy_type		Policy Type
		policy_number		Policy Number
		inscompany_name		Instance Company Name
		effective_from_date	datetime	Effective From Date
		effective_to_date		Effective To Date
		policy_amount	bigint	Policy Amount
		premium_amount		Premium Amount
		due_date	datetime	Due Date
		outstanding_amount	bigint	Outstanding Amount
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_policy_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		asset_number	sql_variant	Asset Number
		tag_number	int	Tag Number
		policy_number	sql_variant	Policy Number
		asset_desc		Asset Description
		tag_desc		Tag Description
		tag_status		Tag Status
		premium_amount	bigint	Premium Amount
		insurable_value		Insurable Value
		valuation_rule_num	sql_variant	Valuation Rule Number
		bu_id		Business Unit Id
		asset_class		Class
		asset_location		Asset Location
		asset_grp		Asset Group
		cost_center		Cost Center
		flag		Flag
		renewal_number		Renewal Number
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
		bpayment_type	sql_variant	Base Payment Type
	ains_rep_policy_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ouid	int	Organization Unit Id
		policy_number	sql_variant	Policy Number
		policy_type		Policy Type
		company_code		Company Code
		fb_id		Finance Book Id
		asset_class		Asset Class
		eff_date_from	datetime	Effective Date From
		eff_date_to		Effective Date To
		policy_amount	bigint	Policy Amount
		premium_amount		Premium Amount
		inv_cycle	sql_variant	Invoice Cycle
		outstanding_amount	bigint	Outstanding Amount
		policy_status	sql_variant	Policy Status
		asset_number		Asset Number
		asset_desc		Asset Description
		tag_number	int	Tag Number
		tag_desc	sql_variant	Tag Description
		tag_cost	bigint	Tag Cost
		insurable_value		Insurable Value
		inservice_date	datetime	Inservice Date
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_settlement_dtl	ou_id	int	Organization Unit Id	Yes
		settlement_number	sql_variant	Settlement Number
		receipt_number		Receipt Number
		timestamp	int	Time Stamp	No
		receipt_date	datetime	Receipt Date
		receipt_amount	bigint	Receipt Amount
		amount_considered		Amount Considered
		receipt_type	sql_variant	Receipt Type
		bank_cash_code		Bank Cash Code
		receipt_mode		Receipt Mode
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_settlement_hdr	ou_id	int	Organization Unit Id	Yes
		settlement_number	sql_variant	Settlement Number
		timestamp	int	Time Stamp	No
		claim_number	sql_variant	Claim Number
		tot_receipt_amount	bigint	Total Receipt Amount
		tot_considered_amount		Total Considered Amount
		fb_id	sql_variant	Finance Book Id
		unsettled_amount	bigint	Unsettled Amount
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_settlement_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		settlement_number	sql_variant	Settlement Number
		receipt_number		Receipt Number
		receipt_date	datetime	Receipt Date
		receipt_amount	bigint	Receipt Amount
		amount_considered		Amount Considered
		receipt_type	sql_variant	Receipt Type
		bank_cash_code		Bank Cash Code
		receipt_mode		Receipt Mode
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_valuation_rules_dtl	ou_id	int	Organization Unit Id	Yes
		val_rule_number	sql_variant	Value Rule Number
		index_year		Index Year
		timestamp	int	Time Stamp	No
		start_date	datetime	Start Date
		end_date		End Date
		indexes	bigint	Indexes
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_valuation_rules_hdr	ou_id	int	Organization Unit Id	Yes
		val_rule_number	sql_variant	Value Rule Number
		timestamp	int	Time Stamp	No
		val_rule_desc	sql_variant	Value Rule Description
		policy_type		Policy Type
		rev_type		Reversal Type
		reval_cum_depr		Revalue Cumulative Description
		depr_book		Description Book
		rev_basis		Reverse Basis
		rev_option		Reverse Option
		reval_percent	bigint	Revalue Percetage
		rev_index_option	sql_variant	Reversal Index Option
		no_index_years	bigint	Number Of Years
		start_year	sql_variant	Start Year
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_voucher_hdr	ou_id	int	Organization Unit Id	Yes
		voucher_number	sql_variant	Voucher Number
		timestamp	int	Time Stamp	No
		bu_id	sql_variant	Business Unit Id
		payee		Payee
		request_date	datetime	Request Date
		pay_date		Pay Date
		bank_cash_code	sql_variant	Bank Cash Code
		pay_amount	bigint	Pay Amount
		unadjust_amount		Other Than Adjustable Amount
		voucher_status	sql_variant	Voucher Status
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_voucher_info_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		pay_date	datetime	Pay Date
		pay_amount	bigint	Pay Amount
		payee	sql_variant	Payee
		currency		Currency
		voucher_type		Voucher Type
		num_type		Numbering Type
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	ains_voucher_tmp	timestamp	int	Time Stamp
		guid	sql_variant	Guid
		ou_id	int	Organization Unit Id
		voucher_number	sql_variant	Voucher Number
		line_no	int	Line Number
		voucher_status	sql_variant	Vocher Status
		bu_id		Business Unit Id
		policy_number		Policy Number
		policy_desc		Policy Description
		renewal_number		Renewal Number
		policy_amount	bigint	Policy Amount
		premium_amount		Premium Amount
		premium_paid		Premium Paid
		adjustable_amount		Adjustable Amount
		company_code	sql_variant	Company Code
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date