Data Dictionary -- Asset Planning

Srl. No.	Table Name	Comment
1	aplan_acq_proposal_amend_dtl	This table will store all amend acquisition proposal details.
2	aplan_acq_proposal_amend_hdr	This table will store all amend acquisition proposal header.
3	aplan_acq_proposal_dtl	This table will store all acquisition proposal details.
4	aplan_acq_proposal_hdr	This table will store all acquisition proposal header.
5	aplan_acq_proposal_yearwise_alloc	this table will store the all aquaisation prposals which are alloctaed yearwise
6	aplan_acq_proposal_yearwise_alloc_amend	This table will store all amend acquaisation proposal which are allocted yearly
7	aplan_budget_amend_dtl	This table will store all ament budget number details.
8	aplan_budget_amend_hdr	This table will store all ament budget number header.
9	aplan_budget_dtl	This table will store all budget number details.
10	aplan_budget_hdr	This table will store all budget number header.
11	aplan_budget_req_dtl	This table will store all retirement budget details.
12	aplan_budget_req_hdr	This table will store all retirement budget header.
13	aplan_notes_dtl	This table will store all proposal note details.
14	aplan_notes_dtl_his	This table will store all proposal note details history.
15	aplan_proposal_bal_dtl	This table will store all proposal balance details.
16	aplan_prop_docbrk_dtl	This table will store all proposal document breakup details.
17	aplan_prop_dochist_dtl	This table will store all proposal document history details.
18	aplan_prop_refsqr_dtl	This table will store all proposal square of amount details.
19	aplan_req_amend_dtl	This table will store all amend retirement proposal details.
20	aplan_req_amend_hdr	This table will store all amend retirement proposal header.
21	aplan_ret_proposal_amend_dtl	This table will store all retirement amend retirement proposal details.
22	aplan_ret_proposal_amend_hdr	This table will store all retirement amend retirement proposal header.
23	aplan_ret_proposal_dtl	This table will store all retirement proposal details.
24	aplan_ret_proposal_hdr	This table will store all retirement proposal header.

Table Name :	aplan_acq_proposal_amend_dtl
Comment :	This table will store all amend acquisition proposal details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
asset_desc	fin_desc40	varchar(40)	No	Asset Description	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
no_of_units	fin_number	int(4)	Yes	Number Of Units	No
proposal_cost	fin_amount	numeric(13)	Yes	Proposal Cost	No
cost_base_curr	fin_amount	numeric(13)	Yes	Cost Base Currency	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
tot_proposal_cost	fin_amount	numeric(13)	Yes	tot_proposal_cost	No
tot_cost_base_curr	fin_amount	numeric(13)	Yes	tot_cost_base_curr	No

Table Name :	aplan_acq_proposal_amend_hdr
Comment :	This table will store all amend acquisition proposal header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
proposal_date	_datetime_8	datetime(8)	Yes	Proposal Date	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
proposal_desc	fin_desc40	varchar(40)	Yes	Proposal Description	No
budget_number	fin_documentnumber	varchar(18)	Yes	Budget Number	No
board_ref	fin_remarks	varchar(100)	Yes	Board Reference	No
board_ref_date	_datetime_8	datetime(8)	Yes	Board Reference Date	No
expiry_date	_datetime_8	datetime(8)	Yes	Expiry Date	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
exchange_rate_var_per	fin_variance	int(4)	Yes	Exchange Rate Variance Percentage	No
cost_var_per	fin_variance	int(4)	Yes	Cost Variance Percentage	No
total_proposed_cost_bc	fin_amount	numeric(13)	Yes	Total Proposed Cost Base Currency	No
total_prop_cost_orig	fin_amount	numeric(13)	Yes	Total Proposed Cost Base Original	No
proposed_cost_variance	fin_amount	numeric(13)	Yes	Proposed Cost Variance	No
proposal_status	fin_status	varchar(25)	Yes	Proposal Status.Values "FR-Fresh,AC-Active, IA-Inactive,RE-Returned,CL-Closed"	No
prop_cost_diff	fin_amount	numeric(13)	Yes	Proposal Cost Difference	No
committed_amount	fin_amount	numeric(13)	Yes	Committed Amount	No
liability_amount	fin_amount	numeric(13)	Yes	Liability Amount	No
proposed_cost	fin_amount	numeric(13)	Yes	Proposed Cost	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
financial_period	fin_financeperiod	varchar(15)	Yes	Financial Period	No
cost_center	fin_maccost	varchar(32)	Yes	Cost Center	No
filename	fin_filename	varchar(50)	Yes	File Name	No
alloc_across_year	fin_designparamcode	Char(5)	Yes	alloc_across_year	No

