Database Schema for

Data Dictionary -- Flight Sheet

Srl. No.	Table Name	Comment
1	fs_ac_activity_info	Flight Sheet Activity Info detail
2	fs_additional_info	Flight sheet additional info
3	fs_bill_summary_dtl	Flight sheet billing summary detail
4	fs_crew_claims_dtl	Flight sheet crew claims detail
5	fs_duty_info	Flight sheet duty info
6	fs_emp_activity_info	Flight sheet employee activity info
7	fs_flight_sheet_hdr	Flight sheet header table
8	fs_jl_flighthours_dtl	Flight sheet journey log flight hours detail
9	fs_Journey_log_info	Flight sheet journey log info
10	fs_Jrnlog_leg_info	Fight sheet journey log leg info
11	fs_jrnlog_param_info	Flight sheet journey log parameter info
12	fs_noflight_info	Flight sheet no flight info
13	fs_other_claims_dtl	Flight sheet other claims detail


Table Name :	fs_ac_activity_info
Comment :	Flight Sheet Activity Info detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ac_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
ac_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet number	Yes
ac_lineno	fin_lineno	Int(4)	No	Line number	Yes
ac_batchid	fin_unique_id	Bigint(8)	No	Batch id	Yes
ac_activity_code	fin_activity	Char(40)	Yes	Activity code	No
ac_from_date	fin_date	Datetime(11)	Yes	From date	No
ac_to_date	fin_date	Datetime(11)	Yes	To date	No
ac_unit	fin_uom	Char(15)	Yes	Unit	No
ac_quantity	fin_quantity	Numeric(28)	Yes	Quantity	No
ac_remarks	fin_notes	Char(2000)	Yes	Remarks	No
ac_modcomments	fin_notes	Char(2000)	Yes	Modification comments	No
ac_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
ac_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
ac_created_date	fin_date	Datetime(11)	Yes	Created date	No
ac_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
ac_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
ac_sourceflag	fin_designparamcode	Char(5)	Yes	Source flag	No
ac_actflag	fin_designparamcode	Char(5)	Yes	Active flag	No


Table Name :	fs_additional_info
Comment :	Flight sheet additional info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
adi_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
adi_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet number	Yes
adi_lineno	fin_lineno	Int(4)	No	Line no	No
adi_batchid	fin_unique_id	Bigint(8)	No	Batchid	Yes
adi_entity_code	fin_designparamcode	Char(5)	Yes	Entity code	No
adi_category_code	fin_designparamcode	Char(5)	Yes	Category code	No
adi_value	fin_quantity	Numeric(28)	Yes	Value	No
adi_remarks	fin_notes	Char(2000)	Yes	Remarks	No
adi_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
adi_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
adi_created_date	fin_date	Datetime(11)	Yes	Created date	No
adi_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
adi_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
adi_actflag	fin_designparamcode	Char(5)	Yes	Action flag	No
adi_sourceflag	fin_designparamcode	Char(5)	Yes	Source flag	No
adi_modifycomments	fin_comments	Char(255)	Yes	Modification comments	No


Table Name :	fs_bill_summary_dtl
Comment :	Flight sheet billing summary detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bs_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
bs_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet number	Yes
bs_billing_head	fin_billhead	Char(100)	No	Billing head	Yes
bs_bill_parameter	fin_description	Char(100)	No	Billing parameter	Yes
bs_billable_value	fin_quantity	Numeric(28)	Yes	Billable value	No
bs_nonbillable_value	fin_quantity	Numeric(28)	Yes	Non billable value	No
bs_remarks	fin_remarks	Char(100)	Yes	Remarks	No
bs_batch_id	fin_int	Int(4)	Yes	Batch id	No
bs_currency	fin_currency	Char(5)	Yes	Currency	No
bs_tabflag	fin_designparamcode	Char(5)	Yes	Tab flag	No
bs_contracted	fin_quickcodes	Char(25)	Yes	Contracted	No
bs_chargetype	fin_description	Char(100)	Yes	Charge type	No
bs_qty	fin_quantity	Numeric(28)	Yes	Quantity	No
bs_chargetypedesc	fin_description	Char(100)	Yes	Chargetypr description	No
bs_billing_headdesc	fin_comments	Char(255)	Yes	Billing head description	No
bs_uomdesc	fin_comments	Char(255)	Yes	UOM description	No


