IV30101 - Sales Summary History

Stores annual sales summary by item including quantities sold and cost of goods sold.

SQL Query Builder

SELECT * FROM IV30101

Select all

Column	Type	Shared With
ITEMNMBR	char(31) ''	87 tables
SQTYSYTD	numeric(19,5) 0.00	-
SUMCSYTD	numeric(19,5) 0.00	-
SMSLSYTD	numeric(19,5) 0.00	-
SQTYSLYR	numeric(19,5) 0.00	-
SUMCSLYR	numeric(19,5) 0.00	-
SMSLSLYR	numeric(19,5) 0.00	-
DEX_ROW_ID	int auto number (1,1)	608 tables

Tables that share columns with IV30101. Click "Join" to add to your query.

DEX_ROW_ID

ITEMNMBR