Data Dictionary -- Heli Charter Contracts

Srl. No.	Table Name	Comment
1	fsc_calsgn_ac_asgn_dtl	Call sign assignment details
2	fsc_cnt_ac_att_dtl	Aircraft attribute details
3	fsc_cnt_ac_dtl	Aircraft details
4	fsc_cnt_ac_prsnl_dtl	Aircraft personal detail
5	fsc_cnt_ac_prsnl_pric_dtl	Aircraft Personal pricing detail
6	fsc_cnt_addinfo_dtl	Aircraft additional info details
7	fsc_cnt_claim_dtl	crew claim details
8	fsc_cnt_invbasis_dtl	invoice basis details
9	fsc_cnt_invrate_dtl	invoice rate details
10	fsc_cnt_milestone_dtl	milestone details
11	fsc_cnt_nonbill_dtl	Non billable details
12	fsc_cnt_opr_param_dtl	Operating paramter details
13	fsc_cnt_sbrate_cnt_dtl	contract slab based rate details
14	fsc_cnt_sbrate_dtl	slab based rate details
15	fsc_cnt_sub_milestone_dtl	contract sub milestone details
16	fsc_cnt_tab_rev_dtl	contract tab revision detail
17	fsc_cnt_tcd_dtl	contract tax charge discount details
18	fsc_inv_element_dtl	invoice element details
19	fsc_ret_hist_dtl	Return history detail

Table Name :	fsc_calsgn_ac_asgn_dtl
Comment :	Call sign assignment details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
asgn_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
asgn_lineno	fin_lineno	Int(4)	No	Lineno	Yes
asgn_ac_regno	fin_acregno	Char(30)	Yes	Aircraft registration no	No
asgn_ac_msn_no	fin_msnno	Char(40)	Yes	Aircraft msn no	No
asgn_eff_fromdate	fin_date	Datetime(11)	Yes	Effective from	No
asgn_eff_fromtime	fin_tatime	time(11)	Yes	Effective from time	No
asgn_eff_todate	fin_date	Datetime(11)	Yes	Effective todate	No
asgn_eff_totime	fin_tatime	time(11)	Yes	Effecive to time	No
asgn_usage_type	fin_enum_cd	Char(5)	Yes	Usage type	No
asgn_call_sign	fin_callsign	Char(20)	Yes	Call sign	No
asgn_rplcd_ac_regno	fin_acregno	Char(30)	Yes	Replaced Aircraft registration no	No
asgn_contractno	fin_documentno	Char(40)	Yes	Contract no	No
asgn_asgn_type	fin_enum_cd	Char(5)	Yes	Assignment type	No
asgn_charter_type	fin_quickcodes	Char(25)	Yes	Charter type	No
asgn_customerno	fin_customer_id	Char(18)	Yes	Customer no	No
asgn_status	fin_status	Char(25)	Yes	Assignment status	No
asgn_remarks	fin_remarks	Char(100)	Yes	Remarks	No
asgn_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
asgn_created_date	fin_date	Datetime(11)	Yes	Created by	No
asgn_createdby	fin_ctxt_user	Char(30)	Yes	Created Date	No
asgn_modified_date	fin_date	Datetime(11)	Yes	Modified by	No
asgn_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified date	No
asgn_ac_model	fin_aircraftmodel	Char(20)	Yes	Aircraft model no	No

