Skip to main content

Knowledge Center

Load Article sales prices - INP/14540

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 *

#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.

MFR

20

ACME

Manufacturer. The manufacturers have to be registered in the Manufacturer archive (MFR) in RamBase prior to the Article load.

SALESCUR

Y

NOK

Selling currency.

SALESQTY

Y**

5

Quantity step for sales prices. ** Can not have a value if SALESPRICEGROUPAGREEMENT has a value.

SALESPRICE

8.6

Salesprice in the currency defined in SALESCUR, and the quantity defined in SALESQTY.

SALESGM

80

Sales gross margin in percent (%).  Will be calculated if SALESPRICE is set.

SALESFROM

2005.06.200523

Sales price valid from set date.

PLINO

100000

PLINAME

Price list name.