Table Name :	fs_crew_claims_dtl
Comment :	Flight sheet crew claims detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cc_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
cc_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet number	Yes
cc_lineno	fin_lineno	Int(4)	No	Line no	Yes
cc_batchid	fin_unique_id	Bigint(8)	No	Batch id	Yes
cc_date	fin_date	Datetime(11)	Yes	Date	No
cc_crew_type	fin_quickcodes	Char(25)	Yes	Crew Type	No
cc_employee_code	fin_employee_code	Char(60)	Yes	Employee code	No
cc_chargecode	fin_doctype	Char(40)	Yes	Charge code	No
cc_unit	fin_unit	Char(100)	Yes	Unit	No
cc_quantity	fin_quantity	Numeric(28)	Yes	Quantity	No
cc_currency	fin_currency	Char(5)	Yes	Currency	No
cc_amount	fin_amount	Numeric(28)	Yes	Amount	No
cc_remarks	fin_notes	Char(2000)	Yes	Remarks	No
cc_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
cc_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
cc_created_date	fin_date	Datetime(11)	Yes	Created date	No
cc_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
cc_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
cc_actflag	fin_designparamcode	Char(5)	Yes	Action flag	No
cc_sourceflag	fin_designparamcode	Char(5)	Yes	Source flag	No
cc_modifycomments	fin_comments	Char(255)	Yes	Modification comments	No


Table Name :	fs_duty_info
Comment :	Flight sheet duty info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
di_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
di_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet number	Yes
di_lineno	fin_lineno	Int(4)	No	Line no	Yes
di_batchid	fin_unique_id	Bigint(8)	No	Batch id	Yes
di_crew_type	fin_quickcodes	Char(25)	Yes	Creaw type	No
di_from_date	fin_date	Datetime(11)	Yes	From date	No
di_to_date	fin_date	Datetime(11)	Yes	To date	No
di_employee_code	fin_employee_code	Char(60)	Yes	Employee code	No
di_duty_type	fin_activity	Char(40)	Yes	Duty type	No
di_unit	fin_uom	Char(15)	Yes	Unit	No
di_value	fin_quantity	Numeric(28)	Yes	Value	No
di_diffflag	fin_designparamcode	Char(5)	Yes	Difference flag	No
di_remarks	fin_remarks	Char(100)	Yes	Remarks	No
di_modification_notes	fin_notes	Char(2000)	Yes	Modification comments	No
di_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
di_createby	fin_ctxt_user	Char(30)	Yes	Created by	No
di_create_date	fin_date	Datetime(11)	Yes	Created date	No
di_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
di_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
di_sourceflag	fin_designparamcode	Char(5)	Yes	Action flag	No
di_actflag	fin_designparamcode	Char(5)	Yes	Source flag	No


Table Name :	fs_emp_activity_info
Comment :	Flight sheet employee activity info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
emp_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
emp_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet number	Yes
emp_lineno	fin_lineno	Int(4)	No	Line no	Yes
emp_batchid	fin_unique_id	Bigint(8)	Yes	Batch id	No
emp_crew_type	fin_quickcodes	Char(25)	Yes	Creaw type	No
emp_from_date	fin_date	Datetime(11)	Yes	From date	No
emp_to_date	fin_date	Datetime(11)	Yes	To date	No
emp_employee_code	fin_employee_code	Char(60)	Yes	Employee code	No
emp_activity_code	fin_activity	Char(40)	Yes	Activity code	No
emp_unit	fin_uom	Char(15)	Yes	Employee Unit	No
emp_quantity	fin_quantity	Numeric(28)	Yes	Quantity	No
emp_remarks	fin_remarks	Char(100)	Yes	Remarks	No
emp_diffflag	fin_designparamcode	Char(5)	Yes	Difference flag	No
emp_modification_notes	fin_notes	Char(2000)	Yes	Modification notes	No
emp_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
emp_createby	fin_ctxt_user	Char(30)	Yes	Created by	No
emp_create_date	fin_date	Datetime(11)	Yes	Created date	No
emp_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
emp_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
emp_source	fin_flag	Char(25)	Yes	Source flag	No
emp_actflag	fin_designparamcode	Char(5)	Yes	Action flag	No


