IC Items

This lists functions related to Items within the system.

Update Item Number Using MySQL:

These are all the tables that include an item number field

TABLE   FIELD

iccosts sitemnumber

icentrylines sitemnumber

icitemlocations sitemnumber

icitemprices sitemnumber

icitems sitemnumber

icitemstatistics sitemnumber

icpoinvoicelines sitemnumber

icpolines sitemnumber

icporeceiptlines sitemnumber

ictransactions sitemnumber

icvendoritems sitemnumber

invoicedetails sItemNumber

labortypes sItemNumber

orderdetails sItemNumber

THIS IS A SAMPLE SET OF UPDATE STATEMENTS TO CHANGE AN ITEM NUMBER:

UPDATE iccosts set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icentrylines set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icitemlocations set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icitemprices set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icitems set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icitemstatistics set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icpoinvoicelines set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icpolines set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icporeceiptlines set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE ictransactions set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE icvendoritems set sitemnumber = replace(sitemnumber, '_', '') WHERE INSTR(sitemnumber, '_') > 0;

UPDATE invoicedetails set sItemNumber = replace(sItemNumber, '_', '') WHERE INSTR(sItemNumber, '_') > 0;

UPDATE labortypes set sItemNumber = replace(sItemNumber, '_', '') WHERE INSTR(sItemNumber, '_') > 0;

UPDATE orderdetails set sItemNumber = replace(sItemNumber, '_', '') WHERE INSTR(sItemNumber, '_') > 0;