PRINTER_SUPPLIES

This table represents supplies in printers. There is a row in this table for each supply in a given printer, all pointing to the same PRINTER_ID. Depending on the type, not all columns apply.

Field Name	Data Type	Description
^*This data type is required for Microsoft SQL Server.
SUPPLY_ID	BIGINT	The primary key.
CAPACITY	BIGINT	The maximum sheet capacity of the supply.
COLOR	VARCHAR(255)	The color of the supply (for example, Black, Cyan, or NULL).
NAME	VARCHAR(255)	The name of the supply (for example, Black Toner, Fuser, and Waste Bottle).
SMART_CARTRIDGE_PREBATE	SMALLINT/ TINYINT^*	The flag indicating whether this supply is a smart cartridge prebate.
SMART_CARTRIDGE_REFILLED	SMALLINT/ TINYINT^*	The flag indicating whether this supply is a smart cartridge refill.
SMART_CARTRIDGE_SERIAL_NUM BER	VARCHAR(255)	The smart cartridge serial number.
TYPE	VARCHAR(255)	The type of supply (for example, Toner, Transfer Belt, Fuser, Container, or Imaging Unit).
PRINTER_ID	BIGINT	The foreign key to NETWORK_PRINTER.PRINTER_ID.
PERCENT_FULL	BIGINT	The calculated remaining percentage of the supply.

Was this article helpful?