Database Schema for

Data Dictionary -- Reports - Fixed Assets Management

Srl. No.	Table Name	Comment
1	repsfam_locationcheck	To store information of location check
2	repsfam_quick_code_met	To store information of quick code details
3	rep_acvalue_gen_hdr	This Table is for the generation of offline Aircraft value report with run number
4	rep_acvalue_gen_output_dtl	It will give the Output of afflin Aircraft value report with Asset details
5	rep_acval_sch_input_log	It will Certain Processed data of offline Aircraft value report


Table Name :	repsfam_locationcheck
Comment :	To store information of location check


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
guid	fin_guid	varchar(40)	Yes	Guid	No
parentloc_code	fin_assetlocation	varchar(20)	Yes	Parent location code	No
loc_code	fin_assetlocation	varchar(20)	Yes	Location code	No
child	fin_macstatus	varchar(1)	Yes	Child	No
parent_group	fin_group	varchar(25)	Yes	Parent group	No
child_group	fin_group	varchar(25)	Yes	Child group	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	repsfam_quick_code_met
Comment :	To store information of quick code details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
component_id	fin_componentshortid	varchar(20)	Yes	Component id	No
parameter_type	fin_param_type	varchar(6)	Yes	Parameter type	No
parameter_category	fin_param_categ	varchar(16)	Yes	Parameter category	No
parameter_code	fin_param_code	varchar(6)	Yes	Parameter code	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_param_text	varchar(255)	Yes	Parameter text	No
language_id	fin_lang_id	int(4)	Yes	Language id	No
extension_flag	fin_eflag	varchar(1)	Yes	Extension flag	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 :	rep_acvalue_gen_hdr
Comment :	This Table is for the generation of offline Aircraft value report with run number


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rep_acval_gen_ou	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	Yes	Generate the Oraganization Unit	No
rep_acval_company	_fin_captions_15	fin_captions(15)	Yes	Contains acval_company	No
rep_acval_modelno	_fin_captions_15	fin_captions(15)	Yes	Model Number	No
rep_acval_group	_fin_documentno_40	fin_documentno(40)	Yes	Group	No
rep_acval_regno	_fin_captions_15	fin_captions(15)	Yes	Register Number	No
rep_acval_gen_date	_fin_datetime_8	fin_datetime(8)	Yes	Generate Date	No
rep_acval_gen_srno	_fin_seqno_4	fin_seqno(4)	Yes	Serial Number	No
rep_acval_run_status	_fin_status_25	fin_status(25)	Yes	Run Status	No
rep_acval_gen_runno	_fin_captions_15	fin_captions(15)	Yes	Generate Run Number	No
rep_acval_acstatus	_fin_status_25	fin_status(25)	Yes	Aircraft Status	No
rep_acval_created_by	_fin_captions_15	fin_captions(15)	Yes	Created by	No
rep_acval_created_date	_fin_datetime_8	fin_datetime(8)	Yes	Created Date	No
rep_acval_file_name	_fin_exception_1000	fin_exception(1000)	Yes	File Name	No


