Preparing the A/C Readiness Load File, via eMRO Load AC Readiness through TraxDoc

MANUALS > TraxDoc > TraxDoc Module > TraxDoc, Update Menu > TraxDoc Master > TraxDoc Document Detail > TraxDoc Document Detail, TraxDoc Explorer Tab > Import From OEM Manual Button, via TraxDoc Document Detail > Load AC Readiness through TraxDoc, via AC Readiness Load (ACRD) Doctype > Preparing the A/C Readiness Load File, via eMRO Load AC Readiness through TraxDoc

The A/C Readiness import is useful when creating master data. This import can be used to create, add, enhance, or modify the template being used to import aircraft information.

The A/C Readiness Records text file must be laid out as shown in the table below. It is recommended that the A/C Readiness File is opened in Microsoft Excel and inspected to make sure that the criteria defined in the table below is met.

Prepare the Aircraft Readiness Load Excel File (.xlsx) provided by the aircraft manufacturer in Microsoft Excel as follows:

Arrange and modify the columns (fields) to meet the specification in the table below.

Note: The Aircraft Readiness Load Excel File must be created in a specific format. A template has been provided to ensure that the exact parameters are followed for optimal results. Click here to download a copy of the Excel template: eMRO A/C Readiness Load Template. Once ready, the file must be loaded into eMRO in one of the following formats: .xlsx, .csv, or .txt.

Note: Any date entered in the excel must be in the format of MM-DD-YYYY.

Column	Column Name	Date Limitation	Fields Populated	Path
A	Program ID	20	N/A	N/A
B	Line Number	5	N/A	N/A
C	Variable	5	N/A	N/A
D	Propulsion	5	N/A	N/A
E	Basic	5	N/A	N/A
F	Model Number	10	N/A	N/A
G	ARL Zone	8	N/A	N/A
H	MPD Zone	3	N/A	N/A
I	Part Description	80	Part Description	Inventory/ Update/ Inventory Transaction/ Inventory Detail, General tab. Also used for P/N in P/N Master (if doesn't exist already). Note: This field is mandatory
J	Used On	32	N/A	N/A
K	Part Number	35	Part Number	Inventory/ Update/ Inventory Transaction/ Inventory Detail, General tab. Note: This field is mandatory
L	Spec Number	32	N/A	N/A
M	Cage Code	6		Settings/ Update/ Vendor Master, Optional tab. Note: This field is mandatory
N	Vendor Name	27	Vendor	Settings/ Update/ P/N Master, General tab. If Load P/N checkbox is selected, Vendor will be assigned against P/N in P/N Master (if doesn't already exist). Note: This field is mandatory
O	Quantity	6	N/A	N/A
P	Serial/Lot Number	27	Serial Number	Inventory/ Inventory Transaction/ Inventory Detail, General tab Note: This field is mandatory
Q	Misc Location	20	Installed Position	Inventory/ Inventory Transaction/ Inventory Detail, A/C tab Note: This field is mandatory
R	X Station	13	N/A	N/A
S	Y Buttockline	10	N/A	N/A
T	Z Waterline	10	N/A	N/A
U	Source	3	N/A	N/A
V	ATA	12	Chapter	Settings/ Update/ P/N Master, General tab. Only applicable if P/N Load checkbox is selected. Note: This field is mandatory
W	Mfg Date	10	N/A	P/N Control Reset Date, P/N E/C Effectivity date, P/N Birth Date
X	Hst Date	10	N/A	N/A
Y	Pack Date	10	N/A	N/A
Z	Batt Exp Date	10	N/A	N/A
AA	Test Date	10	N/A	N/A
AB	Batt Mfg Date	10	N/A	N/A
AC	Exp Date	10	N/A	N/A
AD	Install Date	10	N/A	N/A
AE	Country Code	3	N/A	N/A
AF	Hex Code	15	N/A	N/A
AG	Alt Authority	32	N/A	N/A
AH	Life Limited Ind	1	N/A	N/A
AI	Press ves Flag	1	N/A	N/A
AJ	AD Affected	1	N/A	N/A
AK	Refurb Hours	10	N/A	N/A
AL	Refurb Cycles	10	N/A	N/A
AM	Boeing Test Date	32	N/A	N/A