Data Dictionary -- Asset Depreciation Processing

Srl. No.	Table Name	Comment
1	adepp_accounting_info_dtl	To store accounting information detail
2	adepp_adjustments_dtl	To store information of adjustment detail
3	adepp_adjustments_hdr	To store information of adjustment header
4	adepp_asset_tag_usage_summ	To store information of Asset tag usage summary
5	adepp_assign_deprcat	To store information of assignment depreciation category
6	adepp_batch_process_dtl	To store information of batch process detail
7	adepp_change_depr_dtl	To store information of change depreciation detail
8	adepp_change_depr_hdr	To store information of change depreciation header
9	adepp_change_setup_dtl	To store information of change setup detail
10	adepp_change_setup_hdr	To store information of change setup header
11	adepp_depr_expenses_rpt	To store information of depreciation expenses report
12	adepp_error_log	To store information of error log
13	adepp_maintain_usage_info	To maintain usage information
14	adepp_notes_dtl	To store information of notes detail
15	adepp_notes_dtl_his	To store history of notes
16	adepp_process_dtl	To store information of process detail
17	adepp_process_hdr	To store information of process header
18	adepp_process_summ	To store information of process summary
19	adepp_reverse_dtl	To store information of reverse detail
20	adepp_reverse_hdr	To store information of reverse header
21	adepp_rev_adjustments_dtl	To store information of reverse adjustment detail
22	adepp_rev_adjustments_hdr	To store information of reverse adjustment header
23	adepp_simulate_detail_rpt	To store information of simulate detail report
24	adepp_simulate_dtl	To store information of simulate detail
25	adepp_simulate_hdr	To store information of simulate header
26	adepp_suspension_dtl	To store information of suspension detail
27	adepp_suspension_hdr	To store information of suspension header
28	adepp_usage_allocation_dtl	To store information about Usage allocation details
29	adepp_usage_error_metadata	To store information about Usage error metadata
30	adep_depr_rule_hdr	asset depreciation rule header
31	cmn_adepp_cmewriteoff_input_his	asset depreciation cme write off input history
32	cmn_adepp_cmewriteoff_instance	asset depreciation cme write off instance table

Table Name :	adepp_accounting_info_dtl
Comment :	To store accounting information detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
tran_number	fin_transactionnumber	varchar(18)	Yes	Transaction number	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction	No
fb_id	fin_financebookid	varchar(20)	Yes	Financial book id	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
sub_analysis_code	fin_subanalysiscode	varchar(5)	Yes	Sub analysis code	No
bc_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
pbc_erate	fin_exchangerate	numeric(9)	Yes	Parallel base currency exchange rate	No
pbase_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
fin_period	fin_calendarcode	varchar(10)	Yes	Financial period	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_adjustments_dtl
Comment :	To store information of adjustment detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
document_no	fin_documentnumber	varchar(18)	No	Document number	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
drcr_flag	fin_flag	varchar(25)	Yes	Debit credit flag	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
cost_center	fin_costcentercode	varchar(10)	Yes	Coast center	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cme_depr_category	fin_deprcategory	varchar(40)	Yes	cme depreciation category	No
cme_depr_charge	fin_deprcategory	varchar(40)	Yes	cme depreciation charge	No

Table Name :	adepp_adjustments_hdr
Comment :	To store information of adjustment header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
document_no	fin_documentnumber	varchar(18)	No	Document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
doc_status	fin_status	varchar(25)	Yes	Document status	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
depr_total	fin_amount	numeric(13)	Yes	Depreciation total	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cme_depr_total	fin_amount	numeric(13)	Yes	cme_depr_total	No

Table Name :	adepp_asset_tag_usage_summ
Comment :	To store information of Asset tag usage summary

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit ID	Yes
Asset_Number	fin_assetnumber	varchar(18)	No	Asset Number	Yes
Tag_Number	fin_assettagno	int(4)	No	Tag Number	Yes
processed_uptodate	fin_datetime	datetime(8)	Yes	Processed upto date	No
job_id	fin_tasktrackid	bigint(8)	Yes	Job ID	No
ovh_date	fin_date	datetime(8)	Yes	Overhaul date	No
depr_runno	fin_documentno	varchar(40)	Yes	Depreciation run number	No
jv_number	fin_documentno	varchar(40)	Yes	Journal voucher number	No
rev_ovh_date	fin_date	datetime(8)	Yes	Revised Overhaul date	No
usage_fetched_upto	fin_datetime	datetime(8)	Yes	Usage Fetched Up to period	No
usage_saved_upto	fin_datetime	datetime(8)	Yes	Usage saved Up to period	No
cost_type	fin_costtypeeam	varchar(10)	Yes	Cost type	No
Maint_Type	fin_costtypeeam	varchar(10)	Yes	Maintenace type	No
rev_depr_runno	fin_documentno	varchar(40)	Yes	reverse depreciation run number	No
rev_jv_number	fin_documentno	varchar(40)	Yes	reverse journal voucher number	No
woff_flag	fin_int	int(4)	Yes	write off flag	No
revwoff_flag	fin_int	int(4)	Yes	reverse write off flag	No
replication_key	fin_bigint	Bigint(8)	No	replication key	Yes

