This document includes two different file layouts:
Note: The NEOPOST.EXE program is designed to convert Neopost Audit Trail Version 4.01. If using a newer version of Neopost (e.g., 7.51), the file layout presented for NEOPOST.EXE will not be exported by the newer software. However, newer versions can export a format compatible with TBDevice using the Other format; the layout for this format is also shown below.
Program: NEOPOST.EXE
Data File: Can be any name conforming to the DOS 8.3 naming convention
File Type: Variable Length (comma-delimited)
Neopost File Layout
Field Name Description
----- ---------------- ---------------------------------------------
1 Record Type Ignored
2 Invoice Number Ignored
3 Date Converted as Tran Date (in YYYYMMDD format)
4 Suffix Number Ignored
5 Sequence for SWOG Ignored
6 Pickup Number Ignored
7 Department Converted as Client ID (has "." separator)
8 Client ID Ignored
9 Auxiliary Field Ignored
10 Tracking Number Ignored
11 Carrier Mode Ignored
12 Hundredweight ID Ignored
13 Shipper ID Ignored
14 Call Tag Number Ignored
15 Flags Ignored
16 Operator ID Ignored
17 Carrier Code Ignored
18 Rate Code Ignored
19 Services Ignored
20 Codes Ignored
21 Destination Zip Code Ignored
22 Origin Zip Code Ignored
23 Shipping Zone Ignored
24 Transaction Number Ignored
25 Number of Pieces Ignored
26 Rated Weight Ignored
27 Actual Weight Ignored
28 Shipping Charge Converted as Tran Amount (in n.nnn format)
29 COD Charge Ignored
30 Declared Value Charge Ignored
31 AIP Charge Ignored
32 Handling Charge Ignored
33 Other Charge Ignored
34 COD Amount Ignored
35 Declared Value Amount Ignored
36 AIP Amount Ignored
37 Other Amount Ignored
38 Base Charge Field Ignored
39 Client DBase Pointer Ignored
40 Reserved for Future Ignored
41 ID # for Multisystems Ignored
42 ID # for Postage Meter Ignored
43 Extra Handling Charge Ignored
44 Shipper Number Ignored
45 Time Ignored
46 Fixed Length Padding Ignored
Note: Neopost users have the option of exporting data in comma delimited or
fixed length format. Our interface program requires that they export the
data in the comma delimited format.
Sample Neopost data file: Please note that the long records were wrapped to the
next line and indented 5 spaces. "Actual" records would have 1 line per
transaction entry no matter how long they are.
"S","S19980305-085228",19980305,1,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," B 0 ","9482","2","1",0,0,"00000-0000","20000-0000",
0,0,371,371.000,27.825,203.500,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.00,0.000,0,"",0,1,0,0,"105916",""
"S","S19980305-105942",19980305,1,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," B 0 ","9455","2","1",0,0,"00000-0000","20000-0000",
0,0,19,19.000,0.475,6.080,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"154726",""
"S","S19980305-154804",19980305,1,0,"","4404.01434","","","","POS-1ST","",
"DC 123-456",""," B 0 ","9455","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,0.068,0.550,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"155715",""
"S","S19980305-155737",19980305,1,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," 000 ","9433","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,.012,.320,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"155721",""
"S","S19980305-160757",19980305,1,0,"","1985.00026","","","","POS-1ST","",
"DC 123-456",""," 000 ","9417","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,.043,.320,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"160800",""
"S","S19980305-160809",19980305,1,0,"","1985.00026","","","","POS-1ST","",
"DC 123-456",""," 000 ","9417","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,.043,.320,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"160806",""
"S","S19980305-163208",19980305,1,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," 000 ","9455","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,.012,.320,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"163206",""
"S","S19980305-163217",19980305,1,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," 000 ","9455","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,.012,.320,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"163210",""
"S","S19980305-170533",19980305,1,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," B 0 ","9482","2","1",0,0,"00000-0000","20000-0000",
0,0,19,19.000,1.178,10.450,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"171402",""
"S","S19980305-170533",19980305,2,0,"","9999.99999","","","","POS-1ST","",
"DC 123-456",""," 000 ","9482","2","1",0,0,"00000-0000","20000-0000",
0,0,1,1.000,.068,.550,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.000,0,"",0,1,0,0,"171411",""
Program: TBDevice.EXE (Other) Data File: Can be any name File Type: Variable Length (comma-delimited) Neopost File Layout Field Name Description ----- ---------------- --------------------------------------------- 1 File # Converted as Client ID (has "." separator) 2 Dept/Acct Name Ignored 3 Pieces Converted as Units 4 Rounded Weight Ignored 5 Actual Weight Ignored 6 Shipping Charge Ignored 7 Service Charge Ignored 8 Total Shipping Charge Ignored 9 Handling Charge Ignored 10 Total Charge Converted as Amount Note: Because Neopost does not export a date field, all transactions will be imported using the date of the Import. Sample Neopost data file: 1.01,,3,3.000,0.148,2.370,0.00,2.370,0.000,2.370 100.00,,7,8.000,4.074,16.020,0.00,16.020,0.000,16.020 101.00,,4,4.000,1.193,5.400,0.00,5.400,0.000,5.400 102.00,,3,3.000,0.187,1.410,8.50,9.910,0.000,9.910 103.00,,13,13.000,3.037,14.910,21.25,36.160,0.000,36.160 123.45,,10,10.000,3.341,14.940,0.00,14.940,0.000,14.940