Column order (header in row 1, data from row 2): REQ. NO., REQ. REC. DT., Accounts Pass Date, INV. NO, INV. DT., Actual INV. DT., INV. QTY., INV. VALUE, DIV, CUSTOMER, LOC, STATE, ZONE, TRANSPORTER NAME, LR. NO., Boxes, ACTUAL DISPATCH DT. — 17 columns, no FREIGHT column. Every field is mandatory; a row missing any of them is skipped and listed below.
Column order (header in row 1, data from row 2): REQ. NO. | INV. NO | FREIGHT — only 3 columns. Each row is matched to an existing record by REQ. NO. + INV. NO., and only that record's FREIGHT value is updated. Rows that don't match any existing record are listed below.