Flat files used with RDC Flat File Processing need to be in a tab-delimited format and contain specific columns of information.
Tab-delimited formatting separates cells of information by one tab and lines of information by one carriage return. Tab-delimited flat files are easy to create:
Create the flat file in a normal Microsoft Excel spreadsheet.
From the Files menu, select Save As to display the Save As window.
In the Save as type field, select Text (Tab delimited) (*.txt).
Include the following columns of information for RDC flat files:
|
Column |
Information |
|
1st column |
The part number to identify the product. Part numbers can be any of the following:
|
|
2nd column |
The product locations defined on the Customer / Vendor Specific Part Numbers screen. This column of data is not required. |
|
3rd column |
The order quantity or levels count for the product in the location. Flat files cannot contain both order and levels quantities. You must create separate flat files for each type of quantity. |
Note: When creating the file, do not label the columns of information. Only include the actual values.
See Also: