Data Dictionary -- Flight Log

Srl. No.	Table Name	Comment
1	FLOG_DFDPRSL_DEF_DISC_RESOL	Contains the deferred MR Information with corresponding Aircraft Maintenance Execution(AME) Reference Document #.
2	FLOG_FLACDT_AIRCRAFT_LVL_DTL	Holds details about the last Journey log & Aircraft Maintenance Execution(AME) Reference Document of an Aircraft.
3	FLOG_FLMR_MAT_REQ_DTL	Holds details about Material Requests (MR) generated for Aircraft Maintenance Execution(AME) Reference Documents.
4	FLOG_FLOGQC_QUICK_CODE	Holds user defied Quick Codes related to line maintenance activities.
5	FLOG_FLSYSOP_SYS_OPT_SETTING	Holds various option values set for line maintenance related transactions.
6	FLOG_FLWKDAILY_WU_OPT_SETTING	The details regarding the option setting of the work unit based on the daily flight log gets stored here.
7	FLOG_FODTL_ENG_APU_OILUP_DTL	Holds details of Engine & APU fuel uplift information of an Aircraft.
8	FLOG_FODTL_FUEL_UPLIFT_DTL	Holds details of fuel uplift information of an Aircraft.
9	FLOG_FODTL_OTH_POS_OILUP_DTL	Holds details of fuel uplift information of an Aircraft for positions other than Engine & APU
10	FLOG_FOLOG_FUEL_OIL_HDR	Holds fuel uplift information of an Aircraft.
11	FLOG_FSLEGPASSENGER_DTL	The number of passenger in accordance with the leg during the JL is stored in this table
12	FLOG_JLGAMDA_DOC_ATTACH_DTL	This has the journey log ammend document attached details
13	FLOG_JLGAMSH_AMMEND_SHTDWN	Journey log ammend schedule and ammend shutdown details are get stored in this table
14	FLOG_JLGANDY_JRNLG_ANLY_DLY	FLOG_JLGANDY_JRNLG_ANLY_DLY
15	FLOG_JLGBK_JRNLOG_LOG_BOOK	The details of the log book and its contents on certain journey is get stored in this table
16	FLOG_JLGCPRM_COMP_PARAM_DTL_ECEH	The parameter details of the journey is get stored in this table
17	FLOG_JLGINC_JRNLG_INC_DTL	Journey log increment details is het stored in this table
18	FLOG_JLGLF_JRNLOG_LOG_LEAF	The details given by the pilot regarding the last flight .Clearly the supplementry details and the other parameter details get stored in this table
19	FLOG_JLGMN_JOURNEY_LOG_HDR	Journey log header details are get stored here
20	FLOG_JL_BATCHPROCESS	The scheduler for the last update value based on the journey log created details get stored in this table
21	flog_rbsc_bench_stk_cons_dtl	AME Backflusing detail table
22	FLOG_TLGCOM_TECH_COM_DTL	Holds the details about COM details of a AME package.
23	FLOG_TLGCR_TECH_LOG_CR_DTL	AME Component Replacement detail table
24	FLOG_TLGCR_TECH_LOG_CR_DTL_LOG	AME Component Replacement History detail table
25	FLOG_TLGDA_DOC_ATTACH_DTL	Holds reference documents details associated to AME documents
26	FLOG_TLGDTL_TECH_LOG_DTL	Holds the fuel uplift details defined through AME packages
27	FLOG_TLGEA_EMP_ACTUALS_DTL	Holds the timesheet actual of employess recorded through AME packages.
28	FLOG_TLGEC_EXCOMM_HIST	AME Task Execution Comments history table
29	FLOG_TLGFIN_FINANCE_INFO	Holds finance related information for AME packages
30	Flog_TLgITM_Emp_Idir_Work_Hrs	Holds employee In-direct booking hours details for AME packages
31	FLOG_TLGMN_TECH_LOG_HDR	AME Header table
32	FLOG_TLGOIL_TECHLOG_FUELOIL	Holds information about fuel oil uplift details recorded through AME package
33	FLOG_TLGPC_PART_CONSUMP_DTL	Holds details about AME Part Requests/Consumptions.
34	Flog_TlgPm_Param_Upd_Dtl	Holds parameter value details recorded through AME package
35	FLOG_TLGRC_RES_CONSUMP_DTL	Holds resource consumption details for AME packages.
36	FLOG_TLGSC_SOCOMM_HIST	Holds AME task sign-off comments history
37	FLOG_TLGSKL_COM_SKILL_DTL	Holds the AME - Certificate of Maintenance skill details
38	FLOG_TLGSL_SERIAL_LOT_DTL	Holds preferred Serial/Lot information recorded against AME packages
39	FLOG_TLGSNG_TECH_LOG_SNAG_DTL	Holds the snags/discrepancies recorded through AME package
40	FLOG_TLGSTSO_SUBTSK_SNOFF	Holds the AME sub-task sign-Off information
41	FLOG_TLGTSO_TSK_SNOFF	Holds AME task level sign-off details
42	FLOG_TLGWU_STS_LOG	Holds AME transaction status change log details
43	FLOG_TLGWU_WORK_UNIT_DTL	Holds the list of tasks and its related information which are performed through AME packages
44	FLOG_TLOP_OPERATE_TYP_HDR	Holds master information about different types of flight operations
45	FLOG_WORK_ASSIGN_DTL	Holds employee assignment details of AME packages
46	FL_TLISSRET_ISSUE_DTL	Holds part issues done for AME packages

Table Name :	FLOG_DFDPRSL_DEF_DISC_RESOL
Comment :	Contains the deferred MR Information with corresponding Aircraft Maintenance Execution(AME) Reference Document #.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DFDPRSL_TECHLOG_NO	_VARCHAR_40	varchar(40)	No	Aircraft Maintenance Execution(AME) Reference Document # / Package # reported for an Aircraft through which the reported discrepancy is deferred.	Yes
DFDPRSL_SLFSRC_OUINSTANCE	_DECIMAL_9_0	decimal(9)	No	Organization unit in which the Aircraft Maintenance Execution(AME) Reference Document # / Package # is reported.	Yes
DFDPRSL_MAINT_REPORT_OU	_DECIMAL_9_0	decimal(9)	No	Organization unit in which the Maintenance Report is reported.	Yes
DFDPRSL_MAINT_REPORT_NO	_VARCHAR_40	varchar(40)	No	Maintenance Report #.	Yes
DFDPRSL_RESOL_ACTION	_VARCHAR_5	varchar(5)	Yes	Resolution action taken against the Maintenance Report. For eg: Closed, No Fault Found, Cancel, etc.,	No
DFDPRSL_TASK_NO	_UDD_TASKCODE_30	UDD_TASKCODE(30)	Yes	Task #.	No
CREATED_AREA_CODE	_VARCHAR_40	varchar(40)	Yes	Area code/Location in which the MR document is generated. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FLACDT_AIRCRAFT_LVL_DTL
Comment :	Holds details about the last Journey log & Aircraft Maintenance Execution(AME) Reference Document of an Aircraft.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FLACDT_AIRCRAFT_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organization unit in which the Aircraft is defined.	Yes
FLACDT_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Registration # of the Aircraft.	Yes
FLACDT_LAST_JRNLOG_NO	_varchar_40	varchar(40)	Yes	The last Journey log # reported for this Aircraft.	No
FLACDT_JL_LAST_REPORTED_DTTME	_datetime_8	datetime(8)	Yes	The last Journey log reported date & time.	No
FLACDT_LAST_TECHLOG_NO	_varchar_40	varchar(40)	Yes	The last Aircraft Maintenance Execution(AME) Reference Document # / Package # reported for this Aircraft.	No
FLACDT_TL_LAST_REPORTED_DTTME	_datetime_8	datetime(8)	Yes	The last AME / Package reported date & time.	No
REPLICATION_KEY	_uniqueidentifier_16	uniqueidentifier(16)	Yes	Unique Key value to maintain the uniqueness of Aircraft Information.	No
CREATED_AREA_CODE	_varchar_40	varchar(40)	Yes	Area code/Location in which this Aircraft related information is reported. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FLMR_MAT_REQ_DTL
Comment :	Holds details about Material Requests (MR) generated for Aircraft Maintenance Execution(AME) Reference Documents.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FLMR_PART_KEY_SEQ_NO	bigint	Bigint(8)	Yes	Unique ID of an AME Part Request.	No
FLMR_TASK_TRACK_ID	bigint	Bigint(8)	Yes	Unique ID of an AME Task.	No
FLMR_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organization unit in which the part is requested.	No
FLMR_PART_NO	udd_partno	varchar(40)	Yes	Part requested.	No
FLMR_MR_QTY	udd_quantity	numeric(13)	Yes	Quantity requested.	No
FLMR_MR_UOM	udd_uom	varchar(15)	Yes	Unit of Measurement of the requested part.	No
FLMR_WH_NO	udd_warehouse	varchar(10)	Yes	Warehouse from where the part is requested.	No
FLMR_STOCK_STATUS	udd_flag	varchar(25)	Yes	Stock Status of the requested Part.	No
FLMR_NEWPART_FLAG	udd_designparamcode	varchar(5)	Yes	Part Exist Flag? N - No; Y - Yes. If the part requested is a new part, this flag will be Yes.	No
FLMR_PART_DESC	udd_txt150	varchar(150)	Yes	Description of the requested part.	No
FLMR_REP_CLASS	udd_quickcodes	varchar(25)	Yes	Repair Classification for Material Request	No
FLMR_NEED_FREQ	udd_flag	varchar(25)	Yes	Need Frequency for Part #. A- Always, AR- As Required;	No
FLMR_REQUEST_MODE	udd_flag	varchar(25)	Yes	Part request mode: NRM - Normal, CREQ-Conditional Req., FREQ - Force Req.	No
FLMR_REQUIRED_COND	udd_designparamcode	varchar(5)	Yes	Requested condition of the requested part.	No
FLMR_ALTERNATE_TYPE	udd_flag	varchar(25)	Yes	Part Alternate Type: NHA - NHA, NA - Not Allowed, SA - Specific Alternates.	No
FLMR_ALTERNATE_PART	udd_partno	varchar(40)	Yes	Alternate Part for the requested part	No
FLMR_EFF_NOTES	udd_txt2000	varchar(2000)	Yes	Effectivity Notes for Request Mode - Conditional Req. & Force Req..	No
FLMR_HOLD_CODE	udd_quickcodes	varchar(25)	Yes	Hold Code when the material request is put on hold.	No
FLMR_HOLD_COMMENTS	udd_txt2000	varchar(2000)	Yes	Hold Code Comments when the material request is put on hold.	No
FLMR_MR_NO	udd_documentno	varchar(40)	Yes	Material Request # through which the part is requested	No
FLMR_MR_LINENO	udd_lineno	int(4)	Yes	Material Request line # through which the part is requested	No
FLMR_MR_OU	udd_ctxt_ouinstance	int(4)	Yes	Organization unit in which the Material Request is generated.	No
FLMR_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	User who requested the part.	No
FLMR_CREATED_DATE	udd_datetime1	datetime(8)	Yes	Date & time in which the part request is raised.	No
FLMR_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	User who modified the part request last.	No
FLMR_MODIFIED_DATE	udd_datetime1	datetime(8)	Yes	Date & time in which the part request is modified last.	No
FLMR_SERVICE_NAME	udd_ctxt_service	varchar(32)	Yes	System service through which the part request is raised.	No
FLMR_TIMESTAMP	udd_rowno	int(4)	Yes	Time Stamp for part request. Incremented during modification and used for concurrency check.	No
FLMR_MR_SHCL_QTY	udd_quantity	numeric(13)	Yes	Short Close Quantity of the requested part	No
CREATED_AREA_CODE	_Varchar_40	varchar(40)	Yes	Area code/Location in which the MR document is generated. Applicable only if the application is configured for OFMS operations.	No
FLMR_SOURCE_FLAG	udd_designparamcode	varchar(5)	Yes	Source from where the Material Request is generated. ON - Online OFF - Offline;	No
FLMR_UNIQUE_ID	bigint	Bigint(8)	No	Unique ID helps to track AME Material Requests	Yes
FLMR_BEN_STK_FLAG	udd_designparamcode	varchar(5)	Yes	Bench Stock Flag - NRM - Normal; BF - BackFlushing	No

Table Name :	FLOG_FLOGQC_QUICK_CODE
Comment :	Holds user defied Quick Codes related to line maintenance activities.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FLOGQC_OUINSTANCE	_int_10	int(10)	No	Organization unit in which the quick code is defined.	Yes
FLOGQC_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
FLOGQC_TYPE	_varchar_5	varchar(5)	No	Type of the quick code	Yes
FLOGQC_QUICK_CODE	_varchar_25	Varchar(25)	No	Line maintenance related quick code defined for the corresponding quick code type.	Yes
FLOGQC_DESC	_varchar_80	varchar(80)	Yes	Description of the quick code.	No
FLOGQC_STATUS	_varchar_5	varchar(5)	Yes	Status of the quick code.	No
FLOGQC_CREATED_BY	_varchar_30	varchar(30)	Yes	User who defined the quick code.	No
FLOGQC_CREATEDDATE	_datetime_8	datetime(8)	Yes	Date & Time in which the quick code got defined.	No
FLOGQC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who modified the quick code last.	No
FLOGQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date & Time in which the quick code got modified last.	No
FLOGQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp for quick code. Incremented during modification and used for concurrency check.	No
CREATED_AREA_CODE	_varchar_40	varchar(40)	Yes	Area code/Location in which the quick code is defined. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FLSYSOP_SYS_OPT_SETTING
Comment :	Holds various option values set for line maintenance related transactions.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FLSYSOP_OUINSTANCE	_DECIMAL_10_0	decimal(10)	No	Organization unit in which the values for multiple line maintenance related options are set.	Yes
FLSYSOP_SLFSRC_OUINSTANCE	_DECIMAL_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
FLSYSOP_ALLOW_EXTRA_HOUR	_VARCHAR_5	varchar(5)	Yes	Allow extra hour reporting without authorization.	No
FLSYSOP_APU_OIL_PART_NO	_VARCHAR_40	varchar(40)	Yes	Part # Used For APU Oil uplift.	No
FLSYSOP_APU_OIL_PART_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization unit in which the part used for APU Oil uplift is defined.	No
FLSYSOP_EMP_ARS_VLD	_VARCHAR_5	varchar(5)	Yes	Validate for employee presence as per ARS	No
FLSYSOP_ENGINE_OIL_PART_NO	_VARCHAR_40	varchar(40)	Yes	Part # Used For Engine Oil	No
FLSYSOP_ENGINE_OIL_PART_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization unit in which the part used for Engine Oil uplift is defined.	No
FLSYSOP_FLT_HRS_UPD_BASIS	_VARCHAR_5	varchar(5)	Yes	Basis To Update Engine Flight Hours. Flight Hours / Block Hours.	No
FLSYSOP_FUEL_PART_NO	_VARCHAR_40	varchar(40)	Yes	Part # Used For Fuel.	No
FLSYSOP_FUEL_PART_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization unit in which the part used for Fuel is defined.	No
FLSYSOP_HYD_OIL_PART_NO	_VARCHAR_40	varchar(40)	Yes	Part # Used For Hydraulic Oil.	No
FLSYSOP_HYD_OIL_PART_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization unit in which the part used for Hydraulic Oil is defined.	No
FLSYSOP_OVERTIME_COMP_BASIS	_VARCHAR_5	varchar(5)	Yes	Basis for computing Overtime. Shift Pattern / Standard Rate.	No
FLSYSOP_CANNIB_REASON	_VARCHAR_20	varchar(20)	Yes	Default Reason for Cannibalization.	No
FLSYSOP_TIME_INDICATOR	_VARCHAR_5	varchar(5)	Yes	Time Zone Reference for Log Records: Local/UTC/Destination Station/Starting Station/User Defined.	No
FLSYSOP_PIREP_DISC_NUMTYPE	_VARCHAR_25	Varchar(25)	Yes	Numbering type identified for Pilot reported discrepancies.	No
FLSYSOP_MIREP_DISC_NUMTYPE	_VARCHAR_25	Varchar(25)	Yes	Numbering type identified for Mechanic reported discrepancies.	No
FLSYSOP_MR_NUMTYPE	_VARCHAR_25	Varchar(25)	Yes	Numbering type identified for Maintenance Report	No
FLSYSOP_UTC_TIMEZONE	_VARCHAR_30	varchar(30)	Yes	Time Zone identified as UTC time zone.	No
FLSYSOP_VLD_LOGLEAF	_VARCHAR_5	varchar(5)	Yes	Validate Log leaf #? Yes or No.	No
FLSYSOP_CR_RPLC_NUM_TYPE	_VARCHAR_25	Varchar(25)	Yes	Numbering type identified for replacements.	No
FLSYSOP_CR_CANNIB_NUM_TYPE	_VARCHAR_25	Varchar(25)	Yes	Numbering type identified for Cannibalization/Swap.	No
FLSYSOP_DISC_TRNSF_NUM_TYPE	_VARCHAR_25	Varchar(25)	Yes	Numbering type identified for Discrepancy Transfer.	No
FLSYSOP_VLD_BASIS	_VARCHAR_5	varchar(5)	Yes	Flight Details Validation Basis: Not Required or Assignment or Flight #.	No
FLSYSOP_FUEL_OIL_RPT	_VARCHAR_5	varchar(5)	Yes	Fuel Oil Report	No
FLSYSOP_RPT_DELAY_MOD	_VARCHAR_5	varchar(5)	Yes	Reported Delay Modification: Add new delays or Fully Modifiable or Not allowed.	No
FLSYSOP_VLD_ENT_DLY_DURN	_VARCHAR_5	varchar(5)	Yes	Validate Entered Delay Duration: With Assigned Values or Entered Values or None	No
FLSYSOP_AUTODPCLS_FLAG	_VARCHAR_5	varchar(5)	Yes	Auto DP closure? Yes or No.	No
FLSYSOP_AUTOMRCNF_FLAG	_VARCHAR_5	varchar(5)	Yes	Auto MR confirmation? Yes or No.	No
FLSYSOP_CRT_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization Unit	No
FLSYSOP_ENF_SIGNOFF	_VARCHAR_5	varchar(5)	Yes	Enforce Sign-Off? Yes or No.	No
FLSYSOP_PMTDUAL_SIGNOFF	_VARCHAR_5	varchar(5)	Yes	Permit Dual Sign-off by the employee: Yes or No or Allowed for Flight Ops.	No
FLSYSOP_ENF_CORERET	_VARCHAR_5	varchar(5)	Yes	Enforce Excess/Core Returns? Yes or No.	No
FLSYSOP_EFBJLOG_NUMTYPE	_VARCHAR_20	varchar(20)	Yes	Numbering Type for EFB based Journey Log.	No
FLSYSOP_EFBFLTSHT_NUMTYPE	_VARCHAR_20	varchar(20)	Yes	Numbering Type for EFB based Flight Sheet.	No
FLSYSOP_TM_UPD_MODE	_VARCHAR_5	varchar(5)	Yes	Employee Time Sheet Updation Mode: Clock/Manual/Clock&Manual	No
FLSYSOP_COMPL_FLT_OPN	udd_designparamcode	varchar(5)	Yes	Ref. Date for Complaince against Flight Ops: Start Date/End Date/User Defined	No
FLSYSOP_COMPL_RO	udd_designparamcode	varchar(5)	Yes	Ref. Date for Compliance against Repair Station: Start Date/End Date/User Defined	No
FLSYSOP_SIGNOFF_REQD	udd_designparamcode	varchar(5)	Yes	Sign-off Reqd. for Deferral of Discrepancy? Yes or No.	No
FLSYSOP_COM_REQD	udd_designparamcode	varchar(5)	Yes	CoM Reqd?: Required/Not Required/User Selected.	No
FLSYSOP_PMTERRLOG_CR	udd_designparamcode	varchar(5)	Yes	Permit Error CR? Yes or No	No
FLSYSOP_AUTH_TIMESHEET	udd_designparamcode	varchar(5)	Yes	Authorization of Timesheet Records: Not Required/Required.	No
FLSYSOP_CONF_TIMESHEET	udd_designparamcode	varchar(5)	Yes	Confirmation of Timesheet Records: Not Required/Required.	No
FLSYSOP_ENF_SEQ_REP	udd_designparamcode	varchar(5)	Yes	Enforce Sequential Reporting of Journey Log? Yes or No.	No
LOGLEAF_VALID_BASIS	udd_designparamcode	varchar(5)	Yes	Technical Log level or Discrepancy Level or optional	No
FLSYSOP_PND_WU_ALLOW_BASIS	udd_flag	varchar(25)	Yes	work unit aloow basis set by 0 or 1	No
FLSYSOP_RETR_FCWU_DFRDISCP	udd_metadata_code	varchar(8)	Yes	NULL	No
FLSYSOP_TLOG_CONF	udd_designparamcode	varchar(5)	Yes	Confirmation of AME required or not? Yes or No	No
FLSYSOP_CHK_OILCONS	udd_designparamcode	varchar(5)	Yes	Check Oil Consumption	No
FLSYSOP_ENABLE_PLN_MR	udd_designparamcode	varchar(5)	Yes	Enable Planned MR? Yes or No	No
FLSYSOP_ENF_COMPL_PRECLO_DISCTSK	udd_designparamcode	varchar(5)	Yes	NULL	No
FLSYSOP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp for set options. Incremented during modification and used for concurrency check.	No
FLSYSOP_CREATED_BY	_varchar_30	varchar(30)	Yes	User who set the values for options.	No
FLSYSOP_CREATEDDATE	_datetime_8	datetime(8)	Yes	Date & Time in which the value for options is set.	No
FLSYSOP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who modified the option values last.	No
FLSYSOP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date & Time in which the value for options modified last.	No
CREATED_AREA_CODE	_varchar_40	varchar(40)	Yes	Area code/Location in which the set options are defined. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FLWKDAILY_WU_OPT_SETTING
Comment :	The details regarding the option setting of the work unit based on the daily flight log gets stored here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FLWKDAILY_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU instance	No
FLWKDAILY_MODEL_NO	udd_model	varchar(20)	No	Model number	No
FLWKDAILY_CONF_CLASS	udd_configid	varchar(30)	Yes	configuration class of the FL	No
FLWKDAILY_DAILY_WU	udd_workunitcode	varchar(30)	Yes	flight log work unit detail on daily basis	No
FLWKDAILY_WEEKLY_WU	udd_workunitcode	varchar(30)	Yes	Weekly work unit type	No
FLWKDAILY_DAILY_WUTYPE	udd_designparamcode	varchar(5)	Yes	work unit type on daily basis	No
FLWKDAILY_WEEKLY_WUTYPE	udd_designparamcode	varchar(5)	Yes	Work unit type on weekly basis	No
FLWKDAILY_Daily_LastPerfmDate	udd_datetime	varchar(30)	Yes	Last performed date	No
FLWKDAILY_DlyChk_AlrtDur	udd_schvalue	numeric(13)	Yes	Alert duration schedule value on daily basis	No
FLWKDAILY_DlyChk_Intvl	udd_schvalue	numeric(13)	Yes	Daily checking interval schedule value	No
FLWKDAILY_Wkly_LastPerfmDate	udd_datetime	varchar(30)	Yes	The last performed date on the week	No
FLWKDAILY_WklyChk_AlrtDur	udd_schvalue	numeric(13)	Yes	Alert duration schedule value	No
FLWKDAILY_WklyChk_Intvl	udd_schvalue	numeric(13)	Yes	Weekly cheking interval shedule value	No
replication_key	_uniqueidentifier_16	uniqueidentifier(16)	No	Unique Key value to maintain the uniqueness of Option Setting information.	Yes

