The data file to import Stock Requests must consist of nine (9) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
1 |
Group Number |
Required |
The group number represents one stock required. Each row in the import data file will be added as a request item to a stock request. To group several request items together, they must have the same Group Number, Cost Centre, Request Date, and Requestor. The import data file must be sorted by Group Number to have the request items added to the same request. If this value is not supplied, the request item will not be processed. |
2 |
Cost Centre Code |
Required |
The value for this field will be added to the Cost Centre table if it does not already exist. |
3 |
Request Date |
Optional |
This will default to the date of the import if no value is supplied. |
4 |
Requestor Surname |
Optional |
If the combination of Requestor Surname and Requestor First Name match an existing Staff/Non-supplier, then the Requestor of the Stock Request will be the matching Staff/Non-supplier. |
5 |
Requestor First Name |
Optional |
If the combination of Requestor Surname and Requestor First Name match an existing Staff/Non-supplier, then the Requestor of the Stock Request will be the matching Staff/Non-supplier. |
6 |
Stock Item ID |
Required |
This must be the Stock ID of a valid stock item in Pinnacle. |
7 |
Comments |
Optional |
|
8 |
Quantity Required |
Optional |
This will default to 1 if no value is supplied. |
9 |
Quantity Outstanding |
Optional |
This will default to the Quantity Required if no value is supplied. |