DPINVENT Sample

In this section:

The DPINVENT table contains inventory information.


Top of page

x
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);

Top of page

x
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

Information Builders