| Format
of the DATA FILE for UPLOADING DATA ONLINE at Trackyourcargo.com |
| The
File should start with the indicator <TYC/IMPEX/1.0>.This
should be followed by the indicator <TABLE>
for each main table data that you include in the file. The File should
end with the line <END>
indicating the termination of File contents.
|
|
|
| Note
: The Delimiter
to separate individual columns is chr(29).
|
|
|
| For each Main
table that you include, precede the name of the table with <TABLE>
to indicate the start of Data for the particular Table. For Example, the
table AWBMaster
can be Represented as <TABLE>AWBMaster.
|
|
|
| The table below
contains the Order, DataField
Name and Data Type for each of the
main tables viz; AWBMaster,
AWBTrack, FLTDetail,
BLMaster, BLTrack
and ContDetail. Please maintain the
order strictly in your Files to prevent Data miscarriage.
|
| Please click
here to view a sample of the Data File.
|
|
|
| ORDER
|
FIELD
NAME
|
FIELD
DATA TYPE
|
| AWBMaster
|
| 1.
|
Airway Bill
Number
|
varchar(13)
|
| 2.
|
House Airway
Bill Number
|
int
|
| 3.
|
Document
Date
|
datetime
|
| 4.
|
Airline
|
varchar(35)
|
| 5.
|
Shipper
|
varchar(50)
|
| 6.
|
Consignee
|
varchar(50)
|
| 7.
|
Agent
|
varchar(50)
|
| 8.
|
Departure
Port
|
varchar(20)
|
| 9.
|
Destination
Port
|
varchar(20)
|
| 10.
|
No. of
Packages
|
int
|
| 11.
|
Description
|
varchar(50)
|
| 12.
|
Gross Wt.
|
float
|
| 13.
|
Unit for Wt.
|
char(3)
|
| 14.
|
Current
Status
|
varchar(40)
|
| 15.
|
Current
Status Date
|
date time
|
| 16.
|
Current
Status Time
|
date time
|
| 17.
|
Current
Status Remark
|
varchar(30)
|
| 18.
|
Is a
MasterBILL
|
bit (1 if
YES and 0 if NO)
|
| 19.
|
Ship Invoice
No.
|
varchar(25)
|
| 20.
|
Ship Invoice
Date
|
datetime
|
| 21.
|
Purchase
Order No.
|
varchar(20)
|
| 22.
|
Purchase
Order Date
|
datetime
|
| 23.
|
Document ID
|
varchar(25)
|
| 24.
|
Document
Completion Date
|
date time
|
| 25.
|
Type of Bill
|
char(1) (I
for Import and E for Export)
|
| 26.
|
Duty
|
int
|
| *27.
|
User Defined
Field1
|
varchar(25)
|
| *28.
|
User Defined
Field2
|
varchar(25)
|
| *29.
|
User Defined
Field3
|
varchar(25)
|
| *30.
|
User Defined
Field4
|
varchar(25)
|
| *31.
|
User Defined
Field5
|
varchar(25)
|
|
| AWBTrack
|
| 1.
|
Document ID
|
varchar(25)
|
| 2.
|
Type of Bill
|
char(1) (I
for Import and E for Export)
|
| 3.
|
Airway Bill
Number
|
varchar(13)
|
| 4.
|
House Airway
Bill Number
|
int
|
| 5.
|
Status
|
varchar(40)
|
| 6.
|
Date
|
datetime
|
| 7.
|
Time
|
datetime
|
| 8.
|
Remark
|
varchar(30)
|
|
| FLTDetail
|
| 1.
|
Document ID
|
varchar(25)
|
| 2.
|
Type of Bill
|
char(1) (I
for Import and E for Export)
|
| 3.
|
Airway Bill
Number
|
varchar(13)
|
| 4.
|
House Airway
Bill Number
|
int
|
| 5.
|
Serial
Number
|
int (maximum
3)
|
| 6.
|
Booking
Airline Code
|
char(2)
|
| 7.
|
Booking
Flight No.
|
varchar(10)
|
| 8.
|
Booking Date
|
datetime
|
| 9.
|
Booking Time
|
datetime
|
| 10.
|
Actual
Airline Code
|
char(2)
|
| 11.
|
Actual
Flight No.
|
varchar(10)
|
| 12.
|
Actual Date
|
datetime
|
| 13.
|
Actual Time
|
datetime
|
| 14.
|
Destination
Code
|
varchar(3)
|
|
| BLMaster
|
| 1.
|
Bill of
Lading
|
varchar(20)
|
| 2.
|
House Bill
of Lading
|
varchar(20)
|
| 3.
|
Document
Date
|
date time
|
| 4.
|
Shipping
Line
|
varchar(50)
|
| 5.
|
Shipper
|
varchar(50)
|
| 6.
|
Consignee
|
varchar(50)
|
| 7.
|
Agent
|
varchar(50)
|
| 8.
|
Departure
Port
|
varchar(20)
|
| 9.
|
Destination
Port
|
varchar(20)
|
| 10.
|
No. of
Packages
|
int
|
| 11.
|
Description
|
varchar(50)
|
| 12.
|
Gross Wt.
|
float
|
| 13.
|
Unit for Wt.
|
char(3)
|
| 14.
|
Current
Status
|
varchar(40)
|
| 15.
|
Current
Status Date
|
date time
|
| 16.
|
Current
Status Time
|
date time
|
| 17.
|
Current
Status Remark
|
varchar(30)
|
| 18.
|
Is a
MasterBILL
|
bit (1 if
YES and 0 if NO)
|
| 19.
|
Ship Invoice
No.
|
varchar(25)
|
| 20.
|
Ship Invoice
Date
|
date time
|
| 21.
|
Purchase
Order No.
|
varchar(20)
|
| 22.
|
Purchase
Order Date
|
datetime
|
| 23.
|
Document ID
|
varchar(25)
|
| 24.
|
Document
Completion Date
|
date time
|
| 25.
|
Type of Bill
|
char(1) (I
for Import and E for Export)
|
| 26.
|
Duty
|
int
|
| *27.
|
User Defined
Field1
|
varchar(25)
|
| *28.
|
User Defined
Field2
|
varchar(25)
|
| *29.
|
User Defined
Field3
|
varchar(25)
|
| *30.
|
User Defined
Field4
|
varchar(25)
|
| *31.
|
User Defined
Field5
|
varchar(25)
|
|
| BLTrack
|
| 1.
|
Document ID
|
varchar(25)
|
| 2.
|
Type of Bill
|
char(1) (I
for Import and E for Export)
|
| 3.
|
Bill of
Lading
|
varchar(20)
|
| 4.
|
House Bill
of Lading
|
varchar(20)
|
| 5.
|
Status
|
varchar(40)
|
| 6.
|
Date
|
date time
|
| 7.
|
Time
|
date time
|
| 8.
|
Remark
|
varchar(30)
|
|
| CONTDetail
|
| 1.
|
Document ID
|
varchar(25)
|
| 2.
|
Type of Bill
|
char(1) (I
for Import and E for Export)
|
| 3.
|
Bill of
Lading
|
varchar(20)
|
| 4.
|
House Bill
of Lading
|
varchar(20)
|
| 5.
|
Container
Number
|
varchar(15)
|
| 6.
|
Container
Size
|
char(2)
|
| 7.
|
Seal No.
|
varchar(10)
|
| 8.
|
Container
Type
|
varchar(5)
|
|
|
|
|
Note :
* :
Indicates User Defined Fields which are optional and if available should be
appended at the end of the line along with the delimiter. Before uploading data
belonging to User Defined Fields, Please create the Fields online by clicking on
the Define Fields button found under the Control
Panel section in Trackyourcargo.com.
|
