APLAN

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	aplan_acq_proposal_amend_dtl	This table will store all amend acquisition proposal details will be stored.	proposal_number	sql_variant	Proposal Number	Yes	No
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			amendment_number		Amendment Number
			asset_desc		Asset Description
			timestamp	int	Time Stamp	No
			no_of_units		Number Of Units
			proposal_cost	bigint	Proposal Cost
			cost_base_curr		Cost Base Currency
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_acq_proposal_amend_hdr		ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			amendment_number		Amendment Number
			proposal_number		Proposal Number
			timestamp	int	Time Stamp	No
			proposal_date	datetime	Proposal Date
			numbering_typeno	sql_variant	Numbering Type Number
			proposal_desc		Proposal Description
			budget_number		Budget Number
			board_ref		Board Reference
			board_ref_date	datetime	Board Reference Date
			expiry_date		Expiry Date
			exchange_rate	bigint	Exchange Rate
			exchange_rate_var_per	int	Exchange Rate Variance Percentage
			cost_var_per		Cost Variance Percentage
			total_proposed_cost_bc	bigint	Total Proposed Cost Base Currency
			total_prop_cost_orig		Total Proposed Cost Base Original
			proposed_cost_variance		Proposed Cost Variance
			proposal_status	sql_variant	Proposal Status.Values "FR-Fresh,AC-Active, IA-Inactive,RE-Returned,CL-Closed"
			prop_cost_diff	bigint	Proposal Cost Difference
			committed_amount		Committed Amount
			liability_amount		Liability Amount
			proposed_cost		Proposed Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			financial_period	sql_variant	Financial Period
			cost_center		Cost Center
			filename		File Name
	aplan_acq_proposal_dtl	This table will store all acquisition proposal details will be stored.	fb_id		Finance Book Id	Yes
			ou_id	int	Organization Unit Id
			financial_year	sql_variant	Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			asset_desc		Asset Description
			proposal_number		Proposal Number
			timestamp	int	Time Stamp	No
			no_of_units		Number Of Units
			proposal_cost	bigint	Proposal Cost
			cost_base_curr		Cost Base Currency
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_acq_proposal_hdr		ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			proposal_number		Proposal Number
			timestamp	int	Time Stamp	No
			proposal_date	datetime	Proposal Date
			numbering_typeno	sql_variant	Numbering Type Number
			proposal_desc		Proposal Description
			budget_number		Budget Number
			board_ref		Board Reference
			board_ref_date	datetime	Board Reference Date
			expiry_date		Expiry Date
			exchange_rate	bigint	Exchange Rate
			exchange_rate_var_per	int	Exchange Rate Variance Percentage
			cost_var_per		Cost Variance Percentage
			total_proposed_cost_bc	bigint	Total Proposed Cost Base Currency
			proposed_cost_variance		Proposed Cost Variance
			proposal_status	sql_variant	Proposal Status.Values "FR-Fresh,AC-Active, IA-Inactive,RE-Returned,CL-Closed"
			amendment_number		Amendment Number
			proposed_cost	bigint	Proposed Cost
			commited_amount		Commited Amount
			liability_amount		Liability Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			financial_period	sql_variant	Financial Period
			cost_center		Cost Center
			filename		File Name
	aplan_acq_proposal_tmp		ou_id	int	Organization Unit Id	Yes
			guid	sql_variant	Guid
			proposal_number		Proposal Number
			asset_desc		Asset Description
			timestamp	int	Time Stamp	No
			no_of_units		Number Of Units
			currency_code	sql_variant	Currency Code
			proposal_cost	bigint	Proposal Cost
			cost_base_curr		Cost Base Currency
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_amend_dtl	This table will store all ament budget number details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			financial_year		Financial Year
			amendment_number		Amendment Number
			budget_number		Budget Number
			timestamp	int	Time Stamp	No
			amount_required	bigint	Amount Required
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			allocated_amount		Allocated Amount
			allow_variance	sql_variant	Allow Variance
			variance_per	int	Variance Percentage
			variance_amount	bigint	Variance Amount
			base_alloc_amount		Base Allocation Amount
			base_variance_amount		Base Variance Amount
			remarks	sql_variant	Remarks
			utilized_amount	bigint	Utilized Amount
			base_utilized_amount		Base Utilized Amount
			balance_amount		Balance Amount
			base_balance_amount		Base Balance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_amend_hdr		ou_id	int	Organization Unit Id	Yes
			financial_year	sql_variant	Financial Year
			amendment_number		Amendment Number
			budget_number		Budget Number
			timestamp	int	Time Stamp	No
			budget_date	datetime	Budget Date
			numbering_typeno	sql_variant	Numbering Type Number
			total_base_req_amount	bigint	Total Base Required Amount
			total_base_alloc_amount		Total Base Allocation Amount
			total_base_variance_amount		Total Base Variance Amount
			budget_status	sql_variant	Budget Status.Value AC-Active
			doc_type		Document Type
			utilized_amount	bigint	Utilized Amount
			total_proposed_amount		Total Proposed Amount
			total_alloc_amount		Total Allocation Amount
			total_utilized_amount		Total Utilized Amount
			total_base_bal_amount		Total Base Balance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_dtl	This table will store all budget number details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_class_code		Asset Class Code
			financial_year		Financial Year
			currency_code		Currency Code
			budget_number		Budget Number
			timestamp	int	Time Stamp	No
			amount_required	bigint	Amount Required
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			allocated_amount		Allocated Amount
			allow_variance	sql_variant	Allow Variance
			variance_per	int	Variance Percentage
			variance_amount	bigint	Variance Amount
			base_alloc_amount		Base Allocation Amount
			base_variance_amount		Base Variance Amount
			remarks	sql_variant	Remarks
			utilized_amount	bigint	Utilized Amount
			base_utilized_amount		Base Utilized Amount
			balance_amount		Balance Amount
			base_balance_amount		Base Balance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_hdr		ou_id	int	Organization Unit Id	Yes
			financial_year	sql_variant	Financial Year
			budget_number		Budget Number
			timestamp	int	Time Stamp	No
			budget_date	datetime	Budget Date
			numbering_typeno	sql_variant	Numbering Type Number
			total_base_req_amount	bigint	Total Base Required Amount
			total_base_alloc_amount		Total Base Allocation Amount
			total_base_variance_amount		Total Base Variance Amount
			budget_status	sql_variant	Budget Status.Value AC-Active
			doc_type		Document Type
			utilized_amount	bigint	Utilized Amount
			total_proposed_amount		Total Proposed Amount
			amendment_number	sql_variant	Amendment Number
			total_alloc_amount	bigint	Total Allocation Number
			total_utilized_amount		Total Utilized Amount
			total_base_bal_amount		Total Base Balance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_req_dtl	This table will store all retirement budget details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			timestamp	int	Time Stamp	No
			budget_req_number	sql_variant	Budget Requirement Number
			amount_required	bigint	Amount Required
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			budget_number		Budget Number
			alloc_amount	bigint	Allocation Amount
			allow_variance	sql_variant	Allow Variance
			variance_amount	bigint	Variance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_req_hdr		ou_id	int	Organization Unit Id	Yes
			financial_year	sql_variant	Financial Year
			fb_id		Finance Book Id
			budget_req_number		Budget Requirement Number
			budget_req_status		Budget Requirement Status.Value AC-Active	No
			timestamp	int	Time Stamp
			request_date	datetime	Request Date
			numbering_typeno	sql_variant	Numbering Type Number
			amendment_number		Amendment Number
			total_amount_reqd	bigint	Total Amount Required
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_req_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			timestamp	int	Time Stamp	No
			amount_required	bigint	Amount Required
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_budget_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			budget_number	sql_variant	Budget Number
			fb_id		Finance Book Id
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			timestamp	int	Time Stamp	No
			budget_req_number	sql_variant	Budget Requirement Number
			amount_required	bigint	Amount Required
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			allocated_amount		Allocated Amount
			allow_variance	sql_variant	Allow Variance
			variance_per	int	Variance Percentage
			variance_amount	bigint	Variance Amount
			base_alloc_amount		Base Allocation Amount
			base_variance_amount		Base Variance Amount
			remarks	sql_variant	Remarks
			utilized_amount	bigint	Utilized Amount
			base_utilized_amount		Base Utilized Amount
			balance_amount		Balance Amount
			base_balance_amount		Base Balance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_key_holder_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			key1		Key 1
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_notes_dtl	This table will store all proposal note details will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			proposal_number	sql_variant	Proposal Number
			budget_number		Budget Number
			budget_req_number		Budget Requirement Number
			notes_desc		Noted Description
			fin_type		Finance Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_notes_dtl_his	This table will store all proposal note details will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			proposal_number	sql_variant	Proposal Number
			budget_number		Budget Number
			budget_req_number		Budget Requirement Number
			notes_desc		Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_notes_dtl_tmp		guid	sql_variant	Guid	Yes
			timestamp	int	Time Stamp	No
			notes_id	sql_variant	Notes Id
			notes_desc		Notes Description
			notes		Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_prop_cost_history_temp		componentid	sql_variant	Component Id
			proposalno		Proposal Number
			proposalamt	bigint	Proposal Amount
			exp_date	datetime	Expiry Date
	aplan_prop_docbrk_dtl	This table will store all proposal document breakup details will be stored.	ouid	int	Organization Unit Id
			fbid	sql_variant	Finance Book Id
			proposal_no		Proposal Number
			currencycode		Currency Code
			compid		Component Id
			doc_type		Document Type
			doc_no		Document Number
			task_no		Task Number
			stage		Stage
			doc_amount	bigint	Document Amount
			sq_off_amount		Sequence Off Amount
			balance_amount		Balance Amount
			tran_date	datetime	Transaction Date
	aplan_prop_dochist_dtl		ouid	int	Organization Unit Id
			fbid	sql_variant	Finance Book Id
			compid		Component Id
			doc_type		Document Type
			doc_no		Document Number
			task_no		Task Document
			flag		Flag
			prop_date	datetime	Proposal Date
			currencycode	sql_variant	Currency Code
			proposal_no		Proposal Number
			stage		Stage
			amount	bigint	Amount
	aplan_prop_refsqr_dtl	This table will store all proposal square of amount details will be stored.	ouid	int	Organization Unit Id
			fbid	sql_variant	Finance Book Id
			ref_compid		Reference Component Id
			doc_no		Document Number
			task_no		Task Number
			flag		Flag
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			ref_task_no		Reference Task Number
			ref_doc_proposal_no		Reference Document Proposal Number
			stage		Stage
			ref_doc_currency		Reference Document Currency
			ref_doc_amount	bigint	Reference Document Amount
	aplan_prop_temp		guid	sql_variant	Guid
			ouid	int	Organization Unit Id
			fbid	sql_variant	Finance Book Id
			compid		Component Id
			doc_type		Document Type
			doc_no		Document Number
			task_no		Task Number
			flag		Flag
			prop_date	datetime	Proposal Date
			currencycode	sql_variant	Currency Code
			proposal_no		Proposal Number
			stage		Stage
			amount	bigint	Amount
			ref_compid	sql_variant	Reference Component Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			ref_task_no		Reference Task Number
			ref_doc_proposal_no		Reference Document Proposal Number
			ref_doc_currency		Reference Document Currency
			ref_doc_amount	bigint	Reference Document Amount
			seqno	int	Sequence Number
	aplan_proposal_bal_dtl	This table will store all proposal balance details will be stored.	timestamp		Time Stamp
			ou_id		Organization Unit Id
			proposal_number	sql_variant	Proposal Number
			currency		Currency
			proposal_amount	bigint	Proposal Amount
			balance_amount		Balance Amount
			committed_amount		Committed Amount
			liability_amount		Liability Amount
			utilized_amount		Utilized Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_proposal_rep_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			proposal_number		Proposal Number
			proposal_desc		Proposal Description
			proposal_date	datetime	Proposal Date
			total_proposed_cost_bc	bigint	Total Proposed Cost Base Currency
			proposal_status	sql_variant	Proposal Status
			asset_number		Asset Number
			asset_desc		Asset Description
			cap_date	datetime	Capitalization Date
			asset_cost	bigint	Asset Cost
			balanceamount		Balance Amount
			asset_class	sql_variant	Asset Class
			asset_group		Asset Group
			commited_amount	bigint	Committed Amount
			liability_amount		Liability Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_req_amend_dtl	This table will store all amend retirement proposal details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			amendment_number		Amendment Number
			timestamp	int	Time Stamp	No
			budget_req_number	sql_variant	Budget Requirement Number
			amount_required	bigint	Amount Required
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			budget_number		Budget Number
			alloc_amount	bigint	Allocation Amount
			allow_variance	sql_variant	Allow Variance
			variance_amount	bigint	Variance Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_req_amend_hdr		ou_id	int	Organization Unit Id	Yes
			financial_year	sql_variant	Financial Year
			fb_id		Finance Book Id
			amendment_number		Amendment Number
			timestamp	int	Time Stamp	No
			budget_req_number	sql_variant	Budget Requirement Number
			request_date	datetime	Request Date
			numbering_typeno	sql_variant	Numbering Type Number
			budget_req_status		Budget Requirement Status.value AC-Active
			total_amount_reqd	bigint	Total Amount Required
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_ret_proposal_amend_dtl	This table will store all retire amend retirement proposal details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			amendment_number		Amendment Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			proposal_number	sql_variant	Proposal Number
			timestamp	int	Time Stamp	No
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_cost	bigint	Asset Cost
			cum_depreciation		Cumulative Depreciation
			wdv_amount		Amount
			sale_value		Sale Value
			sale_value_orig		Sale Value Original
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_ret_proposal_amend_hdr		ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			amendment_number		Amendment Number
			proposal_number		Proposal Number
			timestamp	int	Time Stamp	No
			proposal_date	datetime	Proposal Date
			retirement_mode	sql_variant	Retirement Mode
			numbering_typeno		Numbering Type Number
			proposal_desc		Proposal Description
			board_ref		Board Reference
			board_ref_date	datetime	Board Reference Date
			proposal_status	sql_variant	Proposal Status.value AC-Active
			total_proposed_amount_bc	bigint	Total Proposed Amount Base Currency
			total_prop_amount_orig		Total Proposed Amount Original
			prop_amount_diff		Proposed Amount Difference
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_ret_proposal_dtl	This table will store all petire proposal details will be stored.	asset_number	sql_variant	Asset Number	Yes
			tag_number	int	Tag Number
			ou_id		Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			proposal_number		Proposal Number
			timestamp	int	Time Stamp	No
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_cost	bigint	Asset Cost
			cum_depreciation		Cumulative Depreciation
			wdv_amount		Amount
			sale_value		Sale Value
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_ret_proposal_hdr	This table will store all retire proposal details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			proposal_number		Proposal Number
			timestamp	int	Time Stamp	No
			proposal_date	datetime	Proposal Date
			retirement_mode	sql_variant	Retirement Mode
			numbering_typeno		Numbering Type Number
			proposal_desc		Proposal Description
			board_ref		Board Reference
			board_ref_date	datetime	Board Reference Date
			proposal_status	sql_variant	Proposal Status.Values FR-Fresh,AC-Active,IA-Inactive,RE-ReturnemCL-Closed
			total_proposed_amount_bc	bigint	Total Proposed Amount Base Currency
			amendment_number	sql_variant	Amendment Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	aplan_ret_proposal_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			financial_year	sql_variant	Financial Year
			fb_id		Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			proposal_number	sql_variant	Proposal Number
			asset_desc		Asset Description
			tag_desc		Tag Description
			asset_cost	bigint	Asset Cost
			cum_depreciation		Cumulative Depreciation
			wdv_amount		Amount
			sale_value		Sale Value
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date