Table Name :	aplan_acq_proposal_dtl
Comment :	This table will store all acquisition proposal details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
asset_desc	fin_desc40	varchar(40)	No	Asset Description	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
no_of_units	fin_number	int(4)	Yes	Number Of Units	No
proposal_cost	fin_amount	numeric(13)	Yes	Proposal Cost	No
cost_base_curr	fin_amount	numeric(13)	Yes	Cost Base Currency	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
tot_proposal_cost	fin_amount	numeric(13)	Yes	tot_proposal_cost	No
tot_cost_base_curr	fin_amount	numeric(13)	Yes	tot_cost_base_curr	No

Table Name :	aplan_acq_proposal_hdr
Comment :	This table will store all acquisition proposal header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
proposal_date	_datetime_8	datetime(8)	Yes	Proposal Date	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
proposal_desc	fin_desc40	varchar(40)	Yes	Proposal Description	No
budget_number	fin_documentnumber	varchar(18)	Yes	Budget Number	No
board_ref	fin_remarks	varchar(100)	Yes	Board Reference	No
board_ref_date	_datetime_8	datetime(8)	Yes	Board Reference Date	No
expiry_date	_datetime_8	datetime(8)	Yes	Expiry Date	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
exchange_rate_var_per	fin_variance	int(4)	Yes	Exchange Rate Variance Percentage	No
cost_var_per	fin_variance	int(4)	Yes	Cost Variance Percentage	No
total_proposed_cost_bc	fin_amount	numeric(13)	Yes	Total Proposed Cost Base Currency	No
proposed_cost_variance	fin_amount	numeric(13)	Yes	Proposed Cost Variance	No
proposal_status	fin_status	varchar(25)	Yes	Proposal Status.Values "FR-Fresh,AC-Active, IA-Inactive,RE-Returned,CL-Closed"	No
amendment_number	fin_documentnumber	varchar(18)	Yes	Amendment Number	No
proposed_cost	fin_amount	numeric(13)	Yes	Proposed Cost	No
commited_amount	fin_amount	numeric(13)	Yes	Commited Amount	No
liability_amount	fin_amount	numeric(13)	Yes	Liability Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
financial_period	fin_financeperiod	varchar(15)	Yes	Financial Period	No
cost_center	fin_maccost	varchar(32)	Yes	Cost Center	No
filename	fin_filename	varchar(50)	Yes	File Name	No
alloc_across_year	fin_designparamcode	Char(5)	Yes	alloc_across_year	No

Table Name :	aplan_acq_proposal_yearwise_alloc
Comment :	this table will store the all aquaisation prposals which are alloctaed yearwise

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
proposal_number	fin_documentnumber	varchar(18)	Yes	proposal_number	No
fb_id	fin_financebookid	varchar(20)	Yes	fb_id	No
financial_year	fin_financeyear	varchar(15)	Yes	financial_year	No
asset_class_code	fin_assetclass	varchar(20)	Yes	asset_class_code	No
amendment_number	fin_seqno	Int(4)	Yes	amendment_number	No
currency_code	fin_currency	varchar(5)	Yes	currency_code	No
proposal_cost	fin_amount	numeric(13)	Yes	proposal_cost	No
cost_base_curr	fin_amount	numeric(13)	Yes	cost_base_curr	No
createdby	fin_ctxt_user	varchar(30)	Yes	createdby	No
createddate	fin_datetime	Datetime(25)	Yes	createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modifiedby	No
modifieddate	fin_datetime	Datetime(25)	Yes	modifieddate	No
timestamp	fin_timestamp	Int(4)	Yes	timestamp	No