Table Name :	adepp_assign_deprcat
Comment :	To store information of assignment depreciation category

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_tagno	varchar(20)	Yes	Tag number	No
prev_deprcate	fin_deprcategory	varchar(40)	Yes	Previous depreciation rate	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
inservice_date	fin_datetime	datetime(8)	Yes	Inservice date	No
effective_date	fin_datetime	datetime(8)	Yes	Effective date	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_batch_process_dtl
Comment :	To store information of batch process detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
guid	fin_guid	varchar(40)	No	Guid	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_proc_runno	fin_deprkey	varchar(20)	No	Depreciation process run number	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
susp_charge	fin_amount	numeric(13)	Yes	Suspension charge	No
tag_status	fin_status	varchar(25)	Yes	Tag status	No
tran_type	fin_transactiontypeid	varchar(10)	Yes	Transaction type	No
process_status	fin_status	varchar(25)	Yes	Process status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_change_depr_dtl
Comment :	To store information of change depreciation detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_proc_runno	fin_deprkey	varchar(20)	No	Depreciation process run number	Yes
change_setup_no	fin_deprkey	varchar(20)	No	Change setup number	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
inservice_date	fin_datetime	datetime(8)	No	Inservice date	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
fp_start_date	fin_datetime	datetime(8)	Yes	Financial period start date	No
fp_end_date	fin_datetime	datetime(8)	Yes	Financial period end date	No
existing_rule	fin_deprkey	varchar(20)	Yes	Existing rule	No
new_rule	fin_deprkey	varchar(20)	Yes	New rule	No
old_susp_amount	fin_amount	numeric(13)	Yes	Old suspension amount	No
old_depr_amount	fin_amount	numeric(13)	Yes	Old depreciation amount	No
new_susp_amount	fin_amount	numeric(13)	Yes	New suspension amount	No
new_depr_amount	fin_amount	numeric(13)	Yes	New depreciation amount	No
new_rev_susp_amount	fin_amount	numeric(13)	Yes	New reversal suspension amount	No
new_rev_depr_amount	fin_amount	numeric(13)	Yes	New reversal depreciation amount	No
old_rev_depr_amount	fin_amount	numeric(13)	Yes	Old reversal depreciation amount	No
old_rev_susp_amount	fin_amount	numeric(13)	Yes	Old reversal suspension amount	No
pbc_old_susp_amount	fin_amount	numeric(13)	Yes	Parallel base currency ol suspension amount	No
pbc_old_depr_amount	fin_amount	numeric(13)	Yes	Parallel base currency old depreciation amount	No
pbc_new_depr_amount	fin_amount	numeric(13)	Yes	Parallel base currency new depreciation amount	No
pbc_new_susp_amount	fin_amount	numeric(13)	Yes	Parallel base currency new suspension amount	No
pbc_old_rev_depr_amount	fin_amount	numeric(13)	Yes	Parallel base currency old reversal depreciation amount	No
pbc_old_rev_susp_amount	fin_amount	numeric(13)	Yes	Parallel base currency old reversal suspension amount	No
pbc_new_rev_depr_amount	fin_amount	numeric(13)	Yes	Parallel base currency new reversal depreciation amount	No
pbc_new_rev_susp_amount	fin_amount	numeric(13)	Yes	Parallel base currency new reversal suspension amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_change_depr_hdr
Comment :	To store information of change depreciation header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_proc_runno	fin_deprkey	varchar(20)	No	Depreciation process run number	Yes
change_setup_no	fin_deprkey	varchar(20)	No	Change setup number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
process_date	fin_datetime	datetime(8)	Yes	Process date	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
status	fin_status	varchar(25)	Yes	Status	No
fb_id	fin_financebookid	varchar(20)	Yes	Financial book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
pcost_center	fin_costcentercode	varchar(10)	Yes	Parallel cost center	No
currency	fin_currency	varchar(5)	Yes	Currency	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_change_setup_dtl
Comment :	To store information of change setup detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
change_setup_no	fin_deprkey	varchar(20)	No	Change setup number	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
existing_rule	fin_deprkey	varchar(20)	Yes	Existing rule	No
new_rule	fin_deprkey	varchar(20)	Yes	New rule	No
susp_amount	fin_amount	numeric(13)	Yes	Suspension amount	No
depr_amount	fin_amount	numeric(13)	Yes	Depreciation amount	No
fp_start_date	fin_datetime	datetime(8)	Yes	Finance period start date	No
fp_end_date	fin_datetime	datetime(8)	Yes	Financial period end date	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_change_setup_hdr
Comment :	To store information of change setup header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
change_setup_no	fin_deprkey	varchar(20)	No	Change setup number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
setup_desc	fin_desc40	varchar(40)	Yes	Setup description	No
process_date	fin_datetime	datetime(8)	Yes	Process date	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fp_upto	fin_calendarcode	varchar(10)	Yes	Financial period upto	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
incl_susp	fin_desc40	varchar(40)	Yes	Include suspension	No
incl_rev	fin_desc40	varchar(40)	Yes	Include reversal	No
pcost_ceneter	fin_costcentercode	varchar(10)	Yes	Parallel cost center	No
proc_upto_date	fin_datetime	datetime(8)	Yes	Process uptodate	No
assets_selected	fin_numberrecords	varchar(20)	Yes	Assets selected	No
tags_selected	fin_numberrecords	varchar(20)	Yes	Tags seleted	No
rec_selected	fin_numberrecords	varchar(20)	Yes	Record selected	No
def_depr_rule_no	fin_deprkey	varchar(20)	Yes	Default depreciation rule number	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_depr_expenses_rpt
Comment :	To store information of depreciation expenses report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
date_from	fin_datetime	datetime(8)	Yes	Date from	No
date_to	fin_datetime	datetime(8)	Yes	Date to	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
depr_book	fin_depkey	varchar(20)	Yes	Depreciation book	No
finance_book	fin_financebookid	varchar(20)	Yes	Finance book	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
process_run_number	fin_documentnumber	varchar(18)	Yes	Process run number	No
depr_amount	fin_amount	numeric(13)	Yes	Depreciation amount	No
account_dr	fin_accountcode	varchar(32)	Yes	Account debit	No
account_cr	fin_accountcode	varchar(32)	Yes	Account credit	No
depr_category	fin_depcategory	varchar(20)	Yes	Depreciation category	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_error_log
Comment :	To store information of error log

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
guid	fin_guid	varchar(40)	No	Guid	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
depr_proc_runno	fin_deprkey	varchar(20)	No	Depreciation process run number	Yes
error_no	fin_errorno	int(4)	No	Error number	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
year_no	fin_int	int(4)	No	Year number	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
process_date	fin_datetime	datetime(8)	Yes	Process date	No
tag_status	fin_status	varchar(25)	Yes	Tag status	No
process_status	fin_status	varchar(25)	Yes	Process status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_maintain_usage_info
Comment :	To maintain usage information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Batch_Id	fin_guid	varchar(40)	No	Batch id	Yes
Key_SeqNo	fin_seqno	int(4)	No	Key sequence number	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
Depr_book	fin_book	varchar(30)	Yes	Depreciation Book	No
cost_type	fin_costtypeeam	varchar(10)	Yes	Cost Type	No
Asset_Number	fin_assetnumber	varchar(18)	No	Asset Number	Yes
Tag_Number	fin_assettagno	int(4)	No	Tag Number	Yes
Asset_Cost	fin_amount	numeric(13)	Yes	Asset cost	No
Book_Value	fin_amount	numeric(13)	Yes	Book value	No
Depr_Category	fin_depcategory	varchar(20)	Yes	Depreciation Category	No
Depr_Rule	fin_deprkey	varchar(20)	Yes	Depreciation Rule	No
Comp_id	fin_componentid	varchar(90)	Yes	Component id	No
Usage_Param	fin_parameter	varchar(40)	Yes	Usage parameter	No
Maint_Interval	fin_usage	numeric(13)	Yes	Mainitenance interval	No
Cum_Usage	fin_usage	numeric(13)	Yes	Cumulative usage	No
Migrated_Usage	fin_usage	numeric(13)	Yes	Migrated usage	No
Cum_Depr_Usage	fin_usage	numeric(13)	Yes	Cumulative Depreciation usage	No
Depr_Usage	fin_usage	numeric(13)	Yes	Depreciation usage	No
Prev_Period	fin_amount	numeric(13)	Yes	Previous period	No
Remaining_Usage	fin_usage	numeric(13)	Yes	Remaining usage	No
Depr_Rate	fin_rate	numeric(13)	Yes	Depreciation Rate	No
Revised_Book_Val	fin_amount	numeric(13)	Yes	Revised Book Value	No
Depr_Amount	fin_amount	numeric(13)	Yes	Depreciation amount	No
Cum_Depr	fin_amount	numeric(13)	Yes	Cumulative Depreciation	No
Aircraft_dtl	fin_flag	varchar(25)	Yes	Aircraft details	No
Asset_Class	fin_assetclass	varchar(20)	Yes	Asset Class	No
Asset_Desc	fin_desc40	varchar(40)	Yes	Asset Description	No
Tag_Desc	fin_desc40	varchar(40)	Yes	Tag Description	No
Fin_Book	fin_financebookid	varchar(20)	Yes	Finance Book	No
Fin_Year	fin_financeyear	varchar(15)	Yes	Finance Year	No
Fin_Period	fin_financeperiod	varchar(15)	Yes	Finance period	No
Part_No	fin_partno	varchar(40)	Yes	Part number	No
Serial_No	fin_serialno	varchar(18)	Yes	Serial number	No
Aircraft_Number	fin_documentno	varchar(40)	Yes	Aircraft number	No
Maint_Type	fin_costtypeeam	varchar(10)	Yes	Mainitenance type	No
fp_start_date	fin_datetime	datetime(8)	Yes	Finance period start date	No
fp_end_date	fin_datetime	datetime(8)	Yes	Finance period end date	No
fin_periodseqno	fin_seqno	int(4)	Yes	Finance period sequence number	No
Inservice_Date	fin_datetime	datetime(8)	Yes	Inservice date	No
Error_Flag	fin_flag	varchar(25)	Yes	Error Flag	No
Error_id	fin_errorid	int(4)	Yes	Error id	No
Job_id	fin_tasktrackid	bigint(8)	Yes	Job id	No
depr_runno	fin_documentno	varchar(40)	Yes	Depreciation run number	No
Depr_Status	fin_status	varchar(25)	Yes	Depreciation status	No
LastModifiedBy	fin_ctxt_user	varchar(30)	Yes	Last Modified by	No
LastModifiedDate	fin_datetime	datetime(8)	Yes	Last modified date	No
Modified_Mig_Usage	fin_usage	numeric(13)	Yes	Modified Migration usage	No
TSO_Remaining_Usage	fin_usage	numeric(13)	Yes	TSO remaining usage	No
Cum_Act_Depr_Usage	fin_usage	numeric(13)	Yes	Cumulative actual depreciation usage	No
Modified_Depr_Usage	fin_usage	numeric(13)	Yes	Modified Depreciation usage	No
Actual_Depr_Usage	fin_usage	numeric(13)	Yes	Actual Depreciation usage	No
writeoff_instanceid	fin_tasktrackid	bigint(8)	Yes	write off instance id	No
timestamp	fin_int	int(4)	Yes	timestamp	No
Period_SeqNo	fin_seqno	int(4)	Yes	period sequence number	No
replication_key	fin_bigint	Bigint(8)	No	replication_key	Yes