Table Name :	fs_flight_sheet_hdr
Comment :	Flight sheet header table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fs_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
fs_flightsheet_no	fin_documentno	Char(40)	No	Flightsheet number	Yes
fs_status	fin_status	Char(25)	Yes	Flight sheet status	No
fs_user_status	fin_quickcodes	Char(25)	Yes	User status	No
fs_source	fin_flag	Char(25)	Yes	Source	No
fs_errorid	fin_errorid	Int(4)	Yes	Error id	No
fs_errorlog	fin_notes	Char(2000)	Yes	Error log	No
fs_return_remarks	fin_remarks	Char(100)	Yes	Return remarks	No
fs_ac_reg_no	fin_acregno	Char(30)	Yes	Aircraft registration number	No
fs_ac_model_no	fin_aircraftmodel	Char(20)	Yes	Aircraft model no	No
fs_replcd_ac_reg_no	fin_acregno	Char(30)	Yes	Replaced aircraft registration no	No
fs_ac_assign_type	fin_enum_cd	Char(5)	Yes	assignment type	No
fs_call_sign	fin_callsign	Char(20)	Yes	Call sign	No
fs_customer_no	fin_customer_id	Char(18)	Yes	customer no	No
fs_contract_no	fin_documentno	Char(40)	Yes	Contract no	No
fs_contracr_rev_no	fin_rev_no	Int(4)	Yes	Contract revision no	No
fs_charter_type	fin_quickcodes	Char(25)	Yes	Charter type	No
fs_group_key	fin_guid	Char(40)	Yes	Group key	No
fs_invoiceno	fin_documentno	Char(40)	Yes	Invoice no	No
fs_genmode	fin_designparamcode	Char(5)	Yes	Generation mode	No
fs_efbrefno	fin_documentno	Char(40)	Yes	efb reference no	No
fs_efbrefou	fin_ctxt_ouinstance	Int(4)	Yes	efb reference ou	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_datetime	Datetime(25)	Yes	Created date	No
fs_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
fs_modified_date	fin_datetime	Datetime(25)	Yes	Modified date	No
fs_confirmedby	fin_ctxt_user	Char(30)	Yes	Confirmed by	No
fs_confirmed_date	fin_datetime	Datetime(25)	Yes	Confirmed date	No
fs_cancelledby	fin_ctxt_user	Char(30)	Yes	Cancelled by	No
fs_cancelled_date	fin_datetime	Datetime(25)	Yes	Cancelled date	No
fs_dirflag	fin_designparamcode	Char(5)	Yes	Directory flag	No
fs_flight_date	fin_datetime	Datetime(25)	Yes	Flight date	No
fs_replcd_ac_modelno	fin_aircraftmodel	Char(20)	Yes	Replaced aircraft model no	No
fs_bill_remarks	fin_remarks	Char(100)	Yes	Billing remarks	No
fs_flight_date_to	fin_date	Datetime(11)	Yes	Flight to date	No
fs_flight_date_frm	fin_date	Datetime(11)	Yes	Flight from date	No
fs_batchid	fin_guid	Char(40)	Yes	Batch id	No
fs_flight_frmdatetime	fin_datetime	Datetime(25)	Yes	Flight from datetime	No
fs_flight_todatetime	fin_datetime	Datetime(25)	Yes	Flight to datetime	No
fs_charter_category	fin_quickcodes	Char(25)	Yes	Charter category	No
fs_billing_remarks	fin_notes	Char(2000)	Yes	Flight sheet Billing remarks	No
fs_utctimezone	fin_timezone	Char(30)	Yes	UTC timezone	No
fs_flightsheetrefno	fin_documentno	Char(40)	Yes	Flight sheet reference no	No