Table Name :	rep_acvalue_gen_output_dtl
Comment :	It will give the Output of afflin Aircraft value report with Asset details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
acval_gen_out_runno	_fin_documentno_40	fin_documentno(40)	No	Aircraft value Generate Run number	No
acval_gen_out_ou	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	No	Aircraft value Generate Organization Unit	No
acval_gen_out_group	_udd_documentno_40	udd_documentno(40)	No	Aircraft value Generate Group	No
acval_gen_out_model_no	_udd_documentno_40	udd_documentno(40)	No	Aircraft value Generate Model Number	No
acval_gen_out_own	_udd_documentno_40	udd_documentno(40)	No	Aircraft value Generate own	No
acval_gen_out_reg_no	_fin_aircraftnumber_30	fin_aircraftnumber(30)	No	Aircraft value Generate Register Number	No
acval_gen_out_AOG	_fin_datetime_8	fin_datetime(8)	No	Aircraft value Generate AOG	No
acval_gen_out_as_on	_fin_datetime_8	fin_datetime(8)	No	Aircraft value Generate as on	No
acval_gen_out_assetbook_value	_fin_amount_13	fin_amount(13)	No	Aircraft value Generate out assetbook value	No
acval_gen_out_asset_class	_fin_assetclass_20	fin_assetclass(20)	No	Aircraft value Generate asset class	No
acval_gen_out_asset_cost	_fin_amount_13	fin_amount(13)	No	Aircraft value Generate asset cost	No
acval_gen_out_asset_desc	_fin_desc40_40	fin_desc40(40)	No	Aircraft value Generate asset descending	No
acval_gen_out_asset_grp	_fin_group_25	fin_group(25)	No	Aircraft value Generate Asset Group	No
acval_gen_out_asset_no	_fin_assetnumber_18	fin_assetnumber(18)	No	Aircraft value GenerateAsset Number	No
acval_gen_out_asset_status	_fin_statuscode_2	fin_statuscode(2)	No	Aircraft value Generate Asset Status	No
acval_gen_out_CMEbook_value	_fin_amount_13	fin_amount(13)	No	Aircraft value Generate Captial maintenance expenditure value	No
acval_gen_out_CME_cost	_fin_amount_13	fin_amount(13)	No	Aircraft value Generate Captial maintenance expenditure cost	No
acval_gen_out_component_id	_fin_componentid_90	fin_componentid(90)	No	Aircraft value Generate component_id	No
acval_gen_out_component_type	_udd_flag_25	udd_flag(25)	No	Aircraft value Generate _component_type	No
acval_gen_out_condition	_fin_desc255_255	fin_desc255(255)	No	Aircraft value Generate condition	No
acval_gen_out_cost_center	_fin_costcentercode_10	fin_costcentercode(10)	No	Aircraft value Generate cost_center	No
acval_gen_out_deprec_category	_fin_deprcategory_40	fin_deprcategory(40)	No	Aircraft value Generate deprec_category	No
acval_gen_out_deprec_method	_fin_captions_15	fin_captions(15)	No	Aircraft value Generate deprec_method	No
acval_gen_out_exceptions	_fin_captions_15	fin_captions(15)	No	Aircraft value Generate exceptions	No
acval_gen_out_finance_book	_fin_financebookid_20	fin_financebookid(20)	No	Aircraft value Generate finance_book	No
acval_gen_out_induction_date	_fin_datetime_8	fin_datetime(8)	No	Aircraft value Generate induction_date	No
acval_gen_out_LLP	_udd_designparamcode_5	udd_designparamcode(5)	No	Aircraft value Generate LLP	No
acval_gen_out_lot_no	_fin_accesscode_15	fin_accesscode(15)	No	Aircraft value Generate lot_no	No
acval_gen_out_MSN_no	_udd_documentno_40	udd_documentno(40)	No	Aircraft value Generate _MSN_no	No
acval_gen_out_nhapart	_fin_component_id_40	fin_component_id(40)	No	Aircraft value Generate nhapart	No
acval_gen_out_nhaserial_no	_fin_component_id_40	fin_component_id(40)	No	Aircraft value Generate nhaserial_no	No
acval_gen_out_partno	_fin_partno_40	fin_partno(40)	No	Aircraft value Generate partno	No
acval_gen_out_partcategory	_fin_accountdesc_60	fin_accountdesc(60)	No	Aircraft value Generate partcategory	No
acval_gen_out_part_clasification	_fin_captions_15	fin_captions(15)	No	Aircraft value Generate part_clasification	No
acval_gen_out_part_desc	_fin_item_desc_150	fin_item_desc(150)	No	Aircraft value Generate part_desc	No
acval_gen_out_part_group	_fin_type_25	fin_type(25)	No	Aircraft value Generate part_group	No
acval_gen_out_part_type	_fin_accountdesc_60	fin_accountdesc(60)	No	Aircraft value Generate part_type	No
acval_gen_out_position_code	_fin_component_id_40	fin_component_id(40)	No	Aircraft value Generate position_code	No
acval_gen_out_remarks	_fin_desc255_255	fin_desc255(255)	No	Aircraft value Generate remarks	No
acval_gen_out_replacement_type	_fin_captions_15	fin_captions(15)	No	Aircraft value Generate replacement_type	No
acval_gen_out_serial_no	_fin_partserialnumber_40	fin_partserialnumber(40)	No	Aircraft value Generate serial Number	No
acval_gen_out_status_of_aircraft	_fin_captions_15	fin_captions(15)	No	Aircraft value Generate status_of_aircraft	No
acval_gen_out_stock_status	_fin_hrdesc_25	fin_hrdesc(25)	No	Aircraft value Generate stock_status	No
acval_gen_out_tag_no	_fin_assettagno_4	fin_assettagno(4)	No	Aircraft value Generate tag_no	No
acval_gen_out_tot_asscost	_fin_amount_13	fin_amount(13)	No	Aircraft value Generate total asscost	No
acval_gen_out_tot_book_val	_fin_amount_13	fin_amount(13)	No	Aircraft value Generate total Book Value	No
format_style	_fin_paramcode_30	fin_paramcode(30)	No	Foramt Style	No


Table Name :	rep_acval_sch_input_log
Comment :	It will Certain Processed data of offline Aircraft value report


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rep_acval_sch_ou	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	Yes	scheduler Oraganization Unit	No
rep_acval_company	_fin_captions_15	fin_captions(15)	Yes	Contains acval_company	No
rep_acval_gen_runno	_fin_captions_15	fin_captions(15)	Yes	Generate Run Number	No
rep_acval_run_status	_fin_documentno_40	fin_documentno(40)	Yes	Generate RunStatus	No
rep_acval_sch_date	_fin_captions_15	fin_captions(15)	Yes	scheduler Date	No
rep_acval_regno	_fin_datetime_8	fin_datetime(8)	Yes	RegNumber	No
rep_acval_modelno	_fin_seqno_4	fin_seqno(4)	Yes	ModelNumber	No
rep_acval_group	_fin_status_25	fin_status(25)	Yes	Group	No
rep_acval_acstatus	_fin_captions_15	fin_captions(15)	Yes	Aircraft Status	No
rep_acval_sch_srno	_fin_status_25	fin_status(25)	Yes	Scheduler Serial Number	No
rep_acval_sch_seqno	_fin_captions_15	fin_captions(15)	Yes	Schedular Sequence Number	No
rep_acval_sch_guid	_fin_datetime_8	fin_datetime(8)	Yes	Scheduler Grapical User Interface ID	No
rep_acval_run_gendate	_fin_exception_1000	fin_exception(1000)	Yes	Run Generate Date	No