/*
--	$Id: resstatus.interbase,v 1.3 2000/06/06 02:15:18 billf Exp $
--
--	Table structure for table 'resstatus'
*/

CREATE TABLE resstatus (
  flag CHAR(1) NOT NULL PRIMARY KEY,
  label VARCHAR(20) NOT NULL
);

INSERT INTO resstatus VALUES ('E','Enroute');
INSERT INTO resstatus VALUES ('R','Recieved');
INSERT INTO resstatus VALUES ('O','Ordered');
INSERT INTO resstatus VALUES ('P','Pending Approval');
INSERT INTO resstatus VALUES ('I','Pending Info');
INSERT INTO resstatus VALUES ('B','Backorder');