Table Name :	FLOG_FODTL_ENG_APU_OILUP_DTL
Comment :	Holds details of Engine & APU fuel uplift information of an Aircraft.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FODTL_SLFSRCOUINSTANCE	ctxt_ouinstance	numeric(9)	No	Organization unit in which the Engine & APU oil uplift is done	Yes
FODTL_FO_LOG_NO	udd_flag2	varchar(25)	No	Fuel uplift transaction log #	Yes
FODTL_POSITIONCODE	udd_positioncode	varchar(25)	No	Position code	Yes
FODTL_POSITION_TYPE	udd_flag	varchar(25)	Yes	Position type	No
FODTL_PARTNO	udd_partno	varchar(40)	Yes	Part # identified for fuel uplift	No
FODTL_ON_ARR_OIL	udd_numericparamval	numeric(13)	Yes	On arrival oil	No
FODTL_UPLIFTED_OIL	udd_numericparamval	numeric(13)	Yes	Uplifted oil	No
FODTL_AT_DEP_OIL	udd_numericparamval	numeric(13)	Yes	At departure oil	No
CREATED_AREA_CODE	_Varchar_40	varchar(40)	Yes	Area code/Location in which the fuel uplift is done. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FODTL_FUEL_UPLIFT_DTL
Comment :	Holds details of fuel uplift information of an Aircraft.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FOdtl_SLFSRCOuinstance	ctxt_ouinstance	numeric(9)	No	Organization unit in which the details of fuel uplift information is recorded.	Yes
FOdtl_FO_Log_no	udd_flag2	varchar(25)	No	Fuel uplift log #	Yes
FOdtl_fuel_type	udd_quickcodes	varchar(25)	Yes	Fuel Type	No
FOdtl_Recpt_no	udd_documentno	varchar(40)	Yes	Receipt #	No
FOdtl_Supplier_no	udd_vendorcode	varchar(45)	Yes	Supplier #	No
FOdtl_Fuel_uplift	udd_numericparamval	numeric(13)	Yes	Fuel uplift details	No
FOdtl_On_Arr_Fuel	udd_numericparamval	numeric(13)	Yes	On Arrival Fuel	No
FOdtl_Before_refuel	udd_numericparamval	numeric(13)	Yes	Measurement before refuel	No
FOdtl_grnd_Cons	udd_numericparamval	numeric(13)	Yes	Ground consumption	No
FOdtl_Aftef_refuel	udd_numericparamval	numeric(13)	Yes	Measurement after refuel	No
FOdtl_Fuel_tran_det	udd_text255	varchar(255)	Yes	Fuel details	No
created_area_code	_Varchar_40	varchar(40)	Yes	Area code/Location in which the fuel uplift details are recorded. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FODTL_OTH_POS_OILUP_DTL
Comment :	Holds details of fuel uplift information of an Aircraft for positions other than Engine & APU

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FODTL_SLFSRCOUINSTANCE	CTXT_OUINSTANCE	numeric(9)	No	Organization unit in which the fuel uplift is done	Yes
FODTL_FO_LOG_NO	UDD_FLAG2	varchar(25)	No	Fuel uplift transaction #	Yes
FODTL_ITEMNUMBER	UDD_CAPTIONS1	varchar(15)	No	Item Number	Yes
FODTL_UOM	UDD_UNITOFMEASUREMENT	varchar(10)	Yes	Unit of measurement for oil uplift	No
FODTL_ON_ARR_OIL	UDD_NUMERICPARAMVAL	numeric(13)	Yes	On Arrival oil	No
FODTL_UPLIFTED_OIL	UDD_NUMERICPARAMVAL	numeric(13)	Yes	Uplifted oil	No
FODTL_AT_DEP_OIL	UDD_NUMERICPARAMVAL	numeric(13)	Yes	At Departure oil	No
CREATED_AREA_CODE	_Varchar_40	varchar(40)	Yes	Area code/Location in which the fuel uplift is done. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FOLOG_FUEL_OIL_HDR
Comment :	Holds fuel uplift information of an Aircraft.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FOLOG_SLFSRCOUINSTANCE	CTXT_OUINSTANCE	numeric(9)	No	Organization unit in which the fuel uplift information is recorded.	Yes
FOLOG_FO_LOG_NO	UDD_FLAG2	varchar(25)	No	Transaction # / Fuel uplift log # for each fuel uplift information	Yes
FOLOG_AIRCRAFT_REG_NO	UDD_AIRCRAFTNUMBER	varchar(30)	Yes	Aircraft Registration # for which the fuel uplift is done	No
FOLOG_REF_DOC_OU	CTXT_OUINSTANCE	numeric(9)	Yes	Organization unit of reference document.	No
FOLOG_REF_DOC_NO	UDD_DOCUMENTNO	varchar(40)	Yes	Reference document #	No
FOLOG_REF_DOC_TYPE	UDD_DESIGNPARAMCODE	varchar(5)	Yes	Type of the reference document	No
FOLOG_WORK_CENTER	UDD_WCCODE	varchar(30)	Yes	Work center	No
FOLOG_EXEC_STATION	UDD_OUCODE	Varchar(32)	Yes	Execution Station	No
FOLOG_UPLIFT_DATETIME	_Datetime_8	datetime(8)	Yes	Fuel uplifted date & time	No
FOLOG_REF_TIME_ZONE	UDD_TIMEZONE	varchar(30)	Yes	Time Zone	No
FOLOG_FLIGHT_NO	UDD_FLTNO	varchar(30)	Yes	Flight #	No
FOLOG_LEAF_NO	UDD_REFDOCNO	varchar(40)	Yes	Log leaf #	No
FOLOG_LEG_NO	UDD_LEGNO	int(4)	Yes	Leg #	No
FOLOG_FILENAME	UDD_FILENAME	varchar(50)	Yes	Reference file name	No
FOLOG_REMARKS	UDD_TXT2000	varchar(2000)	Yes	Remarks	No
FOLOG_ENG_OIL_UOM	UDD_UNITOFMEASUREMENT	varchar(10)	Yes	UOM of Engine Oil	No
FOLOG_APU_OIL_UOM	UDD_UNITOFMEASUREMENT	varchar(10)	Yes	UOM of APU Oil	No
FOLOG_FUEL_UOM	UDD_UNITOFMEASUREMENT	varchar(10)	Yes	UOM of Fuel uplift	No
FOLOG_TIMESTAMP	UDD_TIMESTAMP	int(4)	Yes	Time Stamp	No
FOLOG_CREATED_BY	UDD_CTXT_USER	varchar(30)	Yes	The user who uplifted the oil & recorded the same in the system	No
FOLOG_CREATED_DATE	_Datetime_8	datetime(8)	Yes	The date & time in which the fuel uplift is done	No
FOLOG_MODIFIED_BY	UDD_CTXT_USER	varchar(30)	Yes	The user who modified the uplifted the oil information in the system	No
FOLOG_MODIFIED_DATE	_Datetime_8	datetime(8)	Yes	The date & time in which the fuel uplift information is modified.	No
CREATED_AREA_CODE	_Varchar_40	varchar(40)	Yes	Area code/Location in which the fuel uplift information is recorded. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_FSLEGPASSENGER_DTL
Comment :	The number of passenger in accordance with the leg during the JL is stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FSLEGPASS_OUINSTANCE	int	int(4)	No	ou instance	No
FSLEGPASS_LINE_NO	udd_seqno	int(4)	No	line number	No
FSLEGPASS_FLIGHT_SHEET_NO	varchar	Char(10)	No	flight sheet number	No
FSLEGPASS_AMMEND_NO	varchar	Char(10)	No	ammend number	No
FSLEGPASS_JRNLOG_NO	varchar	Char(10)	No	journey log number	No
FSLEGPASS_LEG_NO	int	int(4)	No	leg number	No
FSLEGPASS_FIRSTNAME	varchar	Char(10)	No	first name of the passenger	No
FSLEGPASS_LASTNAME	varchar	Char(10)	No	last name of the passenger	No
FSLEGPASS_COMPANY	varchar	Char(10)	No	name of the company	No
FSLEGPASS_WEIGHT	int	int(4)	No	Weight	No
FSLEGPASS_BAG_WEIGHT	int	int(4)	No	baggage weight details stored here	No

Table Name :	FLOG_JLGAMDA_DOC_ATTACH_DTL
Comment :	This has the journey log ammend document attached details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGAMDA_CRT_OU	int	int(4)	No	Create organisational unit instance	No
JLGAMDA_SLFSRC_OUINSTANCE	int	int(4)	No	Self source OU instance	No
JLGAMDA_JRNLOG_NO	varchar	Char(10)	No	Journey log number	No
JLGAMDA_AMMEND_NO	varchar	Char(10)	No	Ammend number	No
JLGAMDA_REF_DOC_TYPE	varchar	Char(10)	No	Referel document type	No
JLGAMDA_DOC_ID	varchar	Char(10)	No	Document ID	No
JLGAMDA_FILE_NAME	varchar	Char(10)	No	File name	No
JLGAMDA_REMARKS	varchar	Char(10)	No	Remarks	No

Table Name :	FLOG_JLGAMSH_AMMEND_SHTDWN
Comment :	Journey log ammend schedule and ammend shutdown details are get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGAMSH_JRNLOG_OUINSTANCE	int	int(4)	No	Journey log OU instance	No
JLGAMSH_JRNLOG_NO	varchar	Char(10)	No	Journey log number	No
JLGAMSH_CFG_OUINSTANCE	int	int(4)	No	Configuration OU instance	No
JLGAMSH_AMMEND_NO	varchar	Char(10)	No	ammend number	No
JLGAMSH_POS_CODE	varchar	Char(10)	No	Position Code	No
JLGAMSH_UTC_SHUTDOWN_DATETIME	datetime	Datetime(8)	No	UTC shutdown date	No
JLGAMSH_SHUTDOWN_TYPE	varchar	Char(10)	No	The type of shutdown	No
JLGAMSH_SHUTDOWN_DATETIME	datetime	Datetime(8)	No	Shut down datetime is stored here	No
JLGAMSH_SHUTDOWN_TIMEZONE	varchar	Char(10)	No	Shut down time zone	No
JLGAMSH_RESTART_DATETIME	datetime	Datetime(8)	No	Restart datetime	No
JLGAMSH_UTC_RESTART_DATETIME	datetime	Datetime(8)	No	UTC restart datetime	No
JLGAMSH_RESTART_TIMEZONE	varchar	Char(10)	No	Restart timezone	No
JLGAMSH_SHUTDOWN_REMARKS	varchar	Char(10)	No	Shutdown remarks	No
JLGAMSH_CREATED_BY	varchar	Char(10)	No	created by person name	No
JLGAMSH_CREATEDDATE	datetime	Datetime(8)	No	Created date	No
JLGAMSH_MODIFIED_BY	varchar	Char(10)	No	modified by person name	No
JLGAMSH_MODIFIEDDATE	datetime	Datetime(8)	No	Modified date	No
JLGAMSH_CRT_OU	int	int(4)	No	Create OU	No

Table Name :	FLOG_JLGANDY_JRNLG_ANLY_DLY
Comment :	FLOG_JLGANDY_JRNLG_ANLY_DLY

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGANDY_SLFSRC_OUINSTANCE	int	int(4)	No	Self source OU instance	No
JLGANDY_JRNLOG_NO	varchar	Char(10)	No	Journey log number	No
JLGANDY_DELAY_OU	int	int(4)	No	delay OU	No
JLGANDY_DELAY_NO	varchar	Char(10)	No	Delay sequence number	No
JLGANDY_DELAY_REMARKS	varchar	Char(10)	No	remarks	No
JLGANDY_CREATED_BY	varchar	Char(10)	No	created by person name	No
JLGANDY_DELAY_DAYS	int	int(4)	No	Delay count in days	No
JLGANDY_CREATEDDATE	datetime	Datetime(8)	No	Created date	No
JLGANDY_DELAY_HRS	int	int(4)	No	Delay count in hours	No
JLGANDY_DELAY_MINUTES	int	int(4)	No	Delay count in minutes	No
JLGANDY_MODIFIED_BY	varchar	Char(10)	No	modified by person name	No
JLGANDY_MODIFIEDDATE	datetime	Datetime(8)	No	modified date	No
JLGANDY_TOT_DELAY_INMIN	int	int(4)	No	Total delay in minutes	No
JLGANDY_TIMESTAMP	int	int(4)	No	Timestamp of the current record	No
JLGANDY_CRT_OU	int	int(4)	No	Create oU	No
JLGANDY_ACTION_TAKEN	varchar	Char(10)	No	Action Taken details	No
JLGANDY_DELAY_REASON	varchar	Char(10)	No	Delay reason	No
JLGANDY_ATA_NO	udd_atanumber	varchar(16)	No	ATA NUM	No
JJLGANDY_REPORT_STS	udd_flag2	varchar(25)	No	Report status	No
JLGANDY_JRNLOG_LEGNO	udd_legno	int(4)	No	Journey log legdetails	No
JLGANDY_JRNLOG_LINE_NO	udd_lineno	int(4)	No	line number	No
created_area_code	varchar	Char(10)	No	area code	No

Table Name :	FLOG_JLGBK_JRNLOG_LOG_BOOK
Comment :	The details of the log book and its contents on certain journey is get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGBK_SLFSRC_OUINSTANCE	int	int(4)	No	Self source OU instance	Yes
JLGBK_PART_CRT_OU	int	int(4)	No	ou instance	Yes
JLGBK_PART_NO	varchar	Char(10)	No	part number	Yes
JLGBK_PART_SRL_NO	varchar	Char(10)	No	Serial number	Yes
JLGBK_LOG_BOOK_TYPE	varchar	Char(10)	No	Log book type	Yes
JLGBK_LOG_BOOK_STATUS	varchar	Char(10)	No	staus of the log book	No
JLGBK_LEAF_USG_STATUS	varchar	Char(10)	No	usage status	No
JLGBK_AIRCRAFT_OU	int	int(4)	No	AC OU	No
JLGBK_AIRCRAFT_REG_NO	varchar	Char(10)	No	AC register nnumber	No
JLGBK_FROM_LEAF_NO	varchar	Char(10)	No	from leaf number	No
JLGBK_TO_LEAF_NO	varchar	Char(10)	No	to leaf number	No
JLGBK_LEAF_COUNT	int	int(4)	No	Leaf count	No
JLGBK_ISSUED_BY	varchar	Char(10)	No	Issued by person name	No
JLGBK_ISSUED_DATETIME	datetime	Datetime(8)	No	Datetime of the issue	No
JLGBK_TIMESTAMP	int	int(4)	No	Time stamp of the current record	No
JLGBK_CRT_OU	int	int(4)	No	Create OU	No

Table Name :	FLOG_JLGCPRM_COMP_PARAM_DTL_ECEH
Comment :	The parameter details of the journey is get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGCPRM_CFG_OUINSTANCE	int	int(4)	No	Configuration OuInstance - Generated during Configuration updation	No
JLGCPRM_COMPONENT_OU	int	int(4)	No	component OU	No
JLGCPRM_COMPONENT_ID	varchar	Char(10)	No	Unique id of the component	No
JLGCPRM_JRNLOG_NO	varchar	Char(10)	No	Journey Log NUmber	No
JLGCPRM_SLFSRC_OUINSTANCE	int	int(4)	No	Self source OU instance	No
JLGCPRM_PARAM_CODE	varchar	Char(10)	No	Parameter code	No
JLGCPRM_PARAM_OUINSTANCE	int	int(4)	No	Parameter OUInstance	No
JLGCPRM_PART_NO	varchar	Char(10)	No	Part Number	No
JLGCPRM_PART_OUINSTANCE	int	int(4)	No	Part OU instance	No
JLGCPRM_PART_SERIAL_NO	varchar	Char(10)	No	Part serial number	No
JLGCPRM_POS_CODE	varchar	Char(10)	No	Position code	No
JLGCPRM_POS_TYPE	varchar	Char(10)	No	Position type	No
JLGCPRM_CREATED_BY	varchar	Char(10)	No	created by person name	No
JLGCPRM_CREATEDDATE	datetime	Datetime(8)	No	created date	No
JLGCPRM_MODIFIED_BY	varchar	Char(10)	No	modified by person name	No
JLGCPRM_MODIFIEDDATE	datetime	Datetime(8)	No	Modified date	No
JLGCPRM_PARAM_MANDATORY	varchar	Char(10)	No	Parameter require mandatory value	No
JLGCPRM_UPDATE_MODE	varchar	Char(10)	No	the mode of updation is stored here	No
JLGCPRM_PARAM_TYPE	varchar	Char(10)	No	Parameter type	No
JLGCPRM_PARAM_VALUE	varchar	Char(10)	No	Parameter value for a Task	No
JLGCPRM_CRT_OU	int	int(4)	No	Create OU	No
JLGCPRM_BASE_PRMCODE	varchar	Char(10)	No	Base parameter code	No
JLGCPRM_AMEND_NO	varchar	Char(10)	No	Amend Number	No
created_area_code	varchar	Char(10)	No	AREA code	No

Table Name :	FLOG_JLGINC_JRNLG_INC_DTL
Comment :	Journey log increment details is het stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGINC_SLFSRC_OUINSTANCE	int	int(4)	No	self source OU instance	No
JLGINC_JRNLOG_NO	varchar	Char(10)	No	Journey log number	No
JLGINC_CRT_OU	int	int(4)	No	Create OU	No
JLGINC_INCIDENT_TYPE	varchar	Char(10)	No	Incident type	No
JLGINC_INCIDENT	varchar	Char(10)	No	Incident details is get stored here	No
JLGINC_PILOT_REMARKS	varchar	Char(10)	No	remarks of the pilot	No
JLGINC_CREATED_BY	varchar	Char(10)	No	created by person name	No
JLGINC_CREATED_DATETIME	datetime	Datetime(8)	No	Created datetime	No
JLGINC_MODIFIED_BY	varchar	Char(10)	No	modified by person name	No
JLGINC_MODIFIED_DATETIME	datetime	Datetime(8)	No	Modified datetime	No
created_area_code	varchar	Char(10)	No	Area code	No

Table Name :	FLOG_JLGLF_JRNLOG_LOG_LEAF
Comment :	The details given by the pilot regarding the last flight .Clearly the supplementry details and the other parameter details get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGLF_SLFSRC_OUINSTANCE	int	int(4)	No	self source OU instance	No
JLGLF_PART_NO	varchar	Char(10)	No	part number	No
JLGLF_PART_CRT_OU	int	int(4)	No	Part creation OU	No
JLGLF_PART_SRL_NO	varchar	Char(10)	No	part serial number	No
JLGLF_LEAF_NO	varchar	Char(10)	No	Leaf number	Yes
JLGLF_LEAF_STATUS	varchar	Char(10)	No	Leaf status	No
JLGLF_CRT_OU	int	int(4)	No	Create OU	No

