Sorry about it!
This is the code I am doing to import the BOM into M_Product_BOM. I have completed all the previous steps and already import into the table ImportBOM. This is the last step on how to get it into M_PRODUCT_BOM. Below is the script.
Insert into M_PRODUCT_BOM (AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, LINE, M_PRODUCT_ID, M_PRODUCTBOM_ID, BOMQTY, DESCRIPTION, BOMTYPE)
select AD_CLIENT_ID,AD_ORG_ID,'Y',UPDATED,CREATEDBY,UPDATED,UPDATEDBY,LINE,'','',QTY,' ',BOMTYPE from ImportBOM
After running this script, there is an error message that "cannot insert null value into M_PRODUCT_BOM_ID. I realised that this ID is auto generated. In this case, how do I insert new records into the M_Product_BOM table? Same case for the import of price, as the coding you gave was to update rather than insert.
Thanks! Appreciate your help!