Load Product structures (BOM) - INP/59506
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.
The order of the loaded structure is given by the value in the field KITOPNO, and the order in the file. It is recommended to put operations first, and then articles (PART). The articles are loaded into the structure, for the corresponding KITOPNO, in the order they are given in the file (top to bottom). It is the value in the field KITOPNO that determines which operation the article belongs to. Operations and articles should be loaded in individual lines, which means that each occurrence in the structure should have a separate line in the file. Nb! The KIT structure will be in Status 1 and must be activated.
Field | Required | Example | Description |
PRODUCTID | Y * | ART/#100752 | IT-number and archive prefix of the article you are building a structure on. *PRODUCTID, PRODUCT or PRODUCTEXTID must be present in the file. |
PRODUCT | Y * | 17,17x1,78 Stang | PART-number of the article your are building a structure on. *PRODUCTID, PRODUCT or PRODUCTEXTID must be present in the file. |
PRODUCTEXTID | Y * | 17,17x1,78 Stang | EXTID of the article you building a structure on. *PRODUCTID, PRODUCT or PRODUCTEXTID must be present in the file. |
KITOPNO | Y | 100 | KIT operation number |
OPERATIONID | Y ** | OPR/100155 | RamBase operation number of operation in KIT with archive prefix. **OPERATIONID, OPERATION or OPERATIONEXTID must be present in the file if an operation is to be added to the structure. |
OPERATION | Y ** | 2037_Ekstern tilvirkning | Operation in the structure. **OPERATIONID, OPERATION or OPERATIONEXTID must be present in the file if an operation is to be added to the structure. |
OPERATIONEXTID | Y ** | 2037_Ekstern tilvirkning | EXTID of the operation. **OPERATIONID, OPERATION or OPERATIONEXTID must be present in the file if an operation is to be added to the structure. |
PARTID | Y *** | #100647 | IT-number for the PART in the structure. ***PARTID, PART or PARTEXTID must be present in the file if an article is to be loaded in the structure. |
PART | Y *** | 12.4962B 316 | PART-number of the PART in the structure. ***PARTID, PART or PARTEXTID must be present in the file if an article is to be loaded in the structure. |
PARTEXTID | Y *** | 12.4962B 316 | EXTID of the PART in the structure. ***PARTID, PART or PARTEXTID must be present in the file if an article is to be loaded in the structure. |
RESOURCEID | Y **** | 100043 | Resource number of the resource in the structure. ****RESOURCEID, RESOURCE or RESOURCEEXTID must be present in the file if a resource is to be added to the structure. |
RESOURCE | Y **** | Resource in the structure. ****RESOURCEID, RESOURCE or RESOURCEEXTID must be present in the file if a resource is to be added to the structure. | |
RESOURCEEXTID | Y **** | EXTID of the resource in the structure. ****RESOURCEID, RESOURCE or RESOURCEEXTID must be present in the file if a resource is to be added to the structure. | |
KITQTY | 2 | Quantity of a PART. If the field is empty in the file, the value will automatically be set to "1" | |
KITTIME | 1 | Time spent during operation/resource | |
KITPRETIME | 0.5 | Time spent prior to operation/resource | |
KITPOSTTIME | 0.1 | Time spent after the operation/resource | |
REVISION | Revision of the product | ||
VERSIONNAME | Baseline | Name of this version of the product | |
VERSIONNOTE | Note to this version of the product. It is possible to insert line breaks by using <br> in this field. | ||
KITPOS | Item specification, e.g., customer's part placement. Optional | ||
WASTAGEPCT | Quantity wastage percentage, adder to the kit quantity for a part. | ||
WASTEAGEQTY | Quantity wasted | ||
OPERATIONINFO | It is possible to insert line breaks by using <br> in this field. | ||
KITEXTCUR | |||
KITEXTPRICE | |||
QUEUETIME | |||
KITSALESPRICE | Sales price set in KIT table in ART given in SYS.CUR, in SAR/STR given in SALESCUR (main level). | ||
KITPONOTE | It is possible to insert line breaks by using <br> in this field. | ||
VERSIONOPERATORINFO | It is possible to insert line breaks by using <br> in this field. | ||
KITLEADTIME |