Table Name :	FLOG_JLGMN_JOURNEY_LOG_HDR
Comment :	Journey log header details are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JLGMN_SLFSRC_OUINSTANCE	int	int(4)	No	self source OU instance	Yes
JLGMN_JRNLOG_NO	varchar	Char(10)	No	Journry log number	Yes
JLGMN_FLIGHT_DATE	datetime	Datetime(8)	No	Flight date	No
JLGMN_STARTING_STATION	varchar	Char(10)	No	Startting station	No
JLGMN_AIRCRAFT_OUINSTANCE	int	int(4)	No	AC OU instance	Yes
JLGMN_AIRCRAFT_REG_NO	varchar	Char(10)	No	AC reg number	Yes
JLGMN_JRNLOG_CATEGORY	varchar	Char(10)	No	lourny log category defined in the quick code	No
JLGMN_JRNLOG_STATUS	varchar	Char(10)	No	Status of the journey log	No
JLGMN_JRNLOG_AMENDMENT_NO	int	int(4)	No	ammend number	No
JLGMN_FLIGHT_CATEGORY	varchar	Char(10)	No	flight cateogory	No
JLGMN_REP_TIMEZONE	varchar	Char(10)	No	Timezone	No
JLGMN_AIRCRAFT_MODEL	varchar	Char(10)	No	AC model	No
JLGMN_MFGSRLNO	varchar	Char(10)	No	Manufacturer serial number	No
JLGMN_CONFIG_CLASS	varchar	Char(10)	No	Configuration class	No
JLGMN_LEG_PARAMETER1	varchar	Char(10)	No	The first parameter of the leg.	No
JLGMN_LEG_PARAM1_VAL	varchar	Char(10)	No	value of the parameter 1	No
JLGMN_LEG_PARAM1_UOM	varchar	Char(10)	No	parametr unit of measurement	No
JLGMN_LEG_PARAMETER2	varchar	Char(10)	No	The second parameter of the leg	No
JLGMN_LEG_PARAM2_VAL	varchar	Char(10)	No	value of the parameter 2	No
JLGMN_LEG_PARAM2_UOM	varchar	Char(10)	No	parameter 2 unit of measurement	No
JLGMN_LEG_PARAMETER3	varchar	Char(10)	No	value of the parameter 3	No
JLGMN_LEG_PARAM3_VAL	varchar	Char(10)	No	The third parameter of the leg	No
JLGMN_LEG_PARAM3_UOM	varchar	Char(10)	No	parameter 3 unit of measurement	No
JLGMN_LEG_PARAMETER4	varchar	Char(10)	No	The fourth parameter of the leg.	No
JLGMN_LEG_PARAM4_VAL	varchar	Char(10)	No	value of the parameter 4	No
JLGMN_LEG_PARAM4_UOM	varchar	Char(10)	No	parametr 4 unit of measurement	No
JLGMN_LEG_PARAMETER5	varchar	Char(10)	No	The fifth parameter of the leg.	No
JLGMN_LEG_PARAM5_VAL	varchar	Char(10)	No	value of the parameter 5	No
JLGMN_LEG_PARAM5_UOM	varchar	Char(10)	No	parametr 5th UOM	No
JLGMN_LEG_PARAMETER6	varchar	Char(10)	No	The sixth parameter of the leg.	No
JLGMN_LEG_PARAM6_VAL	varchar	Char(10)	No	value of leg para 6	No
JLGMN_LEG_PARAM6_UOM	varchar	Char(10)	No	parametr 6 unit of measurement	No
JLGMN_PARAM_OUINSTANCE	int	int(4)	No	Parameter OUInstance	No
JLGMN_TOTAL_FLIGHT_HOURS	int	int(4)	No	Total flight hours	No
JLGMN_TOTAL_TAKEOFFS	int	int(4)	No	total take offs	No
JLGMN_FLIGHT_HOURS	int	int(4)	No	Flight hours	No
JLGMN_TAKEOFFS	int	int(4)	No	Take offs	No
JLGMN_TAKEOFFS_UOM	varchar	Char(10)	No	Takeoffs UOM	No
JLGMN_TOTTAKEOFFS_UOM	varchar	Char(10)	No	total takeoffs UOM	No
JLGMN_FLIGHTHOURS_UOM	varchar	Char(10)	No	Flight Hours UOM	No
JLGMN_TOTALFH_UOM	varchar	Char(10)	No	Total flight hours UOM	No
JLGMN_REPORTING_DATETIME	datetime	Datetime(8)	No	Repoting date time	No
JLGMN_UTC_REPORTING_DATETIME	datetime	Datetime(8)	No	Utc reporting date time	No
JLGMN_CREATED_BY	varchar	Char(10)	No	created by person name	No
JLGMN_CREATEDDATE	datetime	Datetime(8)	No	Created date	No
JLGMN_MODIFIED_BY	varchar	Char(10)	No	modified by person name	No
JLGMN_MODIFIEDDATE	datetime	Datetime(8)	No	modified date	No
JLGMN_CONFIRMED_DATE	datetime	Datetime(8)	No	Confirmed date	No
JLGMN_CONFIRMED_BY	varchar	Char(10)	No	Confiemed by person name	No
JLGMN_FILENAME	varchar	Char(10)	No	File name	No
JLGMN_REMARKS	varchar	Char(10)	No	Remarks	No
JLGMN_TIMESTAMP	int	int(4)	No	Timestamp of the current record	No
JLGMN_AMEND_NO	varchar	Char(10)	No	Amend number	Yes
JLGMN_AMDREMARKS	varchar	Char(10)	No	amend remarks	No
JLGMN_CRT_OU	varchar	Char(10)	No	Create OU for journey log maintanance	No
JLGMN_UTC_FLIGHT_DATE	datetime	Datetime(8)	No	UTC Flight Date	No
JLGMN_FLT_OPERATION_TYPE	varchar	Char(10)	No	Flight operation type	No
JLGMN_ENGIN_BLEED	varchar	Char(10)	No	Engineering Bleed	No
JLGMN_PILOT_SREPORT	varchar	Char(10)	No	report from the pilot	No
JLGMN_LANDING_CYCLES	int	int(4)	No	Landing cycles count	No
JLgMn_Block_Hrs	int	int(4)	No	Block hours	No
JLgMn_Last_JLog_Date	datetime	Datetime(8)	No	Last journy log date	No
JLGMN_LAST_JLOGNO	udd_documentno	varchar(40)	No	Last journey log number	No
JLGMN_LAST_JLOG_STATUS	udd_docstatus	varchar(15)	No	Status of the last journey	No
JLGMN_FHLOGMODE	udd_flag	varchar(25)	No	flight hours log mode	No
JLGMN_HMREADING	udd_numericparamval	numeric(13)	No	The reading value in float	No
JLGMN_HMRESET	udd_statusflag	varchar(6)	No	sets y or n based on some condition	No
created_area_code	varchar	Char(10)	No	Area code	No
JLGMN_SOURCE_FLAG	udd_designparamcode	varchar(5)	No	source flag	No
jlgmn_data_trans_flag	udd_designparamcode	varchar(5)	No	data transfer flag	No
JLGMN_LOG_PageNo	udd_model	varchar(20)	Yes	Page No	No

Table Name :	FLOG_JL_BATCHPROCESS
Comment :	The scheduler for the last update value based on the journey log created details get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
JL_OU	udd_ctxt_ouinstance	int(4)	No	OU instance of JL	No
JL_AIRCRAFT	udd_aircraftnumber	varchar(30)	No	Aircraft Number	No
JL_LOG_NO	udd_documentno	varchar(40)	No	Log number	No
JL_UPDATED_FLAG	udd_designparamcode	varchar(5)	No	Updated flag	No
JL_TO_DATE	datetime	Datetime(8)	No	journey log due date	No
JL_COMPID	udd_componentid	varchar(90)	No	component iD	No
created_area_code	varchar	Char(10)	No	created area code	No
JL_CURR_DATE	datetime	Datetime(8)	Yes	System Date	No
JL_UNIQUE	bigint	Bigint(8)	No	Identity Column	No
replication_key	uniqueidentifier	Char(40)	No	Guid	Yes

Table Name :	flog_rbsc_bench_stk_cons_dtl
Comment :	AME Backflusing detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rbsc_ou_instance	udd_ctxt_ouinstance	int(4)	Yes	Organization unit in which the bench stock consumption is done.	No
rbsc_package_no	udd_documentno	varchar(40)	Yes	Package Reference bench stock consumption	No
rbsc_task_no	udd_taskcode	varchar(30)	Yes	Task # against which the bench stock consumption is done.	No
rbsc_tally_no	udd_seqno	int(4)	Yes	Tally #	No
rbsc_part_no	udd_partno	varchar(40)	Yes	Bench stock part consumed	No
rbsc_serial_no	UDD_SERIALNO	varchar(40)	Yes	Serial # of the part	No
rbsc_lot_no	udd_lotno	varchar(18)	Yes	Lot # of the part	No
rbsc_remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
rbsc_warehouse	udd_wccode	varchar(30)	Yes	Warehouse	No
rbsc_stock_stat	udd_flag	varchar(25)	Yes	Stock status	No
rbsc_condition	udd_flag	varchar(25)	Yes	Condition of the part	No
rbsc_zone	udd_zone	varchar(10)	Yes	Warehouse Zone	No
rbsc_bin	udd_bin	varchar(10)	Yes	Warehouse Bin	No
rbsc_mr_no	udd_documentno	varchar(40)	Yes	Material Request # generated for bench stock consumption	No
rbsc_iss_no	udd_documentno	varchar(40)	Yes	Issue # generated for bench stock consumption	No
rbsc_track_id	udd_unique_id	bigint(8)	No	Unique tracking id of the task against which the bench stock consumption is done.	No
rbsc_used_qty	udd_numericparamval	numeric(13)	Yes	Consumed quantity	No
rbsc_rec_status	udd_designparamcode	varchar(5)	Yes	Status	No
rbsc_part_key_seqno	bigint	Bigint(8)	Yes	Unique key which identifies the bench stock consumptions part.	No
rbsc_created_by	udd_ctxt_user	varchar(30)	Yes	The user who has consumed the bench stock part and recorded the details in the system	No
rbsc_created_date	udd_datetime1	datetime(8)	Yes	The date & time in which the bench stock consumption is done	No
rbsc_modified_by	udd_ctxt_user	varchar(30)	Yes	The user who has last modified the bench stock consumption details.	No
rbsc_modified_date	udd_datetime1	datetime(8)	Yes	The date & time in which the bench stock consumption is last modified.	No
rbsc_timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
rbsc_issue_track_id	bigint	Bigint(8)	Yes	Unique ID which associates the bench stock consumption with corresponding Issue transaction.	No
rbsc_mr_track_id	bigint	Bigint(8)	Yes	Unique ID which associates the bench stock consumption with corresponding Material Request transaction.	No
rbsc_key_Seq_no	bigint	Bigint(8)	No	Unique key which uniquely identifies the bench stock consumption across packages.	Yes
rbsc_stock_uom	udd_uom	varchar(15)	Yes	Stock UOM of the consumed part	No
rbsc_part_desc	udd_txt150	varchar(150)	Yes	Part Description	No
rbsc_issue_basis	udd_designparamcode	varchar(5)	Yes	Issue basis of the consumed part	No
rbsc_part_type	udd_designparamcode	varchar(5)	Yes	Type of the consumed part	No
rbsc_uom_desc	udd_uomdesc	varchar(40)	Yes	UOM description	No
rbsc_issueCost	udd_cost	numeric(13)	Yes	Issue cost	No
rbsc_issue_LineNo	udd_seqno	int(4)	Yes	Issue transaction line #	No
rbsc_MR_Priority	udd_flag1	varchar(25)	Yes	MR Priority #	No
rbsc_line_no	udd_seqno	int(4)	Yes	Bench stock transaction line #	No

Table Name :	FLOG_TLGCOM_TECH_COM_DTL
Comment :	Holds the details about COM details of a AME package.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGCOM_SLFSRC_OUINSTANCE	_INT_10	int(10)	No	Organization unit in which the CoM is issued.	Yes
TLGCOM_TECHLOG_NO	_VARCHAR_40	varchar(40)	No	Package # for which the CoM is issued.	Yes
TLGCOM_COM_NO	_VARCHAR_40	varchar(40)	No	Certificate of Maintenance #	Yes
TLGCOM_COM_TYPE	_VARCHAR_5	varchar(5)	Yes	Type of CoM	No
TLGCOM_COM_STATUS	_VARCHAR_5	varchar(5)	Yes	CoM status	No
TLGCOM_USER_STATUS	UDD_QUICKCODES	varchar(25)	Yes	User Status	No
TLGCOM_EMPLOYEE_NO	UDD_EMPCODE	varchar(15)	Yes	Employee who issued the CoM	No
TLGCOM_PRIMARY_SKILL_NO	_VARCHAR_10	varchar(10)	Yes	Primary Skill of the employee who issued the CoM	No
TLGCOM_LICENSE_NO	_VARCHAR_15	varchar(15)	Yes	Licence # of the employee	No
TLGCOM_REMARKS	UDD_TXT255	varchar(255)	Yes	Remarks	No
TLGCOM_COM_DATETIME	_DATETIME_8	datetime(8)	Yes	CoM issued date & time	No
TLGCOM_FILENAME	_VARCHAR_50	varchar(50)	Yes	Name of the file associated with this CoM	No
TLGCOM_COMMENTS	UDD_TXT255	varchar(255)	Yes	Comments	No
TLGCOM_CREATED_DATETIME	_DATETIME_8	datetime(8)	Yes	CoM created date & time	No
TLGCOM_CREATED_BY	UDD_CTXT_USER	varchar(30)	Yes	The user who generated the CoM	No
TLGCOM_MODIFIED_DATETIME	_DATETIME_8	datetime(8)	Yes	Last modified date & time of CoM	No
TLGCOM_MODIFIED_BY	UDD_CTXT_USER	varchar(30)	Yes	The user who last modified the CoM	No
TLGCOM_AUTH_DATETIME	_DATETIME_8	datetime(8)	Yes	CoM authorization date & time	No
TLGCOM_AUTH_BY	UDD_CTXT_USER	varchar(30)	Yes	The user who authorized the CoM	No
TLGCOM_TIMESTAMP	UDD_TIMESTAMP	int(4)	Yes	Time Stamp	No
TLGCOM_CRT_OU	_INT_10	int(10)	Yes	Created Organization Unit	No
CREATED_AREA_CODE	_VARCHAR_40	varchar(40)	Yes	Area code	No

