Skip to main content

Knowledge Center

Load Goods reception (SSA) STOCKQTY - INP/67645

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.

CUSTOMER

Y*

Customer account number for use if DOCTYPE=CUSOWNED (format: TEM-NO:CUS/100000).

* Either CUSTOMER or CUSTOMEREXTID must be present in the file if DOCTYPE=CUSOWNED is used.

CUSTOMEREXTID

Y*

Value in EXTID field on Customer can be used to find the right Customer, if DOCTYPE=CUSOWNED.

This information will not be used if CUSTOMER is given in the file.

*Either CUSTOMEREXTID or CUSTOMER must be present in the file if DOCTYPE=CUSOWNED is used.

EXTID

BO-Fantomet

ID for the stockreference in old system.

DATE

Y

YYYY.MM.DD

DOCTYPE

For example CUSOWNED. Different DOCTYPE can be set. If DOCTYPE=CUSOWNED is set, the file must contain CUSTOMER or CUSTOMEREXTID.

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.

STOCKLOCATION1

The placement of the goods in stock.

QTYSTOCKLOCATION1

Quantity of goods in stock.

STOCKLOCATION2

QTYSTOCKLOCATION2

STOCKLOCATION3

QTYSTOCKLOCATION3

STOCKLOCATION4

QTYSTOCKLOCATION4

STOCKLOCATION5

QTYSTOCKLOCATION5

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.

DEPNO

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.

HEATNO

A heat number is an identification coupon number that is stamped on a material plate after it is removed from the ladle and rolled at a steel mill