Load article purchase prices
Possible fields to be loaded into RamBase are listed in the Field-column in the following table. The other columns in this table provide additional information about each field.
Field |
Required |
Length |
Example |
Description |
IT |
Y * |
7 |
#100000 |
Internal typenumber is a unique ID that identifies the article. This will be assigned by the system when a new article is created. Format: #123456 * IT, PART or EXTID must be present in the file. |
PART |
Y * |
35 |
190-489-A1 |
Article name. * IT, PART or EXTID must be present in the file. |
EXTID |
Y * |
External ID to identify Articles from the customer's system. * IT, PART or EXTID must be present in the file. |
||
PURCHSUP |
Y ** |
Supplier's account number in RamBase. ** PURCHSUPEXTID or PURCHSUP must be present in the file. |
||
PURCHSUPEXTID |
Y ** |
External ID to identify the supplier from the legacy system. ** PURCHSUPEXTID or PURCHSUP must be present in the file. |
||
PURCHCUR |
Y |
EUR |
Buying currency. |
|
PURCHQTY |
Y |
1 / 100 / ... |
The quantity that the given PURCHPRICE is valid for. |
|
PURCHFROM |
Y |
2015.10.01 |
Purchase price valid from date. It will be set to today's date if it is blank or earlier than today's date. |
|
PURCHPRICE |
Y *** |
10.20 |
Purchase price for the given PURCHQTY. ***Do not load if PURCHCONVERT-fields are used. |
|
PURCHCONVERTUNIT |
Y *** |
Kg |
This is used if the purchase price is given in an other unit than the stock keeping unit. Example: Steel has often stock keeping unit mm, and the supplier gives the price in Kg. *** Do not load if PURCHPRICE is loaded. |
|
PURCHCONVPRICE |
Y *** |
1200.00 |
The price per PurchConvertUnit, e.g. the price per kg of the material. *** Do not load if PURCHPRICE is loaded. |
|
PURCHUNIT |
|
|
UNI/103 |
Specifies the unit this article is purchased in. For ex: pcs (pieces), box, mm (milimeter) kg (kilogram) |
PURCHUNITFACTOR |
Y *** |
0.012 |
This is the factor used to convert Unit to PurchConvertUnit. E.g. How much does 1 mm of the material weigh? The price per stock keeping unit (PurchPrice) is then calculated based on these inputs. *** Do not load if PURCHPRICE is loaded. |
|
PURCHTO |
2015.12.31 |
Purchase price valid to date. |
||
PURCHREF |
A12345 |
Contract number if PURCHCOL = CONTRACT. |