Database Schema for

Data Dictionary -- Flight Billing

Srl. No.	Table Name	Comment
1	fir_billhead_summary_dtl	Billing Head Summary Detail
2	fir_crew_charges_dtl	Crew Charges Detail
3	fir_fix_charge_dtl	Fix Charge Detail
4	fir_flight_sheet_dtl	Flight Sheet Detail
5	fir_inv_rel_gen_dtl	Invoice Release Generate Detail
6	fir_opr_charge_dtl	Operation Charge Detail
7	fir_othr_charge_dtl	Other Charge Detail
8	fir_rel_main_hdr	Release Main Header


Table Name :	fir_billhead_summary_dtl
Comment :	Billing Head Summary Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bs_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
bs_inv_rel_no	fin_documentno	Char(40)	No	Invoice Relative Number	Yes
bs_bill_head	fin_billhead	Char(40)	No	Billing Head	Yes
bs_inv_element	fin_designparamcode	Char(5)	Yes	Invoice Element	No
bs_currency	fin_currency	Char(5)	No	Currency	Yes
bs_amount	fin_amount	Numeric(28)	Yes	Amount	No
bs_amount_bill_curr	fin_amount	Numeric(28)	Yes	Amount Billing Currency	No
bs_avg_exch_rate	fin_rate	Numeric(28)	Yes	Average Exchange Rate	No
bs_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
bs_createdby	fin_Ctxt_User	Char(30)	Yes	Created By	No
bs_created_date	fin_date	Date(11)	Yes	Created Date	No
bs_modifiedby	fin_Ctxt_User	Char(30)	Yes	Modified By	No
bs_modified_date	fin_date	Date(11)	Yes	Modified Date	No
bs_horizon_start_date	fin_date	Date(11)	Yes	Horizon Start Date	No
bs_horizon_end_date	fin_date	Date(11)	Yes	Horizon End Date	No
bs_unit	fin_unit	Varchar(40)	Yes	Unit	No


Table Name :	fir_crew_charges_dtl
Comment :	Crew Charges Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
crew_ouinstance_id	Ctxt_OUInstance	Int(4)	No	OUInstance Id	Yes
crew_inv_relno	fin_documentno	Char(40)	No	Invoice Release Number	Yes
crew_line_no	fin_lineno	Int(4)	No	Line Number	Yes
crew_bill_head	fin_billhead	Char(40)	Yes	Billing Head	No
crew_chrg_type	fin_designparamcode	Char(5)	Yes	Charge Type	No
crew_crw_type	fin_documentno	Char(40)	Yes	Crew Type	No
crew_empno	fin_employee_code	Char(60)	Yes	Employee Number	No
crew_empname	fin_employeename	Varchar(77)	Yes	Employee Name	No
crew_unit	fin_unit	Varchar(40)	Yes	Unit	No
crew_currency	fin_currency	Char(5)	Yes	Currency	No
crew_noofunits_sys	fin_quantity	Numeric(28)	Yes	Number of Units System	No
crew_noofunits	fin_quantity	Numeric(28)	Yes	Number of Units	No
crew_rate_sys	fin_rate	Numeric(28)	Yes	Rate System	No
crew_rate	fin_rate	Numeric(28)	Yes	Rate	No
crew_amt	fin_amount	Numeric(28)	Yes	Amount	No
crew_exrate	fin_rate	Numeric(28)	Yes	Exchange Rate	No
crew_amtbillcurr	fin_amount	Numeric(28)	Yes	Amount Billing Currency	No
crew_prcng_disp	fin_Disposition	Char(40)	Yes	Pricing Disposition	No
crew_prcng_notes	fin_notes	Char(2000)	Yes	Pricing Notes	No
crew_mod_cmnts	fin_notes	Char(2000)	Yes	Modification Comments	No
crew_remarks	fin_remarks	Char(100)	Yes	Remarks	No
crew_inv_milestone	fin_designparamcode	Char(5)	Yes	Invoice Milestone	No
crew_milestone_date	fin_date	Date(11)	Yes	Milestone Date	No
crew_bill_horizone	fin_desc40	Char(40)	Yes	Billing Horizon	No
crew_modified_by	fin_Ctxt_User	Char(30)	Yes	Modified By	No
crew_modified_date	fin_date	Date(11)	Yes	Modified Date	No
crew_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
crew_createdby	fin_Ctxt_User	Char(30)	Yes	Created By	No
crew_created_date	fin_date	Date(11)	Yes	Created Date	No
crew_horizon_start_date	fin_date	Date(11)	Yes	Horizon Start Date	No
crew_horizon_end_date	fin_date	Date(11)	Yes	Horizon End Date	No
crew_flag	fin_flag	Char(25)	Yes	Flag	No
crew_ac_assgn_type	fin_enum_cd	Char(5)	Yes	Aircraft Assignment Type	No
crew_pri_ac_model_no	fin_aircraftmodel	Char(20)	Yes	Primary Aircraft Model Number	No
crew_pri_ac_regno	fin_acregno	Char(30)	Yes	Primary Aircraft Registration Number	No


