Load Article purchase prices - INP/15539
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. |