Table Name :	fsc_cnt_ac_att_dtl
Comment :	Aircraft attribute details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
acatt_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
acatt_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
acatt_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
acatt_ac_lineno	fin_lineno	Int(4)	No	Aircraft Line no	Yes
acatt_lineno	fin_lineno	Int(4)	No	Line no	Yes
acatt_nos	fin_quantity	Numeric(28)	Yes	Attribute numbers	No
acatt_coverage_notes	fin_notes	Char(2000)	Yes	Coverage notes	No
acatt_pri_field_base	fin_station	Char(40)	Yes	Primary field base	No
acatt_sub_allwd	fin_enum_cd	Char(5)	Yes	Sub allowed	No
acatt_prmry_sub_model	fin_aircraftmodel	Char(20)	Yes	Primary sub model	No
acatt_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
acatt_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
acatt_Created_Date	fin_date	Datetime(11)	Yes	Created date	No
acatt_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
acatt_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_ac_dtl
Comment :	Aircraft details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ac_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
ac_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
ac_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
ac_lineno	fin_lineno	Int(4)	No	Lineno	Yes
ac_ac_model_no	fin_aircraftmodel	Char(20)	Yes	Air craft model no	No
ac_ac_reg_no	fin_acregno	Char(30)	Yes	Aircraft registration no	No
ac_assign_type	fin_enum_cd	Char(5)	Yes	Assignment type	No
ac_efft_from	fin_date	Datetime(11)	Yes	Effective from	No
ac_efft_to	fin_date	Datetime(11)	Yes	Effective to	No
ac_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
ac_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
ac_Created_Date	fin_date	Datetime(11)	Yes	Created date	No
ac_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
ac_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_ac_prsnl_dtl
Comment :	Aircraft personal detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
prsnl_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
prsnl_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
prsnl_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
prsnl_lineno	fin_lineno	Int(4)	No	Lineno	Yes
prsnl_ac_model_no	fin_aircraftmodel	Char(20)	Yes	Aircraft Model no	No
prsnl_ac_reg_no	fin_acregno	Char(30)	Yes	Aircraft Registration no	No
prsnl_ratedefat	fin_designparamcode	Char(5)	Yes	Rate defnition	No
prsnl_personnel_type	fin_quickcodes	Char(25)	Yes	Personnel type	No
prsnl_skill_no	fin_resourcecode	Char(40)	Yes	Skill No	No
prsnl_nos	fin_quantity	Numeric(28)	Yes	Personnel numbers	No
prsnl_crew_assn_typ	fin_enum_cd	Char(5)	Yes	Crew Assignment type	No
prsnl_crew_spec	fin_notes	Char(2000)	Yes	Crew Specification	No
prsnl_rate_def_for	fin_enum_cd	Char(5)	Yes	Rate defnition for	No
prsnl_eff_from	fin_date	Datetime(11)	Yes	effective from	No
prsnl_eff_to	fin_date	Datetime(11)	Yes	effective to	No
prsnl_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
prsnl_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
prsnl_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
prsnl_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
prsnl_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_ac_prsnl_pric_dtl
Comment :	Aircraft Personal pricing detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
prsnl_pric_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
prsnl_pric_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
prsnl_pric_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
prsnl_pric_lineno	fin_lineno	Int(4)	No	Line no	Yes
prsnl_pric_ac_model_no	fin_aircraftmodel	Char(20)	Yes	A/C Model no	No
prsnl_pric_ac_reg_no	fin_acregno	Char(30)	Yes	A/C Registration no	No
prsnl_pric_ratedefat	fin_designparamcode	Char(5)	Yes	Rate defnition	No
prsnl_pric_personnel_type	fin_quickcodes	Char(25)	Yes	Personnel type	No
prsnl_pric_skill_no	fin_resourcecode	Char(40)	Yes	Skill No	No
prsnl_pric_crew_assn_typ	fin_enum_cd	Char(5)	Yes	Crew Assignment type	No
prsnl_pric_rate_def_for	fin_enum_cd	Char(5)	Yes	Rate defnition for	No
prsnl_pric_charge_basis	fin_enum_cd	Char(5)	Yes	Charge basis	No
prsnl_pric_currency	fin_currency	Char(5)	Yes	currency	No
prsnl_pric_uom	fin_uom	Char(15)	Yes	unit of measurement	No
prsnl_pric_rate_uom	fin_amount	Numeric(28)	Yes	unit of measurement for rate	No
prsnl_pric_pricing_notes	fin_notes	Char(2000)	Yes	pricing notes	No
prsnl_pric_eff_from	fin_date	Datetime(11)	Yes	effective from	No
prsnl_pric_eff_to	fin_date	Datetime(11)	Yes	effective to	No
prsnl_pric_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
prsnl_pric_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
prsnl_pric_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
prsnl_pric_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
prsnl_pric_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_addinfo_dtl
Comment :	Aircraft additional info details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
addinfo_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
addinfo_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
addinfo_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
addinfo_lineno	fin_lineno	Int(4)	No	Line no	Yes
addinfo_catgry	fin_quickcodes	Char(25)	Yes	Category	No
addinfo_attribute	fin_quickcodes	Char(25)	Yes	Additional info Attribute	No
addinfo_value	fin_quantity	Numeric(28)	Yes	Additional info value	No
addinfo_notes	fin_notes	Char(2000)	Yes	Notes	No
addinfo_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
addinfo_Created_by	fin_ctxt_user	Char(30)	Yes	Created by (user)	No
addinfo_Created_Date	fin_date	Datetime(11)	Yes	created date	No
addinfo_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by (user)	No
addinfo_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_claim_dtl
Comment :	crew claim details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
claim_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
claim_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
claim_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
claim_lineno	fin_lineno	Int(4)	No	Lineno	Yes
claim_ac_model	fin_aircraftmodel	Char(20)	Yes	Aircraft Model no	No
claim_ac_reg_no	fin_acregno	Char(30)	Yes	Aircraft Registration no	No
claim_personnel_type	fin_quickcodes	Char(25)	Yes	Personnel type	No
claim_bill_head	fin_doctype	Char(40)	Yes	billing head	No
claim_currency	fin_currency	Char(5)	Yes	currency	No
claim_rate	fin_rate	Numeric(28)	Yes	rate	No
claim_efft_from	fin_date	Datetime(11)	Yes	effective from	No
claim_efft_to	fin_date	Datetime(11)	Yes	effective to	No
claim_timestamp	fin_timestamp	Int(4)	Yes	timestamp	No
claim_created_by	fin_ctxt_user	Char(30)	Yes	created by	No
claim_created_date	fin_date	Datetime(11)	Yes	created date	No
claim_modified_by	fin_ctxt_user	Char(30)	Yes	modified by	No
claim_modified_date	fin_date	Datetime(11)	Yes	modified date	No
claim_pricingnotes	fin_notes	Char(2000)	Yes	pricing notes	No
claim_remarks	fin_notes	Char(2000)	Yes	remarks	No
claim_seqno	fin_int	Int(4)	Yes	sequence no	No