Table Name :	fir_fix_charge_dtl
Comment :	Fix Charge Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fix_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
fix_inv_rel_no	fin_documentno	Char(40)	No	Invoice Release Number	Yes
fix_lineno	fin_lineno	Int(4)	No	Line Number	Yes
fix_bill_head	fin_billhead	Char(40)	Yes	Billing Head	No
fix_charge_type	fin_designparamcode	Char(5)	Yes	Charge Type	No
fix_unit	fin_unit	Varchar(40)	Yes	Unit	No
fix_currency	fin_currency	Char(5)	Yes	Currency	No
fix_no_units_sys	fin_quantity	Numeric(28)	Yes	Number of Units System	No
fix_no_units	fin_quantity	Numeric(28)	Yes	Number Of units	No
fix_rate_sys	fin_rate	Numeric(28)	Yes	Rate System	No
fix_rate	fin_rate	Numeric(28)	Yes	Rate	No
fix_amount	fin_amount	Numeric(28)	Yes	Amount	No
fix_exch_rate	fin_rate	Numeric(28)	Yes	Exchange Rate	No
fix_amount_bill_curr	fin_amount	Numeric(28)	Yes	Amount Billing Currency	No
fix_price_disposition	fin_Disposition	Char(40)	Yes	Price Disposition	No
fix_price_notes	fin_notes	Char(2000)	Yes	Price Notes	No
fix_modification_notes	fin_notes	Char(2000)	Yes	Modification Notes	No
fix_remarks	fin_remarks	Char(100)	Yes	Remarks	No
fix_inv_milestone	fin_designparamcode	Char(5)	Yes	Invoice Milestone	No
fix_milestone_date	fin_date	Date(11)	Yes	Milestone Date	No
fix_bill_horizon	fin_desc40	Char(40)	Yes	Billing Horizon	No
fix_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
fix_createdby	fin_Ctxt_User	Char(30)	Yes	Created By	No
fix_created_date	fin_date	Date(11)	Yes	Created Date	No
fix_modifiedby	fin_Ctxt_User	Char(30)	Yes	Modified By	No
fix_modified_date	fin_date	Date(11)	Yes	Modified Date	No
fix_horizon_start_date	fin_date	Date(11)	Yes	Horizon Start Date	No
fix_horizon_end_date	fin_date	Date(11)	Yes	Horizon End Date	No
fix_assigenment_type	fin_enum_cd	Char(5)	Yes	Assignment Type	No
fix_primary_ac_model	fin_aircraftmodel	Char(20)	Yes	Primary Aircraft Model Number	No
fix_primary_ac_regno	fin_acregno	Char(30)	Yes	Primary Aircraft Registration Number	No