Table Name :	FLOG_TLGCR_TECH_LOG_CR_DTL
Comment :	AME Component Replacement detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGCR_SLFSRC_OUINSTANCE	_Decimal_10_0	decimal(10)	No	AME Component Replacement Self Source Created OUInstance	No
TLGCR_TECHLOG_NO	_Varchar_40	varchar(40)	No	AME Reference # for Component Replacement #	No
TLGCR_SEQ_NO	_Decimal_10_0	decimal(10)	No	Component Replacement Request running number for AME Reference #	No
TLGCR_CRT_OU	_Decimal_10_0	decimal(10)	Yes	AME Component Replacement Created OUInstance	No
TLGCR_REPL_OBJ_TYPE	_Varchar_5	varchar(5)	Yes	Component Replacement Object Type : CMP - Component OP - Other Parts MISC - Miscellaneous	No
TLGCR_CFG_OU	_Decimal_10_0	decimal(10)	Yes	Configuration OuInstance - Generated during Configuration updation	No
TLGCR_LEVEL_NO	_Varchar_150	varchar(150)	Yes	Configuration Level Code for Component Replacement #	No
TLGCR_POS_NO	_Varchar_25	Varchar(25)	Yes	Configuration Position Code for Component Replacement #	No
TLGCR_REASON_FOR_RMVL	_Varchar_20	varchar(20)	Yes	Reason for Removal - Applicable for Remove, Replace, Swap & cannibalize Component Replacement transaction	No
TLGCR_ATA_NO	_Varchar_16	varchar(16)	Yes	ATA Number - Configuration Detail	No
TLGCR_OUTGOING_PART_CRT_OU	_Decimal_10_0	decimal(10)	Yes	Removed Part OuInstance for Component Replacement	No
TLGCR_OUTGOING_PART_NO	_Varchar_40	varchar(40)	Yes	Removed Part # for Component Replacement	No
TLGCR_OUTGOING_PART_SRL_NO	_Varchar_40	varchar(40)	Yes	Removed Serial # for Component Replacement	No
TLGCR_OUTGOING_COMP_OU	_Decimal_10_0	decimal(10)	Yes	Removed Component OU for Component Replacement	No
TLGCR_OUTGOING_COMP_ID	_Varchar_90	varchar(90)	Yes	Removed Component # for Component Replacement	No
TLGCR_REMOVAL_DATETIME	_Datetime_8	datetime(8)	Yes	Component Replacement transaction datetime	No
TLGCR_REPLACED_BY	_Varchar_30	varchar(30)	Yes	Component Replacement transaction Done By	No
TLGCR_OUTGOING_PART_COND	_Varchar_5	varchar(5)	Yes	Removed Condition for Component Replacement	No
TLGCR_EX_AIRCRAFT_REG_OU	_Decimal_10_0	decimal(10)	Yes	Source Aircraft Registration OUInstance updated for "Swap" & "Cannibalize"	No
TLGCR_EX_AIRCRAFT_REG_NO	_Varchar_40	varchar(40)	Yes	Source Aircraft Registration Number updated for "Swap" & "Cannibalize"	No
TLGCR_INCOMING_PART_CRT_OU	_Decimal_10_0	decimal(10)	Yes	Installed Part OuInstance for Component Replacement	No
TLGCR_INCOMING_PART_NO	_Varchar_40	varchar(40)	Yes	Installed Part # for Component Replacement	No
TLGCR_SOURCE	_Varchar_5	varchar(5)	Yes	Source to describe Component Replacement Type : RM - Remove R - Replace A- Attach SW - Swap C - Cannibalize	No
TLGCR_INCOMING_PART_SRL_NO	_Varchar_40	varchar(40)	Yes	Installed Serial # for Component Replacement	No
TLGCR_INCOMING_COMP_OU	_Decimal_10_0	decimal(10)	Yes	Installed Component OUInstance for Component Replacement	No
TLGCR_INCOMING_COMP_ID	_Varchar_90	varchar(90)	Yes	Installed Component # for Component Replacement	No
TLGCR_AC_CR_NO	_Varchar_40	varchar(40)	Yes	Component Replacement #	No
TLGCR_CNB_RMVL_NO	_Varchar_40	varchar(40)	Yes	Component Replacement # - Updated for Swap & cannibalize	No
TLGCR_REMARKS	_Varchar_255	varchar(255)	Yes	Component Replacement Comments	No
TLGCR_TIMESTAMP	_Decimal_10_0	decimal(10)	Yes	TimeStamp Updation for AME Component Replacement transaction	No
TLGCR_EXACRMVL_CFG_OU	_Decimal_10_0	decimal(10)	Yes	Configuration created OU for Swap & Cannibalize	No
TLGCR_EXACRMVL_LEVEL_NO	_Decimal_10_0	decimal(10)	Yes	Configuration Level Code for Swap & Cannibalize	No
TLGCR_EXACRMVL_POS_NO	_Varchar_25	Varchar(25)	Yes	Configuration Position Code for Swap & Cannibalize	No
TLGCR_SERIALNO_TYPE	_Varchar_25	Varchar(25)	Yes	Serial # Type : NEW - New EXIS - Exist	No
TLGCR_OUTGOING_MSN	_Varchar_40	varchar(40)	Yes	Removed Manufacturer Serial Number updated for New removed Serial #	No
TLgCr_Record_Mode	_Varchar_5	varchar(5)	Yes	Record Mode - NW - Normal - WE -	No
TLGCR_PROCESSFLAG	udd_flag	varchar(25)	Yes	Process Flag	No
TLGCR_MATERIAL_COST	udd_amount	numeric(13)	Yes	Material Cost for Component Replacement items	No
tlgcr_basrem_for_reason	udd_txt5	varchar(5)	Yes	Basic Removal : Y - Yes N - No - Attribute for Reason - Applicable for Remove, Replace, Swap & cannibalize Component Replacement transaction	No
tlgcr_remtype_for_reason	udd_txt5	varchar(5)	Yes	Removal Type : S - Scheduled US - Unscheduled O - Others - Attribute for Reason - Applicable for Remove, Replace, Swap & cannibalize Component Replacement transaction	No
TLGCR_RETURN_FLAG	udd_designparamcode	varchar(5)	Yes	Return Flag : N - No Y -Yes - Used for Material Count	No
TLGCR_TASK_NO	udd_documentno	varchar(40)	Yes	Task # for Component Replacement Transaction	No
TLGCR_TASKSEQ_NO	udd_seqno	int(4)	Yes	Task Sequence # for Component Replacement Transaction	No
TLGCR_SOS_DISPOS	udd_designparamcode	varchar(5)	Yes	SOS Disposition details on removal for Unserviceable condition - NA - Not Applicable CF - Confirmed Failure SF - Suspected Failure	No
TLGCR_QUAR_FLAG	udd_designparamcode	varchar(5)	Yes	Quarantine Flag : Y - Yes N - No details on removal for Unserviceable condition	No
TLGCR_SOS_DISPOS_FLAG	udd_designparamcode	varchar(5)	Yes	SOS Disposition Flag : Y - Yes N - No details on removal for Unserviceable condition	No
TLGCR_LEVEL_NUMBER	udd_amount	numeric(13)	Yes	Configuration Level Number	No
TLGCR_EXACRMVL_LEVEL_CODE	udd_cnfglvlcd	varchar(150)	Yes	Source Aircraft Registration Level Code updated for "Swap" & "Cannibalize"	No
TLGCR_EX_COMPONENT	udd_componentid	varchar(90)	Yes	Source Component updated for "Swap" & "Cannibalize"	No
TLGCR_ACCEPTANCEREF	udd_txt255	varchar(255)	Yes	Acceptance Reference for Conditional effectivity Part #	No
TLGCR_ReturnNo	udd_documentno	varchar(40)	Yes	Return # for Removed Item	No
TLGCR_ReturnOu	udd_ctxt_ouinstance	int(4)	Yes	Return OUInstance for Removed Item	No
Tlgcr_autorec_remarks	udd_txt2000	varchar(2000)	Yes	Automatic Reconcile Remarks	No
Tlgcr_autorec_status	udd_designparamcode	varchar(5)	Yes	Automatic Reconcile Status	No
TLGCR_SWO_NO	udd_documentno	varchar(40)	Yes	Shop Work Order Reference #	No
TLGCR_RO_NO	udd_documentno	varchar(40)	Yes	Repair Order Reference #	No
TLGCR_GenOrd_Type	udd_designparamcode	varchar(5)	Yes	Generated Order Type : SWO - Shop Work Order RO - Repair Order	No
TLGCR_Work_center	udd_wccode	varchar(30)	Yes	Work Center reference	No
TLGCR_repair_agency	udd_documentno	varchar(40)	Yes	Repair Agency Reference #	No
TLGCR_remvl_qty	udd_quantity	numeric(13)	Yes	Removal Quantity details	No
TLGCR_Attch_Qty	udd_quantity	numeric(13)	Yes	Attached Quantity details	No
TLGCR_Rem_dispotn	udd_documentno	varchar(40)	Yes	Removal Disposition code details	No
TLGCR_Lot_no	udd_lotno	varchar(18)	Yes	Lot Reference #	No
TLGCR_mfg_Lot_no	udd_lotno	varchar(18)	Yes	Manufacture Lot Number	No
tlgcr_MntReturn_Flag	udd_designparamcode	varchar(5)	Yes	Maintenance Return : N - No Y - Yes	No
TLGCR_CR_return_flag	udd_designparamcode	varchar(5)	Yes	Core Item return flag : N - No Y - Yes	No
TLGCR_scrpnote_docno	udd_documentno	varchar(40)	Yes	Scrap Note Document Reference #	No
TLGCR_scrpnote_lineno	udd_seqno	int(4)	Yes	Scrap Note Document Reference Line #	No
TLGCR_TASK_TRACK_ID	udd_unique_id	bigint(8)	Yes	Task Track Id	No
tlgcr_penretqty	udd_quantity	numeric(13)	Yes	Pending Return Quantity for removal details	No
tlgcr_retqty	udd_quantity	numeric(13)	Yes	Returned Quantity for removal details	No
tlgcr_reconcqty	udd_quantity	numeric(13)	Yes	Manual Reconciled Quantity for removal details	No
tlgcr_reconcremarks	udd_txt2000	varchar(2000)	Yes	Manual Reconciled remarks for removal details	No
tlgcr_retnclass	udd_flag	varchar(25)	Yes	Return Classification for removal details	No
tlgcr_cond	udd_designparamcode	varchar(5)	Yes	Return Condition for removal details	No
tlgcr_certype	udd_flag	varchar(25)	Yes	Certificate Type for returned details	No
tlgcr_certno	udd_documentno	varchar(40)	Yes	Certificate Number for returned details	No
tlgcr_certdate	udd_datetime	varchar(30)	Yes	Certificate Date for returned details	No
tlgcr_expdate	udd_datetime	varchar(30)	Yes	Expired Date for Returned Part #	No
tlgcr_stocksts	udd_documentno	varchar(40)	Yes	Returned Stock Status for removed items	No
tlgcr_retnby	udd_documentno	varchar(40)	Yes	Returned by whom	No
tlgcr_retwhs	udd_documentno	varchar(40)	Yes	Returned Warehouse #	No
created_area_code	_Varchar_40	varchar(40)	Yes	Area Code : Used for OFMS	No
tlgcr_source_flag	udd_designparamcode	varchar(5)	Yes	Source Flag updation based on Usage mode : ON - Online OFF - Offline	No
TLGCR_CR_Unique_id	udd_seqno	int(4)	No	Component Replacement Track Id	Yes
tlgcr_part_type	udd_designparamcode	varchar(5)	Yes	Part type of the removed part	No
tlgcr_part_classify	udd_designparamcode	varchar(5)	Yes	Part classification of the removed part	No
tlgcr_part_ctrl_type	udd_flag	varchar(25)	Yes	Part control type of the removed part	No
tlgcr_expense_type	udd_flag	varchar(25)	Yes	Expense type of the removed part	No
tlgcr_nonstockable_flag	udd_designparamcode	varchar(5)	Yes	Non-stockable flag of the removed part	No
tlgcr_sl_no_logic	udd_designparamcode	varchar(5)	Yes	Serial # generation logic of the removed part	No
tlgcr_sl_no_type_no	udd_designparamcode	varchar(5)	Yes	Numbering type for serial # generation	No
tlgcr_lot_no_type_no	udd_designparamcode	varchar(5)	Yes	Numbering type for lot # generation	No
tlgcr_part_acc_grp	udd_customeraccountgroup	varchar(20)	Yes	Part account group of the removed part	No
tlgcr_part_desc	udd_txt150	varchar(150)	Yes	Part description of the removed part	No
tlgcr_valuation_method	udd_designparamcode	varchar(5)	Yes	Valuation Method of the removed part	No
tlgcr_adj_act_cost	udd_flag	varchar(25)	Yes	Adjusted actual cost of the removed part	No
tlgcr_expensing_policy	udd_designparamcode	varchar(5)	Yes	Expensing policy of the removed part	No
tlgcr_stock_uom	udd_uomcode	varchar(10)	Yes	Stock UOM of the removed part	No
tlgcr_cert_reqd_flag	udd_designparamcode	varchar(5)	Yes	Certification requirement information of the removed part	No
tlgcr_issue_basis	udd_designparamcode	varchar(5)	Yes	Issue basis of the removed part	No
tlgcr_autoissue	udd_designparamcode	varchar(5)	Yes	Indicates whether the attached part is auto issued from stock	No
tlgcr_rtncls	udd_quickcodes	varchar(25)	Yes	Return classification identified for the removed part	No
tlgcr_rtnwarehouse	udd_warehouse	varchar(10)	Yes	Warehouse to which the removed part to be returned	No
tlgcr_rtnzone	udd_zone	varchar(10)	Yes	Zone in the return warehouse identified	No
tlgcr_rtnbin	udd_bin	varchar(10)	Yes	Bin in the return warehouse-zone identified	No

Table Name :	FLOG_TLGCR_TECH_LOG_CR_DTL_LOG
Comment :	AME Component Replacement History detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UPDATED_DATE	_Datetime_8	datetime(8)	No	Component Replacement Log DateTime	Yes
TLGCR_SLFSRC_OUINSTANCE	_Decimal_10_0	decimal(10)	No	AME Component Replacement Self Source Created OUInstance	Yes
TLGCR_TECHLOG_NO	_Varchar_40	varchar(40)	No	AME Reference # for Component Replacement #	Yes
TLGCR_SEQ_NO	_Decimal_10_0	decimal(10)	No	Component Replacement Request running number for AME Reference #	Yes
TLGCR_CRT_OU	_Decimal_10_0	decimal(10)	Yes	AME Component Replacement Created OUInstance	No
TLGCR_REPL_OBJ_TYPE	_Varchar_5	varchar(5)	Yes	Component Replacement Object Type : CMP - Component OP - Other Parts MISC - Miscellaneous	No
TLGCR_CFG_OU	_Decimal_10_0	decimal(10)	Yes	Configuration OuInstance - Generated during Configuration updation	No
TLGCR_LEVEL_NO	_Varchar_150	varchar(150)	Yes	Configuration Level Code for Component Replacement #	No
TLGCR_POS_NO	_Varchar_25	Varchar(25)	Yes	Configuration Position Code for Component Replacement #	No
TLGCR_REASON_FOR_RMVL	_Varchar_20	varchar(20)	Yes	Reason for Removal - Applicable for Remove, Replace, Swap & cannibalize Component Replacement transaction	No
TLGCR_ATA_NO	_Varchar_16	varchar(16)	Yes	ATA Number - Configuration Detail	No
TLGCR_OUTGOING_PART_CRT_OU	_Decimal_10_0	decimal(10)	Yes	Removed Part OuInstance for Component Replacement	No
TLGCR_OUTGOING_PART_NO	_Varchar_40	varchar(40)	Yes	Removed Part # for Component Replacement	No
TLGCR_OUTGOING_PART_SRL_NO	_Varchar_40	varchar(40)	Yes	Removed Serial # for Component Replacement	No
TLGCR_OUTGOING_COMP_OU	_Decimal_10_0	decimal(10)	Yes	Removed Component OU for Component Replacement	No
TLGCR_OUTGOING_COMP_ID	_Varchar_90	varchar(90)	Yes	Removed Component # for Component Replacement	No
TLGCR_REMOVAL_DATETIME	_Datetime_8	datetime(8)	Yes	Component Replacement transaction datetime	No
TLGCR_REPLACED_BY	_Varchar_30	varchar(30)	Yes	Component Replacement transaction Done By	No
TLGCR_OUTGOING_PART_COND	_Varchar_5	varchar(5)	Yes	Removed Condition for Component Replacement	No
TLGCR_EX_AIRCRAFT_REG_OU	_Decimal_10_0	decimal(10)	Yes	Source Aircraft Registration OUInstance updated for "Swap" & "Cannibalize"	No
TLGCR_EX_AIRCRAFT_REG_NO	_Varchar_40	varchar(40)	Yes	Source Aircraft Registration Number updated for "Swap" & "Cannibalize"	No
TLGCR_INCOMING_PART_CRT_OU	_Decimal_10_0	decimal(10)	Yes	Installed Part OuInstance for Component Replacement	No
TLGCR_INCOMING_PART_NO	_Varchar_40	varchar(40)	Yes	Installed Part # for Component Replacement	No
TLGCR_SOURCE	_Varchar_5	varchar(5)	Yes	Source to describe Component Replacement Type : RM - Remove R - Replace A- Attach SW - Swap C - Cannibalize	No
TLGCR_INCOMING_PART_SRL_NO	_Varchar_40	varchar(40)	Yes	Installed Serial # for Component Replacement	No
TLGCR_INCOMING_COMP_OU	_Decimal_10_0	decimal(10)	Yes	Installed Component OUInstance for Component Replacement	No
TLGCR_INCOMING_COMP_ID	_Varchar_90	varchar(90)	Yes	Installed Component # for Component Replacement	No
TLGCR_AC_CR_NO	_Varchar_40	varchar(40)	Yes	Component Replacement #	No
TLGCR_CNB_RMVL_NO	_Varchar_40	varchar(40)	Yes	Component Replacement # - Updated for Swap & cannibalize	No
TLGCR_REMARKS	_Varchar_255	varchar(255)	Yes	Component Replacement Comments	No
TLGCR_TIMESTAMP	_Decimal_10_0	decimal(10)	Yes	TimeStamp Updation for AME Component Replacement transaction	No
TLGCR_EXACRMVL_CFG_OU	_Decimal_10_0	decimal(10)	Yes	Configuration created OU for Swap & Cannibalize	No
TLGCR_EXACRMVL_LEVEL_NO	_Decimal_10_0	decimal(10)	Yes	Configuration Level Code for Swap & Cannibalize	No
TLGCR_EXACRMVL_POS_NO	_Varchar_25	Varchar(25)	Yes	Configuration Position Code for Swap & Cannibalize	No
TLGCR_SERIALNO_TYPE	_Varchar_25	Varchar(25)	Yes	Serial # Type : NEW - New EXIS - Exist	No
TLGCR_OUTGOING_MSN	_Varchar_40	varchar(40)	Yes	Removed Manufacturer Serial Number updated for New removed Serial #	No
TLgCr_Record_Mode	_Varchar_5	varchar(5)	Yes	Record Mode - NW - Normal - WE -	No
TLGCR_PROCESSFLAG	udd_flag	varchar(25)	Yes	Process Flag	No
TLGCR_MATERIAL_COST	udd_amount	numeric(13)	Yes	Material Cost for Component Replacement items	No
tlgcr_basrem_for_reason	udd_txt5	varchar(5)	Yes	Basic Removal : Y - Yes N - No - Attribute for Reason - Applicable for Remove, Replace, Swap & cannibalize Component Replacement transaction	No
tlgcr_remtype_for_reason	udd_txt5	varchar(5)	Yes	Removal Type : S - Scheduled US - Unscheduled O - Others - Attribute for Reason - Applicable for Remove, Replace, Swap & cannibalize Component Replacement transaction	No
TLGCR_RETURN_FLAG	udd_designparamcode	varchar(5)	Yes	Return Flag : N - No Y -Yes - Used for Material Count	No
TLGCR_TASK_NO	udd_documentno	varchar(40)	Yes	Task # for Component Replacement Transaction	No
TLGCR_TASKSEQ_NO	udd_seqno	int(4)	Yes	Task Sequence # for Component Replacement Transaction	No
TLGCR_SOS_DISPOS	udd_designparamcode	varchar(5)	Yes	SOS Disposition details on removal for Unserviceable condition - NA - Not Applicable CF - Confirmed Failure SF - Suspected Failure	No
TLGCR_QUAR_FLAG	udd_designparamcode	varchar(5)	Yes	Quarantine Flag : Y - Yes N - No details on removal for Unserviceable condition	No
TLGCR_SOS_DISPOS_FLAG	udd_designparamcode	varchar(5)	Yes	SOS Disposition Flag : Y - Yes N - No details on removal for Unserviceable condition	No
TLGCR_LEVEL_NUMBER	udd_amount	numeric(13)	Yes	Configuration Level Number	No
TLGCR_EXACRMVL_LEVEL_CODE	udd_cnfglvlcd	varchar(150)	Yes	Source Aircraft Registration Level Code updated for "Swap" & "Cannibalize"	No
TLGCR_EX_COMPONENT	udd_componentid	varchar(90)	Yes	Source Component updated for "Swap" & "Cannibalize"	No
TLGCR_ACCEPTANCEREF	udd_txt255	varchar(255)	Yes	Acceptance Reference for Conditional effectivity Part #	No
TLGCR_ReturnNo	udd_documentno	varchar(40)	Yes	Return # for Removed Item	No
TLGCR_ReturnOu	udd_ctxt_ouinstance	int(4)	Yes	Return OUInstance for Removed Item	No
Tlgcr_autorec_remarks	udd_txt2000	varchar(2000)	Yes	Automatic Reconcile Remarks	No
Tlgcr_autorec_status	udd_designparamcode	varchar(5)	Yes	Automatic Reconcile Status	No
TLGCR_SWO_NO	udd_documentno	varchar(40)	Yes	Shop Work Order Reference #	No
TLGCR_RO_NO	udd_documentno	varchar(40)	Yes	Repair Order Reference #	No
TLGCR_GenOrd_Type	udd_designparamcode	varchar(5)	Yes	Generated Order Type : SWO - Shop Work Order RO - Repair Order	No
TLGCR_Work_center	udd_wccode	varchar(30)	Yes	Work Center reference	No
TLGCR_repair_agency	udd_documentno	varchar(40)	Yes	Repair Agency Reference #	No
TLGCR_remvl_qty	udd_quantity	numeric(13)	Yes	Removal Quantity details	No
TLGCR_Attch_Qty	udd_quantity	numeric(13)	Yes	Attached Quantity details	No
TLGCR_Rem_dispotn	udd_documentno	varchar(40)	Yes	Removal Disposition code details	No
TLGCR_Lot_no	udd_lotno	varchar(18)	Yes	Lot Reference #	No
TLGCR_mfg_Lot_no	udd_lotno	varchar(18)	Yes	Manufacture Lot Number	No
tlgcr_MntReturn_Flag	udd_designparamcode	varchar(5)	Yes	Maintenance Return : N - No Y - Yes	No
TLGCR_CR_return_flag	udd_designparamcode	varchar(5)	Yes	Core Item return flag : N - No Y - Yes	No
TLGCR_scrpnote_docno	udd_documentno	varchar(40)	Yes	Scrap Note Document Reference #	No
TLGCR_scrpnote_lineno	udd_seqno	int(4)	Yes	Scrap Note Document Reference Line #	No
TLGCR_CR_Unique_id	udd_seqno	int(4)	No	Component Replacement Track Id	No
TLGCR_TASK_TRACK_ID	udd_unique_id	bigint(8)	Yes	Task Track Id	No
tlgcr_penretqty	udd_quantity	numeric(13)	Yes	Pending Return Quantity for removal details	No
tlgcr_retqty	udd_quantity	numeric(13)	Yes	Returned Quantity for removal details	No
tlgcr_reconcqty	udd_quantity	numeric(13)	Yes	Manual Reconciled Quantity for removal details	No
tlgcr_reconcremarks	udd_txt2000	varchar(2000)	Yes	Manual Reconciled remarks for removal details	No
tlgcr_retnclass	udd_flag	varchar(25)	Yes	Return Classification for removal details	No
tlgcr_cond	udd_designparamcode	varchar(5)	Yes	Return Condition for removal details	No
tlgcr_certype	udd_flag	varchar(25)	Yes	Certificate Type for returned details	No
tlgcr_certno	udd_documentno	varchar(40)	Yes	Certificate Number for returned details	No
tlgcr_certdate	udd_datetime	varchar(30)	Yes	Certificate Date for returned details	No
tlgcr_expdate	udd_datetime	varchar(30)	Yes	Expired Date for Returned Part #	No
tlgcr_stocksts	udd_documentno	varchar(40)	Yes	Returned Stock Status for removed items	No
tlgcr_retnby	udd_documentno	varchar(40)	Yes	Returned by whom	No
tlgcr_retwhs	udd_documentno	varchar(40)	Yes	Returned Warehouse #	No

Table Name :	FLOG_TLGDA_DOC_ATTACH_DTL
Comment :	Holds reference documents details associated to AME documents

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGDA_CRT_OU	_decimal_10_0	decimal(10)	No	The organization unit in which the reference document details are defined for packages.	No
TLGDA_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
TLGDA_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package # against which the reference documents are associated.	Yes
TLGDA_REF_DOC_TYPE	_varchar_25	Varchar(25)	No	Type of the reference documents	Yes
TLGDA_DOC_ID	_varchar_40	varchar(40)	No	Reference document ID	Yes
TLGDA_FILE_NAME	_varchar_50	varchar(50)	Yes	File name	No
TLGDA_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No

