-- Oracle Table Definition
--
-- RCS Revision
--   $Id: resstatus.oracle,v 1.3 2000/06/06 02:15:19 billf Exp $
--

CREATE TABLE resstatus (
    flag char(1) PRIMARY KEY,
    label varchar2(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');
