Comma-Separated Values (CSV) files are files with data separated by commas. CSV processing is slightly slower than fixed-length processing.
Numbers are displayed without commas as numeric digits. The number of decimal places required for a particular field is illustrated by the examples below. Do not put a value in the place of a non-existent value.
Strings are displayed as alphanumeric characters and can be enclosed with double quotes ("). Double quotes cannot be contained within the string itself. If quotes are required, use single quotes. For a non-existent value, you can use two double quotes side by side (""), but this is not required.
Dates are displayed in the format MM/DD/YYYY. MM is a two-digit month. DD is a two-digit date. YYYY is a four-digit year. Do not put a value in the place of a non-existent value.
The following is a list of fields required in the order they should appear for each line.
|
Field |
Type |
Max |
Example |
|
Account |
String |
15 |
05030 |
|
Units Quantity |
Number |
15 |
10000.0000 |
|
Organization |
String |
20 |
1.2.210 |
|
Organization Abbreviation |
String |
6 |
210 |
|
Project |
String |
30 |
1010.003.20 |
|
CLIN |
String |
10 |
NY LI |
|
Price Catalog |
String |
10 |
COOK |
|
Item |
String |
30 |
CHOC-D |
|
Item Revision |
String |
3 |
1 |
|
Sales Tax Code |
String |
6 |
VA |
|
Usage Date |
Date |
10 |
07/31/2011 |
|
Transaction Description |
String |
30 |
Test |
|
Project Abbreviation |
String |
6 |
511101 |
|
Reference Number 1 |
String |
20 |
100 |
|
Reference Number 2 |
String |
20 |
200 |
|
User Defined Units Amount 1 |
Number |
15 |
1.99 |
|
User Defined Units Amount 2 |
Number |
15 |
2.99 |
|
User Defined Units Description |
String |
30 |
Test |
|
User Defined Units Date |
Date |
10 |
07/31/2011 |
|
Source Project |
String |
30 |
1010.003.20 |
|
Notes |
String |
254 |
Use 'quotes.' |
"05030",10000.0000,"1.2.210","210","1010.003.20","","COOK","CHOC-D","1","VA",07/31/2011,"Test.","","100","200",1.99,2.99,"Test.",07/31/2011,"1010.003.20","Use 'quotes.'"
Fixed-Length files are files with data positioned in a set range of columns for each particular field. For a non-existent value, put spaces in the range of columns for that field. Fixed-length processing is slightly faster than CSV processing.
Numbers are displayed without commas as numeric digits. The number of decimal places allowed for a particular field is illustrated by the examples below.
Strings are displayed as alphanumeric characters. Unlike CSV files, double quotes can be used.
Dates are displayed in the format MM/DD/YYYY. MM is a two-digit month. DD is a two-digit year. YYYY is a four-digit year.
The following is a list of fields required in the order they should appear for each line.
|
Field |
Type |
Column Size |
Range |
Example |
|
Account |
String |
15 |
1 - 15 |
05030 |
|
Units Quantity |
Number |
15 |
16 - 30 |
10000.0000 |
|
Organization |
String |
20 |
31 - 50 |
1.2.210 |
|
Organization Abbreviation |
String |
6 |
51 - 56 |
210 |
|
Project |
String |
30 |
57 - 86 |
1010.003.20 |
|
CLIN |
String |
10 |
87 - 96 |
NY LI |
|
Price Catalog |
String |
10 |
97 - 106 |
COOK |
|
Item |
String |
30 |
107 - 136 |
CHOC-D |
|
Item Revision |
String |
3 |
137 - 139 |
1 |
|
Sales Tax Code |
String |
6 |
140 - 145 |
VA |
|
Usage Date |
Date |
10 |
146 - 155 |
07/31/2011 |
|
Transaction Description |
String |
30 |
156 - 185 |
Test |
|
Project Abbreviation |
String |
6 |
186 - 191 |
511101 |
|
Reference Number 1 |
String |
20 |
192 - 211 |
100 |
|
Reference Number 2 |
String |
20 |
212 - 231 |
200 |
|
User Defined Units Amount 1 |
Number |
15 |
232 - 246 |
1.99 |
|
User Defined Units Amount 2 |
Number |
15 |
247 - 261 |
2.99 |
|
User Defined Units Description |
String |
30 |
262 - 291 |
Test |
|
User Defined Units Date |
Date |
10 |
292 - 301 |
07/31/2011 |
|
Source Project |
String |
30 |
302 - 331 |
1010.003.20 |
|
Notes |
String |
254 |
332 - 585 |
Use 'quotes.' |
05030 10000.0000 1.2.210 210 1010.003.20 COOK CHOC-D 1 VA07/31/2011 Test. 100...