Table Name :	adepp_notes_dtl
Comment :	To store information of notes detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
notes_desc	fin_notes	varchar(2000)	Yes	Notes description	No
doc_number	fin_documentnumber	varchar(18)	Yes	Document number	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_notes_dtl_his
Comment :	To store history of notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
notes_desc	fin_notes	varchar(2000)	Yes	Notes description	No
doc_number	fin_documentnumber	varchar(18)	Yes	Document number	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_process_dtl
Comment :	To store information of process detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_proc_runno	fin_deprkey	varchar(20)	No	Depreciation run number	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
depr_category	fin_deprcategory	varchar(40)	No	Depreciation category	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
depr_rule	fin_deprkey	varchar(20)	No	Depreciation rule	Yes
inservice_date	fin_datetime	datetime(8)	No	Inservice date	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
susp_charge	fin_amount	numeric(13)	Yes	Suspension charge	No
tag_status	fin_status	varchar(25)	Yes	Tag status	No
book_value	fin_amount	numeric(13)	Yes	Book value	No
revalued_cost	fin_amount	numeric(13)	Yes	Revalued cost	No
rev_depr_category	fin_deprcategory	varchar(40)	Yes	Reversal depreciation category	No
rev_depr_rule	fin_deprkey	varchar(20)	Yes	Reversal depreciation rule	No
rev_depr_charge	fin_amount	numeric(13)	Yes	Reversal depreciation charge	No
rev_susp_charge	fin_amount	numeric(13)	Yes	Reversal suspension charge	No
fp_upto	fin_calendarcode	varchar(10)	Yes	Finance period upto	No
fp_start_date	fin_datetime	datetime(8)	Yes	Finance period start date	No
fp_end_date	fin_datetime	datetime(8)	Yes	Finance period end date	No
fp_upto_date	fin_datetime	datetime(8)	Yes	Finance period upto date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
cum_depr_charge	fin_amount	numeric(13)	Yes	Cumulative depreciation charge	No
reval_cum_depr_charge	fin_amount	numeric(13)	Yes	Revalued cumulative depreciation charge	No
pbc_depr_charge	fin_amount	numeric(13)	Yes	Parallel base currency depreciation charge	No
pbc_susp_charge	fin_amount	numeric(13)	Yes	Parallel base currency suspension charge	No
pbc_rev_depr_charge	fin_amount	numeric(13)	Yes	Parallel base currency reversal depreciation charge	No
pbc_rev_susp_charge	fin_amount	numeric(13)	Yes	Parallel base currency reversal suspension charge	No
pbc_cum_depr_charge	fin_amount	numeric(13)	Yes	Parallel base currency cumulative depreciation charge	No
pbc_rev_cum_depr_charge	fin_amount	numeric(13)	Yes	Parallel base currency reversal cumulative depreciation charge	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
srno	fin_lineno	int(4)	No	Serial number	Yes
ref_docno	fin_documentnumber	varchar(18)	Yes	Reference document number	No
depr_charge_flag	fin_flag	varchar(25)	Yes	Depreciation charge flag	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
cap_number	fin_documentnumber	varchar(18)	Yes	Capitalized number	No
cap_date	fin_date	datetime(8)	Yes	Capitalized date	No
min_inservice_date	fin_datetime	datetime(8)	Yes	Minimum inservice date	No
min_cap_date	fin_datetime	datetime(8)	Yes	Minimum capitalized date	No
fin_periodseqno	fin_seqno	int(4)	Yes	Financial period sequence number	No
period_no	fin_seqno	int(4)	Yes	Period number	No
depr_method	fin_deprmethodenu	varchar(25)	Yes	Depreciation method	No
depr_basis	fin_desc40	varchar(40)	Yes	Dpereciation basis	No
depr_conv	fin_desc40	varchar(40)	Yes	Depreciation conversion	No
life_expiry_date	fin_datetime	datetime(8)	Yes	Life expiry date	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
salvage_value	fin_amount	numeric(13)	Yes	Salvage value	No
business_use	fin_deprpercent	numeric(13)	Yes	Business use	No
max_depr	fin_amount	numeric(13)	Yes	Maximum depreciation	No
min_depr	fin_amount	numeric(13)	Yes	Minimum depreciation	No
depr_rate_id	fin_deprkey	varchar(20)	Yes	Depreciation rate id	No
depr_rate	fin_deprpercent	numeric(13)	Yes	Depreciation rate	No
process_strtdate	fin_datetime	datetime(8)	Yes	Process start date	No
process_enddate	fin_datetime	datetime(8)	Yes	Process end date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
conv_applicable	fin_flag	varchar(25)	Yes	Conversion applicable	No
depr_strtdate	fin_datetime	datetime(8)	Yes	Deprecation start date	No
depr_enddate	fin_datetime	datetime(8)	Yes	Depreciation end date	No
susp_strtdate	fin_datetime	datetime(8)	Yes	Suspension start date	No
susp_enddate	fin_datetime	datetime(8)	Yes	Suspension end date	No
noof_depr_days	fin_int	int(4)	Yes	Number of depreciation days	No
noof_susp_days	fin_int	int(4)	Yes	Number of suspension days	No
noof_depr_month	fin_duration	numeric(17)	Yes	Noumber of depreciation month	No
noof_susp_month	fin_duration	numeric(17)	Yes	Number of suspension month	No
batchid	fin_seqno	int(4)	Yes	Batch id	No
deprecaccount	fin_accountcode	varchar(32)	Yes	Depreciation account	No
cumdepaccount	fin_accountcode	varchar(32)	Yes	Cumulative depreciation account	No
process_flag	fin_flag	varchar(25)	Yes	Process flag	No
depr_rule_eff_from	fin_datetime	datetime(8)	Yes	Depreciation rule effective from	No
expdate_eff_from	fin_datetime	datetime(8)	Yes	Exiry date effective from	No
prev_prd_suspstdate	fin_datetime	datetime(8)	Yes	Previous period suspension start date	No
rate_usefullife_flag	fin_flag	varchar(25)	Yes	Rate useful life flag	No
cum_depr_period	fin_duration	numeric(17)	Yes	Cumulative depreciation period	No
rate_appliedon	fin_amount	numeric(13)	Yes	Rate applied on	No
remaining_useful_life	fin_duration	numeric(17)	Yes	Remaining useful life	No
depr_flag	fin_flag	varchar(25)	Yes	Depreciation flag	No
cost_type	fin_usageid	varchar(20)	Yes	Cost type	No
replication_key	fin_bigint	Bigint(8)	Yes	Replication Key	No

