Knowledge Center

AUTOCREATESERIALNOFORLCM

1

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.

AUTOCREATESERIALNOFORSPO

1

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.

BLOCKEDFORPRODUCTION

1

BLOCKEDFORPURCHASE

1

BLOCKEDFORSALE

1

BLOCKEDFORSHIPPING

1

CLASS

2

P

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

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

Code for technical classification of products. Will be generated according to input entered in the WGR.

CODE2

4

1000

Code for technical classification of products. Will be generated according to input entered in the WGR.

CODE3

4

1001

Code for technical classification of products. Will be generated according to input entered in the WGR.

CODE4

4

1001

Code for technical classification of products. Will be generated according to input entered in the WGR.

CODE5

4

1002

Code for technical classification of products. Will be generated according to input entered in the WGR.

CODE6

4

1000

Code for technical classification of products. Will be generated according to input entered in the WGR.

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.

CUS

TEM-NO:CUS/100004

CUSEXTID

CUSPART

1234

Customers Internal Part Number.

DESCR

Long description

Detailed description for the request.

DUTYPAID

EAN

35

4030661359847

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

ENVTAXPAID

EUDUTYPAID

EUTARIC

20

8471.60.40.00

Customs taric code for EU-countries.

EXTERNALREFERENCE

John Doe

EXTID

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

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.

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.

GR3

Field used to support local classification purposes.

HEIGHT

12

0,5

Height per component.

IGNOREINSOP

1

INCLUDEINLCMPARTLIST

1

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

If set to YES:

Serial numbers will be included in part list in LCM.

ISEXTERNALLYMANUFACTURED

1

Y

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

ISMANUFACTUREDBATCHES

ISNOTUSINGASSIGNMENTS

1

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.

LENGTH

12

0,5

Length per component.

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.

MAANAME

Manufacturing area name

METGROUP

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

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.

MFRPART

MINGM

10

90

Minimum allowed gross margin in percent (%).

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.

MPNMFR

1

1

MSG

55

For Test Only !

Message on the article.

Can be blanked by using the value <BLANK>.

MSL

1

1

ORIGIN

2

JP

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

PACK

1

Box

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

PACKQTY

10

1

Quantity per package.

PALLETQTY

10

Quantity per pallet.

PART

Y *

35

190-489-A1

Article name.

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

PRODGROUP

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.

PRODUCEINMULTIPLEOF

5

1

PRODUCTIONSTARTEXPEDITEDAYS

1

1

PURCHASELEADTIME

8

12

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

PURCHCUR

Y*

SEK

Purchase currency.

*Required when loading purchase prices.

PURCHFROM

2014.11.201447

Purchase price valid from set date.

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.

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

1

Purchase price valid to date.

RANK

1

ABC ranking. Free text field.

RENTAL

Y/YES

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

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

article.

RENTALCUR

NOK

Rental price currency.

RENTALPRICE

25.00

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

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.

REPLACEBEFOREPRODUCTION

1

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.

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.

REVISION

1 or A1 or..

Article revision number.

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.

SERVICEDELETE

1

Y

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

SERVICEID

ART/#101234

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

SERVICEMAIN

1

Y

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

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.

STOCKLOC

Y**

Preferred inhouse stock location for given location (LOC).

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

SUBQTY

10

5

Sub-Quantity, inner pack.

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.

SUPLEADTIME

8

12

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

SUPMINQTY

15

Minimum order quantity for this supplier.

SUPPART

30

SP 101963

Supplier's internal part number.

SUPPREFERRED

YES

Flag that when is set to YES tells that the supplier for that record is a preferred supplier for that article.

TARIC

20

49.01.9909

Local custom taric code for non EU-countries.

TEXT

110

Cable 0,5 meters

Article description.

UDF

UDF_NameOfCustomField

Load customfields, created in CUSTOMFIELDS application

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.

URL

110

www.sites.no

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

USEITASPART

YES

This field is only for creating new products. When set to YES, product id is used as name. When set to NO , PART is used as name.

VOLUME

12

0,5

Volume per component.

WARRANTY

6

Warranty time in months.

WASTAGEPCT

4

Quantity wastage percentage, adder to the kit quantity for a part.

WEIGHT

12

0.5

Weight per component - in kilogram.

WIDTH

12

0,5

Width per component.