Load Article archive (ART)
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. |