Table Name :	fs_jl_flighthours_dtl
Comment :	Flight sheet journey log flight hours detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fs_flightsheetno	fin_documentno	Char(40)	No	Flightsheet number	Yes
fs_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
fs_parameter	fin_description	Char(100)	No	Parameter	Yes
fs_batchid	fin_int	Int(4)	No	Batch id	Yes
fs_jlogno	fin_documentno	Char(40)	Yes	Journet log no	No
fs_jlog_ou	fin_ctxt_ouinstance	Int(4)	Yes	Journet log ou	No
fs_jlegno	fin_lineno	Int(4)	Yes	Journet log line no	No
fs_valuesinhrs	fin_quantity	Numeric(28)	Yes	Values in hours	No
fs_valuesindec	fin_quantity	Numeric(28)	Yes	Values in decimals	No


Table Name :	fs_Journey_log_info
Comment :	Flight sheet journey log info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
jl_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
jl_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet no	Yes
jl_loglineno	fin_lineno	Int(4)	No	Log line no	Yes
jl_batchid	fin_unique_id	Bigint(8)	Yes	Batch id	No
jl_journeylog_no	fin_documentno	Char(40)	Yes	Journey log no	No
jl_journeylog_ou	fin_ctxt_ouinstance	Int(4)	Yes	Journey log ou	No
jl_dirflag	fin_int	Int(4)	Yes	Directory flag	No
jl_flight_ops_type	fin_quickcodes	Char(25)	Yes	Flight ops type	No
jl_jl_catgy	fin_quickcodes	Char(25)	Yes	Journey log category	No
jl_flight_catgy	fin_quickcodes	Char(25)	Yes	Flight category	No
jl_amend_flag	fin_flag	Char(25)	Yes	Amend Flag	No
jl_amendment_no	fin_documentno	Char(40)	Yes	Amendment no	No
jl_prev_flightsheet_no	fin_documentno	Char(40)	Yes	Preview flightsheet no	No
jl_billable	fin_designparamcode	Char(5)	Yes	Billable	No
jl_sysbillable	fin_designparamcode	Char(5)	Yes	Sysbillable	No
jl_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
jl_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
jl_created_date	fin_date	Datetime(11)	Yes	Created date	No
jl_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
jl_modified_date	fin_date	Datetime(11)	Yes	Modified date	No


