Skip to main content

Knowledge Center

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.