Table Name :	adepp_process_hdr
Comment :	To store information of process header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_proc_runno	fin_deprkey	varchar(20)	No	Depreciation run number	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
process_status	fin_status	varchar(25)	Yes	Process status	No
process_date	fin_datetime	datetime(8)	Yes	Process date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
incl_rev	fin_desc40	varchar(40)	Yes	Include reversal	No
currency	fin_currency	varchar(5)	Yes	Currency	No
pcost_center	fin_costcentercode	varchar(10)	Yes	Process cost center	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fp_upto	fin_calendarcode	varchar(10)	Yes	Financial period upto	No
fp_start_date	fin_datetime	datetime(8)	Yes	Financial period start date	No
fp_end_date	fin_datetime	datetime(8)	Yes	Financial period end date	No
depr_basis	fin_desc40	varchar(40)	Yes	Depreciation basis	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
cost_center	fin_costcentercode	varchar(10)	Yes	Coat center	No
assets_selected	fin_numberrecords	varchar(20)	Yes	Assets selected	No
tag_selected	fin_numberrecords	varchar(20)	Yes	Tag selected	No
rec_selected	fin_numberrecords	varchar(20)	Yes	Record selected	No
susp_total	fin_amount	numeric(13)	Yes	Suspension total	No
depr_total	fin_amount	numeric(13)	Yes	Depreciation total	No
rev_depr_total	fin_amount	numeric(13)	Yes	Reversal depreciation total	No
rev_susp_total	fin_amount	numeric(13)	Yes	Reversal suspension total	No
pbc_susp_total	fin_amount	numeric(13)	Yes	Parallel base currency suspension total	No
pbc_depr_total	fin_amount	numeric(13)	Yes	Parallel depreciation total	No
pbc_rev_depr_total	fin_amount	numeric(13)	Yes	Parallel base reversal depreciation total	No
pbc_rev_susp_total	fin_amount	numeric(13)	Yes	Parallel base reversal suspension total	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
depr_charge_flag	fin_flag	varchar(25)	Yes	Depreciation charge flag	No
service_flag	fin_flag	varchar(25)	Yes	Service flag	No
cme_depr_total	fin_amount	numeric(13)	Yes	CME depreciation total	No

