Skip to main content

Knowledge Center

Load Goods reception (SSA) NETQTY - INP/67646

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

ACCOUNT

Y*

Supplier account number. The number should match the RamBase supplier number.

*Either ACCOUNT or ACCOUNTEXTID must be present in the file.

EXTID

BO-Fantomet

ID for the stockreference in old system.

DATE

Y

YYYY.MM.DD

LOC

Y

3

VAT

Location: A three character Warehouse Code, identifying a warehouse.

CUR

Y

NOK

QTY

Y

PARTIT

Y*

Part IT.

* PARTIT, PARTEXTID or PART must have a value.

PARTEXTID

Y*

Product/Part ID in old system (Unique).

* PARTIT, PARTEXTID or PART must have a value.

PART

Y*

Servicetime

Part name.

* PARTIT, PARTEXTID or PART must have a value.

MFR

16

MISC

Manufacturer.

PRICE

Y

LOT

QUALITY

Field for Quality information on article, will be copied to Quality field on respective documents.

NOTE

ACCOUNTEXTID

Y*

The supplier's unique ID from the legacy (old) system. To identify the supplier the transaction is to be connected to.

*Either ACCOUNT or ACCOUNTEXTID must be present in the file.

DEPNP

Department Number.

PRJNO

Project Number.

BESTIFUSEDBYDATE

2020.03.30

This is the date this product is best before, but it may also be good enough after this date.

ORIGIN

2

NO

Two-character code (ISO 3166) identifying the default country where the product is produced.

PERIOD

PRODUCTIONDATE

CREATEPO

Y

If a corresponding Purchase order (SPO) should be created

POEXTID

Purchase order ID in old system