Table Name :	fir_flight_sheet_dtl
Comment :	Flight Sheet Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fs_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
fs_inv_rel_no	fin_documentno	Char(40)	No	Invoice Release Number	Yes
fs_flight_sheetno	fin_documentno	Char(40)	No	Flight Sheet Number	Yes
fs_flight_date	fin_date	Date(11)	Yes	Flight Date	No
fs_ac_regno	fin_acregno	Char(30)	Yes	Aircraft Registration Number	No
fs_ac_model_no	fin_aircraftmodel	Char(20)	Yes	Aircraft Model Number	No
fs_primary_flag	fin_flag	Char(25)	Yes	Primary Flag	No
fs_primary_ac_regno	fin_acregno	Char(30)	Yes	Primary Aircraft Registration Number	No
fs_primary_ac_model_no	fin_aircraftmodel	Char(20)	Yes	Primary Aircraft Model Number	No
fs_ac_assgn_type	fin_invtypes	Char(25)	Yes	Aircraft Assignment Type	No
fs_bill_remarks	fin_remarks	Char(100)	Yes	Billing Remarks	No
fs_return_remarks	fin_remarks	Char(100)	Yes	Return Remarks	No
fs_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
fs_createdby	fin_Ctxt_User	Char(30)	Yes	Created By	No
fs_created_date	fin_date	Date(11)	Yes	Created Date	No
fs_modifiedby	fin_Ctxt_User	Char(30)	Yes	Modified By	No
fs_modified_date	fin_date	Date(11)	Yes	Modified Date	No


Table Name :	fir_inv_rel_gen_dtl
Comment :	Invoice Release Generate Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fir_guid	fin_guid	Char(40)	No	GUID	Yes
fir_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
fir_cnt_no	fin_documentno	Char(40)	No	Contact Number	Yes
fir_rev_no	fin_rev_no	Int(4)	No	Revision Number	Yes
fir_billing_head	fin_billhead	Char(40)	No	Billing Head	Yes
fir_chg_type	fin_identifiertype	Char(40)	Yes	Charge Type	No
fir_inv_milestone	fin_designparamcode	Char(5)	Yes	Invoice Milestone	No
fir_milestone_date	fin_date	Date(11)	No	Milestone Date	Yes
fir_horizon_start_date	fin_date	Date(11)	Yes	Horizon Start Date	No
fir_horizon_end_date	fin_date	Date(11)	Yes	Horizon End Date	No
fir_horizon_ref	fin_description	Char(100)	Yes	Horizon Reference	No
fir_cust_no	fin_customer_id	Char(18)	Yes	Customer ID	No
fir_status	fin_status	Char(25)	Yes	Status	No
fir_rel_initiated	fin_flag	Char(25)	Yes	Release Initiated	No
fir_rel_no	fin_documentno	Char(40)	Yes	Release Number	No
fir_invline_no	fin_lineno	Int(4)	Yes	Invoice Line Number	No
fir_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
fir_Created_by	fin_Ctxt_User	Char(30)	Yes	Created By	No
fir_Created_Date	fin_date	Date(11)	Yes	Created Date	No
fir_Modified_by	fin_Ctxt_User	Char(30)	Yes	Modified By	No
fir_Modified_Date	fin_date	Date(11)	Yes	Modified Date	No
fir_primary_lineno	fin_lineno	Int(4)	Yes	Primary Line Number	No
fir_inv_element	fin_designparamcode	Char(5)	Yes	Invoice Element	No
fir_chg_for	fin_designparamcode	Char(5)	Yes	Charge For	No
fir_unit	fin_unit	Varchar(40)	Yes	Unit	No
fir_customer_no	fin_customer_id	Char(18)	Yes	Customer Number	No
fir_charter_type	fin_quickcodes	Char(25)	Yes	Charter Type	No
fir_currency	fin_currency	Char(5)	Yes	Currency	No
fir_user_status	fin_usersts	Varchar(40)	Yes	User Status	No
fir_cust_ser_rep	fin_Ctxt_User	Char(30)	Yes	Customer Service Representative	No
fir_pay_term	fin_payterm	Char(30)	Yes	Pay Term	No
fir_inv_rel_ref	fin_documentno	Char(40)	Yes	Invoice Release Reference	No
fir_sub_primary_lineno	fin_lineno	Int(4)	Yes	Sub Primary Line Number	No
fir_inv_cat	fin_invoicecategory	Char(40)	Yes	Invoice Category	No
fir_event_type	fin_type	Char(25)	Yes	Event Type	No
fir_grp_by	fin_lineno	Int(4)	Yes	Group By	No
fir_gen_rel_status	fin_status	Char(25)	Yes	Generate release Status	No
fir_run_guid	fin_guid	Char(40)	Yes	Run GUID	No
fir_genrel_line_no	fin_lineno	Int(4)	Yes	Generate Release Line Number	No
fir_bill_customer	fin_customer_id	Char(18)	Yes	Billing Customer	No