Table Name :	adepp_process_summ
Comment :	To store information of process summary

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouid	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Financial period	No
fin_period_seqno	fin_seqno	int(4)	Yes	Financial period sequence number	No
period_no	fin_seqno	int(4)	Yes	Period number	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
srno	fin_lineno	int(4)	Yes	srno	No
depr_proc_runno	fin_documentnumber	varchar(18)	Yes	Depreciation run number	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
depreciated_periods	fin_duration	numeric(17)	Yes	Depreciated periods	No
depr_rule	fin_deprkey	varchar(20)	Yes	Depreciation rule	No
depr_method	fin_deprmethodenu	varchar(25)	Yes	Depreciation method	No
depr_basis	fin_desc40	varchar(40)	Yes	Depreciation basis	No
depr_conv	fin_desc40	varchar(40)	Yes	Depreciation conversion	No
depr_rate_id	fin_deprkey	varchar(20)	Yes	Depreciation rate id	No
depr_rate	fin_deprpercent	numeric(13)	Yes	Depreciation rate	No
rate_appliedon	fin_amount	numeric(13)	Yes	Rate applied on	No
cum_book_value	fin_amount	numeric(13)	Yes	Cumulative book value	No
cum_dep_value	fin_amount	numeric(13)	Yes	Cumulative depreciation value	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
processuptodate	fin_datetime	datetime(8)	Yes	Process upto date	No
lst_period_stdate	fin_datetime	datetime(8)	Yes	lst_period_stdate	No
lst_period_enddate	fin_datetime	datetime(8)	Yes	lst_period_enddate	No
lst_prd_suspstdate	fin_datetime	datetime(8)	Yes	lst_prd_suspstdate	No
depr_rule_eff_from	fin_datetime	datetime(8)	Yes	Depreciation rule effective from	No
expdate_eff_from	fin_datetime	datetime(8)	Yes	Expiry date effective from	No
created_date	fin_datetime	datetime(8)	Yes	Created date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes
cost_type	fin_usageid	varchar(20)	Yes	cost type	No
depr_flag	fin_flag	varchar(25)	Yes	Depreciation Flag	No

