DPINVENT Sample

The DPINVENT table contains inventory information.

In this section: DPINVENT Table Definition DPINVENT Contents

DPINVENT Table Definition

  CREATE TABLE DPINVENT
    (BRANCH_NUMBER    INTEGER      NOT NULL,
     VENDOR_NUMBER    INTEGER      NOT NULL,
     PRODUCT          CHAR(5)      NOT NULL,
     NUMBER_OF_UNITS  INTEGER      NOT NULL,
     PER_UNIT_VALUE    DECIMAL(9,2) NOT NULL);

DPINVENT Contents

  SELECT * FROM DPINVENT;
 
  BRANCH_NUMBER VENDOR_NUMBER PRODUCT NUMBER_OF_UNITS PER_UNIT_VALUE
  ------------- ------------- ------- --------------- --------------
              1             1 RADIO                 5          12.95
              2             1 RADIO                 5          12.95
              3             1 RADIO                 5          12.95
              4             1 RADIO                 5          12.95
              1             3 MICRO                 6         110.00
              4             3 MICRO                 2         110.00
              2             3 MICRO                 1         110.00
              2              3 MICRO                 2          110.00