Table Name :	FLOG_TLGDTL_TECH_LOG_DTL
Comment :	Holds the fuel uplift details defined through AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGDTL_SLFSRC_OUINSTANCE	_DECIMAL_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
TLGDTL_TECHLOG_NO	_VARCHAR_40	varchar(40)	No	AME Package # through which the fuel uplift details are recorded.	Yes
TLGDTL_CFG_OUINSTANCE	_DECIMAL_10_0	decimal(10)	No	Organization unit in which the configuration is defined.	No
TLGDTL_POS_CODE	_VARCHAR_25	Varchar(25)	No	Position code against which the fuel oil uplift is done.	Yes
TLGDTL_PART_OUINSTANCE	_DECIMAL_10_0	decimal(10)	No	Organization unit in which the part is defined	No
TLGDTL_PART_NO	_VARCHAR_40	varchar(40)	No	Part for which the fuel uplift is done.	No
TLGDTL_SERIAL_NO	_VARCHAR_40	varchar(40)	No	Serial # of the part	No
TLGDTL_COMPONENT_ID	_VARCHAR_90	varchar(90)	No	Component ID of the part	No
TLGDTL_POS_TYPE	_VARCHAR_25	Varchar(25)	No	Type of the identified position.	No
TLGDTL_CRT_OU	_DECIMAL_10_0	decimal(10)	No	Organization unit in which the fuel uplift is done.	No
TLGDTL_FUEL_ON_ARR	_DECIMAL_28_8	decimal(28)	No	Fuel On Arrival	No
TLGDTL_FUEL_ON_ARR_IN_STKUOM	_DECIMAL_28_8	decimal(28)	No	Fuel On Arrival in Stock UOM	No
TLGDTL_UPLIFTED_OIL	_DECIMAL_28_8	decimal(28)	No	Uplifted Oil	No
TLGDTL_UPLIFTED_OIL_IN_STKUOM	_DECIMAL_28_8	decimal(28)	No	Uplifted Oil in Stock UOM	No
TLGDTL_CREATED_BY	_VARCHAR_30	varchar(30)	No	The user who has defined the fuel uplift information in the system.	No
TLGDTL_ATDEP_OIL	_DECIMAL_28_8	decimal(28)	No	Oil At Departure	No
TLGDTL_ATDEP_OIL_INSTKUOM	_DECIMAL_28_8	decimal(28)	No	Oil At Departure in Stock UOM	No
TLGDTL_CREATEDDATE	_DATETIME_8	datetime(8)	No	The date & time in which the fule uplift is defined.	No
TLGDTL_MODIFIED_BY	_VARCHAR_30	varchar(30)	No	The who last modified the defined fuel oil uplift information.	No
TLGDTL_MODIFIED_DATE	_DATETIME_8	datetime(8)	No	The date & time in which the fule uplift information is last modified.	No
TLGDTL_TIMESTAMP	_DECIMAL_10_0	decimal(10)	No	Timestamp	No
created_area_code	_VARCHAR_40	varchar(40)	No	Area code/Location in which the fuel uplift information is recorded. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGEA_EMP_ACTUALS_DTL
Comment :	Holds the timesheet actual of employess recorded through AME packages.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGEA_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
TLGEA_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Package for which the employee actuals are recorded	Yes
TLGEA_KEY_SEQ_NO	_decimal_10_0	decimal(10)	No	Running sequence # for employee actuals for the corresponding AME package.	Yes
TLGEA_CRT_OU	_decimal_10_0	decimal(10)	Yes	Organization unit in which the employee actual bookings are done.	No
TLGEA_EMP_OU	_decimal_10_0	decimal(10)	Yes	Organization unit in which the employee is defined.	No
TLGEA_EMP_NO	_varchar_20	varchar(20)	Yes	Employee Code	No
TLGEA_ACT_FROM_DATETIME	_datetime_8	datetime(8)	Yes	Actual From DateTime for Time booking	No
TLGEA_ACT_TO_DATETIME	_datetime_8	datetime(8)	Yes	Actual To DateTime for Time booking	No
TLGEA_ACT_DURN_HRS	udd_numericparamval	numeric(13)	Yes	Actual Duration for time booking	No
TLGEA_EMP_COMMENTS	udd_txt2000	varchar(2000)	Yes	Employee comments for time booking	No
TLGEA_CREATED_BY	_varchar_30	varchar(30)	Yes	Time Booking Done By	No
TLGEA_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Time Booking Created DateTime	No
TLGEA_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Time Booking Modified By	No
TLGEA_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Time Booking Modified DateTime	No
TLGEA_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp for time booking details	No
TLGEA_UPDATE_MODE	_varchar_5	varchar(5)	Yes	Update Mode - CLK-Clock MNL - Manual	No
TLGEA_BREAK_HRS	_numeric_28_8	numeric(28)	Yes	Break Hours for Employee for time booking	No
TLGEA_ACT_INDIR_HRS	_numeric_28_8	numeric(28)	Yes	Actual Indirect hours for employee	No
TLGEA_ATTEN_TYPE	udd_flag	varchar(25)	No	Attendance Type - Normal ,Extra Time ,Field Pay,Normal Time,Overtime	No
TLGEA_TMSHT_STATUS	udd_designparamcode	varchar(5)	Yes	Time Sheet Status - AU - Authorized CF - Confirmed FR -Fresh NR - Not Required	No
TLGEA_PRM_SKILL	udd_resourcecode	varchar(40)	Yes	Priamry Skill for Employee	No
TLGEA_TASK_NO	udd_documentno	varchar(40)	Yes	Task Number Reference	No
TLGEA_TASK_SEQ	udd_seqno	int(4)	Yes	Task Sequence Reference #	No
TLGEA_TASK_OU	udd_ctxt_ouinstance	int(4)	Yes	Task OUInstance for Timebooking	No
TLGEA_ACT_RATE	udd_amount	numeric(13)	Yes	Actual Rate for a hour	No
TLGEA_ACT_COST	udd_cost	numeric(13)	Yes	Actual Cost for Employee booked details	No
TLGEA_WC_CODE	udd_wccode	varchar(30)	Yes	Work center details	No
TLGEA_STATION	udd_desc40	varchar(40)	Yes	Station details	No
TLGEA_TILLDATE_TIME	_datetime_8	datetime(8)	Yes	Till DateTime	No
TLGEA_BILLABLE	udd_designparamcode	varchar(5)	Yes	Billable - Accoutable for Invoice	No
TLGEA_UTC_FROM_DATETIME	_datetime_8	datetime(8)	Yes	UTC server datetime for Actual From DateTime	No
TLGEA_UTC_TO_DATETIME	_datetime_8	datetime(8)	Yes	UTC server datetime for Actual To DateTime	No
tlgea_updated_remarks	udd_txt2000	varchar(2000)	Yes	Employee Updated Remarks	No
tlgea_updated_datetime	udd_datetime1	datetime(8)	Yes	Employee Updated DateTime	No
tlgea_updated_by	udd_hrempname	varchar(77)	Yes	Updated By	No
TLGEA_TASK_Track_id	udd_unique_id	bigint(8)	Yes	Task Track #	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the employee actual is recorded. This column is applicable only if the application is configured for OFMS operations.	No
tlgea_cost_center	fin_maccost	varchar(32)	Yes	Cost center for Finance	No
tlgea_booking_id	_bigint_8	Bigint(8)	Yes	Time Booking Track Id	No

Table Name :	FLOG_TLGEC_EXCOMM_HIST
Comment :	AME Task Execution Comments history table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGECH_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	No
TLGECH_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Package for which execution comments are given	No
TLGECH_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	Task Sequence # for which the execution comments are given	No
TLGECH_COMMENTS	_varchar_2000	varchar(2000)	Yes	Execution comments	No
TLGECH_RECORDED_BY	_varchar_30	varchar(30)	Yes	User who recorded the execution comments	No
TLGECH_COMMENTS_DATE	_datetime_8	datetime(8)	No	Comments Entered DateTime	No
TLGECH_COMMENTS_TYPE	_varchar_2000	varchar(2000)	Yes	Comments Type - EXEC - Execution Comments EC - Employee Comments	No
TLGECH_KEY_NO	udd_seqno	int(4)	No	Running Sequence # for execution comments recording.	No
tlgech_trackid	udd_unique_id	bigint(8)	Yes	Unique ID for identification of employee execution comments.	No
TLGECH_WU_Track_id	udd_unique_id	bigint(8)	Yes	Task Track id	No
created_area_code	_uniqueidentifier_16	uniqueidentifier(16)	Yes	Area code/Location in which the execution comment is recorded. This column is applicable only if the application is configured for OFMS operations.	No
REPLICATION_KEY	_varchar_40	varchar(40)	No	Unique Key which uniquely identifies the execution comments details.	Yes

Table Name :	FLOG_TLGFIN_FINANCE_INFO
Comment :	Holds finance related information for AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGFIN_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
TLGFIN_CRT_OU	_decimal_10_0	decimal(10)	No	The organization unit in which the finance information is recorded	No
TLGFIN_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Package # for which the finance information is recorded	Yes
TLGFIN_FIN_BOOK	_varchar_20	varchar(20)	No	Finance Book #	No
TLGFIN_TRAN_TYPE	_varchar_40	varchar(40)	No	Type of the transaction	No
TLGFIN_PARALLEL_BASE_ERATE	udd_amount	numeric(13)	No	Parallel base	No
TLGFIN_CONS_ACC_CODE	_varchar_32	varchar(32)	No	Consumption account code	No
TLGFIN_CONS_CNTACC_TYPE	_varchar_40	varchar(40)	No	Consumption account type	No
TLGFIN_CONS_AUTOPOST_ACCTYPE	_varchar_40	varchar(40)	No	Consumption auto posting account type	No
TLGFIN_CONS_ANLY_CODE	_varchar_5	varchar(5)	No	Consumption analysis code	No
TLGFIN_CONS_SUBANLY_CODE	_varchar_5	varchar(5)	No	Consumption sub-analysis code	No
TLGFIN_CONS_ACC_CURR	_varchar_5	varchar(5)	No	Consumption account currency	No
TLGFIN_MNTADJ_ACC_CODE	_varchar_32	varchar(32)	No	Maintenance Adjustment account code	No
TLGFIN_MNTADJ_CNTACC_TYPE	_varchar_40	varchar(40)	No	Maintenance Adjustment account type	No
TLGFIN_MNTADJ_AUTOPOST_ACCTYPE	_varchar_40	varchar(40)	No	Maintenance Adjustment auto posting account code	No
TLGFIN_MNTADJ_ANLY_CODE	_varchar_5	varchar(5)	No	Maintenance Adjustment analysis code	No
TLGFIN_MNTADJ_SUBANLY_CODE	_varchar_5	varchar(5)	No	Maintenance Adjustment sub-analysis code	No
TLGFIN_MNTADJ_ACC_CURR	_varchar_5	varchar(5)	No	Maintenance Adjustment account currency	No
TLGFIN_MNTSUSP_ACC_CODE	_varchar_32	varchar(32)	No	Maintenance suspense account code	No
TLGFIN_SPRSUSP_ACC_CODE	_varchar_32	varchar(32)	No	Spare suspense account code	No
CREATED_AREA_CODE	_varchar_40	varchar(40)	No	Area code/Location in which the AME package and its finance information is recorded. This column is applicable only if the application is configured for OFMS operations.	No

Table Name :	Flog_TLgITM_Emp_Idir_Work_Hrs
Comment :	Holds employee In-direct booking hours details for AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLgITM_OuInstance	_int_10	int(10)	No	Source organization unit to which the current logged-in organization unit is interacting.	Yes
TLgITM_Employee_No	udd_empcode	varchar(15)	No	Employee who reported the in-direct hours	Yes
TLgITM_Line_No	_int_10	int(10)	No	Running number for indirect hours booking	Yes
TLgITM_Start_DateTime	_datetime_8	datetime(8)	Yes	Start DateTime for indirect hours booking	No
TLgITM_End_DateTime	_datetime_8	datetime(8)	Yes	End DateTime for indirect hours booking	No
TLgITM_Category	_varchar_25	Varchar(25)	Yes	Indirect category : Classroom,Doc Control,Equivalency,ERP,External,T_Classroom	No
TLgITM_Dur_Hours	udd_numericparamval	numeric(13)	Yes	Duration of indirect hours booking	No
TLgITM_Comments	udd_txt2000	varchar(2000)	Yes	Comments recorded by employee	No
TLgITM_Upd_Mode	udd_designparamcode	varchar(5)	Yes	Update Mode : CLK - Clock MNL - Manual	No
TLgiTM_Crt_Ou	_int_10	int(10)	Yes	The organization unit in which the in-direct hours are recorded	No
TLGITM_ATTEN_TYPE	udd_flag	varchar(25)	No	Attendance Type - Normal ,Extra Time ,Field Pay,Normal Time,Overtime	No
TLGITM_TMSHT_STATUS	udd_designparamcode	varchar(5)	Yes	Time Sheet Status - AU - Authorized CF - Confirmed FR -Fresh NR - Not Required	No
TLGITM_PRM_SKILL	udd_resourcecode	varchar(40)	Yes	Primary skill of the employee	No
tlgitm_updated_by	udd_hrempname	varchar(77)	Yes	The user who updated the in-direct hours	No
tlgitm_updated_remarks	udd_txt2000	varchar(2000)	Yes	Remarks provided by the user who updated the in-direct hours booking	No
tlgitm_updated_datetime	udd_datetime1	datetime(8)	Yes	Date & Time at which the in-direct hours booking is updated	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the in-direct hours booking is recorded. This column is applicable only if the application is configured for OFMS operations.	No
TLgITM_Tabooking_id	_bigint_8	Bigint(8)	Yes	In-direct booking reference ID for T&A	No

Table Name :	FLOG_TLGMN_TECH_LOG_HDR
Comment :	AME Header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGMN_TECHLOG_NO	_varchar_40	varchar(40)	No	Aircraft Maintenance Execution(AME) Reference Document # / Package # created for an Aircraft to track the tasks identified to be performed on the Aircraft.	Yes
TLGMN_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit in which the AME / Package # is created.	Yes
TLGMN_TECHLOG_CATEGORY	_varchar_25	Varchar(25)	Yes	Category of AME / Package that is created for an Aircraft.	No
TLGMN_ACT_ARRIVAL_DATETIME	_datetime_8	datetime(8)	Yes	Actual arrival date of the Aircraft to the Line Maintenance Area.	No
TLGMN_AIRCRAFT_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	Organization Unit in which the Aircraft is created.	No
TLGMN_UTC_ACT_ARR_DATETIME	_datetime_8	datetime(8)	Yes	UTC value of actual arrival date of the Aircraft to the Line Maintenance Area.	No
TLGMN_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration # on which the AME Document / Package is created.	No
TLGMN_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	The User who confirmed the AME Document / Package.	No
TLGMN_CONFIRMED_DATE	_datetime_8	datetime(8)	Yes	The date in which the AME Document / Package is confirmed.	No
TLGMN_CREATED_BY	_varchar_30	varchar(30)	Yes	The User who created the AME Document / Package.	No
TLGMN_CREATEDDATE	_datetime_8	datetime(8)	Yes	The date in which the AME Document / Package is created.	No
TLGMN_FIRST_FLIGHT_FLAG	_varchar_5	varchar(5)	Yes	The flag which indicates whether this AME / Package is the first after first journey for the day.	No
TLGMN_FROM_STATION	_varchar_32	varchar(32)	Yes	The station from which the Aircraft is started.	No
TLGMN_JRNLOG_TO_STATION	_varchar_32	varchar(32)	Yes	The station to which the Aircraft is flying from here.	No
TLGMN_GATE_IN_DATETIME	_datetime_8	datetime(8)	Yes	Gate In time of the Aircraft.	No
TLGMN_UTC_GATE_IN_DATETIME	_datetime_8	datetime(8)	Yes	UTC value of Gate In time of the Aircraft.	No
TLGMN_GATE_NO	_varchar_40	varchar(40)	Yes	Gate #	No
TLGMN_ADL_WORK_PERF	_varchar_4000	varchar(4000)	Yes	Additional work performed	No
TLGMN_MECH_COMMENTS	_varchar_255	varchar(255)	Yes	Mechanic comments	No
TLGMN_INSP_EMP_NO	_varchar_20	varchar(20)	Yes	The Inspector who inspected mechanics work	No
TLGMN_INSP_LICENCE_NO	_varchar_15	varchar(15)	Yes	Licence # of the Inspector	No
TLGMN_INSP_COMMENTS	_varchar_255	varchar(255)	Yes	Inspector comments	No
TLGMN_TECHLOG_DTL_1	_varchar_25	Varchar(25)	Yes	Additional details 1	No
TLGMN_TECHLOG_DTL_2	_varchar_25	Varchar(25)	Yes	Additional details 2	No
TLGMN_TECHLOG_DTL_3	_varchar_25	Varchar(25)	Yes	Additional details 3	No
TLGMN_USER_DEFINED_1	_varchar_25	Varchar(25)	Yes	User Defined Details 1	No
TLGMN_USER_DEFINED_2	_varchar_25	Varchar(25)	Yes	User Defined Details 2	No
TLGMN_USER_DEFINED_3	_varchar_25	Varchar(25)	Yes	User Defined Details 3	No
TLGMN_JRNLOG_FLIGHT_NO	_varchar_30	varchar(30)	Yes	Flight # of the Journey Log which is associated with this Package.	No
TLGMN_JRNLOG_LEG_NO	_decimal_10_0	decimal(10)	Yes	Leg # of the Journey Log which is associated with this Package.	No
TLGMN_MECH_LICENSE_NO	_varchar_15	varchar(15)	Yes	Licence # of the Mechanic	No
TLGMN_LOG_LEAF_NO	_varchar_40	varchar(40)	Yes	Log Leaf #	No
TLGMN_MECH_NO	_varchar_20	varchar(20)	Yes	Mechanic who performed the tasks.	No
TLGMN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The user who modified this AME / Package	No
TLGMN_CRT_OU	_decimal_10_0	decimal(10)	Yes	Organization Unit in which the AME / Package is created.	No
TLGMN_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	The date in which the AME / Package is modified	No
TLGMN_OUT_FLIGHT_NO	_varchar_30	varchar(30)	Yes	Flight # of the next journey from the current work station	No
TLGMN_OUT_LEG_NO	_decimal_10_0	decimal(10)	Yes	Leg # of the next journey from the current work station	No
TLGMN_OUT_SCH_DEP_DATETIME	_datetime_8	datetime(8)	Yes	Scheduled departure date & time of the next journey from the current work station	No
TLGMN_OUT_UTC_SCH_DEP_DATETIME	_datetime_8	datetime(8)	Yes	UTC value of scheduled departure date & time of the next journey from the current work station	No
TLGMN_PAPER_DOC_UPD	_varchar_5	varchar(5)	Yes	Flag which indicates whether the paper documents related to this package has been updated or not.	No
TLGMN_RECORDING_STATION	_varchar_32	varchar(32)	Yes	Recording Station of this package	No
TLGMN_REF_JRNLOG_NO	_varchar_40	varchar(40)	Yes	Reference Journey log #	No
TLGMN_REF_JRNLOG_OU	_decimal_10_0	decimal(10)	Yes	Organization unit in which the reference journey log is created	No
TLGMN_RELEASE_COMMENTS	_varchar_255	varchar(255)	Yes	Comments provided during package release	No
TLGMN_RELEASE_STATUS	_varchar_5	varchar(5)	Yes	Release status of the package	No
TLGMN_RELEASED_BY	_varchar_18	varchar(18)	Yes	The user who released the package	No
TLGMN_RELEASED_DATE	_datetime_8	datetime(8)	Yes	The date in which the package got released	No
TLGMN_REPORTING_DATETIME	_datetime_8	datetime(8)	Yes	Reporting date & time of the package	No
TLGMN_REPORTING_STATION	_varchar_32	varchar(32)	Yes	Station in which the package is created	No
TLGMN_TECHLOG_STATUS	_varchar_5	varchar(5)	Yes	Status of the package. Possible values are Draft, Fresh, Released, etc.,	No
TLGMN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Indicates the number of times the package got modified	No
TLGMN_TO_STATION	_varchar_32	varchar(32)	Yes	The station to which the Aircraft is flying from the current location.	No
TLGMN_USER_STATUS	_varchar_25	Varchar(25)	Yes	Status maintained by the user for this AME document	No
TLGMN_UTC_REPORTING_DATETIME	_datetime_8	datetime(8)	Yes	UTC value of reporting date & time of the package	No
TLGMN_FILE_NAME	_varchar_50	varchar(50)	Yes	Name of the file associated to the AME document	No
TLGMN_WORK_CENTER	_varchar_30	varchar(30)	No	Name of the work location in which the tasks identified as part of this AME document is performed	No
TLGMN_MAINTENANCE_EVENT	_varchar_30	varchar(30)	Yes	Maintenance event	No
TLGMN_WORK_CENTER_OU	_decimal_10_0	decimal(10)	No	Organization unit in which the work location is created	No
TLGMN_WORK_TIMESTAMP	_decimal_10_0	decimal(10)	No	Work Timestamp	No
TLGMN_MATERIAL_TIMESTAMP	_decimal_10_0	decimal(10)	No	Material Timestamp	No
TLGMN_CR_TIMESTAMP	_decimal_10_0	decimal(10)	No	CR Timestamp	No
TLGMN_TIMESHEET_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timesheet Timestamp	No
TLGMN_RES_TIMESTAMP	_decimal_10_0	decimal(10)	No	Resource Timestamp	No
TLGMN_LOCAL_TIMEZONE	_varchar_30	varchar(30)	Yes	Timezone in which the work is performed	No
TLGMN_ACTSTART_DTTIME	_datetime_8	datetime(8)	Yes	Date & time in which the mechanic started executing the task identified as part of the AME package.	No
TLGMN_ACTEND_DTTIME	_datetime_8	datetime(8)	Yes	Date & time in which the mechanic completed all the tasks planned as part of the AME document	No
TLGMN_UTC_ACTSTART_DTTIME	_datetime_8	datetime(8)	Yes	UTC value of date & time in which the mechanic started executing the task identified as part of the AME package.	No
TLGMN_UTC_ACTEND_DTTIME	_datetime_8	datetime(8)	Yes	UTC value of date & time in which the mechanic completed all the tasks planned as part of the AME document	No
TLGMN_COM_REQD	_varchar_5	varchar(5)	Yes	Flag which indicates whether Certificate of Maintenance is required for the package or not	No
TLgMn_Start_Station	_varchar_32	varchar(32)	Yes	Starting station	No
Tlgmn_Line_Pack_no	udd_documentno	varchar(40)	Yes	Line package #	No
Tlgmn_Line_Pack_OU	udd_ctxt_ouinstance	int(4)	Yes	Organization unit in which the line package is created	No
TLGMN_TECHLOG_TYPE	udd_designparamcode	varchar(5)	No	Type of the AME document	No
TLGMN_TECHLOG_BASIS	udd_designparamcode	varchar(5)	No	Basis on which the AME document is created	No
TLGMN_EXPENSE_TYPE	udd_designparamcode	varchar(5)	No	Expense Type of AME document	No
TLGMN_REFDOC_TYPE	udd_designparamcode	varchar(5)	No	Type of the Reference document	No
TLGMN_CUSTORDER_NO	udd_documentno	varchar(40)	Yes	Customer Order # related to this AME document	No
TLGMN_MISC_COST	udd_amount	numeric(13)	Yes	Miscelaenious cost incurred to execute the tasks identified as part of this package	No
TLGMN_CAPEXPROPOSAL_NO	udd_documentno	varchar(40)	Yes	CAPEX proposal # of this AME document	No
TLGMN_CUSTORDER_OU	udd_ctxt_ouinstance	int(4)	Yes	Organization unit in which the customer order is created	No
TLGMN_JRNLOG_LINE_NO	udd_seqno	int(4)	Yes	Line # of the journey log if the AME document is created against a JL line.	No
TLGMN_MAT_COST	udd_amount	numeric(13)	Yes	Materials cost incurred to execute the tasks identified as part of this package	No
TLGMN_FAC_COST	udd_amount	numeric(13)	Yes	Facilities cost incurred to execute the tasks identified as part of this package	No
TLGMN_LAB_COST	udd_amount	numeric(13)	Yes	Labour cost incurred to execute the tasks identified as part of this package	No
TLGMN_ROSTER_CODE_FLAG	udd_flag	varchar(25)	Yes	Roster code flag	No
TLGMN_OILCONS_STATUS	udd_status	varchar(25)	Yes	Oil consumption status	No
TLGMN_DAILY_CHECK	_varchar_5	varchar(5)	Yes	Flag which indicates the type of the package	No
TLGMN_WEEKLY_CHECK	_varchar_5	varchar(5)	Yes	Flag which indicates the type of the package1	No
tlgmn_execdoc_type	udd_documenttype	varchar(40)	Yes	Execution document type	No
TLGMN_EXECU_TYPE	udd_documenttype	varchar(40)	Yes	Execution document type1	No
TLGMN_DEF_PRIORITY	udd_optionsettings	varchar(20)	Yes	Priority # of	No
TLGMN_AUTO_RET	udd_designparamcode	varchar(5)	Yes	Flag which indicates Auto Return	No
TLGMN_FB_NO	udd_wccode	varchar(30)	Yes	Finance Book #	No
TLGMN_FB_OU	udd_ctxt_ouinstance	int(4)	Yes	Organization unit in which the Finance Book is created	No
TLGMN_SLOTNO	udd_document	varchar(20)	Yes	Slot #	No
TLGMN_SLOT_StDate	_datetime_8	datetime(8)	Yes	Starting date of the slot	No
TLGMN_SLOT_EnDate	_datetime_8	datetime(8)	Yes	End date of the slot	No
TLGMN_Plan_StDate	_datetime_8	datetime(8)	Yes	Date & time in which the mechanic is planned to start executing the task identified as part of the AME package.	No
TLGMN_Plan_EnDate	_datetime_8	datetime(8)	Yes	Date & time in which the mechanic is planned to complete all the tasks planned as part of the AME document	No
TLGMN_USER_DEF_STATUS	udd_flag	varchar(25)	Yes	User defined status	No
tlgmn_pckg_desc	udd_txt2000	varchar(2000)	Yes	Detailed description of the package	No
tlgmn_repair_proc_code	udd_quickcodes	varchar(25)	Yes	Repair procedure code	No
tlgmn_order_class	udd_designparamcode	varchar(5)	Yes	Order classification	No
tlgmn_repair_class	udd_quickcodes	varchar(25)	Yes	Repair Classification	No
tlgmn_contract_no	udd_documentno	varchar(40)	Yes	Contract # based on which this AME document is created	No
tlgmn_contract_rev_no	udd_seqno	int(4)	Yes	Revision # of the contract	No
tlgmn_contract_eff_code	udd_documentno	varchar(40)	Yes	Contract effectivity code	No
tlgmn_contract_eff_line_no	udd_seqno	int(4)	Yes	Contract effectivity line #	No
tlgmn_est_flag	udd_designparamcode	varchar(5)	Yes	Flag which indicates whether estimation is done for this AME document	No
tlgmn_cus_order_revno	udd_revisionno	varchar(40)	Yes	Revision # of the customer order	No
tlgmn_cust_no	udd_customer_id	varchar(18)	Yes	Customer Order # related to this AME document1	No
tlgmn_operator_code	udd_vendorcode	varchar(45)	Yes	Operator code	No
tlgmn_src_cust_ord	UDD_CustomerorderNo	varchar(40)	Yes	Source customer order #	No
tlgmn_cust_reg_date	udd_datetime1	datetime(8)	Yes	Customer registration date	No
tlgmn_prom_del_date	udd_datetime1	datetime(8)	Yes	Promised delivery date	No
tlgmn_target_date	udd_datetime1	datetime(8)	Yes	Target date of work completion	No
tlgmn_promised_cmp_date	udd_datetime1	datetime(8)	Yes	Promised completion date	No
tlgmn_eventid	udd_txt255	varchar(255)	Yes	Event ID	No
TLGMN_SCH_ARR_DATETIME	udd_datetime1	datetime(8)	Yes	Scheduled arrival time of the flight	No
TLGMN_SCH_DEP_DATETIME	udd_datetime1	datetime(8)	Yes	Scheduled departure time of the flight	No
tlgmn_work_req	udd_txt2000	varchar(2000)	Yes	Work Requested	No
tlgmn_source_flag	udd_designparamcode	varchar(5)	Yes	Source flag	No
TLGMN_cust_warr_req_flag	udd_designparamcode	varchar(5)	Yes	Warranty flag	No
TLGMN_cust_warr_res_flag	udd_designparamcode	varchar(5)	Yes	Warranty flag1	No
TLGMN_cust_warr_notes	udd_txt2000	varchar(2000)	Yes	Warranty notes	No
TLGMN_OPR_TYPE	udd_designparamcode	varchar(5)	Yes	Operations Type	No
TLGMN_OUT_JRNLOG_NO	udd_desc40	varchar(40)	Yes	Reference # of the next journey from this location	No
TLGMN_FLIGHT_CODE	udd_documentno	varchar(40)	Yes	Flight code of the next journey	No
TLGMN_LEG_NO	udd_rowno	int(4)	Yes	Leg # of the next journey from the current work station1	No
TLGMN_SCH_DEP_STATION	fin_maccost	varchar(32)	Yes	Scheduled departure time of the flight from the current location	No
TLGMN_SCH_ARR_STATION	fin_maccost	varchar(32)	Yes	Scheduled arrival time of the flight from the current location	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the AME document is created. Applicable only if the application is configured for OFMS operations.	No
tlgmn_base_source_flag	udd_designparamcode	varchar(5)	Yes	Base Source flag	No
tlgmn_data_trans_flag	udd_designparamcode	varchar(5)	Yes	Flag which indicates whether the details of the AME document has been transferred to main/field base from the area/location in which the AME is created. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGOIL_TECHLOG_FUELOIL
Comment :	Holds information about fuel oil uplift details recorded through AME package

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGOIL_TECHLOG_NO	_VARCHAR_40	varchar(40)	No	AME Package against which the fuel oil uplift details are recorded	Yes
TLGOIL_SLFSRC_OUINSTANCE	_DECIMAL_10_0	decimal(10)	No	The organization unit to which the fuel oil uplifted organization unit is interacting.	Yes
TLGOIL_CRT_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization Unit in which the fuel oil uplift details are recorded	No
TLGOIL_APU_CYCLES	_DECIMAL_28_8	decimal(28)	Yes	APU cycles	No
TLGOIL_APU_HRS	_DECIMAL_28_8	decimal(28)	Yes	APU hours	No
TLGOIL_APU_OIL_UOM	_VARCHAR_10	varchar(10)	Yes	Unit of Measurement of APU oil	No
TLGOIL_FUEL_RCPT_OU	_DECIMAL_10_0	decimal(10)	Yes	Organization unit in which the fuel is received	No
TLGOIL_FUEL_RCPT_NO	_VARCHAR_40	varchar(40)	Yes	Fuel receipt #	No
TLGOIL_ENG_OIL_UOM	_VARCHAR_10	varchar(10)	Yes	Unit of Measurement of Engine oil	No
TLGOIL_FUEL_TRNFR_DTL	_VARCHAR_255	varchar(255)	Yes	Fuel transfer detail	No
TLGOIL_SUP_NO	_VARCHAR_20	varchar(20)	Yes	Fuel supplier #	No
TLGOIL_SUP_OU	_DECIMAL_10_0	decimal(10)	Yes	The organization unit in which the supplier belongs	No
TLGOIL_FUEL_TYPE	_VARCHAR_25	Varchar(25)	Yes	Fuel type	No
TLGOIL_FUEL_UOM	_VARCHAR_10	varchar(10)	Yes	Unit of Measurement of Fuel	No
TLGOIL_HYD_OIL_UOM	_VARCHAR_10	varchar(10)	Yes	Unit of Measurement of Hydralic Oil	No
TLGOIL_REMARKS	_VARCHAR_255	varchar(255)	Yes	Remarks	No
TLGOIL_UPLFT_HYD_OIL_UOM	_VARCHAR_10	varchar(10)	Yes	Unit of Measurement of uplifted Hydralic Oil	No
TLGOIL_GROUND_CONSUMPTION	_DECIMAL_28_8	decimal(28)	Yes	Ground Consumption	No
TLGOIL_GRND_CONS_INSTKUOM	_DECIMAL_28_8	decimal(28)	Yes	Ground Consumption in Stock UOM	No
TLGOIL_ON_ARR_FUEL	_DECIMAL_28_8	decimal(28)	Yes	Fuel on Arrival	No
TLGOIL_ON_ARR_FUEL_INSTKUOM	_DECIMAL_28_8	decimal(28)	Yes	Fuel on Arrival in Stock UOM	No
TLGOIL_FUEL_UPLIFTED	_DECIMAL_28_8	decimal(28)	Yes	Uplifted fuel	No
TLGOIL_FUEL_UPLIFTED_INSTKUOM	_DECIMAL_28_8	decimal(28)	Yes	Uplifted fuel in Stock UOM	No
TLGOIL_BEFORE_REFUEL	_DECIMAL_28_8	decimal(28)	Yes	Measurement before re-fuel	No
TLGOIL_AFTER_REFUEL	_DECIMAL_28_8	decimal(28)	Yes	Measurement after re-fuel	No
TLGOIL_UPLFT_HYD_OIL	_DECIMAL_28_8	decimal(28)	Yes	Uplifted hydralic oil	No
TLGOIL_UPLFT_HYD_OIL_INSTKUOM	_DECIMAL_28_8	decimal(28)	Yes	Uplifted hydralic oil in Stock UOM	No
TLGOIL_FILE_NAME	_VARCHAR_50	varchar(50)	Yes	File Name	No
CREATED_AREA_CODE	_VARCHAR_40	varchar(40)	Yes	Area code/Location in which the fuel oil uplift details are recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGPC_PART_CONSUMP_DTL
Comment :	Holds details about AME Part Requests/Consumptions.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGPC_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit to which the part consumption/request unit is interacting.	No
TLGPC_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package # for which the part request/consumption is recorded.	No
TLGPC_KEY_SEQ_NO2	_bigint_8	Bigint(8)	Yes	Key Sequence #	No
TLGPC_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Request / Consumption recorded organization unit.	No
TLGPC_MR_SOURCE	_varchar_5	varchar(5)	Yes	Source of Material Request	No
TLGPC_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the part is defined.	No
TLGPC_PART_NO	_varchar_40	varchar(40)	Yes	Requested / Consumped part #	No
TLGPC_STOCK_STATUS	_varchar_40	varchar(40)	Yes	Stock status of the part	No
TLGPC_REQD_QTY	_decimal_28_8	decimal(28)	Yes	Required Quantity	No
TLGPC_MATREQ_NO	_varchar_40	varchar(40)	Yes	Material Request #	No
TLGPC_MATREQ_OU	_decimal_10_0	decimal(10)	Yes	Organization unit in which the MR is created	No
TLGPC_MATREQ_LINE_NO	_decimal_10_0	decimal(10)	Yes	Material Request line #	No
TLGPC_CONSMD_QTY	_decimal_28_8	decimal(28)	Yes	Consumed Quantity	No
TLGPC_ISSUED_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the issued part is created.	No
TLGPC_ISSUED_PART_NO	_varchar_40	varchar(40)	Yes	Issued part #	No
TLGPC_ISSUED_QTY	_decimal_28_8	decimal(28)	Yes	Issued quantity	No
TLGPC_MATERIAL_COST	_decimal_28_8	decimal(28)	Yes	Cost of the material	No
TLGPC_SUBSTITUTE_TYPE	_varchar_5	varchar(5)	Yes	Substitute type	No
TLGPC_SUBSTITUTE_PART_NO	_varchar_40	varchar(40)	Yes	Substitute part #	No
TLGPC_SUBS_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the substitute part is created.	No
TLGPC_WAREHOUSE_NO	_varchar_10	varchar(10)	Yes	Warehouse #	No
TLGPC_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the warehouse is created.	No
TLGPC_PEND_RET_QTY	_decimal_28_8	decimal(28)	Yes	Pending Return Quantity	No
TLGPC_PEND_RET_QTY_CORE	_decimal_28_8	decimal(28)	Yes	Pending Return Quantity - Core	No
TLGPC_RET_QTY	_decimal_28_8	decimal(28)	Yes	Returned Quantity	No
TLGPC_CORE_RET_QTY	_decimal_28_8	decimal(28)	Yes	Returned Quantity - Core	No
TlgPc_Reqmnt_Type	_varchar_25	Varchar(25)	Yes	Requirement Type	No
TLGPC_DiscrepancyNo	udd_documentno	varchar(40)	Yes	Discrepancy for which the part is requested/consumed.	No
TLGPC_AVAIL_QTY	_decimal_28_8	decimal(28)	Yes	Available quantity	No
TLGPC_DISCREPANCY_SRCOU	udd_ctxt_ouinstance	int(4)	Yes	The organization unit in which the discrepancy is created	No
TLGPC_TASK_OU	udd_ctxt_ouinstance	int(4)	Yes	The organization unit in which the task is created	No
TLGPC_TASK_NO	udd_workunitcode	varchar(30)	Yes	Task for which the part is requested/consumed.	No
TLGPC_TASK_SEQ	_bigint_8	Bigint(8)	Yes	Sequence # of the task	No
TLGPC_NewPart	udd_designparamcode	varchar(5)	Yes	New part flag	No
TLGPC_NeedFrequency	udd_designparamcode	varchar(5)	Yes	Need frequency	No
TLGPC_MRPriority	udd_flag1	varchar(25)	Yes	MR Priority	No
TLGPC_UOM	udd_unitofmeasurement	varchar(10)	Yes	Unit of Measurement of Part	No
TLGPC_PartDescription	udd_txt150	varchar(150)	Yes	Description of part	No
TLGPC_RECON_QTY	udd_quantity	numeric(13)	Yes	Reconciliation Quantity	No
tlgpc_wcstatus	udd_designparamcode	varchar(5)	Yes	Work Center status	No
TLGPC_CreatedBy	udd_ctxt_user	varchar(30)	Yes	The user who recorded the part request/consumption	No
TLGPC_CreatedDt	_datetime_8	datetime(8)	Yes	The date & time in which the part request/consumption is recorded	No
TLGPC_ModifiedBy	udd_ctxt_user	varchar(30)	Yes	The user who modified the part request/consumption last	No
TLGPC_ModifiedDt	_datetime_8	datetime(8)	Yes	The date & time in which the part request/consumption modified last.	No
TLGPC_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
TLGPC_TmpStamp	udd_timestamp	int(4)	Yes	Indicates the number of times the part request/consumption is modified	No
TLGPC_RECMODE	udd_designparamcode	varchar(5)	Yes	Record Mode	No
TLGPC_EFFFLAG	udd_designparamcode	varchar(5)	Yes	Effectivity flag	No
TLGPC_RECQTL_EXCESS	udd_quantity	numeric(13)	Yes	Reconciliation Quantity - Excess	No
TLGPC_ACTMAT_COST	udd_cost	numeric(13)	Yes	Actual material cost	No
tlgpc_required_for	udd_documentno	varchar(40)	Yes	Part required part	No
tlgpc_std_qty	udd_quantity	numeric(13)	Yes	Standard Quantity	No
tlgpc_est_qty	udd_quantity	numeric(13)	Yes	Estimation Quantity	No
tlgpc_confirmed_qty	udd_quantity	numeric(13)	Yes	Confirmed Quantity	No
tlgpc_mr_qty	udd_quantity	numeric(13)	Yes	MR Quantity	No
tlgpc_rep_class	udd_quickcodes	varchar(25)	Yes	Repair Classification	No
tlgpc_requirment_flag	udd_designparamcode	varchar(5)	Yes	Requirement flag	No
tlgpc_pma_flag	udd_chkflag	varchar(1)	Yes	PMA flag	No
tlgpc_billable_flag	udd_chkflag	varchar(1)	Yes	Billable flag	No
tlgpc_warranty_flag	udd_chkflag	varchar(1)	Yes	Warranty flag	No
tlgpc_est_remarks	udd_txt2000	varchar(2000)	Yes	Estimation remarks	No
tlgpc_curr_rev_no	udd_revisionno	varchar(40)	Yes	Current estimation revision #	No
tlgpc_baseline_rev_no	udd_revisionno	varchar(40)	Yes	Baseline estimation revision #	No
tlgpc_plan_unplan_flag	udd_chkflag	varchar(1)	Yes	Planned / Un-Planned flag	No
tlgpc_effect_notes	udd_txt2000	varchar(2000)	Yes	Effectivity Notes	No
tlgpc_est_done	udd_chkflag	varchar(1)	Yes	Estimation completeness flag	No
TLGPC_TASK_Track_id	_bigint_8	Bigint(8)	Yes	Unique id of the task	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the part request/consumption is recorded. Applicable only if the application is configured for OFMS operations.	No
tlgpc_probability	udd_numericparamval	numeric(13)	Yes	Probability	No
tlgpc_mfr_part_no	udd_partno	varchar(40)	Yes	Manufacturer Part #	No
tlgpc_mfr_no	udd_vendorcode	varchar(45)	Yes	Manufacturer #	No
TLGPC_Spec_Est_flag	udd_chkflag	varchar(1)	Yes	Estimation flag	No
tlgpc_source_flag	udd_designparamcode	varchar(5)	Yes	Source flag	No
TLGPC_KEY_SEQ_NO	_bigint_8	Bigint(8)	No	Unique key which identifies the part request/consumption uniquely	Yes
TLGPC_PART_CONDITION	udd_flag	varchar(25)	Yes	Condition of the part	No

Table Name :	Flog_TlgPm_Param_Upd_Dtl
Comment :	Holds parameter value details recorded through AME package

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGPM_SLFSRC_OUINSTANCE	_numeric_10_0	numeric(10)	No	Self Source OUInstance	Yes
TLGPM_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Reference #	Yes
TLGPM_Wu_seq_no	_numeric_10_0	numeric(10)	No	Task Sequence Number	Yes
TLGPM_Drilldown_seq_No	_numeric_10_0	numeric(10)	No	Drill Down Sequence for a task	Yes
TLGPM_Subtsk_Key_seq_no	_numeric_10_0	numeric(10)	No	Sub Task Sequence number for a task	Yes
TLGPM_Param_code	_varchar_40	varchar(40)	No	Parameter Code for a task	Yes
TLGPM_sub_task_desc	_varchar_2000	varchar(2000)	Yes	Sub Task Description	No
TLGPM_Param_Type	_varchar_18	varchar(18)	Yes	Parameter Type for a Task	No
TLGPM_Param_Value	udd_charparamval	varchar(32)	Yes	Parameter value for a Task	No
TLGPM_Upd_DateTime	_datetime_8	datetime(8)	Yes	Parameter Updated DateTime	No
TLGPM_Param_Mandatory	_varchar_5	varchar(5)	Yes	Parameter Mandatory Flag	No
TLGPM_Remarks	_varchar_200	varchar(200)	Yes	Remarks for Parameter Reading	No
TLGPM_Update_mode	_varchar_15	varchar(15)	Yes	Update Mode	No
TLGPM_Param_Ouinstance	_numeric_10_0	numeric(10)	Yes	Parameter OUInstance	No
TLGPM_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
TLGPM_Modified_Date	_datetime_8	datetime(8)	Yes	Modified DateTime	No
Tlgpm_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
Tlgpm_created_datetime	_datetime_8	datetime(8)	Yes	Created DateTime	No
TLGPM_Wu_Track_id	udd_unique_id	bigint(8)	Yes	Task Track Id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the parameter value is recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGRC_RES_CONSUMP_DTL
Comment :	Holds resource consumption details for AME packages.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGRC_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit to which the resource consumption recorded unit is interacting	Yes
TLGRC_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package for which the resource consumption is recorded	Yes
TLGRC_KEY_SEQ_NO	_decimal_10_0	decimal(10)	No	Unique # which identifies the resource consumption for AME package	Yes
TLGRC_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the resource consumption is recorded	No
TLGRC_RESOURCE_TYPE	_varchar_5	varchar(5)	Yes	Type of the resource	No
TLGRC_RESOURCE_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the consumed resource is defined	No
TLGRC_RESOURCE_NO	_varchar_40	varchar(40)	Yes	Resource #	No
TLGRC_ACT_FROM_DATETIME	_datetime_8	datetime(8)	Yes	Actual resource consumption start time	No
TLGRC_ACT_TO_DATETIME	_datetime_8	datetime(8)	Yes	Actual resource consumption end time	No
TLGRC_ACT_RES_DURN_HRS	_decimal_28_8	decimal(28)	Yes	Actual duration in hours	No
TLGRC_TASK_NO	udd_desc40	varchar(40)	Yes	Task for which the resource consumption is recorded	No
TLGRC_TASK_SEQNO	udd_taskseqno	int(4)	Yes	Sequence # of the task	No
TLGRC_ACT_COST	udd_cost	numeric(13)	Yes	Actual cost for the resources consumed.	No
TLGRC_EST_FROM_DATETIME	_datetime_8	datetime(8)	Yes	Estimated start time	No
TLGRC_EST_TO_DATETIME	_datetime_8	datetime(8)	Yes	Estimated end time	No
TLGRC_EST_DURN_HRS	udd_duration	numeric(13)	Yes	Estimated duration in hours	No
TLGRC_UPMODE_ACT	udd_designparamcode	varchar(5)	Yes	Actual update mode	No
TLGRC_EST_COST	udd_cost	numeric(13)	Yes	Estimated cost	No
TLGRC_UPMODE_EST	udd_designparamcode	varchar(5)	Yes	Estimated update mode	No
TLGRC_ACT_RATE	udd_amount	numeric(13)	Yes	Actual rate	No
TLGRC_TASK_Track_id	udd_unique_id	bigint(8)	Yes	Unique ID of task in AME package	No
TLGRC_FAC_OBJ_CODE	udd_resourcecode	varchar(40)	Yes	Facility object code	No
TLGRC_USED_VALUE	udd_quantity	numeric(13)	Yes	Used value	No
TLGRC_USED_UOM	udd_uom	varchar(15)	Yes	Used UOM	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the resource consumption is recorded. Applicable only if the application is configured for OFMS operations.	No
tlgrc_cost_center	fin_maccost	varchar(32)	Yes	Cost Center	No
TLGRC_rep_class	udd_quickcodes	varchar(25)	Yes	Repair Classification	No
TLGRC_actual_no	udd_quantity	numeric(13)	Yes	Actual resources consumed	No
TLGRC_std_no	udd_quantity	numeric(13)	Yes	Estimated resources	No
TLGRC_req_no	udd_quantity	numeric(13)	Yes	Requested resources	No
tlgrc_plan_unplan_flag	udd_chkflag	varchar(1)	Yes	Planned / Un-Planned flag	No
tlgrc_created_by	udd_ctxt_user	varchar(30)	Yes	The user who recorded the resource consumption	No
tlgrc_created_date	udd_datetime1	datetime(8)	Yes	The date & time in which the resource consumption is recorded	No
tlgrc_modified_by	udd_ctxt_user	varchar(30)	Yes	The user who last modified the resource consumption	No
tlgrc_modified_date	udd_datetime1	datetime(8)	Yes	The date & time in which the resource consumption is last modified	No
tlgrc_timestamp	udd_timestamp	int(4)	Yes	Indicates the number of times the resource consumption got modified	No
tlgrc_std_time	udd_duration	numeric(13)	Yes	Estimated time	No
tlgrc_req_time	udd_duration	numeric(13)	Yes	Requested time	No
tlgrc_actual_time	udd_duration	numeric(13)	Yes	Actual time	No
tlgrc_warranty_flag	udd_chkflag	varchar(1)	Yes	Warranty flag	No
tlgrc_est_time_uom	udd_uom	varchar(15)	Yes	Unit of Measurement of estimated time	No

Table Name :	FLOG_TLGSC_SOCOMM_HIST
Comment :	Holds AME task sign-off comments history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGSCH_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit against which the sign-off comments recorded unit is interacting.	No
TLGSCH_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package # for which the sign-off comments are recorded.	No
TLGSCH_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	Task Sequence Reference #	No
TLGSCH_SUBTSK_SEQ_NO	_varchar_150	varchar(150)	No	Sub Task Sequence Reference #	No
TLGSCH_DRILLDOWN_SEQ_NO	_decimal_10_0	decimal(10)	No	Drill Down Sequence #	No
TLGSCH_SKILL_CODE	_varchar_25	Varchar(25)	Yes	Skill Code	No
TLGSCH_RESOURCE_GRP	_varchar_25	Varchar(25)	Yes	Resource Group	No
TLGSCH_RECORDED_BY	_varchar_30	varchar(30)	No	The user who recorded the sign-off comments	No
TLGSCH_COMMENTS_DATE	_datetime_8	datetime(8)	Yes	The date & time at which the sign-off comments are recorded	No
TLGSCH_COMMENTS_TYPE	_varchar_2000	varchar(2000)	Yes	Type of sign-off comments	No
TLGSCH_SNOFF_FLAG	_varchar_2	varchar(2)	No	Sign- Off Status - SO - Signed-Off V - Void	No
TLGSCH_COMMENTS	_varchar_2000	varchar(2000)	Yes	Sign-off comments	No
TLGSCH_KEY_NO	udd_seqno	int(4)	No	Running sequence #	No
TLGSCH_WU_Track_id	udd_unique_id	bigint(8)	Yes	Task Track Id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the sign-off comments are recorded. Applicable only if the application is configured for OFMS operations.	No
replication_key	_uniqueidentifier_16	uniqueidentifier(16)	No	The unique id which uniquely identifies the sign-off comments	Yes

Table Name :	FLOG_TLGSKL_COM_SKILL_DTL
Comment :	Holds the AME - Certificate of Maintenance skill details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGSKL_SLFSRC_OUINSTANCE	_int_10	int(10)	No	The main organization unit which interacts with the logged-in unit	Yes
TLGSKL_TECHLOG_NO	udd_documentno	varchar(40)	No	AME package #	Yes
TLGSKL_COM_NO	udd_documentno	varchar(40)	No	Certificate of Maintenance #	Yes
TLGSKL_EMPLOYEE_NO	udd_empcode	varchar(15)	No	Employee #	Yes
TLGSKL_CRT_OU	_int_10	int(10)	No	Created organization unit	No
TLGSKL_SKILL_NO	_varchar_10	varchar(10)	Yes	Skill code	No
TLGSKL_LICENSE_NO	_varchar_15	varchar(15)	Yes	License #	No
TLGSKL_REMARKS	udd_txt255	varchar(255)	Yes	Remarks	No
CREATED_AREA_CODE	_varchar_40	varchar(40)	Yes	Area code/Location in which the COM skill details are recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGSL_SERIAL_LOT_DTL
Comment :	Holds preferred Serial/Lot information recorded against AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGSL_SLFSRC_OUINSTANCE	_int_10	int(10)	No	The organization unit in which the preferred serial/lot details are recorded	Yes
TLGSL_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package # for which the preferred serial/lot details are recorded	Yes
TLGSL_PART_KEY_SEQ_NO	_int_10	int(10)	No	Unique ID which uniquely identifies the part request raised against the corresponding AME package	Yes
TLGSL_SL_KEY_SEQ_NO	_int_10	int(10)	No	Unique ID which uniquely identifies the preferred serial/lot details raised against the corresponding AME package	Yes
TLGSL_SL_DISP_SEQ_NO	_int_10	int(10)	No	Display sequence # of the preferred serial / lot request	No
TLGSL_SERIAL_NO	_varchar_40	varchar(40)	Yes	Preferred serial # requested	No
TLGSL_LOT_NO	_varchar_18	varchar(18)	Yes	Preferred lot # requested	No
TLGSL_QUANTITY	_numeric_28_8	numeric(28)	Yes	Quantity requested	No
TLGSL_CREATED_BY	_varchar_30	varchar(30)	Yes	The user who raised the preferred serial/lot request	No
TLGSL_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date & time at which the preferred serial/lot request is recorded	No
TLGSL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The user who modified the preferred serial/lot request last	No
TLGSL_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date & time at which the preferred serial/lot request is modified last	No
TLGSL_MR_Quantity	udd_quantity	numeric(13)	Yes	Material Request quantity	No
TLGSL_Task_Track_id	udd_rowno	int(4)	Yes	Task Track Id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the preferred serial/lot is recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGSNG_TECH_LOG_SNAG_DTL
Comment :	Holds the snags/discrepancies recorded through AME package

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGSNG_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit in which the snag/discrepancy details are recorded	Yes
TLGSNG_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Package through which the discrepancy is recorded	Yes
TLGSNG_DISCREPANCY_NO	_varchar_40	varchar(40)	No	Discrepancy #	Yes
TLGSNG_DISCREPANCY_OU	_decimal_10_0	decimal(10)	No	The organization unit in which the snag/discrepancy is defined	No
TLGSNG_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the discrepancy details are recorded	No
TLGSNG_ACTION	_varchar_15	varchar(15)	Yes	Action identified to resolve the discrepancy	No
TLGSNG_CREATED_BY	_varchar_30	varchar(30)	Yes	The user who created the discrepancy	No
TLGSNG_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date & time at which the discrepancy is recorded	No
TLGSNG_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The user who modified the discrepancy last	No
TLGSNG_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date & time at which the discrepancy is last modified	No
TLGSNG_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Indicates the number of times the discrepancy got modified	No
TLgSng_Task_No	_varchar_40	varchar(40)	Yes	Task # reference for Discrepancy	No
TLGSNG_LOG_LEAF_NO	udd_refdocno	varchar(40)	Yes	Log Leaf Number	No
TLGSNG_SIGNOFF_REQT	udd_designparamcode	varchar(5)	Yes	Sign- Off Requirement Flag	No
TLgSng_Task_Track_id	udd_unique_id	bigint(8)	Yes	Task Track Id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the discrepancy is recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGSTSO_SUBTSK_SNOFF
Comment :	Holds the AME sub-task sign-Off information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGSTSO_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit in which the sub-task sign-off information is recorded	Yes
TLGSTSO_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package for which the sub-task sign-off information is recorded	Yes
TLGSTSO_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	The sequence # which uniquely identifies the task in the corresponding AME package	Yes
TLGSTSO_DRILLDOWN_SEQ_NO	_decimal_10_0	decimal(10)	No	Drill down sequence #	Yes
TLGSTSO_SUBTSK_SEQ_NO	_varchar_150	varchar(150)	No	Sub task sequence #	Yes
TLGSTSO_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the sign-off information is recorded	No
TLGSTSO_SUB_TASK_DESC	_varchar_2000	varchar(2000)	Yes	Sub task description	No
TLGSTSO_SKILL_CODE	_varchar_25	Varchar(25)	Yes	Skill code	No
TLGSTSO_RESOURCE_GRP	_varchar_25	Varchar(25)	Yes	Resource group	No
TLGSTSO_OTHER_SNOFF_INFO	_varchar_5	varchar(5)	Yes	Other sign-off information	No
TLGSTSO_EMP_NO	_varchar_20	varchar(20)	Yes	Employee code	No
TLGSTSO_LAST_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The user who last modified the sign-off information	No
TLGSTSO_LAST_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	The date & time at which the sign-off information is last modified	No
TLGSTSO_DISC_REP_FLAG	_varchar_5	varchar(5)	Yes	Discrepancy flag	No
TLGSTSO_SIGN_OFF_COMMENTS	_varchar_2000	varchar(2000)	Yes	Sign-off comments	No
TLGSTSO_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Indicates the number of times the sign-off information got modified	No
TLGSTSO_RECORDED_BY	_varchar_30	varchar(30)	Yes	The user who recorded the sign-off details	No
tlgstso_sgnoffsource	udd_flag	varchar(25)	Yes	Source of sign-off	No
TLGSTSO_WU_Track_id	udd_unique_id	bigint(8)	Yes	Task track id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the sign-off infromation is recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGTSO_TSK_SNOFF
Comment :	Holds AME task level sign-off details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGTSO_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit in which the task level sign-off information is recorded	Yes
TLGTSO_TECHLOG_NO	_varchar_40	varchar(40)	No	AME package for which the task level sign-off information is recorded	Yes
TLGTSO_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	Unique sequence # which identifies the task in AME package	Yes
TLGTSO_DRILLDOWN_SEQ_NO	_decimal_10_0	decimal(10)	No	Unique sequence # which identifies the sign-off details in AME package	Yes
TLGTSO_CRT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the task level sign-off information is recorded.	No
TLGTSO_WORK_PACKAGE_NO	_varchar_40	varchar(40)	Yes	Work package #. No longer used in the application.	No
TLGTSO_STD_PROC_NO	_varchar_40	varchar(40)	Yes	Standard Procedure #. No longer used in the application.	No
TLGTSO_TASK_NO	_varchar_40	varchar(40)	Yes	Task # for which sign-off information is recorded	No
TLGTSO_TASK_OU	_decimal_10_0	decimal(10)	Yes	Organization unit in which the task is defined	No
TLGTSO_TSK_SIGNOFF_INFO	_varchar_5	varchar(5)	Yes	Sign-off information	No
TLGTSO_TASK_REV_NO	_varchar_40	varchar(40)	Yes	Task Revision #	No
TLGTSO_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp; Indicates the number of times the sign-off information got modified.	No
tlgtso_sgnoffsource	udd_flag	varchar(25)	Yes	Source of sign-off information	No
TLGTSO_WU_Track_id	udd_unique_id	bigint(8)	Yes	Task tracking id which uniquely identifies the task in AME packages	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the sign-off infromation is recorded. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLGWU_STS_LOG
Comment :	Holds AME transaction status change log details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGWU_STS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	The organization unit in which the AME / Task status change has happened	No
TLGWU_TECHLOG_NO	udd_documentno	varchar(40)	Yes	AME Package #	No
TLGWU_ENTITY_CHG	udd_designparamcode	varchar(5)	Yes	Entity Type - AME - Log for Package; Task - Log for AME Task	No
TLGWU_TASK_NO	udd_documentno	varchar(40)	Yes	Task Number	No
TLGWU_TASK_SEQ	udd_seqno	int(4)	Yes	Task Sequence #	No
TLGWU_TASK_OU	udd_ctxt_ouinstance	int(4)	Yes	The organization unit in which the task is defined.	No
TLGWU_FROM_STS	udd_designparamcode	varchar(5)	Yes	From Status	No
TLGWU_TO_STS	udd_designparamcode	varchar(5)	Yes	To Status	No
TLGWU_PERF_STATION	udd_wccode	varchar(30)	Yes	Station in which the package/task related activity is performed.	No
TLGWU_CHANGE_BY	udd_ctxt_user	varchar(30)	Yes	Changed By	No
TLGWU_CHANGE_DATE	_datetime_8	datetime(8)	Yes	Changed DateTime	No
TLGWU_PERF_WORKCENTER	udd_wccode	varchar(30)	Yes	Work Center in which the package/task related activity is performed.	No
tlgwu_service	udd_ctxt_service	varchar(32)	Yes	Service name related to user action which triggered the package/task level status change	No
TLGWU_TASK_Track_id	udd_unique_id	bigint(8)	Yes	Task Track Id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the task status change has happened. Applicable only if the application is configured for OFMS operations.	No
replication_key	_uniqueidentifier_16	uniqueidentifier(16)	No	The key which uniquely identifies the AME status change log information	Yes