Table Name :	fir_opr_charge_dtl
Comment :	Operation Charge Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opr_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
opr_inv_rel_no	fin_documentno	Char(40)	No	Invoice Release Number	Yes
opr_lineno	fin_lineno	Int(4)	No	Line Number	Yes
opr_charge_for	fin_designparamcode	Char(5)	Yes	Charge For	No
opr_bill_head	fin_billhead	Char(40)	Yes	Billing Head	No
opr_charge_type	fin_designparamcode	Char(5)	Yes	Charge Type	No
opr_unit	fin_unit	Varchar(40)	Yes	Unit	No
opr_currency	fin_currency	Char(5)	Yes	Currency	No
opr_no_units_sys	fin_quantity	Numeric(28)	Yes	Number of Units System	No
opr_no_units	fin_quantity	Numeric(28)	Yes	Number of Units	No
opr_rate_slab	fin_remarks	Char(100)	Yes	Rate Slab	No
opr_ac_assgn_type	fin_types	Varchar(30)	Yes	Account Assignment Type	No
opr_rate_for	fin_designparamcode	Char(5)	Yes	Rate For	No
opr_rate_sys	fin_rate	Numeric(28)	Yes	Rate System	No
opr_rate	fin_rate	Numeric(28)	Yes	Rate	No
opr_amount	fin_amount	Numeric(28)	Yes	Amount	No
opr_markup	fin_rate	Numeric(28)	Yes	Markup	No
opr_markup_amount	fin_amount	Numeric(28)	Yes	Markup Amount	No
opr_total_amount	fin_amount	Numeric(28)	Yes	Total Amount	No
opr_exch_rate	fin_rate	Numeric(28)	Yes	Exchange Rate	No
opr_amount_bill_curr	fin_amount	Numeric(28)	Yes	Amount Billing Currency	No
opr_price_disposition	fin_Disposition	Char(40)	Yes	Price Disposition	No
opr_price_notes	fin_notes	Char(2000)	Yes	Price Notes	No
opr_modification_notes	fin_notes	Char(2000)	Yes	Modification Notes	No
opr_remarks	fin_remarks	Char(100)	Yes	Remarks	No
opr_inv_milestone	fin_designparamcode	Char(5)	Yes	Invoice Milestone	No
opr_milestone_date	fin_date	Date(11)	Yes	Milestone Date	No
opr_bill_horizon	fin_desc40	Char(40)	Yes	Billing Horizon	No
opr_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
opr_createdby	fin_Ctxt_User	Char(30)	Yes	Created By	No
opr_created_date	fin_date	Date(11)	Yes	Created Date	No
opr_modifiedby	fin_Ctxt_User	Char(30)	Yes	Modified By	No
opr_modified_date	fin_date	Date(11)	Yes	Modified Date	No
opr_horizon_start_date	fin_date	Date(11)	Yes	Horizon Start Date	No
opr_horizon_end_date	fin_date	Date(11)	Yes	Horizon End Date	No


Table Name :	fir_othr_charge_dtl
Comment :	Other Charge Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
othr_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
othr_inv_rel_no	fin_documentno	Char(40)	No	Invoice Release Number	Yes
othr_lineno	fin_lineno	Int(4)	No	Line Number	Yes
othr_bill_head	fin_doctype	Char(40)	Yes	Billing Head	No
othr_charge_type	fin_designparamcode	Char(5)	Yes	Charge Type	No
othr_unit	fin_unit	Varchar(40)	Yes	Unit	No
othr_currency	fin_currency	Char(5)	Yes	Currency	No
othr_no_units_sys	fin_quantity	Numeric(28)	Yes	Number of Units System	No
othr_no_units	fin_quantity	Numeric(28)	Yes	Number of Units	No
othr_rate_sys	fin_rate	Numeric(28)	Yes	Rate System	No
othr_rate	fin_rate	Numeric(28)	Yes	Rate	No
othr_amount	fin_amount	Numeric(28)	Yes	Amount	No
othr_exch_rate	fin_rate	Numeric(28)	Yes	Exchange Rate	No
othr_amount_bill_curr	fin_amount	Numeric(28)	Yes	Amount Billing Currency	No
othr_price_disposition	fin_Disposition	Char(40)	Yes	Price Disposition	No
othr_price_notes	fin_notes	Char(2000)	Yes	Price Notes	No
othr_modification_comnts	fin_notes	Char(2000)	Yes	Modification Comments	No
othr_remarks	fin_remarks	Char(100)	Yes	Remarks	No
othr_inv_milestone	fin_designparamcode	Char(5)	Yes	Invoice Milestone	No
othr_milestone_date	fin_date	Date(11)	Yes	Milestone Date	No
othr_bill_horizon	fin_desc40	Char(40)	Yes	Billing Horizon	No
othr_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
othr_createdby	fin_Ctxt_User	Char(30)	Yes	Created By	No
othr_created_date	fin_date	Date(11)	Yes	Created Date	No
othr_modifiedby	fin_Ctxt_User	Char(30)	Yes	Modified By	No
othr_modified_date	fin_date	Date(11)	Yes	Modified Date	No
oth_horizon_start_date	fin_date	Date(11)	Yes	Horizon Start Date	No
oth_horizon_end_date	fin_date	Date(11)	Yes	Horizon End Date	No


