This import brings in the second and subsequent Rate Code information for a Plant Item. It will populate the 'Plant Costs' tab.
The file has to have the following 6 columns:
Column | Name | Description | Data Type | Length | Required | Validated |
1A | Plant Code | Plant Code | Text | 20 | -1 | Yes |
2B | Rate Code | Rate Code | Text | 10 | -1 | Yes |
3C | Cost Rate | Cost Rate | Number | Null | 0 |
|
4D | Sell Rate | Sell Rate | Number | Null | 0 |
|
5E | Work Code | Cost Work Centre Code | Text | 10 | 0 | Yes |
6F | Activity Code | Cost Activity Code | Text | 10 | -1 | Yes |
Notes:
Rate Code is validated against the Rate Code Maintenance. The combination of Plant Code & Rate Code must not already exist.
Cost Work Centre is not mandatory but if entered must be a valid Work Centre
Activity Code is validated against the Activities master list.
The following is an example of a spreadsheet for the Plant Rate Code Import.