FLOG_TLGCR_TECH_LOG_CR_DTL

Captures component replacement activities recorded under Aircraft Maintenance Execution (AME) packages. Includes removed component IDs, installed component details, and maintenance references.

Process: LINEMAINTENANCE · Component: BasFltLog · Table type: Transaction Table Category: Organize the table related to the Aircraft Maintenance Execution ( AME ) package which tracks part consumption, resources, materials, component removals and component replacement.

Primary key

TLGCR_SLFSRC_OUINSTANCE, TLGCR_TECHLOG_NO, TLGCR_SEQ_NO

Columns (145)

#	Column	Type	Description
1	`TLGCR_SLFSRC_OUINSTANCE` 🔑	#N/A	Aircraft Maintenance and Execution Component Replacement Self Source Created OUInstance
2	`TLGCR_TECHLOG_NO` 🔑	varchar	Aircraft Maintenance and Execution Package Reference for Component Replacement
3	`TLGCR_SEQ_NO` 🔑	#N/A	Component Replacement Request Running Number for Aircraft Maintenance and Execution Package Reference
4	`TLGCR_CRT_OU`	#N/A	Aircraft Maintenance and Execution Component Replacement Created OUInstance
5	`TLGCR_REPL_OBJ_TYPE`	varchar	Component Replacement Object Type CMP Component OP Other Parts MISC Miscellaneous
6	`TLGCR_CFG_OU`	#N/A	Configuration OUInstance Generated During Configuration Updation
7	`TLGCR_LEVEL_NO`	varchar	Configuration Level Code for Component Replacement
8	`TLGCR_POS_NO`	Varchar	Configuration Position Code for Component Replacement
9	`TLGCR_REASON_FOR_RMVL`	varchar	Reason for Removal Applicable for Remove Replace Swap and Cannibalize Component Replacement Transaction
10	`TLGCR_ATA_NO`	varchar	ATA Number Configuration Detail
11	`TLGCR_OUTGOING_PART_CRT_OU`	#N/A	Removed Part OUInstance for Component Replacement
12	`TLGCR_OUTGOING_PART_NO`	varchar	Removed Part Number for Component Replacement
13	`TLGCR_OUTGOING_PART_SRL_NO`	varchar	Removed Serial Number for Component Replacement
14	`TLGCR_OUTGOING_COMP_OU`	#N/A	Removed Component OU for Component Replacement
15	`TLGCR_OUTGOING_COMP_ID`	varchar	Removed Component Number for Component Replacement
16	`TLGCR_REMOVAL_DATETIME`	datetime	Component Replacement Transaction Datetime
17	`TLGCR_REPLACED_BY`	varchar	Component Replacement Transaction Done By
18	`TLGCR_OUTGOING_PART_COND`	varchar	Removed Condition for Component Replacement
19	`TLGCR_EX_AIRCRAFT_REG_OU`	#N/A	Source Aircraft Registration OUInstance Updated for Swap and Cannibalize
20	`TLGCR_EX_AIRCRAFT_REG_NO`	varchar	Source Aircraft Registration Number Updated for Swap and Cannibalize
21	`TLGCR_INCOMING_PART_CRT_OU`	#N/A	Installed Part OUInstance for Component Replacement
22	`TLGCR_INCOMING_PART_NO`	varchar	Installed Part Number for Component Replacement
23	`TLGCR_SOURCE`	varchar	Source to Describe Component Replacement Type RM Remove R Replace A Attach SW Swap C Cannibalize
24	`TLGCR_INCOMING_PART_SRL_NO`	varchar	Installed Serial Number for Component Replacement
25	`TLGCR_INCOMING_COMP_OU`	#N/A	Installed Component OUInstance for Component Replacement
26	`TLGCR_INCOMING_COMP_ID`	varchar	Installed Component Number for Component Replacement
27	`TLGCR_AC_CR_NO`	varchar	Component Replacement Number
28	`TLGCR_CNB_RMVL_NO`	varchar	Component Replacement Number Updated for Swap and Cannibalize
29	`TLGCR_REMARKS`	varchar	Component Replacement Comments
30	`TLGCR_TIMESTAMP`	#N/A	Timestamp Updation for Aircraft Maintenance and Execution Component Replacement Transaction
31	`TLGCR_EXACRMVL_CFG_OU`	#N/A	Configuration Created OU for Swap and Cannibalize
32	`TLGCR_EXACRMVL_LEVEL_NO`	#N/A	Configuration Level Code for Swap and Cannibalize
33	`TLGCR_EXACRMVL_POS_NO`	Varchar	Configuration Position Code for Swap and Cannibalize
34	`TLGCR_SERIALNO_TYPE`	Varchar	Serial Number Type NEW New EXIS Exist
35	`TLGCR_OUTGOING_MSN`	varchar	Removed Manufacturer Serial Number Updated for New Removed Serial Number
36	`TLgCr_Record_Mode`	varchar	Record Mode NW Normal WE
37	`TLGCR_PROCESSFLAG`	varchar	Process Flag
38	`TLGCR_MATERIAL_COST`	numeric	Material Cost for Component Replacement Items
39	`tlgcr_basrem_for_reason`	varchar	Basic Removal Y Yes N No Attribute for Reason Applicable for Remove Replace Swap and Cannibalize Component Replacement Transaction
40	`tlgcr_remtype_for_reason`	varchar	Removal Type S Scheduled US Unscheduled O Others Attribute for Reason Applicable for Remove Replace Swap and Cannibalize Component Replacement Transaction
41	`TLGCR_RETURN_FLAG`	varchar	Return Flag N No Y Yes Used for Material Count
42	`TLGCR_TASK_NO`	varchar	Task Number for Component Replacement Transaction
43	`TLGCR_TASKSEQ_NO`	int	Task Sequence Number for Component Replacement Transaction
44	`TLGCR_SOS_DISPOS`	varchar	SOS Disposition Details on Removal for Unserviceable Condition NA Not Applicable CF Confirmed Failure SF Suspected Failure
45	`TLGCR_QUAR_FLAG`	varchar	Quarantine Flag Y Yes N No Details on Removal for Unserviceable Condition
46	`TLGCR_SOS_DISPOS_FLAG`	varchar	SOS Disposition Flag Y Yes N No Details on Removal for Unserviceable Condition
47	`TLGCR_LEVEL_NUMBER`	numeric	Configuration Level Number
48	`TLGCR_EXACRMVL_LEVEL_CODE`	varchar	Source Aircraft Registration Level Code Updated for Swap and Cannibalize
49	`TLGCR_EX_COMPONENT`	varchar	Source Component Updated for Swap and Cannibalize
50	`TLGCR_ACCEPTANCEREF`	varchar	Acceptance Reference for Conditional Effectivity Part Number
51	`TLGCR_ReturnNo`	varchar	Return Number for Removed Item
52	`TLGCR_ReturnOu`	int	Return OUInstance for Removed Item
53	`Tlgcr_autorec_remarks`	varchar	Automatic Reconcile Remarks
54	`Tlgcr_autorec_status`	varchar	Automatic Reconcile Status
55	`TLGCR_SWO_NO`	varchar	Shop Work Order Reference
56	`TLGCR_RO_NO`	varchar	Repair Order Reference
57	`TLGCR_GenOrd_Type`	varchar	Generated Order Type SWO Shop Work Order RO Repair Order
58	`TLGCR_Work_center`	varchar	Work Center Reference
59	`TLGCR_repair_agency`	varchar	Repair Agency Reference
60	`TLGCR_remvl_qty`	numeric	Removal Quantity Details
61	`TLGCR_Attch_Qty`	numeric	Attached Quantity Details
62	`TLGCR_Rem_dispotn`	varchar	Removal Disposition Code Details
63	`TLGCR_Lot_no`	varchar	Lot Reference Number
64	`TLGCR_mfg_Lot_no`	varchar	Manufacture Lot Number
65	`tlgcr_MntReturn_Flag`	varchar	Maintenance Return N No Y Yes
66	`TLGCR_CR_return_flag`	varchar	Core Item Return Flag N No Y Yes
67	`TLGCR_scrpnote_docno`	varchar	Scrap Note Document Reference
68	`TLGCR_scrpnote_lineno`	int	Scrap Note Document Reference Line
69	`TLGCR_TASK_TRACK_ID`	bigint	Task Track Id
70	`tlgcr_penretqty`	numeric	Pending Return Quantity for Removal Details
71	`tlgcr_retqty`	numeric	Returned Quantity for Removal Details
72	`tlgcr_reconcqty`	numeric	Manual Reconciled Quantity for Removal Details
73	`tlgcr_reconcremarks`	varchar	Manual Reconciled Remarks for Removal Details
74	`tlgcr_retnclass`	varchar	Return Classification for Removal Details
75	`tlgcr_cond`	varchar	Return Condition for Removal Details
76	`tlgcr_certype`	varchar	Certificate Type for Returned Details
77	`tlgcr_certno`	varchar	Certificate Number for Returned Details
78	`tlgcr_certdate`	varchar	Certificate Date for Returned Details
79	`tlgcr_expdate`	varchar	Expired Date for Returned Part Number
80	`tlgcr_stocksts`	varchar	Returned Stock Status for Removed Items
81	`tlgcr_retnby`	varchar	Returned By Whom
82	`tlgcr_retwhs`	varchar	Returned Warehouse Number
83	`TLGCR_CR_Unique_id`	int	Component Replacement Track Id
84	`tlgcr_source_flag`	varchar	Source Flag Updation Based on Usage Mode ON Online OFF Offline
85	`tlgcr_part_type`	varchar	Part Type of the Removed Part
86	`tlgcr_part_classify`	varchar	Part Classification of the Removed Part
87	`tlgcr_part_ctrl_type`	varchar	Part Control Type of the Removed Part
88	`tlgcr_expense_type`	varchar	Expense Type of the Removed Part
89	`tlgcr_nonstockable_flag`	varchar	Non Stockable Flag of the Removed Part
90	`tlgcr_sl_no_logic`	varchar	Serial Number Generation Logic of the Removed Part
91	`tlgcr_sl_no_type_no`	varchar	Numbering Type for Serial Number Generation
92	`tlgcr_lot_no_type_no`	varchar	Numbering Type for Lot Number Generation
93	`tlgcr_part_acc_grp`	varchar	Part Account Group of the Removed Part
94	`tlgcr_part_desc`	varchar	Part Description of the Removed Part
95	`tlgcr_valuation_method`	varchar	Valuation Method of the Removed Part
96	`tlgcr_adj_act_cost`	varchar	Adjusted Actual Cost of the Removed Part
97	`tlgcr_expensing_policy`	varchar	Expensing Policy of the Removed Part
98	`tlgcr_stock_uom`	varchar	Stock UOM of the Removed Part
99	`tlgcr_cert_reqd_flag`	varchar	Certification Requirement Information of the Removed Part
100	`tlgcr_issue_basis`	varchar	Issue Basis of the Removed Part
101	`tlgcr_autoissue`	varchar	Indicates Whether the Attached Part is Auto Issued from Stock
102	`tlgcr_rtncls`	varchar	Return Classification Identified for the Removed Part
103	`tlgcr_rtnwarehouse`	varchar	Warehouse to Which the Removed Part to be Returned
104	`tlgcr_rtnzone`	varchar	Zone in the Return Warehouse Identified
105	`tlgcr_rtnbin`	varchar	Bin in the Return Warehouse Zone Identified
106	`tlgcr_work_requested`	varchar	Work Requested
107	`tlgcr_issueunique_id`	bigint	Issue Unique Id
108	`tlgcr_installed_lotno`	varchar	Installed Lot Number
109	`tlgcr_modno`	varchar	Part Mod Number
110	`TLGCR_Exec_fac`	varchar	Component Replacement Execution Facility
111	`tlgcr_part_groupid`	int	Part Group Number
112	`TLGCR_MODIFIED_DATETIME`	datetime	Component Replacement Recorded Datetime
113	`TLGCR_CREATED_DATETIME`	datetime	Component Replacement Modified Datetime
114	`tlgcr_confdisp_sts`	varchar	Component Replacement Dispositioning Status
115	`tlgcr_prev_remdisp`	varchar	Previous Removal Disposition
116	`tlgcr_disp_qty`	numeric	Disposition Quantity for Removed Part
117	`tlgcr_pend_dispqty`	numeric	Pending Disposition Quantity
118	`tlgcr_pck_cntcover`	varchar	Flag to Indicate Removed Part are Covered Under Aircraft Hangar Contract
119	`tlgcr_contract_no`	varchar	Removed Part Contract Number
120	`tlgcr_custpo_no`	varchar	Removed Part Customer PO Reference Number
121	`tlgcr_custorder_no`	varchar	Removed Part Customer Order Number
122	`tlgcr_override_flg`	varchar	Flag to Indicate the Removed Part will be Considered in the Hangar Contract Even if Not Covered
123	`tlgcr_cover_mr`	varchar	Material Request Coverage Number to Track the Removed Part Back to Aircraft Maintenance and Execution
124	`tlgcr_usr_sts`	varchar	Component Replacement User Status
125	`tlgcr_usr_stsrem`	varchar	Component Replacement User Status Remarks
126	`tlgcr_rpc`	varchar	Repair Process Code
127	`tlgcr_ncr_revno`	int	Non Component Replacement Reverse Number
128	`tlgcr_ref_cruniqueid`	bigint	Reference Component Replacement Record Tracking Number
129	`tlgcr_disp_rtnloc`	varchar	Disposition Part Return Location
130	`tlgcr_off_cvrdflg`	varchar	Flag to Indicate Offline Processed to Update the Contract Details for Removed Part
131	`tlgcr_off_cpflg`	varchar	Status to Indicate Offline Processed to Update the Contract Details for Removed Part
132	`tlgcr_contract_revno`	int	Removed Part Contract Revision Number
133	`tlgcr_cust_no`	varchar	Removed Part Customer Number
134	`tlgcr_aceff_code`	varchar	Aircraft Effective Code
135	`tlgcr_aceff_lineno`	int	Aircraft Effective Object Line Number
136	`tlgcr_prteff_code`	varchar	Part Effective Code
137	`tlgcr_ptreff_lineno`	int	Part Effective Object Line Number
138	`tlgcr_pckgcntrt`	varchar	Contract Number for the Removed Part
139	`tlgcr_covmrlineno`	int	Material Request Line Coverage Number to Track the Removed Part Back to Aircraft Maintenance and Execution
140	`tlgcr_dispby`	varchar	Dispositioned By Employee
141	`tlgcr_dispdate`	datetime	Dispositioned By Datetime
142	`tlgcr_custordrevno`	int	Removed Customer Order Revision Number
143	`TLGCR_USERDEFINED1`	varchar	User Defined 1
144	`TLGCR_USERDEFINED2`	varchar	User Defined 2
145	`TLGCR_USERDEFINED3`	varchar	User Defined 3

FLOG_TLGCR_TECH_LOG_CR_DTL

Primary key

Columns (145)

See also