Table Name :	FLOG_TLGWU_WORK_UNIT_DTL
Comment :	Holds the list of tasks and its related information which are performed through AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLGWU_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit in which the AME package is recorded	No
TLGWU_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Package @	No
TLGWU_DOC_TYPE	_varchar_5	varchar(5)	No	Document Type MR Or DP	No
TLGWU_DOC_NO	_varchar_40	varchar(40)	No	Maintenance Report # or Discrepancy # or Empty	No
TLGWU_CRT_OU	_decimal_10_0	decimal(10)	No	AME package recorded organization unit	No
TLGWU_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence # which uniquely identifies the tasks in AME package	No
TLGWU_WORK_UNIT_TYPE	_varchar_5	varchar(5)	Yes	Work Unit Type: Task, New Task	No
TLGWU_WORK_UNIT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the task is defined.	No
TLGWU_WORK_UNIT_CODE	_varchar_30	varchar(30)	Yes	Task #	No
TLGWU_TASK_REVNO	_varchar_40	varchar(40)	Yes	Task Revision #	No
TLGWU_EXEC_STATUS	_varchar_15	varchar(15)	Yes	Execution Status could be "Deferred Work Unit" "Performed Work Unit"	No
TLGWU_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Number	No
TLGWU_EXEC_COMMENTS	_varchar_2000	varchar(2000)	Yes	Execution comments	No
TLGWU_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Aircraft Level code	No
TLGWU_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Aircraft Position code	No
TLGWU_PART_NO	_varchar_40	varchar(40)	Yes	Part Number on which the task needs to be performed.	No
TLGWU_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number on which the task needs to be performed.	No
TLGWU_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component on which the task needs to be performed.	No
TLGWU_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the component is defined	No
TLGWU_JOB_TYPE	_varchar_5	varchar(5)	Yes	Job type could be "On wing " , "Aircraft" , "Component Removal"	No
TLGWU_SRC_DOC_TYP	_varchar_25	Varchar(25)	Yes	The type of source document from where the tasks were posted for execution.	No
TLGWU_SRC_DOC_OU	_decimal_10_0	decimal(10)	Yes	The organization unit in which the source document is defined	No
TLGWU_SOURCE_DOC_NO	_varchar_40	varchar(40)	Yes	The source document from where the tasks were posted for execution.	No
TLGWU_SRC_DOC_REV_NO	_varchar_40	varchar(40)	Yes	The revision # of source document from where the tasks were posted for execution.	No
TLGWU_WU_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Work Unit sequence #	No
TLGWU_MAINT_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type 'Overhaul' 'Inspection'	No
TLGWU_SIGN_OFF_INFO	_varchar_5	varchar(5)	Yes	Sign Off Status for the Work Unit	No
TLGWU_FILE_NAME	_varchar_50	varchar(50)	Yes	File Name	No
TLGWU_FORECAST_NO	_varchar_40	varchar(40)	Yes	Work Unit's Forecast Number	No
TLGWU_COMPLIANCE_DATETIME	_datetime_8	datetime(8)	Yes	Last Compliance Date for the WorkUnit	No
TLGWU_SCHEDULE_DATE	_datetime_8	datetime(8)	Yes	Schedule Date	No
TLGWU_PLAN_START_DATE	_datetime_8	datetime(8)	Yes	Plan Start Date	No
TLGWU_PLANNING_TYPE	_varchar_5	varchar(5)	Yes	Planning Type 'Planned' 'UnPlanned'	No
TLGWU_WORKUNIT_SOURCE	_varchar_5	varchar(5)	Yes	Source of the WorkUnit	No
TLGWU_INCOMPLETE_FLAG	_varchar_5	varchar(5)	Yes	Yes or No	No
TLGWU_INCOMPLETE_DOCNO	_varchar_40	varchar(40)	Yes	Document Number from which Incomplete Details are fetched	No
TLGWU_INCOMPLETE_DATE	_datetime_8	datetime(8)	Yes	Incomplete Date	No
TLGWU_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequence number.	No
TLGWU_MATERIAL_COST	_decimal_28_8	decimal(28)	Yes	Material Cost to perform the task	No
TLGWU_LABOUR_COST	_decimal_28_8	decimal(28)	Yes	Labour Cost to perform the task	No
TLGWU_TOOLS_COST	_decimal_28_8	decimal(28)	Yes	Tools Cost to perform the task	No
TLGWU_EQUIPMENT_COST	_decimal_28_8	decimal(28)	Yes	Equipment Cost to perform the task	No
TLGWU_OTHERS_COST	_decimal_28_8	decimal(28)	Yes	Any Other Cost to perform the task	No
TLGWU_SKILL_COST	_decimal_28_8	decimal(28)	Yes	Skill Cost to perform the task	No
TLGWU_MAN_HOURS	_decimal_28_8	decimal(28)	Yes	Required Man Hours to perform the task	No
TLGWU_RES_TOOLS_HRS	_decimal_28_8	decimal(28)	Yes	Resource Tool Hours	No
TLGWU_RES_EQUIP_HRS	_decimal_28_8	decimal(28)	Yes	Resource equipment hours	No
TLGWU_RES_OTHER_HRS	_decimal_28_8	decimal(28)	Yes	Resource other hours	No
TLGWU_RES_SKILL_HRS	_decimal_28_8	decimal(28)	Yes	Resource skill hours	No
TLGWU_RECORDED_BY	_varchar_30	varchar(30)	Yes	Recorded By user	No
TLGWU_CORDER_SEQNO	udd_seqno	int(4)	Yes	Customer order sequence number	No
TLGWU_CORDER_UPDATE	udd_designparamcode	varchar(5)	Yes	Customer order update(Yes/No)	No
TLGWU_TSK_TYPE	udd_quickcode	varchar(25)	Yes	Type of the task	No
TLGWU_PREV_EXEC_COMMENTS	udd_txt2000	varchar(2000)	Yes	Previous execution comments	No
TLGWU_PRV_INCMP_TLOG_NO	udd_documentno	varchar(40)	Yes	Previous in-complete package #	No
TLGWU_SCHSTDT_DATETIME	_datetime_8	datetime(8)	Yes	Schedule start datetime	No
TLGWU_SCHEDDT_DATETIME	_datetime_8	datetime(8)	Yes	Schedule End datetime	No
TLGWU_ACTSTDT_DATETIME	_datetime_8	datetime(8)	Yes	Actual Start datetime	No
TLGWU_ACTEDDT_DATETIME	_datetime_8	datetime(8)	Yes	Actual end datetime	No
TLGWU_ACTMAN_HRS	udd_value	numeric(13)	Yes	Actual Man hours	No
TLGWU_RIIREPORT_BY	udd_ctxt_user	varchar(30)	Yes	RII Reported By	No
TLGWU_ADDNREPORT_BY	udd_txt255	varchar(255)	Yes	Additional Reported By	No
TLGWU_RIIREPORT_REQ	udd_designparamcode	varchar(5)	Yes	RII reported required	No
TLGWU_ADDNREPORT_REQ	udd_designparamcode	varchar(5)	Yes	Additional reported required	No
TLGWU_RIIREPORT_SOFF	udd_designparamcode	varchar(5)	Yes	RII signed off	No
TLGWU_REL_TASK	udd_documentno	varchar(40)	Yes	Related Task	No
TLGWU_STD_PROC	udd_documentno	varchar(40)	Yes	Standard procedure; No longed used	No
TLGWU_WRK_PKG	udd_wccode	varchar(30)	Yes	Work package;No longer used.	No
TLGWU_TSK_STATION	udd_wccode	varchar(30)	Yes	Station in which the task is performed	No
TLGWU_TSK_WCCODE	udd_wccode	varchar(30)	Yes	Work center in which the task is performed	No
TLGWU_TSK_EXEDATE	_datetime_8	datetime(8)	Yes	Task Execution Date & time	No
TLGWU_TSK_EXEPHAS	udd_documentno	varchar(40)	Yes	Task Execution Phase	No
TLGWU_TSK_ZONEWRK	udd_workarea	varchar(15)	Yes	Task work area	No
TLGWU_TSK_ADDSIGN	udd_txt255	varchar(255)	Yes	Task Additional Sign off	No
TLGWU_EXPENSE_TYPE	udd_designparamcode	varchar(5)	Yes	Expense Type	No
TLGWU_CAPEXPROPOSAL_NO	udd_documentno	varchar(40)	Yes	Capex Proposal Number	No
TLGWU_PRIORITY_CODE	udd_optionsettings	varchar(20)	Yes	Priority code	No
TLGWU_REFNO	udd_documentno	varchar(40)	Yes	Reference Number	No
TLGWU_FORECAST_INSTID	udd_seqno	int(4)	Yes	Forecast Instance Id	No
TLGWU_ESTMATERIAL_COST	udd_cost	numeric(13)	Yes	Estimated Material Cost	No
TLGWU_ESTLABOUR_COST	udd_cost	numeric(13)	Yes	Estimated Labour Cost	No
TLGWU_ESTTOOLS_COST	udd_cost	numeric(13)	Yes	Estimated Tool Cost	No
TLGWU_ESTEQUIPMENT_COST	udd_cost	numeric(13)	Yes	Estimated Equiment cost	No
TLGWU_ESTOTHERS_COST	udd_cost	numeric(13)	Yes	Estimate other cost	No
TLGWU_ESTSKILL_COST	udd_cost	numeric(13)	Yes	Estimated Skill Cost	No
TLGWU_EST_ELASPED_TIME_IN_MIN	udd_cost	numeric(13)	Yes	Estimated Elapsed time in minutes	No
TLGWU_ASSIGN_STATUS	udd_designparamcode	varchar(5)	Yes	Assignment status	No
TLGWU_MISC_COST	udd_cost	numeric(13)	Yes	Miscellaneous cost	No
TLGWU_EXEC_CATEGORY	udd_flag	varchar(25)	Yes	Execution Category	No
TLGWU_PERCENT_COMPLETE	udd_percentagecompleted	int(4)	Yes	Percentage Completed	No
TLGWU_ZONE	udd_aczone	varchar(80)	Yes	Zone	No
TLGWU_USER_DEF_STATUS	udd_flag	varchar(25)	Yes	User defined Status	No
TLGWU_ENG_DOCNO	udd_documentno	varchar(40)	Yes	Enginerring Document No	No
TLGWU_DOC_UNIQUEID	udd_guid	varchar(40)	Yes	Unique id for Document attribute Page.	No
TLgWu_Eng_DocRevNo	udd_documentno	varchar(40)	Yes	Revision # of engineering document	No
TLgWu_CusOrd_TskLineNo	udd_seqno	int(4)	Yes	Customer Order - Task Line #	No
Tlgwu_TimeStamp	udd_seqno	int(4)	Yes	Work Unit Time Stamp	No
Tlgwu_ParaRef_Id	udd_txt150	varchar(150)	Yes	Work Unit Parent Reference Id(Used for Record Parameter Reading)	No
Tlgwu_Maint_Event	udd_maintainevent	varchar(30)	Yes	Maintenance Event	No
TLGWU_PSTMAT_COST	udd_cost	numeric(13)	Yes	Material cost which got posted to finance function	No
TLGWU_PSTLABOUR_COST	udd_cost	numeric(13)	Yes	Labour cost which got posted to finance function	No
TLGWU_PSTTOOLS_COST	udd_cost	numeric(13)	Yes	Tools cost which got posted to finance function	No
TLGWU_PSTEQUIPMENT_COST	udd_cost	numeric(13)	Yes	Equipment cost which got posted to finance function	No
TLGWU_PSTOTHERS_COST	udd_cost	numeric(13)	Yes	Other cost which got posted to finance function	No
TLGWU_PSTSKILL_COST	udd_cost	numeric(13)	Yes	Skill cost which got posted to finance function	No
TLGWU_PSTMISC_COST	udd_cost	numeric(13)	Yes	Miscellaneous cost which got posted to finance function	No
TLGWU_HOLD_ID	udd_txt80	varchar(80)	Yes	Hold code applied on the task	No
TLGWU_HOLD_COMMENT	udd_txt80	varchar(80)	Yes	Hold comments	No
TLGWU_TRANSIENT_STATUS	udd_txt80	varchar(80)	Yes	Transient status	No
Tlgwu_CreatedDt	_datetime_8	datetime(8)	Yes	The date & time at which the task is added to the package for execution	No
TLGWU_created_by	udd_ctxt_user	varchar(30)	Yes	The user who added the task to the package for execution	No
TLGWU_modifiedDt	udd_datetime1	datetime(8)	Yes	The date & time at which the task is modified last.	No
TLGWU_modified_by	udd_ctxt_user	varchar(30)	Yes	The user who last modified the task.	No
TLGWU_task_Desc	udd_txt2000	varchar(2000)	Yes	Task description	No
TLGWU_part_desc	udd_txt150	varchar(150)	Yes	Part description	No
TLGWU_mfr_partno	udd_partno	varchar(40)	Yes	Manufacturer part #	No
TLGWU_mfr_no	udd_vendorcode	varchar(45)	Yes	Manufacturer #	No
TLGWU_hierarchy_id	_hierarchyid_892	hierarchyid(892)	Yes	Hierarchy ID which helps to identify the task relationships	No
TLGWU_root_task	udd_workunitcode	varchar(30)	Yes	Root task	No
TLGWU_rep_seqno	udd_seqno	int(4)	Yes	Repair sequence #	No
TLGWU_org_seqno	udd_seqno	int(4)	Yes	Original sequence #	No
TLGWU_seq_cntrl_no	udd_seqno	int(4)	Yes	Sequence control #	No
TLGWU_wbs_code	udd_quickcodes	varchar(25)	Yes	WBS code	No
TLGWU_wrk_scp_flag	udd_chkflag	varchar(1)	Yes	Work scoping flag - Indicates if the task is a work scoping task	No
TLGWU_Rpr_schm_flag	udd_chkflag	varchar(1)	Yes	Repair scheme flag	No
TLGWU_wbs_level	udd_chkflag	varchar(1)	Yes	WBS level	No
TLGWU_exec_opr_flag	udd_chkflag	varchar(1)	Yes	Execution Operation flag - Indicates if the task is a operational task	No
TLGWU_compl_flag	udd_chkflag	varchar(1)	Yes	Compliance flag	No
TLGWU_exec_action	udd_designparamcode	varchar(5)	Yes	Execution action	No
TLGWU_task_rel_flag	udd_designparamcode	varchar(5)	Yes	Task relationship flag	No
TLGWU_mandatory_flag	udd_chkflag	varchar(1)	Yes	Mandatory flag	No
TLGWU_seperated_flag	udd_chkflag	varchar(1)	Yes	Separated flag	No
TLGWU_ext_facility_flag	udd_chkflag	varchar(1)	Yes	External facility flag	No
TLGWU_est_status	udd_designparamcode	varchar(5)	Yes	Estimation status	No
TLGWU_routing_reg	udd_chkflag	varchar(1)	Yes	Routing Requirement flag	No
TLGWU_repair_class	udd_quickcodes	varchar(25)	Yes	Repair classification	No
TLGWU_repair_agency	udd_documentno	varchar(40)	Yes	Repair agency	No
TLGWU_ro_no	udd_documentno	varchar(40)	Yes	Repair Order #	No
TLGWU_eventid	udd_txt255	varchar(255)	Yes	Event ID	No
TLGWU_parent_task_trackid	udd_unique_id	bigint(8)	Yes	Parent task - unique id	No
TLGWU_est_purpose	udd_txt150	varchar(150)	Yes	Estimation purpose	No
TLGWU_est_inst_id	udd_txt150	varchar(150)	Yes	Estimation instance id	No
TLGWU_quote_rel_id	udd_txt150	varchar(150)	Yes	Quotation related identifier	No
TLGWU_charge_est_flag	udd_chkflag	varchar(1)	Yes	Flag related to estimation	No
TLGWU_other_est_flag	udd_chkflag	varchar(1)	Yes	Other estimation flag	No
TLGWU_part_est_flag	udd_chkflag	varchar(1)	Yes	Part estimation flag	No
TLGWU_res_est_flag	udd_chkflag	varchar(1)	Yes	Resource estimation flag	No
TLGWU_source_flag	udd_designparamcode	varchar(5)	Yes	Source flag	No
TLGWU_TRACK_ID	udd_unique_id	bigint(8)	No	Track id which uniquely identifies the task in a AME package	Yes
TLGWU_cust_warr_flag	udd_designparamcode	varchar(5)	Yes	Customer warranty flag	No
TLGWU_WRK_SCOP_COM	udd_txt2000	varchar(2000)	Yes	Working scoping COM	No
TLGWU_REF_TALLY_NO	_bigint_8	Bigint(8)	Yes	Reference tally #	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the task is added to the package. Applicable only if the application is configured for OFMS operations.	No
tlgwu_base_source_flag	udd_designparamcode	varchar(5)	Yes	On-line / Off-line flag. Applicable only if the application is configured for OFMS operations.	No

Table Name :	FLOG_TLOP_OPERATE_TYP_HDR
Comment :	Holds master information about different types of flight operations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLOP_OPTYPE_CODE	udd_flag2	varchar(25)	No	Operation type code	Yes
TLOP_OPTYPE_DESC	udd_flag2	varchar(25)	Yes	Description of operation type	No

Table Name :	FLOG_WORK_ASSIGN_DTL
Comment :	Holds employee assignment details of AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FLOG_OUINSTANCE	ctxt_ouinstance	numeric(9)	No	The organization unit in which the employee work assignments are done for AME package	No
FLOG_REFDOCNO	udd_refdocno	varchar(40)	No	Reference document/Package #	No
FLOG_REFDOCTYPE	udd_documenttype	varchar(40)	Yes	AME Package Type	No
FLOG_SEQNO	udd_seqno	int(4)	No	Task Sequence Number	No
FLOG_TASKNO	udd_workunitcode	varchar(30)	Yes	Task # for which the employee assignment is done	No
FLOG_WORKCENTER	udd_wccode	varchar(30)	Yes	Work center in which the task is performed	No
FLOG_EMPOU	ctxt_ouinstance	numeric(9)	Yes	The organization unit in which the employee is defined	No
FLOG_EMPNO	ctxt_user	varchar(30)	Yes	Employee Code	No
FLOG_FROMDATE	_datetime_8	datetime(8)	Yes	Assigned From DateTime	No
FLOG_TODATE	_datetime_8	datetime(8)	Yes	Assigned To DateTime	No
FLOG_ASSIGN_HOURS	udd_duration	numeric(13)	Yes	Assigned Hours for an Employee	No
FLOG_ASSIGN_COMMENTS	udd_txt2000	varchar(2000)	Yes	Assigned Comments for an Employee	No
FLOG_CREATED_BY	ctxt_user	varchar(30)	Yes	The user who has done the assignments	No
FLOG_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date & time at which the assignment is done	No
FLOG_MODIFIED_BY	ctxt_user	varchar(30)	Yes	The use who last modified the employee work assignment	No
FLOG_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date & time at which the employee work assignment is last modified	No
FLOG_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp; helps to identifies the number of time the employee work assignment is modified	No
FLOG_KEYSEQNO	udd_seqno	int(4)	No	Running number for employee work assignments at package level	No
flog_updated_remarks	udd_txt2000	varchar(2000)	Yes	Updated remarks	No
flog_updated_datetime	udd_datetime1	datetime(8)	Yes	Updated date & time	No
flog_updated_by	udd_hrempname	varchar(77)	Yes	The user who has updated the employee work assignments	No
FLOG_TASK_tRACK_ID	udd_unique_id	bigint(8)	Yes	Task Track Id	No
flog_emp_comments	udd_txt2000	varchar(2000)	Yes	Employee Comments	No
replication_key	_uniqueidentifier_16	uniqueidentifier(16)	No	Key which uniquely identifies the employee assignment details of AME package	Yes

Table Name :	FL_TLISSRET_ISSUE_DTL
Comment :	Holds part issues done for AME packages

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TLISSRET_SLFSRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	The organization unit in which the issue detail is recorded	No
TLISSRET_TECHLOG_NO	_varchar_40	varchar(40)	No	AME Package #	No
TLISSRET_KEY_SEQ_NO	_bigint_8	Bigint(8)	Yes	Key which helps to identify the issue details under AME package	No
TLISSRET_ISSUEPART	_varchar_40	varchar(40)	No	Issued Part Number	No
TLISSRET_LOT	_varchar_18	varchar(18)	No	Issued Lot Number	No
TLISSRET_SERIAL	_varchar_40	varchar(40)	No	Issued Serial Number	No
TLISSRET_RETURN_BASIS	_varchar_10	varchar(10)	Yes	Return Basis. E.g, EX- Exchange	No
TLISSRET_RETURN_PART	_varchar_40	varchar(40)	Yes	Return Part Number	No
TLISSRET_RETURN_LOT	_varchar_18	varchar(18)	Yes	Return Lot Number	No
TLISSRET_RETURN_SERIAL	_varchar_40	varchar(40)	Yes	Return Serial Number	No
TLISSRET_RETURN_QUANTITY	_decimal_28_8	decimal(28)	Yes	Return Quantity	No
TLISSRET_RETURN_UOM	_varchar_10	varchar(10)	Yes	Return UOM	No
TLISSRET_STOCK_STATUS	udd_partstatus	varchar(40)	Yes	Stock Status	No
TLISSRET_CONDITION_RETURNED	_varchar_15	varchar(15)	Yes	Condition in which the part is returned	No
TLISSRET_EXPIRY_DATE	_datetime_8	datetime(8)	Yes	Expiry Date	No
TLISSRET_PART_TYPE	_varchar_25	Varchar(25)	Yes	Type of part. 'Component', 'Consumable', etc.,	No
TLISSRET_PART_CONTROL_TYPE	_varchar_25	Varchar(25)	Yes	Part Control Type. 'Lot', 'Serial', 'Lot and Serial'	No
TLISSRET_EXPENSE_TYPE	_varchar_25	Varchar(25)	Yes	The type of expense incurred	No
TLISSRET_VALUE	_decimal_28_8	decimal(28)	Yes	Return Value	No
TLISSRET_ISSUED_QUANTITY	_decimal_28_8	decimal(28)	Yes	Issued Quantity	No
TLISSRET_ISSUED_UOM	_varchar_10	varchar(10)	Yes	The Unit of Measurement in which the part is issued	No
TLISSRET_ISSUE_WAREHOUSE	_varchar_10	varchar(10)	Yes	Ware House from where the part is issued	No
TLISSRET_ACCOUNT_USAGE	_varchar_20	varchar(20)	Yes	Account Usage	No
TLISSRET_COSTING_USAGE	_varchar_20	varchar(20)	Yes	Costing Usage	No
TLISSRET_LINE_NO	_decimal_10_0	decimal(10)	Yes	Line NUmber	No
TLISSRET_TASK_NO	_varchar_40	varchar(40)	Yes	Task Number	No
TLISSRET_MATERIAL_TYPE	_varchar_5	varchar(5)	Yes	Material Type. 'Main Core', 'Regular'	No
TLISSRET_ISSUE_NO	_varchar_40	varchar(40)	No	Issue Document Number	No
TLISSRET_USED_QTY	udd_quantity	numeric(13)	Yes	Used Quantity	No
TLISSRET_PEND_RET_QTY	udd_quantity	numeric(13)	Yes	Pending Return quantity	No
TLISSRET_PEND_RET_QTY_CORE	udd_quantity	numeric(13)	Yes	Pending Return Core Quantity	No
TLISSRET_CORE_RET_QTY	udd_quantity	numeric(13)	Yes	Core Return Quantity	No
TLISSRET_ISSUE_COST	udd_cost	numeric(13)	Yes	Issue Cost	No
TLISSRET_SRLOT_SEQNO	udd_seqno	int(4)	Yes	Issue Serial sequence Number	No
TLISSRET_TIME_STAMP	udd_timestamp	int(4)	Yes	Timestamp. Helps to identify the number of time the issue request got modfied	No
TLISSRET_ISS_BASIS	udd_designparamcode	varchar(5)	Yes	Issue Basis	No
TLISSRET_ISUID_PRTSYSLNNO	udd_seqno	int(4)	Yes	Issue part line number	No
TLISSRET_RET_COST	udd_cost	numeric(13)	Yes	Return Cost	No
TLISSRET_RET_NO	udd_documentno	varchar(40)	Yes	Return document Number	No
TLISSRET_RET_SYSLNNO	udd_seqno	int(4)	Yes	Return line number	No
TLISSRET_RECON_QTY	udd_quantity	numeric(13)	Yes	Reconcile Quantity	No
TLISSRET_RECQTY_EXCESS	udd_quantity	numeric(13)	Yes	Reconcile Excess Quantity	No
TLISSRET_RECREMARKS	udd_txt2000	varchar(2000)	Yes	Reconcile Remarks	No
TLISSRET_ISSCOMPID	udd_componentid	varchar(90)	Yes	Issued component ID	No
tlissret_autorec_remarks	udd_txt2000	varchar(2000)	Yes	Auto reconciliation remarks	No
TLISSRET_Task_Track_ID	udd_rowno	int(4)	Yes	Track ID which uniquely identifies tasks in AME packages	No
TLISSRET_request_part_no	udd_partno	varchar(40)	Yes	Requested Part Number	No
TLISSRET_requested_serial_no	UDD_SERIALNO	varchar(40)	Yes	Requested Serial Number	No
TLISSRET_requested_lot_no	udd_lotno	varchar(18)	Yes	Requested Lot Number	No
TLISSRET_MR_NO	udd_documentno	varchar(40)	Yes	Material Request Number	No
TLISSRET_MR_LINE_NO	udd_lineno	int(4)	Yes	Material Request Line Number	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code/Location in which the AME Issue infromation is recorded. Applicable only if the application is configured for OFMS operations.	No
tlissret_source_flag	udd_designparamcode	varchar(5)	Yes	Source flag. On-line / Off-line	No
TLISSRET_ISSUE_UNIQUEID	udd_unique_id	bigint(8)	No	Key which helps to identify the issue details uniquely under AME package	Yes
tlissret_ben_stk_flag	udd_designparamcode	varchar(5)	Yes	Bench stock flag. Will be true if the issue is happened through bench stock consumption	No
tlissret_nonstockable_flag	udd_designparamcode	varchar(5)	Yes	Non-stockable flag of issued part	No
tlissret_sl_no_logic	udd_designparamcode	varchar(5)	Yes	Serial # generation logic of issued part	No
tlissret_sl_no_type_no	udd_designparamcode	varchar(5)	Yes	Numbering type for serial # generation for issued part	No
tlissret_lot_no_type_no	udd_designparamcode	varchar(5)	Yes	Numbering type for lot # generation for issued part	No
tlissret_part_acc_grp	udd_customeraccountgroup	varchar(20)	Yes	Part account group of issued part	No
tlissret_part_desc	udd_txt150	varchar(150)	Yes	Part description of issued part	No
tlissret_valuation_method	udd_designparamcode	varchar(5)	Yes	Valuation method of issued part	No
tlissret_adj_act_cost	udd_flag	varchar(25)	Yes	Adjusted actual cost of issued part	No
tlissret_expensing_policy	udd_designparamcode	varchar(5)	Yes	Expensing policy of issued part	No
tlissret_stock_uom	udd_uomcode	varchar(10)	Yes	Stock UOM of issued part	No