Table Name :	adepp_reverse_dtl
Comment :	To store information of reverse detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	No
rev_doc_no	fin_documentnumber	varchar(18)	No	Reversal document number	No
depr_category	fin_deprcategory	varchar(40)	No	Depreciation category	No
asset_number	fin_assetnumber	varchar(18)	No	Asset number	No
tag_number	fin_assettagno	int(4)	No	Tag number	No
depr_rule_no	fin_deprkey	varchar(20)	No	Depreciation rule number	No
fin_period	fin_calendarcode	varchar(10)	No	Financial period	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
susp_depr	fin_amount	numeric(13)	Yes	Suspension charge	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_reverse_hdr
Comment :	To store information of reverse header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
rev_doc_no	fin_documentnumber	varchar(18)	No	Reversal document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
revr_option	fin_option	varchar(20)	Yes	Reversal option	No
depr_proc_runno	fin_deprkey	varchar(20)	Yes	Depreciation run number	No
depr_total	fin_amount	numeric(13)	Yes	Depreciation total	No
susp_total	fin_amount	numeric(13)	Yes	Suspension total	No
reversal_date	fin_datetime	datetime(8)	Yes	Reversal date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
rev_status	fin_status	varchar(25)	Yes	Reversal status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cme_depr_total	fin_amount	numeric(13)	Yes	CME depreciation total	No

Table Name :	adepp_rev_adjustments_dtl
Comment :	To store information of reverse adjustment detail

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
reversal_no	fin_documentnumber	varchar(18)	No	Reversal number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
drcr_flag	fin_flag	varchar(25)	Yes	Debit credit flag	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cme_depr_charge	fin_amount	numeric(13)	Yes	cme depreciation charge	No

Table Name :	adepp_rev_adjustments_hdr
Comment :	To store information of reverse adjustment header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
reversal_no	fin_documentnumber	varchar(18)	No	Reversal number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
doc_status	fin_status	varchar(25)	Yes	Document status	No
document_no	fin_documentnumber	varchar(18)	Yes	Document number	No
reversal_date	fin_datetime	datetime(8)	Yes	Reversal date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
depr_total	fin_amount	numeric(13)	Yes	Depreciation total	No
reversal_remarks	fin_text255	varchar(255)	Yes	Reversal remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cme_depr_total	fin_amount	numeric(13)	Yes	cme depreciation total	No

Table Name :	adepp_simulate_detail_rpt
Comment :	To store information of simulate detail report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
sim_run_no	fin_deprkey	varchar(20)	Yes	Simulate run number	No
depr_category	fin_depcategory	varchar(20)	Yes	Depreciation category	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
year_no	fin_number	int(4)	Yes	Year number	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
salvage_cost	fin_amount	numeric(13)	Yes	Salvage cost	No
existing_depr_charge	fin_amount	numeric(13)	Yes	Existing depreciation charge	No
existing_susp_charge	fin_amount	numeric(13)	Yes	Existing suspension charge	No
depr_charge1	fin_amount	numeric(13)	Yes	Depreciation charge 1	No
depr_charge2	fin_amount	numeric(13)	Yes	Depreciation charge 2	No
depr_charge3	fin_amount	numeric(13)	Yes	Depreciation charge 3	No
company_name	fin_comp_name	varchar(40)	Yes	Company name	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adepp_simulate_dtl
Comment :	To store information of simulate detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
sim_run_no	fin_deprkey	varchar(20)	No	Simulate run number	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
asset_desc	fin_desc40	varchar(40)	No	Asset description	Yes
year_no	fin_number	int(4)	No	Year number	Yes
inservice_date	fin_datetime	datetime(8)	No	Inservice date	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_category	fin_depcategory	varchar(20)	Yes	Depreciation category	No
depr_rule1	fin_deprkey	varchar(20)	Yes	Depreciation rule 1	No
depr_rule2	fin_deprkey	varchar(20)	Yes	Depreciation rule 2	No
depr_rule3	fin_deprkey	varchar(20)	Yes	Depreciation rule 3	No
depr_charge1	fin_amount	numeric(13)	Yes	Depreciation charge 1	No
depr_charge2	fin_amount	numeric(13)	Yes	Depreciation charge 2	No
depr_charge3	fin_amount	numeric(13)	Yes	Depreciation charge 3	No
susp_charge1	fin_amount	numeric(13)	Yes	Suspension charge 1	No
susp_charge2	fin_amount	numeric(13)	Yes	Suspension charge 2	No
susp_charge3	fin_amount	numeric(13)	Yes	Suspension charge 3	No
existing_depr_charge	fin_amount	numeric(13)	Yes	Existing depreciation charge	No
existing_susp_charge	fin_amount	numeric(13)	Yes	Existing suspension charge	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
salvage_cost	fin_amount	numeric(13)	Yes	Salvage cost	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
start_date	fin_datetime	datetime(8)	Yes	Start date	No
end_date	fin_datetime	datetime(8)	Yes	End date	No
rev_depr_charge1	fin_amount	numeric(13)	Yes	Reversal deprecition charge 1	No
rev_depr_charge2	fin_amount	numeric(13)	Yes	Reversal deprecition charge 2	No
rev_depr_charge3	fin_amount	numeric(13)	Yes	Reversal deprecition charge 3	No
rev_susp_charge1	fin_amount	numeric(13)	Yes	Reversal suspension charge 1	No
rev_susp_charge2	fin_amount	numeric(13)	Yes	Reversal suspension charge 2	No
rev_susp_charge3	fin_amount	numeric(13)	Yes	Reversal suspension charge 3	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
tran_type	fin_trantype	varchar(40)	Yes	Transaction type	No

