onInsert.js

import("system.datetime");
import("system.vars");
import("system.db");

var cols = [ "PROD2PRODID"
           , "DEST_ID"
           , "SOURCE_ID"
           , "QUANTITY"
           , "OPTIONAL"
           , "TAKEPRICE" ];

var vals = [ vars.get("$field.UID")
           , vars.get("$field.DEST_ID")
           , vars.get("$field.SOURCE_ID")
           , vars.get("$field.QUANTITY")
           , vars.get("$field.OPTIONAL")
           , vars.get("$field.TAKEPRICE") ];

var colTypes = db.getColumnTypes("PROD2PROD", cols);

db.insertData("PROD2PROD", cols, colTypes, vals);