Table Name :	fs_Jrnlog_leg_info
Comment :	Fight sheet journey log leg info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
jll_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Journey log ouinstance	Yes
jll_flightsheet_no	fin_documentno	Char(40)	No	Journey log flightsheet no	Yes
jll_loglineno	fin_lineno	Int(4)	No	Journey log logline no	Yes
jll_leglineno	fin_lineno	Int(4)	No	Journey log leg line no	Yes
jll_batchid	fin_unique_id	Bigint(8)	Yes	Journey log batchid	No
jll_dirflag	fin_int	Int(4)	Yes	Journey log direct flag	No
jll_journeyleg_no	fin_documentno	Char(40)	Yes	Journey log journey legno	No
jll_journeylog_ou	fin_ctxt_ouinstance	Int(4)	Yes	Journey log journet logou	No
jll_sys_billable	fin_designparamcode	Char(5)	Yes	Journey log sys billable	No
jll_billable	fin_designparamcode	Char(5)	Yes	Journey log billable	No
jll_from_datetime	fin_datetime	Datetime(25)	Yes	Journey log from datetime	No
jll_from_timezone	fin_timezone	Char(30)	Yes	Journey log from timezone	No
jll_to_datetime	fin_datetime	Datetime(25)	Yes	Journey log to datetime	No
jll_to_timezone	fin_timezone	Char(30)	Yes	Journey log to timezone	No
jll_departure_station	fin_station	Char(40)	Yes	Journey log departure station	No
jll_arrival_station	fin_station	Char(40)	Yes	Journey log arrival station	No
jll_valueindec	fin_quantity	Numeric(28)	Yes	Journey log value in decimal	No
jll_valueinhrs	fin_description	Char(100)	Yes	Journey log value in hours	No
jll_modvalindec	fin_quantity	Numeric(28)	Yes	Journey log modvalue in decimals	No
jll_modvalinhrs	fin_description	Char(100)	Yes	Journey log modvalue in hours	No
jll_roundoff_value	fin_quantity	Numeric(28)	Yes	Journey log roundoff value	No
jll_takeoff_datetime	fin_datetime	Datetime(25)	Yes	Journey log takeoff datetime	No
jll_landing_datetime	fin_datetime	Datetime(25)	Yes	Journey log landing datetime	No
jll_remarks	fin_notes	Char(2000)	Yes	Journey log remarks	No
jll_modification_notes	fin_notes	Char(2000)	Yes	Journey log modification notes	No
jll_flight_status	fin_status	Char(25)	Yes	Journey log flight status	No
jll_timestamp	fin_timestamp	Int(4)	Yes	Journey log timestamp	No
jll_createdby	fin_ctxt_user	Char(30)	Yes	Journey log created by	No
jll_created_date	fin_date	Datetime(11)	Yes	Journey log created date	No
jll_modifiedby	fin_ctxt_user	Char(30)	Yes	Journey log modified by	No
jll_modified_date	fin_date	Datetime(11)	Yes	Journey log modified date	No
jll_timeref	fin_comments	Char(255)	Yes	Journey log time reference	No
jll_bill_parameter	fin_description	Char(100)	Yes	Journey log bill parameter	No
jll_journeylog_no	fin_documentno	Char(40)	Yes	Journey log journeylog no	No
jll_sourceflag	fin_designparamcode	Char(5)	Yes	Journey log source flag	No
jll_actflag	fin_designparamcode	Char(5)	Yes	Journey log actual flag	No
jll_flight_catgy	fin_quickcodes	Char(25)	Yes	Journey log flight category	No
jll_flight_ops_type	fin_quickcodes	Char(25)	Yes	Journey log flight ops type	No
jll_jl_catgy	fin_quickcodes	Char(25)	Yes	Journey log category	No
jll_prevfsheet_no	fin_documentno	Char(40)	Yes	Journey log preview flight sheet no	No
jll_amend_flag	fin_flag	Char(25)	Yes	Journey log amend flag	No
jll_amend_no	fin_documentno	Char(40)	Yes	Journey log amend no	No
jll_from_utc_datetime	fin_datetime	Datetime(25)	Yes	Journey log from utc datetime	No
jll_from_utc_date	fin_date	Datetime(11)	Yes	Journey log from utc date	No
jll_to_utc_date	fin_date	Datetime(11)	Yes	Journey log to utc date	No
jll_from_utc_time	fin_tatime	Time(11)	Yes	Journey log from utc time	No
jll_to_utc_time	fin_tatime	Time(11)	Yes	Journey log to utc time	No
jll_roundoff_indec	fin_quantity	Numeric(28)	Yes	Journey log round off in decimals	No
jll_roundoff_inhrs	fin_description	Char(100)	Yes	Journey log round off in hours	No
jll_to_utc_datetime	fin_datetime	Datetime(25)	Yes	Journey log to utc datetime	No
jll_indicator_flag	fin_designparamcode	Char(5)	Yes	Journey log indicator flag	No
jll_revised_flag	fin_designparamcode	Char(5)	Yes	Journey log revised flag	No


Table Name :	fs_jrnlog_param_info
Comment :	Flight sheet journey log parameter info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
jbr_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
jbr_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet no	Yes
jbr_loglineno	fin_lineno	Int(4)	No	Log line no	Yes
jbr_flag	fin_flag	Char(25)	No	Flag	No
jbr_batchid	fin_unique_id	Bigint(8)	No	Batch id	Yes
jbr_jl_leg_lineno	fin_lineno	Int(4)	No	Leg lineno	Yes
jbr_remarks	fin_notes	Char(2000)	Yes	Remarks	No
jbr_modcomments	fin_comments	Char(255)	Yes	Modification comments	No
jbr_parameter	fin_description	Char(100)	Yes	Parameter	No
jbr_roundofvalue	fin_quantity	Numeric(28)	Yes	Roundoff value	No
jbr_modvalue	fin_quantity	Numeric(28)	Yes	Modified value	No
jbr_unit	fin_unit	Char(100)	Yes	Unit	No
jbr_value	fin_quantity	Numeric(28)	Yes	Value	No
jbr_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
jbr_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
jbr_created_date	fin_date	Datetime(11)	Yes	Created date	No
jbr_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
jbr_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
jbr_logno	fin_documentno	Char(40)	Yes	Log no	No
jbr_legno	fin_documentno	Char(40)	Yes	Leg no	No
jbr_baseparam	fin_designparamcode	Char(5)	Yes	Base parameter	No
jbr_sourceflag	fin_designparamcode	Char(5)	Yes	Source flag	No
jbr_actflag	fin_designparamcode	Char(5)	Yes	Action flag	No


