Liquid Controls FlightConnect Office - Manual (Page 20)

20
Appendix
daTa fIles oVeRVIeW
The first section of the appendix includes examples of ASCII text files (.txt) and tables describing each field. The text
file name and the DMS file name are noted in parantheses.
fIeld Types
The number in the Field Type column represents the maximum number of characters allowed in the field.
A - Alphanumeric
N - Numeric, no decimal point
F - Numeric floating, decimal point
Numeric fields must contain a value. If the field
does not have a value, use a “0”.
If an alphanumeric fields 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
)