Load Product Structures (PDMIMPORTTOPRODUCT) - INP/73720
PDMIMPORTTOPRODUCT can contain products, operations, materials/parts, phantom Kits and added costs. There is no fixed order for these records, but each type must point to the PRODUCT it belongs to.
Only .csv and .txt file extensions are accepted.
Parameter setup
To access the company settings from the RamBase menu click on Admin and click on Overview. Select Settings and then click on Company settings. The settings listed below are available from module list. Select Production, and then Production.
PDMImportCreateNewProduct = ‘ON' - New product is created if not found in RamBase.
PDMImportDefaultManufacturerID = ‘MFR/nnnn’ - Manufacturer for the product if this is not specified in the file.
PDMImportCreateNewPart = ‘ON’: - New part/material is created if not found in RamBase.
PDMImportOperationNo = ‘nnnnnn’ - The operation that is added to a new product structure if the file does not include operations.
PDMImportActivateNewStructure = 'ON’ - The updated/loaded product structures are activated to Status 4, new valid product version.
Default Material for PDM Import = ‘ART/#nnnnnn’: The ‘to be replaced’ part that is used instead of new part / material in the file if new part/material shall not be created by the PDM input.
Product records and fields
The records with type = PRODUCT, used to create or update products and sub products for Class = K* articles. Some of these fields are also required at material, operation and added cost lines to identify the product they belong to.
Column (field) | Mandatory | Legal value/example | Description |
|---|---|---|---|
ISBATCHPRODUCTION | 0 or 1 | ||
KITSTATUS | 2 or 1 | Status of imported KIT. Default value is 2. Can also be 1. | |
MAANAME | YES | PRODUCTION | Logical manufacturing area |
OPERATIONSINCLUDED | YES | 0 or 1 | 1' states that operations are included in the file so the load of the structure will depend on that. ‘Blank’ or ‘0’: the load will select the default operation specified in setting: 'PDMImportOperationNo’. |
PRODLINE | Yes | PRODUCTION | Manufacturing area (logical). |
PRODUCTCLASS | YES | K, KA, KS | The class of the product |
PRODUCTGR1 | E.g. ‘valves’ | Product grouping fields, value is copied to transactions for the product. | |
PRODUCTGR2 | E.g. ‘ball valves’ | Product grouping fields, value is copied to transactions for the product. | |
PRODUCTIT | YES (If PRODUCT is not given) | #123456 | Unique RamBase Id for existing product. |
PRODUCTMSG | Only for export | Message that is set at the product, visible to sales and procurement. | |
PRODUCTREVISION | Product revision number | ||
PRODUCTTEXT | High class valve | The product description | |
PRODUCTUNIT | YES | Pcs, kg | The measurement unit for the product |
PRODUCTWEIGHT | 1.023 | Product net weight in kg | |
PRODUCT | YES (If PRODUCTIT is not given) | Main product A-1 | The product name (Part field in ART archive). |
TYPE | YES | PRODUCT | Record type identifier. Product means that the record is a product record. |
PRODUCTNOTCHANGED | 0 | Set to 0, or leave empty if product should be changed. Set to 1 if product should not be changed. | |
VERSIONFILENAME | E.g. ‘DRAWING.PDF’ | The file name for the drawing to be mapped to the new version. The drawing can be loaded to the file archive in RamBase before or after the PDM load. The file must have module = PDM. | |
VERSIONNAME | YES | Added quality control | Short description for the new product structure version. The structure will not be updated correctly if there are no valid (ST 4) product structures for each of class K* items in the product. |
VERSIONNOTE | Long text | Text area field containing a more detailed description of the new version that will be added. | |
VERSIONOPERATORINFO | Free text | Text that will show to operator at all operations in the routing. |
Operation records and fields
The records with type = OPERATION are optional and will be ignored if the product record fields OPERATIONSINCLUDED has value ‘0’ or ‘blank’. In that case, the operation specified in the setting 'PDMImportOperationNo’ will be included instead.
Column (field) | Mandatory | Legal value/example | Description |
|---|---|---|---|
OPERATIONINFO | Remember to… | Text that will show to operator at this specific operation in the routing. | |
OPERATIONNO | YES | 100134 | Operation number (OPR) in RamBase. |
OPNO | YES | 10 | Operation sequence number. |
PONOTE | Note to supplier | Only applies to external operations. The text in PONOTE will then be copied to the Note field at the SPO item for external work. | |
POSTTIME | *1 | 0.5 | The work time per produced unit. Value in decimals, 1.5 h 1h 30m. |
PRETIME | *1 | 1 | The work time per produced unit. Value in decimals, 1.5 h 1h 30m. |
PRODUCTIT | YES (If PRODUCT is not given) | #123456 | Unique RamBase Id for existing product. |
PRODUCT | YES (If PRODUCTIT is not given) | Main product A-1 | The product name (Part field in ART archive) |
QUEUETIME | 48 | The queue time per produced unit, before next operation can be started. Value in decimals, 1.5 h 1h 30m. | |
TIME | *1 | 1.5 | The work time per produced unit. Value in decimals, 1.5 h 1h 30m. |
TYPE | YES | OPERATION | Record type identifier. OPERATION means that the record is an operation record. |
*If operations are defined in the file, then at least one of the fields TIME/PRETIME/POSTTIME must have a value.
Material/part records and fields
The record with type = MATERIAL for materials, parts and sub products that are to be included in the bill of materials for the new product revision/version. If no operations were defined, then parts will be added to the default operation.
Column (field) | Mandatory | Legal value/example | Description |
|---|---|---|---|
ACCOUNT | 100234 | Supplier account for the UNITCOST. Can be an ‘internal’ supplier if the supplier is not known, must be a supplier that is specified with the company currency as one of the currencies. | |
CLASS | YES | P, M, C, Z, K, KA, KS | The material/part class. |
FILENAME | Material1-1_1 | The file name for the drawing to be mapped to the new material/part revision. The drawing can be loaded to the file archive in RamBase before or after the PDM load. The file must have module = PDM. | |
INCLUDEINLCMPARTLIST | ‘0’ or ‘1’ or blank | ‘1’ = this material/part will be automatically added to the product units trace list. | |
IT | YES (If PART is not given) | The unique RamBase Id (IT) for existing material/part. | |
MFR | Siemens | If MFR is given in the file and IT is not given: ART search for match on material/part will use input fields PART and MFR to find IT from existing ART in RamBase. The job will search for match on PART if neither IT or MFR is given in the file. | |
MSG | This part is… | Message that is set at the part, visible to sales and procurement. | |
PART | YES (If IT is not given) | Material 1 | The material/part name (Part field at ART). |
PRODUCT | YES (If PRODUCTIT is not given) | Main product A-1 | The product name (Part field in ART archive). |
QTY | YES | 2 | Material/part quantity to be used per product. |
REVISION | 1.1 | The material/part revision number, alphanumeric. | |
TEXT | Material 1 description | The material/part description. | |
TYPE | YES | MATERIAL | Record type identifier. MATERIAL means that the record is a product/material record. |
UNIT | YES | Pcs, mm … | The measurement unit for the material/part. ‘pcs’ is used if no value is given. |
WEIGHT | 0.125 | The material/part weight per UNIT, in kg. | |
CUSTOMERREF | Customer 123456 | Customer reference number that can later be modified by editing a material (part, material, kit) line in the Product structure that is in edit mode. | |
GR1 | Mechanical | Material/part grouping field, value is copied to transactions for the product. | |
GR2 | Nuts | Material/part grouping field, value is copied to transactions for the product. | |
OPNO | (YES) | 10 | Operation sequence number that the part shall be added to. Mandatory if the product in the file is specified to contain operations. |
POS | A1 | The assembly position of the part. | |
PRODUCTIT | YES (If PRODUCT is not given) | #123456 | Unique RamBase Id for existing product. |
UNITCOST | 23.50 | Purchase price per part unit that can be added for new material/parts. In company currency. May be useful to get a cost indication for the part and the products it is included in. Will be added to new part as purchase price. | |
WASTAGEPCT | 2 | Adder used when allocating material/part to work orders. Value in percentage. | |
WASTAGEQTY | 1.11 | Standard quantity of wastage for product when used in a production work order in this location. |
Added cost records and fields
The records with type = COST used if added cost records are included in the file.
Column (field) | Mandatory | Legal value/example | Description |
|---|---|---|---|
COSTNO | YES | 100103 | The added cost (ADC) number in RamBase. |
ISMATERIALCOST | ‘0’ or ‘1’ or blank | ‘1’: The added cost is included as material cost in the calculated main level costs in the structure. | |
OPNO | 10 | Operation sequence number that the added cost applies to. Will be added to the structure (the KIT) if OPNO = ‘blank’. | |
PRODUCTIT | YES (If PRODUCT is not given) | #123456 | Unique RamBase Id for existing product. |
PRODUCT | YES (If PRODUCTIT is not given) | Main product A-1 | The product name (Part field in ART archive) |
TYPE | YES | MATERIAL | Record type identifier. MATERIAL means that the record is a product / material record. |