We are trying to come up with a set of standards to use to send flat data files to third parties. Can somebody provide feedback on the standards we are leaning towards, or suggest other standards? The rules we have defined are pipe-delimited, .txt extension, header rows included, and an audit record on the first row. The audit record would be flexible, and would contain a record count (first column), and could contain zero, one, or many sums of columns. Here is an example:
3|10.77|12
ID|Product|Cost|Qty
1|Widget|1.12|7
2|Sprocket|2.65|3
3|Gizmo|7.00|2