Skip to main content

Knowledge Center

Load Article archive (ART) - INP/14542

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.

It is recommended to use the Load article purchase prices to load Purchase prices. If you still decide to use this load for it, then you need to check Load article purchase prices to see which field are required.

Import articles from file. New articles will be created, or existing updated if IT given in file. Mandatory fields are IT or PART and MFR. Articles that does not exist will be created.

Initial load of the Article archive

To be able to identify and update an article at a later time, the initial load must contain values in the fields PART, MFR, and the field CREATE must be set to YES. It is also recommended to add a value to the field EXTID.

Update of the Article archive

To identify the article to be updated, the load file must contain a value in the field IT or a combination of the fields PART+MFR.

Field

Required

Length

Example

Description

CREATE

Y*

3

YES

If you want to create a new article you have to set this value to YES. If blank, the system will try to update existing articles.

Existing article will be found by exact match on:

a) IT  (RamBase internal article ID)

b) Part + MFR

* Required if the article does not exist in the ART archive.

IT

Y*

7

#100000

Internal typenumber is a unique ID that identifies the article. This will be assigned by RamBase when a new article is created.

* IT or PART+MFR must be present in the file.

ST

Y

1

4

Status of the article. Legal values: 2 – new, 3 – For approval, 4 – Ordinary article, 5 – To be revised, 6 – On hold, 7 – Announced EOL (end of life), 9 – Obsolete / discontinued.

PART

Y *

35

190-489-A1

Article name.

* IT or PART+MFR must be present in the file.

MFR

Y *

20

ACME

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

* IT or PART+MFR must be present in the file.

EXTID

External ID to identify Article/Product from the customer's system.

LOC

Y **

3

AUT

Warehouse code for MINSTOCK quantity and REORDERQTY and STOCKLOC.

LOC must match one of the values predifined in the LOC register. LOC must be active (St:4).

**If LOC has a value, MINSTOCK or STOCKLOC must have a value too.

MINSTOCK

Y **

8

Minimum stock value for the given article connected to the given location (LOC).

**If this field has a value, the field LOC must have a value too.

REORDERQTY

Y **

8

Re-order quantity for given location (LOC). Must be an integer value.

**If this field has a value, the fields LOC and MINSTOCK must have a value too.

STOCKLOC

Y**

Preferred inhouse stock location for given location (LOC).

**If this field has a value, the field LOC must have a value too.

TEXT

110

Cable 0,5 meters

Article description.

URL

110

www.sites.no

Link to a page on the internet. (URL = Uniform Resource Locator)

PURCHASELEADTIME

8

12

Standard Purchase lead time could be added in Purchase on Product (ART). Valueis delivery time from Supplier, in days.

SALESLEADTIME

8

12

Sales lead time could be added in Main Data on Product (ART). Value is number of days used when calculating assignment window.

SUPLEADTIME

8

12

Supplier lead time could be added in Part Supplier Info pop-up on product (ART).

PACK

8

Box

Package type. "Box", "Reel", .....

GR1

20

Cable

Field used to support local classification purposes. Free text. Inherited to orders, invoices etc.

Can be blanked by using the value <BLANK>.

GR2

20

HDMI

Field used to support local classification purposes. Free text. Inherited to orders, invoices etc.

PACKQTY

10

10

Quantity per package.

SUBQTY

10

5

Sub-Quantity, inner pack.

ORIGIN

2

JP

Country of Origin. Stored as two-character code according to the ISO 3166 standard.

WEIGHT

12

0.5

Weight per component - in kilogram.

CLASS

2

P

Classification: See topic Define class on a new article in RamBase Knowledge center.

MSG

55

For Test Only !

Message on the article.

Can be blanked by using the value <BLANK>.

MINGM

10

90

Minimum allowed gross margin in percent (%).

FRPCT

Y*

2.5

Freight percent (%) on products in the product structure cost table. *If only value in this file, and the IT# - it will not be updated. If so, PART should be included.

REQUIRESERIALNOTOSHIP

1

Legal values: 1 / 0     1=YES, 0=NO

If set to YES:

Serial numbers have to be registered on CSA, SRT, and STW before shipping parts.

REQUIRESERIALNOTORECEIVE

0