Table Name :	fsc_cnt_invbasis_dtl
Comment :	invoice basis details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
invbasis_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
invbasis_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
invbasis_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
invbasis_lineno	fin_lineno	Int(4)	No	Lineno	Yes
invbasis_bill_head	fin_billhead	Char(40)	Yes	billing head	No
invbasis_inv_milestone	fin_designparamcode	Char(5)	Yes	invoice milestone	No
invbasis_chg_type	fin_identifiertype	Char(40)	Yes	charge type	No
invbasis_unit	fin_unit	Char(40)	Yes	invoice basis unit	No
invbasis_exp_acc_usage	fin_ccusage	Char(20)	Yes	epence acount usage	No
invbasis_payterm	fin_payterm	Char(30)	Yes	payterm	No
invbasis_invelement	fin_identifiertype	Char(40)	Yes	invoice element	No
invbasis_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
invbasis_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
invbasis_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
invbasis_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
invbasis_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No
invbasis_status	fin_status	Char(25)	Yes	invoice basis status	No
invbasis_flg_optyp	fin_identifiertype	Char(40)	Yes	flight oprational type	No
invbasis_act_optyp	fin_identifiertype	Char(40)	Yes	activityoperational type	No
invbasis_remarks	fin_notes	Char(2000)	Yes	remarks	No
invbasis_chg_for	fin_identifiertype	Char(40)	Yes	charge for	No

Table Name :	fsc_cnt_invrate_dtl
Comment :	invoice rate details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
invrate_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
invrate_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
invrate_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
invrate_lineno	fin_lineno	Int(4)	No	Lineno	Yes
invrate_def_at	fin_designparamcode	Char(5)	Yes	rate definition at	No
invrate_ac_model	fin_aircraftmodel	Char(20)	Yes	Aircraft model	No
invrate_ac_reg_no	fin_acregno	Char(30)	Yes	Aircraft registration no	No
invrate_def_fr	fin_designparamcode	Char(5)	Yes	Definition for	No
invrate_bill_head	fin_billhead	Char(40)	Yes	billing head	No
invrate_invoicebasis	fin_notes	Char(2000)	Yes	invoice basis	No
invrate_currecy	fin_currency	Char(5)	Yes	currency	No
invrate_rate	fin_rate	Numeric(28)	Yes	invoice rate	No
invrate_amount	fin_amount	Numeric(28)	Yes	invoice amount	No
invrate_markup	fin_amount	Numeric(28)	Yes	markup	No
invrate_efft_from	fin_date	Datetime(11)	Yes	effective from	No
invrate_efft_to	fin_date	Datetime(11)	Yes	effective to	No
invrate_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
invrate_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
invrate_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
invrate_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
invrate_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No
invrate_price_notes	fin_notes	Char(2000)	Yes	pricing notes	No
invrate_remarks	fin_notes	Char(2000)	Yes	remarks	No
invrate_assign_type	fin_types	Char(40)	Yes	assignment type	No
invrate_seqno	fin_int	Int(4)	Yes	sequence no	No

