AINS

Table Owner	Table Name	Table Comment	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		Permium 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 Unid 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		Numering 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		Numering 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	Amendent 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 Clas
			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 Clas
			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 Descripiton
			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		Numbring 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