Legal values: 1 / 0     1=YES, 0=NO

If set to YES:

Serial numbers have to be registered on SSA before the goods can be received.

INCLUDEINLCMPARTLIST

1

Legal values: 1 / 0     1=YES, 0=NO

If set to YES:

Serial numbers will be included in part list in LCM.

AUTOCREATESERIALNOFORLCM

0

Legal values: 1 / 0     1=YES, 0=NO

If set to YES:

Serial numbers will automatically be created for LCM in a production.

*According to setup in the fields SNOPREFIX and SNOCNT.

AUTOCREATESERIALNOFORSPO

1

Legal values: 1 / 0     1=YES, 0=NO

If set to YES:

Serial numbers will automatically be created for LCM in a production.

*According to setup in the fields SNOPREFIX and SNOCNT.

TARIC

20

49.01.9909

Local custom taric code for non EU-countries.

EUTARIC

20

8471.60.40.00

Customs taric code for EU-countries.

EAN

35

4030661359847

European article numbering. US: UCC Uniform Code Council (barcode)

RANK

1

ABC ranking. Free text field.

WARRANTY

6

Warranty time in months.

PURCHCUR

Y*

SEK

Purchase currency.

*Required when loading purchase prices.

PURCHPRICE

Y*

0.15

Purchase price in purchase currency.

*Required when loading purchase prices.

PURCHQTY

Y*

10

1

Purchase quantity.

*Required when loading purchase prices.

PURCHTO

2015.01.20

Purchase price valid to date.

SUPPART

30

SP 101963

Supplier's internal part number.

SUP

Y*

SUP/123456

RamBase supplier number. If SUPPART is filled, SUP or SUPEXTID must also have a value.

*Required when loading purchase prices.

SUPEXTID

Legacy system supplier identification. If SUPPART is filled, SUPEXTID or SUP must also have a value.

SUPMINQTY

15

Minimum order quantity for this supplier.

UNIT

pcs

Trade unit for the part.  Values like "pcs", "mm", "kg"..

The UNI archive must be defined before the ART load.

All trading (purchase, stock, sales, ...) must follow the

UNIT of the article.

PRODLINE

A production line. Used for articles of Class = K* to control which internal production-"supplier" to use for work orders and which production line that is default for the product.

If PRODLINE is used, enter the PRODLINE name (For example: RENTAL) and the article is associated with the specified PRODLINE.

If Manufacturing area is used,enter the MAA name (ex: PRODUCTION) and the article will be associated with the specified manufacturing area code.

PALLETQTY

10

Quantity per pallet.

DESCR

Long description

Detailed description for the request.

CODE

1010011000

Classification Code: Reference to the Classification Management Code (WGR). Value concatinated from values of Code0 – Code6.  CODE is inherited to orders, invoices ... .

CODE0

2

10

If CODE0 is missing in the file, the default will be 10 (or chosen from the CSV Default Product Classification Group if this is activated and has another value than 10).

CODE1

4

1001

CODE2

4

1000

CODE3

4

1001

CODE4

4

CODE5

4

CODE6

4

PURCHGROUP

Used to define certain buyers/groups for specific articles. Allows filtering by this in the purchase program (PUR).

Value must match predefined purchase group in PUG register.

SERVICEID

ART/#101234

ID to the main service article (Class = KM) for the product.

SERVICEDELETE

1

Y

If "Y": Main service article will be deleted from the product.

SERVICEMAIN

1

Y

"Y" if the given SERVICEID shall be main service.

RENTAL

Y/YES

If value = "Y" or "YES" and CREATE = "YES":

A rental "part" (Class = R) will be created for the

article.

RENTALPRICE

25.00

Rental price for the part, in currency given by RENTALCUR.

RENTALCUR

NOK

Rental price currency.

REVISION

1 or A1 or..

Article revision number.

ISEXTERNALLYMANUFACTURED

1

Y

True if the article is manufactured externally. Only valid for articles with CLASS:K*.

METGROUP

Group name for measuring Tools, used when creating new tool for a Class WT part.

HEIGHT

12

0,5

Height per component.

WIDTH

12

0,5

Width per component.

LENGTH

12

0,5

Length per component.

VOLUME

12

0,5

Volume per component.