Table Name :	fsc_cnt_milestone_dtl
Comment :	milestone details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cnt_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
cnt_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
cnt_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
cnt_billing_head	fin_billhead	Char(40)	Yes	billing head	No
cnt_chg_type	fin_identifiertype	Char(40)	Yes	charge type	No
cnt_inv_milestone	fin_designparamcode	Char(5)	Yes	invoice milestone	No
cnt_milestone_date	fin_date	Datetime(11)	Yes	milestone date	No
cnt_horizon_start_date	fin_date	Datetime(11)	Yes	horizon start date	No
cnt_horizon_end_date	fin_date	Datetime(11)	Yes	horizon end date	No
cnt_horizon_ref	fin_description	Char(100)	Yes	horizon reference	No
cnt_cust_no	fin_customer_id	Char(18)	Yes	customer no	No
cnt_status	fin_status	Char(25)	Yes	status	No
cnt_rel_initiated	fin_flag	Char(25)	Yes	release initiated	No
cnt_rel_no	fin_documentno	Char(40)	Yes	release no	No
cnt_invline_no	fin_lineno	Int(4)	Yes	invoiceline no	No
cnt_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
cnt_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
cnt_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
cnt_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
cnt_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No
cnt_primary_lineno	fin_lineno	Int(4)	No	primary lineno	Yes
cnt_currency	fin_currency	Char(5)	Yes	currency	No
cnt_milestone_source	fin_quickcodes	Char(25)	Yes	milestone source	No

Table Name :	fsc_cnt_nonbill_dtl
Comment :	Non billable details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
nonbill_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
nonbill_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
nonbill_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
nonbill_lineno	fin_lineno	Int(4)	No	Lineno	Yes
nonbill_billhead	fin_doctype	Char(40)	Yes	billing head	No
nonbill_fltopstype	fin_vardesc	Char(80)	Yes	flight operation type	No
nonbill_fltcategory	fin_quickcodes	Char(25)	Yes	flight category	No
nonbill_nousgreasoncd	fin_quickcodes	Char(25)	Yes	no usage reason code	No
nonbill_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
nonbill_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
nonbill_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
nonbill_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
nonbill_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_opr_param_dtl
Comment :	Operating paramter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opr_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
opr_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
opr_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
opr_lineno	fin_lineno	Int(4)	No	Lineno	Yes
opr_element	fin_designparamcode	Char(5)	Yes	operational element	No
opr_value	fin_count	Int(4)	Yes	operational value	No
opr_notes	fin_notes	Char(2000)	Yes	operational notes	No
opr_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
opr_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
opr_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
opr_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
opr_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_cnt_sbrate_cnt_dtl
Comment :	contract slab based rate details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sbcnt_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
sbcnt_cnt_no	fin_documentno	Char(40)	No	contract no	Yes
sbcnt_rev_no	fin_rev_no	Int(4)	No	revision no	Yes
sbcnt_bill_head	fin_billhead	Char(40)	Yes	billing head	No
sbcnt_fromdate	fin_date	Datetime(11)	Yes	from date	No
sbcnt_todate	fin_date	Datetime(11)	Yes	to date	No
sbcnt_count	fin_count	Int(4)	Yes	slab based count	No
sbcnt_status	fin_status	Char(25)	Yes	Slab based status	No
sbcnt_timestamp	fin_timestamp	Int(4)	Yes	timestamp	No
sbcnt_Created_by	fin_ctxt_user	Char(30)	Yes	created by	No
sbcnt_Created_Date	fin_date	Datetime(11)	Yes	created date	No
sbcnt_Modified_by	fin_ctxt_user	Char(30)	Yes	modified by	No
sbcnt_Modified_Date	fin_date	Datetime(11)	Yes	modified date	No
sbcnt_line_no	fin_lineno	Int(4)	No	Lineno	Yes
sbcnt_hori_desc	fin_description	Char(100)	Yes	description	No
sbcnt_currency	fin_currency	Char(5)	Yes	currency value	No

