Stock items may be imported as required (refer to the section of this document for full details):
|
Field Name |
Size |
Mandatory |
Comments |
|
Stock Number |
20 |
Y |
The (K212 Finance) item number |
|
Stock Group |
2 |
Y |
The stock group. This will be validated against the Commodity Codes in Code Management |
|
Buyer Code |
4 |
Y |
The buyer responsible for this item. This must be an active buyer (buyer batch code assigned to a K212 Finance user) |
|
Sales Tax Code |
1 |
Y |
The tax code for the item. This must be a valid tax code in the tax settings |
|
Extra Rate Profile 1 |
1 |
|
If there are other charge codes or discount codes defined in the tax settings, these may be referenced here |
|
Extra Rate Profile 2 |
1 |
|
If there are other charge codes or discount codes defined in the tax settings, these may be referenced here |
|
Extra Rate Profile 3 |
1 |
|
If there are other charge codes or discount codes defined in the tax settings, these may be referenced here |
|
Purchase Measure |
10 |
Y |
The unit of measure for the item |
|
Issue Measure |
10 |
|
Not applicable |
|
Catalog Description |
2000 |
|
The catalogue description |
|
Brand Description |
1000 |
|
The item's brand |
|
E.O.Q. |
11 |
|
The economic order quantity - reference only |
|
Last Purchase Price |
13 |
|
The last purchase price - reference only |
|
This Issue Price |
13 |
|
Not applicable |
|
Next Issue Price |
13 |
|
Not applicable |
|
Issue Date |
8 |
|
Not applicable |
|
Date Received |
8 |
|
The last date that the item was received - reference only |
|
Product Description |
2000 |
Y |
The product description for the item |
|
Work Management Type |
1 |
|
Work management type - if integrating a 3rd party work management system, this may be significant |
|
Vendor Number |
10 |
Y |
The vendor number from whom this item will be ordered by default (at shopping cart time) |
|
Tender Number |
12 |
|
The tender number for this item (if applicable - reference only) |
|
Tender Price |
13 |
Y |
The price for this item - when the item is selected in the shopping cart (and elsewhere) this is the price that will be used |
|
Tender Expiry Date |
8 |
Y |
The tender expiry date. Once this date is in the past, the stock item will cease to show up in shopping cart stock searches |
|
Internal notes |
255 |
|
Notes entered here will display to the user when the item number is referenced (e.g. shopping cart, purchase order entry) |