Table Name :	aplan_acq_proposal_yearwise_alloc_amend
Comment :	This table will store all amend acquaisation proposal which are allocted yearly

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
proposal_number	fin_documentnumber	varchar(18)	Yes	proposal_number	No
fb_id	fin_financebookid	varchar(20)	Yes	fb_id	No
financial_year	fin_financeyear	varchar(15)	Yes	financial_year	No
asset_class_code	fin_assetclass	varchar(20)	Yes	asset_class_code	No
amendment_number	fin_seqno	Int(4)	Yes	amendment_number	No
currency_code	fin_currency	varchar(5)	Yes	currency_code	No
proposal_cost	fin_amount	numeric(13)	Yes	proposal_cost	No
cost_base_curr	fin_amount	numeric(13)	Yes	cost_base_curr	No
createdby	fin_ctxt_user	varchar(30)	Yes	createdby	No
createddate	fin_datetime	Datetime(25)	Yes	createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modifiedby	No
modifieddate	fin_datetime	Datetime(25)	Yes	modifieddate	No
timestamp	fin_timestamp	Int(4)	Yes	timestamp	No

Table Name :	aplan_budget_amend_dtl
Comment :	This table will store all ament budget number details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
budget_number	fin_documentnumber	varchar(18)	No	Budget Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
amount_required	fin_amount	numeric(13)	Yes	Amount Required	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
base_amount	fin_amount	numeric(13)	Yes	Base Amount	No
allocated_amount	fin_amount	numeric(13)	Yes	Allocated Amount	No
allow_variance	fin_allowvaren	varchar(20)	Yes	Allow Variance	No
variance_per	fin_variance	int(4)	Yes	Variance Percentage	No
variance_amount	fin_amount	numeric(13)	Yes	Variance Amount	No
base_alloc_amount	fin_amount	numeric(13)	Yes	Base Allocation Amount	No
base_variance_amount	fin_amount	numeric(13)	Yes	Base Variance Amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
utilized_amount	fin_amount	numeric(13)	Yes	Utilized Amount	No
base_utilized_amount	fin_amount	numeric(13)	Yes	Base Utilized Amount	No
balance_amount	fin_amount	numeric(13)	Yes	Balance Amount	No
base_balance_amount	fin_amount	numeric(13)	Yes	Base Balance Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
alloc_across_year	fin_designparamcode	Char(5)	Yes	alloc_across_year	No

Table Name :	aplan_budget_amend_hdr
Comment :	This table will store all ament budget number header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
budget_number	fin_documentnumber	varchar(18)	No	Budget Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
budget_date	_datetime_8	datetime(8)	Yes	Budget Date	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
total_base_req_amount	fin_amount	numeric(13)	Yes	Total Base Required Amount	No
total_base_alloc_amount	fin_amount	numeric(13)	Yes	Total Base Allocaiton Amount	No
total_base_variance_amount	fin_amount	numeric(13)	Yes	Total Base Variance Amount	No
budget_status	fin_status	varchar(25)	Yes	Budget Status.Value AC-Active	No
doc_type	fin_type	varchar(25)	Yes	Document Type	No
utilized_amount	fin_amount	numeric(13)	Yes	Utilized Amount	No
total_proposed_amount	fin_amount	numeric(13)	Yes	Total Proposed Amount	No
total_alloc_amount	fin_amount	numeric(13)	Yes	Total Allocation Amount	No
total_utilized_amount	fin_amount	numeric(13)	Yes	Total Utilized Amount	No
total_base_bal_amount	fin_amount	numeric(13)	Yes	Total Base Balance Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_budget_dtl
Comment :	This table will store all budget number details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
budget_number	fin_documentnumber	varchar(18)	No	Budget Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
amount_required	fin_amount	numeric(13)	Yes	Amount Required	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
base_amount	fin_amount	numeric(13)	Yes	Base Amount	No
allocated_amount	fin_amount	numeric(13)	Yes	Allocated Amount	No
allow_variance	fin_allowvaren	varchar(20)	Yes	Allow Variance	No
variance_per	fin_variance	int(4)	Yes	Variance Percentage	No
variance_amount	fin_amount	numeric(13)	Yes	Variance Amount	No
base_alloc_amount	fin_amount	numeric(13)	Yes	Base Allocation Amount	No
base_variance_amount	fin_amount	numeric(13)	Yes	Base Variance Amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
utilized_amount	fin_amount	numeric(13)	Yes	Utilized Amount	No
base_utilized_amount	fin_amount	numeric(13)	Yes	Base Utilized Amount	No
balance_amount	fin_amount	numeric(13)	Yes	Balance Amount	No
base_balance_amount	fin_amount	numeric(13)	Yes	Base Balance Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
alloc_across_year	fin_designparamcode	Char(5)	Yes	alloc_across_year	No