Table Name :	fs_noflight_info
Comment :	Flight sheet no flight info


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Nfl_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
Nfl_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet no	Yes
Nfl_lineno	fin_lineno	Int(4)	No	Log line no	Yes
Nfl_batchid	fin_unique_id	Bigint(8)	Yes	Batch id	No
Nfl_efb_ref_no	fin_documentno	Char(40)	Yes	efb reference no	No
Nfl_fromdate	fin_date	Datetime(11)	Yes	From date	No
Nfl_fromtime	fin_tatime	Time(11)	Yes	From time	No
Nfl_todate	fin_date	Datetime(11)	Yes	To date	No
Nfl_totime	fin_tatime	Time(11)	Yes	to time	No
Nfl_from_datetime	fin_datetime	Datetime(25)	Yes	From datetime	No
Nfl_from_timezone	fin_timezone	Char(30)	Yes	From Timezone	No
Nfl_to_datetime	fin_datetime	Datetime(25)	Yes	To datetime	No
Nfl_to_timezone	fin_timezone	Char(30)	Yes	To Timezone	No
nfl_fromuctdattime	fin_datetime	Datetime(25)	Yes	From UCTdatetime	No
nfl_touctdatetime	fin_datetime	Datetime(25)	Yes	To UCT datetime	No
Nfl_timezone	fin_timezone	Char(30)	Yes	Timezone	No
Nfl_station	fin_station	Char(40)	Yes	Station	No
Nfl_valueinhrs	fin_description	Char(100)	Yes	Value in hours	No
Nfl_billable	fin_designparamcode	Char(5)	Yes	Billable	No
Nfl_sysbillable	fin_designparamcode	Char(5)	Yes	Sysbillable	No
Nfl_nousage_reasoncode	fin_quickcodes	Char(25)	Yes	No usage reason code	No
Nfl_valueindec	fin_quantity	Numeric(28)	Yes	Value in decimals	No
Nfl_remarks	fin_remarks	Char(100)	Yes	Remarks	No
Nfl_modification_notes	fin_notes	Char(2000)	Yes	Modification comments	No
Nfl_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
Nfl_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
Nfl_created_date	fin_date	Datetime(11)	Yes	Created date	No
Nfl_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
Nfl_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
Nfl_Source_flag	fin_flag	Char(25)	Yes	Source flag	No
Nfl_Act_flag	fin_flag	Char(25)	Yes	Action flag	No
Nfl_roundoff_indec	fin_quantity	Numeric(28)	Yes	Round off in decimals	No
Nfl_roundoff_inhrs	fin_description	Char(100)	Yes	Round off in hours	No


Table Name :	fs_other_claims_dtl
Comment :	Flight sheet other claims detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
oc_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
oc_flightsheet_no	fin_documentno	Char(40)	No	Flight sheet no	Yes
oc_lineno	fin_lineno	Int(4)	No	Log line no	Yes
oc_batchid	fin_unique_id	Bigint(8)	No	Batch id	Yes
oc_date	fin_date	Datetime(11)	Yes	Date	No
oc_charge_code	fin_doctype	Char(40)	Yes	Charge code	No
oc_currency	fin_currency	Char(5)	Yes	Currency	No
oc_unit	fin_uomdesc	Char(100)	Yes	Unit	No
oc_quantity	fin_amount	Numeric(28)	Yes	Quantity	No
oc_amount	fin_amount	Numeric(28)	Yes	Amount	No
oc_remarks	fin_notes	Char(2000)	Yes	Remarks	No
oc_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
oc_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
oc_created_date	fin_date	Datetime(11)	Yes	Created date	No
oc_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
oc_modified_date	fin_date	Datetime(11)	Yes	Modified date	No
oc_actflag	fin_designparamcode	Char(5)	Yes	Action flag	No
oc_sourceflag	fin_designparamcode	Char(5)	Yes	Source flag	No
oc_rate	fin_amount	Numeric(28)	Yes	Rate	No
oc_modifycomment	fin_comments	Char(255)	Yes	Modification comments	No