Table Name :	fsc_cnt_sbrate_dtl
Comment :	slab based rate details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sbrate_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	No
sbrate_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
sbrate_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
sbrate_lineno	fin_unique_id	Bigint(8)	No	Lineno	Yes
sbrate_rate_def_at	fin_quickcodes	Char(25)	Yes	rate definition at	No
sbrate_ac_model	fin_aircraftmodel	Char(20)	Yes	aircraft model no	No
sbrate_ac_reg_no	fin_acregno	Char(30)	Yes	aircraft registration no	No
sbrate_bill_head	fin_doctype	Char(40)	Yes	billing head	No
sbrate_rate_def_fr	fin_quickcodes	Char(25)	Yes	rate definition for	No
sbrate_usage_from	fin_quantity	Numeric(28)	Yes	usage from	No
sbrate_usage_to	fin_quantity	Numeric(28)	Yes	usage to	No
sbrate_rate	fin_rate	Numeric(28)	Yes	rate	No
sbrate_efft_from	fin_date	Datetime(11)	Yes	effective from	No
sbrate_efft_to	fin_date	Datetime(11)	Yes	effective to	No
sbrate_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
sbrate_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
sbrate_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
sbrate_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
sbrate_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No
sbrate_currency	fin_currency	Char(5)	Yes	currency	No
sbrate_pricingnotes	fin_notes	Char(2000)	Yes	pricing notes	No
sbrate_remarks	fin_notes	Char(2000)	Yes	remarks	No
sbrate_ac_assignment	fin_types	Char(40)	Yes	aircraft assignment	No
sbrate_seqno	fin_int	Int(4)	Yes	sequence no	No
sbrate_groupid	fin_int	Int(4)	Yes	group id	No

Table Name :	fsc_cnt_sub_milestone_dtl
Comment :	contract sub milestone details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cnt_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
cnt_cnt_no	fin_documentno	Char(40)	No	contract no	Yes
cnt_rev_no	fin_rev_no	Int(4)	No	revision no	Yes
cnt_billing_head	fin_billhead	Char(40)	Yes	billing head	No
cnt_chg_type	fin_identifiertype	Char(40)	Yes	charge type	No
cnt_inv_milestone	fin_designparamcode	Char(5)	Yes	invoice milestone	No
cnt_milestone_date	fin_date	Datetime(11)	Yes	milestone date	No
cnt_horizon_start_date	fin_date	Datetime(11)	Yes	horizon start date	No
cnt_horizon_end_date	fin_date	Datetime(11)	Yes	horizon end date	No
cnt_horizon_ref	fin_description	Char(100)	Yes	horizon reference	No
cnt_cust_no	fin_customer_id	Char(18)	Yes	customer no	No
cnt_status	fin_status	Char(25)	Yes	status	No
cnt_rel_initiated	fin_flag	Char(25)	Yes	releasse initiated	No
cnt_rel_no	fin_documentno	Char(40)	Yes	release no	No
cnt_invline_no	fin_lineno	Int(4)	Yes	invoice lineno	No
cnt_timestamp	fin_timestamp	Int(4)	Yes	timestamp	No
cnt_Created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
cnt_Created_Date	fin_date	Datetime(11)	Yes	Created Date	No
cnt_Modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
cnt_Modified_Date	fin_date	Datetime(11)	Yes	Modified date	No
cnt_milestone_lineno	fin_lineno	Int(4)	No	milestone line no	Yes
cnt_sub_milestone_lineno	fin_lineno	Int(4)	No	sub milestone lineno	Yes
cnt_currency	fin_currency	Char(5)	Yes	currency	No
cnt_milestone_source	fin_quickcodes	Char(25)	Yes	milestone source	No