Table Name :	fir_rel_main_hdr
Comment :	Release Main Header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fir_ouinstance	Ctxt_OUInstance	Int(4)	No	OUInstance	Yes
fir_inv_rel_no	fin_documentno	Char(40)	No	Invoice Release Number	Yes
fir_bill_horizon	fin_desc40	Char(40)	Yes	Billing Horizon	No
fir_rel_status	fin_status	Char(25)	Yes	Release Status	No
fir_customer_no	fin_customer_id	Char(18)	Yes	Customer Number	No
fir_contract_no	fin_documentno	Char(40)	Yes	Contract Number	No
fir_contract_revno	fin_rev_no	Int(4)	Yes	Contract Revision Number	No
fir_charter_type	fin_quickcodes	Char(25)	Yes	Charter Type	No
fir_charter_ctgy	hdn_chartcategory	Char(5)	Yes	Charter Category	No
fir_bill_currency	fin_currency	Char(5)	Yes	Billing Currency	No
fir_base_currency	fin_currency	Char(5)	Yes	Base Currency	No
fir_rel_value	fin_amount	Numeric(28)	Yes	Release Value	No
fir_exch_rate	fin_rate	Numeric(28)	Yes	Exchange Rate	No
fir_rel_value_base_curr	fin_amount	Numeric(28)	Yes	Release Value Base Currency	No
fir_rel_date	fin_date	Date(11)	Yes	Release Date	No
fir_inv_ctgy	fin_invoicecategory	Char(40)	Yes	Invoice Category	No
fir_user_status	fin_usersts	Varchar(40)	Yes	User Status	No
fir_bill_rep	fin_Ctxt_User	Char(30)	Yes	Billing Representative	No
fir_return_remarks	fin_comments	Char(255)	Yes	Return Remarks	No
fir_release_remarks	fin_comments	Char(255)	Yes	Release Remarks	No
fir_payterm	fin_payterm	Char(30)	Yes	Payterm	No
fir_exception	fin_notes	Char(2000)	Yes	Exception	No
fir_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
fir_createby	fin_Ctxt_User	Char(30)	Yes	Created By	No
fir_create_date	fin_date	Date(11)	Yes	Create Date	No
fir_modifiedby	fin_Ctxt_User	Char(30)	Yes	Modified By	No
fir_modified_date	fin_date	Date(11)	Yes	Modified Date	No
fir_confirmedby	fin_Ctxt_User	Char(30)	Yes	Confirmed By	No
fir_confirmed_date	fin_date	Date(11)	Yes	Confirmed Date	No
fir_cancelledby	fin_Ctxt_User	Char(30)	Yes	Cancelled By	No
fir_cancelled_date	fin_date	Date(11)	Yes	Cancelled Date	No
fir_batch_id	fin_guid	Char(40)	Yes	Batch ID	No
fir_event_type	fin_type	Char(25)	Yes	Event Type	No
fir_milestone_date	fin_date	Date(11)	Yes	Milestone Date	No
fir_milestone_ref	fin_designparamcode	Char(5)	Yes	Milestone Reference	No
fir_final_inv_no	fin_documentno	Char(40)	Yes	Final Invoice Number	No
fir_bill_customer	fin_customer_id	Char(18)	Yes	Billing Customer	No