Overview

	Column Name	Definition	Data Type	Format	Length (max)
1	Connote	Consignment Tracking Number	varchar		20
2	Released	Consignment Release date	date	YYYY-MM-DD	-
3	Reference	Primary consignment reference	varchar		20
4	Service	Carrier Service (as defined in OneFlo)	varchar		10
5	Carrier	Carrier Name (as defined in OneFlo)	varchar		50
6	Sender	Sender Name	varchar		50
7	SAddress1	Sender Address Line 1	varchar		30
8	SAddress2	Sender Address Line 2	varchar		30
9	SLocality	Sender Locality / Suburb	varchar		50
10	SState	Sender State	varchar		5
11	SPCode	Sender Postcode	varchar		10
12	Receiver	Receiver Name	varchar		50
13	RAddress1	Receiver Address Line 1	varchar		30
14	RAddress2	Receiver Address Line 2	varchar		30
15	RLocality	Receiver Locality / Suburb	varchar		50
16	RState	Receiver State	varchar		5
17	RPCode	Receiver Postcode	varchar		10
18	Items	Total number of Items	int		-
19	Weight	Total Weight	float		-
20	Volume	Total volume	float		-
21	Time	Total Time (if captured)	float		-
22	Distance	Total Distance (if captured)	float		-
23	ZoneFrom	Carrier Zone From	varchar		10
24	ZoneTo	Carrier Zone To	varchar		10
25	Freight	Basic Freight Charge	money		-
26	Fees	Fees Charge	money		-
27	Net	Net Charge	money		-
28	GST	Tax	money		-
29	Total	Total Freight Charge (Freight+Fees+GST)	money		-
30	UserField1	User defined field #1	varchar		20
31	UserField2	User defined field #2	varchar		20
32	UserField3	User defined field #3	varchar		20
33	UserField4	User defined field #4	varchar		20
34	UserField5	User defined field #5	varchar		20
35	References	Additional References	comma-delimited varchar	"ref1,ref2,ref3"	∞

Available Formats

Type	Advantages	Sample
CSV	Useful for basic consignment level reporting Readable in Spreadsheet applications such as Microsoft Excel Human friendly	Customer_Daily_20180815190020.csv
XML	Robust data structure Easily imported into ERP or WMS or vital systems relevant for freight reporting	Sample_Postback_Full.xml