Table Name :	fsc_cnt_tab_rev_dtl
Comment :	contract tab revision detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tab_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
tab_cnt_no	fin_documentno	Char(40)	No	contract no	Yes
tab_rev_no	fin_rev_no	Int(4)	No	revision no	Yes
tab_ac_revno	fin_rev_no	Int(4)	Yes	Aircraft revision no	No
tab_prsnl_revno	fin_rev_no	Int(4)	Yes	Perssonnal revision no	No
tab_opr_revno	fin_rev_no	Int(4)	Yes	operating revision no	No
tab_fixchg_revno	fin_rev_no	Int(4)	Yes	Fixed charge revision no	No
tab_oprchg_revno	fin_rev_no	Int(4)	Yes	operating charge revision no	No
tab_forate_revno	fin_rev_no	Int(4)	Yes	fixed rate revision no	No
tab_sbrate_revno	fin_rev_no	Int(4)	Yes	slab based revision no	No
tab_chg_revno	fin_rev_no	Int(4)	Yes	charge revision no	No
tab_nbfleg_revno	fin_rev_no	Int(4)	Yes	non billable flight leg revision no	No
tab_nbchg_revno	fin_rev_no	Int(4)	Yes	nonbillabe charge revision no	No
tab_addinfo_revno	fin_rev_no	Int(4)	Yes	aditional info revision no	No
tab_invrate_revno	fin_rev_no	Int(4)	Yes	invoice rate revision no	No
tab_tcd_rev_no	fin_rev_no	Int(4)	Yes	tcs revision no	No
tab_invbasis_revno	fin_rev_no	Int(4)	Yes	invoice basis revision no	No
tab_prsnl_pric_revno	fin_rev_no	Int(4)	Yes	pesonnel pricing revision no	No
tab_claim_rev_no	fin_rev_no	Int(4)	Yes	claim revision no	No
tab_acatt_revno	fin_rev_no	Int(4)	Yes	aircraft attribute revision no	No
tab_nonbill_revno	fin_rev_no	Int(4)	Yes	nonbillable revision no	No

Table Name :	fsc_cnt_tcd_dtl
Comment :	contract tax charge discount details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tcd_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
tcd_cnt_no	fin_documentno	Char(40)	No	Contract no	Yes
tcd_rev_no	fin_rev_no	Int(4)	No	Revision no	Yes
tcd_lineno	fin_lineno	Int(4)	No	Lineno	Yes
tcd_tcd_no	fin_tcdcodes	Char(25)	Yes	tcd number	No
tcd_variant_no	fin_tcdvariant	Char(25)	Yes	variant no	No
tcd_applied_on	fin_quickcodes	Char(25)	Yes	tcd applied on	No
tcd_currency	fin_currency	Char(5)	Yes	currency	No
tcd_rate	fin_rate	Numeric(28)	Yes	rate	No
tcd_remarks	fin_notes	Char(2000)	Yes	remarks	No
tcd_efft_from	fin_date	Datetime(11)	Yes	effective from	No
tcd_efft_to	fin_date	Datetime(11)	Yes	effective to	No
tcd_timestamp	fin_timestamp	Int(4)	Yes	Time stamp	No
tcd_created_by	fin_ctxt_user	Char(30)	Yes	Created by	No
tcd_created_date	fin_date	Datetime(11)	Yes	Created Date	No
tcd_modified_by	fin_ctxt_user	Char(30)	Yes	Modified by	No
tcd_modified_date	fin_date	Datetime(11)	Yes	Modified date	No

Table Name :	fsc_inv_element_dtl
Comment :	invoice element details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
inv_head_code	fin_designparamcode	Char(5)	No	head code	Yes
inv_head_desc	fin_description	Char(100)	Yes	head description	No
inv_element_code	fin_designparamcode	Char(5)	Yes	element code	No
inv_element_desc	fin_description	Char(100)	No	element description	Yes
inv_lang_id	fin_ctxt_ouinstance	Int(4)	Yes	language id	No

Table Name :	fsc_ret_hist_dtl
Comment :	Return history detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fsc_cnt_no	fin_documentno	Char(40)	No	contract no	Yes
fsc_rev_no	fin_rev_no	Int(4)	No	revision no	Yes
fsc_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
fsc_status	fin_status	Char(25)	Yes	status	No
fsc_reasonret	fin_notes	Char(2000)	Yes	return reason	No
fsc_remarks	fin_notes	Char(2000)	Yes	remarks	No
fsc_Termination_Date	fin_date	Datetime(11)	Yes	termination date	No
fsc_lastmodifiedby	fin_ctxt_user	Char(30)	Yes	lastmodified by	No
fsc_lastmodifieddate	fin_date	Datetime(11)	Yes	lastmodified date	No
fsc_returnedby	fin_ctxt_user	Char(30)	Yes	treturned by	No
fsc_returneddate	fin_date	Datetime(11)	Yes	returned date	No