Table Name :	adepp_simulate_hdr
Comment :	To store information of simulate header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
sim_run_no	fin_deprkey	varchar(20)	No	Simulate run number	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
sim_status	fin_status	varchar(25)	Yes	Simulate status	No
def_depr_rule_no	fin_deprkey	varchar(20)	Yes	Default depreciation rule number	No
sim_yr	fin_assetlife	numeric(13)	Yes	Simulate year	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
incl_rev	fin_desc40	varchar(40)	Yes	Include reversal	No
incl_susp	fin_desc40	varchar(40)	Yes	Include suspension	No
currency	fin_currency	varchar(5)	Yes	Currency	No
assets_selected	fin_numberrecords	varchar(20)	Yes	Assets selected	No
tags_selected	fin_numberrecords	varchar(20)	Yes	Tags selected	No
rec_selected	fin_numberrecords	varchar(20)	Yes	Record selected	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_suspension_dtl
Comment :	To store information of suspension detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_category	fin_deprcategory	varchar(40)	No	Depreciation category	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
suspension_no	fin_deprkey	varchar(20)	No	Suspension number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
susp_start_date	fin_datetime	datetime(8)	Yes	Suspension start date	No
susp_end_date	fin_datetime	datetime(8)	Yes	Suspension end date	No
status	fin_status	varchar(25)	Yes	Status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_suspension_hdr
Comment :	To store information of suspension header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
suspension_no	fin_deprkey	varchar(20)	No	Suspension number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
suspension_desc	fin_desc40	varchar(40)	Yes	Suspension description	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
susp_start_date	fin_datetime	datetime(8)	Yes	Suspension start date	No
susp_end_date	fin_datetime	datetime(8)	Yes	Suspension end date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adepp_usage_allocation_dtl
Comment :	To store information about Usage allocation details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Batch_Id	fin_guid	varchar(40)	No	Batch id	Yes
RefKey_SeqNo	fin_seqno	int(4)	Yes	Reference Key Sequence number	No
Key_SeqNo	fin_seqno	int(4)	No	Key Sequence Number	Yes
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization Unit ID	Yes
Depr_book	fin_book	varchar(30)	Yes	Depreciation Book	No
cost_type	fin_costtypeeam	varchar(10)	Yes	Cost Type	No
Asset_Number	fin_assetnumber	varchar(18)	No	Asset Number	Yes
Tag_Number	fin_assettagno	int(4)	No	Tag Number	Yes
Usage	fin_designparamcode	varchar(5)	Yes	Usage	No
Comp_id	fin_componentid	varchar(90)	Yes	Component ID	No
Aircraft_Number	fin_aircraftnumber	varchar(30)	Yes	Aircraft Number	No
Usage_Param	fin_parameter	varchar(40)	Yes	Usage Parameter	No
Cum_Usage	fin_usage	numeric(13)	Yes	Cumulative Usage	No
Cum_Depr_Usage	fin_usage	numeric(13)	Yes	Cumulative Depreciation Usage	No
Depr_Usage	fin_usage	numeric(13)	Yes	Depreciation Usage	No
Actual_Depr_Usage	fin_usage	numeric(13)	Yes	Actual Depreciation Usage	No
Prev_Period	fin_amount	numeric(13)	Yes	Previous Period	No
usage_percentage	fin_percentage	numeric(9)	Yes	Usage Percentage	No
Depr_Amount	fin_amount	numeric(13)	Yes	Depreciation Amount	No
Apportion_Amount	fin_amount	numeric(13)	Yes	Apportion Amount	No
Cost_Center	fin_costcentercode	varchar(10)	Yes	Cost Center	No
Depr_Status	fin_status	varchar(25)	Yes	Depreciation Status	No
Asset_Class	fin_assetclass	varchar(20)	Yes	Asset Class	No
Asset_Desc	fin_desc40	varchar(40)	Yes	Asset Description	No
Tag_Desc	fin_desc40	varchar(40)	Yes	Tag Description	No
Fin_Book	fin_financebookid	varchar(20)	Yes	Finance Book	No
Fin_Year	fin_financeyear	varchar(15)	Yes	Finance Year	No
Fin_Period	fin_financeperiod	varchar(15)	Yes	Finance Period	No
Part_No	fin_partno	varchar(40)	Yes	Part Number	No
Serial_No	fin_serialno	varchar(18)	Yes	Serial Number	No
LastModifiedBy	fin_ctxt_user	varchar(30)	Yes	Last Modified by	No
LastModifiedDate	fin_datetime	datetime(8)	Yes	Last Modfied Date	No
indicator	fin_designparamcode	varchar(5)	Yes	Indicator	No
replication_key	fin_bigint	Bigint(8)	No	replication_key	Yes
cost_center_desc	_fin_desc40_40	fin_desc40(40)	Yes	Cost_center_description	No
analysis_code	_fin_analysiscode_5	fin_analysiscode(5)	Yes	Analysis Code	No
analysis_code_desc	_fin_desc40_40	fin_desc40(40)	Yes	Analysis Code Description	No

Table Name :	adepp_usage_error_metadata
Comment :	To store information about Usage error metadata

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
error_id	fin_errorid	int(4)	No	Error ID	Yes
error_shrtdesc	fin_shortdesc	varchar(75)	Yes	Error Short Description	No
error_desc	fin_errordesc	varchar(255)	Yes	Error Description	No

