User guide

20
Appendix
DATA FILES OVERVIEW
TherstsectionoftheappendixincludesexamplesofASCIItextles(.txt)andtablesdescribingeacheld.Thetext
lenameandtheDMSlenamearenotedinparantheses.
FIELD TYPES
ThenumberintheFieldTypecolumnrepresentsthemaximumnumberofcharactersallowedintheeld.
A-Alphanumeric
N-Numeric,nodecimalpoint
F -Numericoating,decimalpoint
Numeric elds must contain a value. If the eld
does not have a value, use a “0”.
If an alphanumeric elds does not have a value,
use a blank space “ ”.
Field # Field Name Description Field Type Example
1 Code Codeofairportlocation. A4 ADM
2 Name Nameofairportlocation. A79 ArdmoreMunicipalAirport
3 City Cityofairportlocation. A47 Ardmore
4 State Stateofairportlocation. A31 OK
5 Country Countryofairportlocation. A31 USA
“ADM”,”ArdmoreMunicipalAirport”,”Ardmore”,”OK”,”USA”
Airport Code File (ACode.txt - ACode.501)
Field # Field Name Description Field Type Example
1 Name Nameofaircrafttype. A7 BO747
2 Code Aircrafttypecode. A10 747
“BO747”,”747”
Aircraft Type File (AType.txt - AType.501)
Field # Field Name Description Field Type Example
1 name Customername. A35 JetBlue
2 account Customeraccountnumber. A12 47
3 code Customercode. A4 JTB
“JetBlue”,”47”,”JTB”
Customer File (Customer.txt - Customer.501)