Table Name :	aplan_budget_hdr
Comment :	This table will store all budget number header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
budget_number	fin_documentnumber	varchar(18)	No	Budget Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
budget_date	_datetime_8	datetime(8)	Yes	Budget Date	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
total_base_req_amount	fin_amount	numeric(13)	Yes	Total Base Required Amount	No
total_base_alloc_amount	fin_amount	numeric(13)	Yes	Total Base Allocaiton Amount	No
total_base_variance_amount	fin_amount	numeric(13)	Yes	Total Base Variance Amount	No
budget_status	fin_status	varchar(25)	Yes	Budget Status.Value AC-Active	No
doc_type	fin_type	varchar(25)	Yes	Document Type	No
utilized_amount	fin_amount	numeric(13)	Yes	Utilized Amount	No
total_proposed_amount	fin_amount	numeric(13)	Yes	Total Proposed Amount	No
amendment_number	fin_documentnumber	varchar(18)	Yes	Amendment Number	No
total_alloc_amount	fin_amount	numeric(13)	Yes	Total Allocation Amount	No
total_utilized_amount	fin_amount	numeric(13)	Yes	Total Utilized Amount	No
total_base_bal_amount	fin_amount	numeric(13)	Yes	Total Base Balance Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_budget_req_dtl
Comment :	This table will store all retirement budget details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
budget_req_number	fin_documentnumber	varchar(18)	Yes	Budget Requirement Number	No
amount_required	fin_amount	numeric(13)	Yes	Amount Required	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
base_amount	fin_amount	numeric(13)	Yes	Base Amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
budget_number	fin_documentnumber	varchar(18)	Yes	Budget Number	No
alloc_amount	fin_amount	numeric(13)	Yes	Allocation Amount	No
allow_variance	fin_allowvaren	varchar(20)	Yes	Allow Variance	No
variance_amount	fin_amount	numeric(13)	Yes	Variance Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_budget_req_hdr
Comment :	This table will store all retirement budget header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
budget_req_status	fin_status	varchar(25)	No	Budget Requirement Status.Value AC-Active	No
timestamp	_int_0	int(1)	Yes	Time Stamp	No
budget_req_number	fin_documentnumber	varchar(18)	No	Budget Requirement Number	Yes
request_date	_datetime_8	datetime(8)	Yes	Request Date	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
amendment_number	fin_documentnumber	varchar(18)	Yes	Amendment Number	No
total_amount_reqd	fin_amount	numeric(13)	Yes	Total Amount Required	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_notes_dtl
Comment :	This table will store all proposal note details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(1)	Yes	Time Stamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization Unit Id	No
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
budget_number	fin_documentnumber	varchar(18)	Yes	Budget Number	No
budget_req_number	fin_documentnumber	varchar(18)	Yes	Budget Requirement Number	No
notes_desc	fin_notes	varchar(2000)	Yes	Noted Description	No
fin_type	fin_type	varchar(25)	Yes	Finance Type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	aplan_notes_dtl_his
Comment :	This table will store all proposal note details history.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(1)	Yes	Time Stamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization Unit Id	No
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
budget_number	fin_documentnumber	varchar(18)	Yes	Budget Number	No
budget_req_number	fin_documentnumber	varchar(18)	Yes	Budget Requirement Number	No
notes_desc	fin_notes	varchar(2000)	Yes	Noted Description	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	aplan_proposal_bal_dtl
Comment :	This table will store all proposal balance details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(1)	Yes	Time Stamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization Unit Id	No
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
proposal_amount	fin_amount	numeric(13)	Yes	Proposal Amount	No
balance_amount	fin_amount	numeric(13)	Yes	Balance Amount	No
committed_amount	fin_amount	numeric(13)	Yes	Committed Amount	No
liability_amount	fin_amount	numeric(13)	Yes	Liability Amount	No
utilized_amount	fin_amount	numeric(13)	Yes	Utilized Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	aplan_prop_docbrk_dtl
Comment :	This table will store all proposal document breakup details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouid	fin_ctxt_ouinstance	int(4)	Yes	Organization Unit Id	No
fbid	fin_financebookid	varchar(20)	Yes	Finance Book Id	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
currencycode	fin_currencycode	varchar(5)	Yes	Currency Code	No
compid	fin_componentshortid	varchar(20)	Yes	Component Id	No
doc_type	fin_cmntrantype	varchar(10)	Yes	Document Type	No
doc_no	fin_documentnumber	varchar(18)	Yes	Document Number	No
task_no	fin_taskcode	varchar(30)	Yes	Task Number	No
stage	fin_param_text	varchar(255)	Yes	Stage	No
doc_amount	fin_amount	numeric(13)	Yes	Document Amount	No
sq_off_amount	fin_amount	numeric(13)	Yes	Sequence Off Amount	No
balance_amount	fin_amount	numeric(13)	Yes	Balance Amount	No
tran_date	_datetime_8	datetime(8)	Yes	Transaction Date	No
task_seqno	fin_taskseqno	int(4)	Yes	task_seqno	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	aplan_prop_dochist_dtl
Comment :	This table will store all proposal document history details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouid	fin_ctxt_ouinstance	int(4)	Yes	Organization Unit Id	No
fbid	fin_financebookid	varchar(20)	Yes	Finance Book Id	No
compid	fin_componentshortid	varchar(20)	Yes	Component Id	No
doc_type	fin_cmntrantype	varchar(10)	Yes	Document Type	No
doc_no	fin_documentnumber	varchar(18)	Yes	Document Number	No
task_no	fin_taskcode	varchar(30)	Yes	Task Number	No
flag	fin_flag	varchar(25)	Yes	Flag	No
prop_date	_datetime_8	datetime(8)	Yes	Proposal Date	No
currencycode	fin_currencycode	varchar(5)	Yes	Currency Code	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
stage	fin_param_text	varchar(255)	Yes	Stage	No
amount	fin_amount	numeric(13)	Yes	Amount	No
task_seqno	fin_taskseqno	int(4)	Yes	Task sequence number	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	aplan_prop_refsqr_dtl
Comment :	This table will store all proposal square of amount details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouid	fin_ctxt_ouinstance	int(4)	Yes	Organization Unit Id	No
fbid	fin_financebookid	varchar(20)	Yes	Finance Book Id	No
ref_compid	fin_componentshortid	varchar(20)	Yes	Reference Component Id	No
doc_no	fin_documentnumber	varchar(18)	Yes	Document Number	No
task_no	fin_taskcode	varchar(30)	Yes	Task Number	No
flag	fin_flag	varchar(25)	Yes	Flag	No
ref_doc_type	fin_cmntrantype	varchar(10)	Yes	Reference Document Type	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference Document Number	No
ref_task_no	fin_taskcode	varchar(30)	Yes	Reference Task Number	No
ref_doc_proposal_no	fin_documentnumber	varchar(18)	Yes	Reference Document Proposal Number	No
stage	fin_param_text	varchar(255)	Yes	Stage	No
ref_doc_currency	fin_currencycode	varchar(5)	Yes	Reference Document Currency	No
ref_doc_amount	fin_amount	numeric(13)	Yes	Reference Document Amount	No
task_seqno	fin_taskseqno	int(4)	Yes	Task sequence number	No
Ref_task_seqno	fin_taskseqno	int(4)	Yes	Reference task sequence number	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	aplan_req_amend_dtl
Comment :	This table will store all amend retirement proposal details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
asset_class_code	fin_assetclass	varchar(20)	No	Asset Class Code	Yes
currency_code	fin_currency	varchar(5)	No	Currency Code	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
budget_req_number	fin_documentnumber	varchar(18)	Yes	Budget Requirement Number	No
amount_required	fin_amount	numeric(13)	Yes	Amount Required	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
base_amount	fin_amount	numeric(13)	Yes	Base Amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
budget_number	fin_documentnumber	varchar(18)	Yes	Budget Number	No
alloc_amount	fin_amount	numeric(13)	Yes	Allocation Amount	No
allow_variance	fin_allowvaren	varchar(20)	Yes	Allow Variance	No
variance_amount	fin_amount	numeric(13)	Yes	Variance Amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_req_amend_hdr
Comment :	This table will store all amend retirement proposal header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
budget_req_number	fin_documentnumber	varchar(18)	Yes	Budget Requirement Number	No
request_date	_datetime_8	datetime(8)	Yes	Request Date	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
budget_req_status	fin_status	varchar(25)	Yes	Budget Requirement Status.Value AC-Active	No
total_amount_reqd	fin_amount	numeric(13)	Yes	Total Amount Required	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_ret_proposal_amend_dtl
Comment :	This table will store all retirement amend retirement proposal details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset Number	Yes
tag_number	fin_assettagno	int(4)	No	Tag Number	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset Description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag Description	No
asset_cost	fin_amount	numeric(13)	Yes	Asset Cost	No
cum_depreciation	fin_depprecent	numeric(13)	Yes	Cumulative Depreciation	No
wdv_amount	fin_amount	numeric(13)	Yes	Amount	No
sale_value	fin_amount	numeric(13)	Yes	Sale Value	No
sale_value_orig	fin_amount	numeric(13)	Yes	Sale Value Original	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_ret_proposal_amend_hdr
Comment :	This table will store all retirement amend retirement proposal header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
amendment_number	fin_documentnumber	varchar(18)	No	Amendment Number	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
proposal_date	_datetime_8	datetime(8)	Yes	Proposal Date	No
retirement_mode	fin_retirementmodeen	varchar(25)	Yes	Retirement Mode	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
proposal_desc	fin_desc40	varchar(40)	Yes	Proposal Description	No
board_ref	fin_remarks	varchar(100)	Yes	Board Reference	No
board_ref_date	_datetime_8	datetime(8)	Yes	Board Reference Date	No
proposal_status	fin_status	varchar(25)	Yes	Proposal Status.Values "FR-Fresh,AC-Active, IA-Inactive,RE-Returned,CL-Closed"	No
total_proposed_amount_bc	fin_amount	numeric(13)	Yes	Total Proposed Amount Base Currency	No
total_prop_amount_orig	fin_amount	numeric(13)	Yes	Total Proposed Amount Original	No
prop_amount_diff	fin_amount	numeric(13)	Yes	Proposed Amount Difference	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_ret_proposal_dtl
Comment :	This table will store all retirement proposal details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
asset_number	fin_assetnumber	varchar(18)	No	Asset Number	Yes
tag_number	fin_assettagno	int(4)	No	Tag Number	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset Description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag Description	No
asset_cost	fin_amount	numeric(13)	Yes	Asset Cost	No
cum_depreciation	fin_depprecent	numeric(13)	Yes	Cumulative Depreciation	No
wdv_amount	fin_amount	numeric(13)	Yes	Amount	No
sale_value	fin_amount	numeric(13)	Yes	Sale Value	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	aplan_ret_proposal_hdr
Comment :	This table will store all retirement proposal header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
financial_year	fin_financeyear	varchar(15)	No	Financial Year	Yes
proposal_number	fin_documentnumber	varchar(18)	No	Proposal Number	Yes
timestamp	_int_0	int(1)	Yes	Time Stamp	No
proposal_date	_datetime_8	datetime(8)	Yes	Proposal Date	No
retirement_mode	fin_retirementmodeen	varchar(25)	Yes	Retirement Mode	No
numbering_typeno	fin_notypeno	varchar(10)	Yes	Numbering Type Number	No
proposal_desc	fin_desc40	varchar(40)	Yes	Proposal Description	No
board_ref	fin_remarks	varchar(100)	Yes	Board Reference	No
board_ref_date	_datetime_8	datetime(8)	Yes	Board Reference Date	No
proposal_status	fin_status	varchar(25)	Yes	Proposal Status.Values "FR-Fresh,AC-Active, IA-Inactive,RE-Returned,CL-Closed"	No
total_proposed_amount_bc	fin_amount	numeric(13)	Yes	Total Proposed Amount Base Currency	No
amendment_number	fin_documentnumber	varchar(18)	Yes	Amendment Number	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	_datetime_8	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	_datetime_8	datetime(8)	Yes	Modified Date	No