SET @Supplier  := "Finger Chips Intl.";
SET @SuppShort := "FCI";
SET @Contact   := "Jackson";
SET @Phone     := "568974521";
SET @EMail     := "supplier1@example.com";
SET @Website   := "http://www.fci.com";
SET @Address   := "Alpha Street,\nGladystown - 654543";
SET @GST       := "8954587411";
SET @DefCurr   := (SELECT `value` FROM `3_sys_prefs` WHERE `name`="curr_default" AND `category`="setup.company");
SET @CredAc    := (SELECT `value` FROM `3_sys_prefs` WHERE `name`="creditors_act" AND `category`="glsetup.purchase");
SET @PayDsctAc := (SELECT `value` FROM `3_sys_prefs` WHERE `name`="pyt_discount_act" AND `category`="glsetup.purchase");

INSERT INTO `3_suppliers` VALUES
(NULL, @Supplier, @SuppShort, @Address, '', @Phone, '', '', @Website, '', @DefCurr, '4', '0', '0', '0', '1', '0', '', @CredAc, @PayDsctAc, '', '0');
SET @SupplierID := (SELECT LAST_INSERT_ID());

INSERT INTO `3_crm_persons` VALUES
(NULL, @SuppShort, @Contact, NULL, @Address, @GST, NULL, NULL, @EMail, NULL, '', '0');
SET @PersonID := (SELECT LAST_INSERT_ID());

INSERT INTO `3_crm_contacts` VALUES
(NULL, @PersonID, 'supplier', 'general', @SupplierID);