Load CUSPART
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 |
|
PART |
Y * |
35 |
190-489-A1 |
Article name. |
|
MFR |
Y * |
ACME |
Manufacturer. The manufacturers have to be registered in the Manufacturer archive (MFR) in RamBase prior to the article load. |
|
|
CUSPART |
Y ** |
24 |
290631 |
Customer's internal part number. **If CUSPART has a value, CUS or CUSEXTID must have a value too. |
|
CUS |
Y ** |
CUS/123456 |
RamBase customer number. **If CUSPART has a value, CUS or CUSEXTID must have a value too. |
|
|
CUSEXTID |
Y ** |
Legacy system customer identification. **If CUSPART has a value, CUS or CUSEXTID must have a value too. |
||
|
CREATE |
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 If you put YES in this field, a new PART will be created in St=0 with default settings for MFR and CLASS. This article will be updated with given CUSPART information. |