Table Name :	adep_depr_rule_hdr
Comment :	asset depreciation rule header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	ouinstance id	Yes
depr_rule_number	fin_deprkey	varchar(20)	No	depreciation rule number	Yes
timestamp	fin_int	int(4)	Yes	timestamp	No
asset_class	fin_assetclass	varchar(20)	Yes	asset class	No
eff_date	fin_datetime	datetime(8)	Yes	effective date	No
depr_rule_desc	fin_desc40	varchar(40)	Yes	depreciation rule description	No
depr_method	fin_deprmethodenu	varchar(25)	Yes	depreciation method	No
depr_basis	fin_desc40	varchar(40)	Yes	depreciation basis	No
yearly_percent	fin_flag	varchar(25)	Yes	yearly percent	No
depr_rate_id	fin_deprkey	varchar(20)	Yes	depreciation rate id	No
useful_asset_life	fin_assetlife	numeric(13)	Yes	useful asset life	No
depr_conv	fin_desc40	varchar(40)	Yes	depreciation conv	No
fy_conv	fin_deprpercent	numeric(13)	Yes	fy conv	No
max_depr	fin_amount	numeric(13)	Yes	maximum depreciation	No
min_depr	fin_amount	numeric(13)	Yes	minimum depreciation	No
rule_status	fin_status	varchar(25)	Yes	rule status	No
createdby	fin_ctxt_user	varchar(30)	Yes	created by	No
createddate	fin_datetime	datetime(8)	Yes	created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	modified date	No
usage_parameter	fin_parameter	varchar(40)	Yes	usage parameter	No

Table Name :	cmn_adepp_cmewriteoff_input_his
Comment :	asset depreciation cme write off input history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou instance id	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book id	No
service	fin_ctxt_service	Varchar(32)	Yes	service	No
comp_name	fin_componentid	varchar(90)	Yes	company name	No
event_id	fin_event	Varchar(40)	Yes	event id	No
doc_type	fin_transactiontype	varchar(40)	Yes	document type	No
doc_number	fin_documentno	varchar(40)	Yes	document number	No
doc_date	fin_date	datetime(8)	Yes	document date	No
flag	fin_flag	varchar(25)	Yes	flag	No
part_number	fin_partno	varchar(40)	Yes	part number	No
serial_number	fin_partserialnumber	Varchar(40)	Yes	serial number	No
comp_id	fin_componentid	varchar(90)	Yes	company id	No
aircraft_regno	fin_aircraftnumber	varchar(30)	Yes	aircraft registration number	No
task_no	fin_taskno	Varchar(40)	Yes	task number	No
job_id	fin_tasktrackid	bigint(8)	Yes	jod id	No
requestdate	fin_datetime	datetime(8)	Yes	request date	No
asset_number	fin_assetnumber	varchar(18)	Yes	asset number	No
tag_number	fin_assettagno	int(4)	Yes	tag number	No
line_no	fin_lineno	int(4)	Yes	line number	No
seqno_no	fin_seqno	int(4)	Yes	sequence number	No
task_name	fin_desc40	varchar(40)	Yes	task name	No
line_number	fin_lineno	int(4)	Yes	line no	No
depr_runno	fin_documentno	varchar(40)	Yes	depreciation run number	No
jv_number	fin_documentno	varchar(40)	Yes	journal voucher number	No
tran_date	fin_date	datetime(8)	Yes	transaction date	No
manuf_part_number	fin_partno	varchar(40)	Yes	manufacture part number	No
manuf_serial_number	fin_partserialnumber	Varchar(40)	Yes	manufacture serial number	No
manuf_no	fin_vendorcode	Varchar(45)	Yes	manufacture number	No
maint_type	fin_designparamcode	varchar(5)	Yes	maintenance type	No
process_flag	fin_int	int(4)	Yes	process flag	No
rep_proc_code	fin_repairprocesscode	Varchar(25)	Yes	replication proc code	No
rep_proc_mainttype	fin_designparamcode	varchar(5)	Yes	replication proc main type	No
remarks	fin_remarks	Varchar(100)	Yes	remarks	No
replication_key	fin_bigint	Bigint(8)	No	replication key	Yes
asset_class	fin_assetclass	varchar(20)	Yes	asset class	No
task_track_id	fin_unique_id	Bigint(8)	Yes	task track id	No
batch_id	fin_guid	varchar(40)	Yes	batch id	No

Table Name :	cmn_adepp_cmewriteoff_instance
Comment :	asset depreciation cme write off instance table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
writeoff_instanceid	fin_int	int(4)	No	write off instance id	Yes
batch_id	fin_guid	varchar(40)	Yes	batch id	No
seqno_no	fin_seqno	int(4)	Yes	sequence number	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ouinstance id	No
event_id	fin_event	Varchar(40)	Yes	event id	No
tran_date	fin_date	datetime(8)	Yes	transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book id	No
maint_type	fin_designparamcode	varchar(5)	Yes	maintenance type	No
asset_class	fin_assetclass	varchar(20)	Yes	asset class	No
asset_number	fin_assetnumber	varchar(18)	Yes	asset number	No
tag_number	fin_assettagno	int(4)	Yes	tag number	No
part_number	fin_partno	varchar(40)	Yes	part number	No
serial_number	fin_partserialnumber	Varchar(40)	Yes	serial number	No
doc_type	fin_transactiontype	varchar(40)	Yes	document type	No
doc_number	fin_documentno	varchar(40)	Yes	document number	No
task_no	fin_taskno	Varchar(40)	Yes	task number	No
task_track_id	fin_unique_id	Bigint(8)	Yes	tast track id	No
job_id	fin_tasktrackid	bigint(8)	Yes	job id	No
depr_runno	fin_documentno	varchar(40)	Yes	depreciation run number	No
jv_number	fin_documentno	varchar(40)	Yes	journal voucher number	No
revwoff_instanceid	fin_int	int(4)	Yes	reverse write off instance id	No
process_flag	fin_int	int(4)	Yes	process flag	No
remarks	fin_remarks	Varchar(100)	Yes	remarks	No
created_by	fin_ctxt_user	varchar(30)	Yes	created by	No
created_date	fin_date	datetime(8)	Yes	created date	No
modified_by	fin_ctxt_user	varchar(30)	Yes	modified by	No
modified_date	fin_date	datetime(8)	Yes	modified date	No