Technical Specification

When you click the Export button in the  Menu screen, then following sample data will be in your export file.

"D","1","2563","28082006","107","","IN","16395",0,0,2,0,0,1
"D","2","2563","28082006","107","","IN","15692",0,0,3,0,0,2
"D","3","2563","31082006","","","IN","15692",0,0,25,0,0,3
"D","4","2563","03092006","","","IN","15692",0,0,1,0,0,4
"D","5","2563","04092006","","","IN","15692",0,0,1,0,0,5
"D","6","2563","05092006","","","IN","15692",0,0,1,0,0,6
"D","7","2563","05092006","602","","IN","16395",0,0,2,0,0,7
"D","8","2563","05092006","602","","IN","15692",0,0,1,0,0,8
"D","9","2563","05092006","602","","IN","16956",0,0,3,0,0,9
"D","10","2563","06092006","","","IN","15692",0,0,1,0,0,10
"D","11","2563","06092006","6989","","IN","15692",0,0,1,0,0,11
"D","12","2563","07092006","","","IN","15692",0,0,1,0,0,12
"D","13","2563","08092006","","","IN","15692",0,0,1,0,0,13
"D","14","2563","09092006","","","IN","15692",0,0,1,0,0,14
"D","15","2563","12092006","6987","","IN","15692",0,0,3,0,0,15
"D","16","2563","12092006","6987","","IN","16956",0,0,3,0,0,16
"D","17","2563","12092006","6987","","IN","16395",0,0,4,0,0,17
"D","18","2563","12092006","6988","","IN","15692",0,0,9,0,0,18
"D","19","2563","12092006","6988","","IN","16395",0,0,1,0,0,19
"D","20","2563","12092006","6988","","IN","16956",0,0,4,0,0,20
"D","1","3269","24082006","6987","","IN","16395",0,0,56,0,0,21
"D","2","3269","24082006","6987","","IN","16956",0,0,6,0,0,22
"D","3","3269","24082006","6987","","IN","15692",0,0,6,0,0,23
"D","4","3269","24082006","6987","","IN","15692",0,0,6,0,0,24
"D","5","3269","24082006","6987","","IN","15692",0,0,5,0,0,25
"D","6","3269","24082006","6987","","IN","15692",0,0,2,0,0,26
"D","7","3269","24082006","6987","","IN","16395",0,0,8,0,0,27
"D","8","3269","24082006","6987","","IN","16956",0,0,5,0,0,28
"D","9","3269","24082006","6987","","IN","15692",0,0,5,0,0,29
"D","10","3269","24082006","6987","","IN","16956",0,0,6,0,0,30
"T",2006928929,30

 

Column Definitions

Column
1 Set to D (meaning Detail on all except last line.  Set to T meaning Trailer on last line of file)
2 Line number within Order
3 Glanbia Account Code
4 Delivery Date(must be ddmmyyyy)
5 Delivery Docket number
6 Other ref number (optional)
7 Docket Type  (IN = Invoice, RT = Returns)
8 Glanbia Material Code
9 Pack Size
10 Number of packs delivered
11 Number of split units delivered
12 Number of packs returned
13 Number of split units returned
14 Sequence number within file
Trailer Record
1 Set to T
2 File Sequnce number
3 Total number of records in file