CREATE TABLE gen_invoice_unit (
`id` int(11),
`unit` varchar(50),
`unit_desc` varchar(100)
);

INSERT INTO gen_invoice_unit VALUES (N'1',N'BOX',N'BOX');
INSERT INTO gen_invoice_unit VALUES (N'2',N'OTH',N'OTHERS');
INSERT INTO gen_invoice_unit VALUES (N'3',N'PAC',N'PACKS');
INSERT INTO gen_invoice_unit VALUES (N'4',N'PCS',N'PIECES');
INSERT INTO gen_invoice_unit VALUES (N'5',N'ROL',N'ROLLS');
INSERT INTO gen_invoice_unit VALUES (N'6',N'SET',N'SETS');
INSERT INTO gen_invoice_unit VALUES (N'7',N'SQF',N'SQUARE FEET');
INSERT INTO gen_invoice_unit VALUES (N'8',N'SQM',N'SQUARE METERS');
INSERT INTO gen_invoice_unit VALUES (N'9',N'UNT',N'UNITS');
