SH.PRODUCTS (table)

wikibot

Table

SH.PRODUCTS

Column	Data Type	Nullable	Default	PK	Index
PROD_ID	NUMBER	not null		PRODUCTS_PK
PROD_NAME	VARCHAR2	not null
PROD_DESC	VARCHAR2	not null
PROD_SUBCATEGORY	VARCHAR2	not null			PRODUCTS_PROD_SUBCAT_IX
PROD_SUBCATEGORY_ID	NUMBER	not null
PROD_SUBCATEGORY_DESC	VARCHAR2	not null
PROD_CATEGORY	VARCHAR2	not null			PRODUCTS_PROD_CAT_IX
PROD_CATEGORY_ID	NUMBER	not null
PROD_CATEGORY_DESC	VARCHAR2	not null
PROD_WEIGHT_CLASS	NUMBER	not null
PROD_UNIT_OF_MEASURE	VARCHAR2	null
PROD_PACK_SIZE	VARCHAR2	not null
SUPPLIER_ID	NUMBER	not null
PROD_STATUS	VARCHAR2	not null			PRODUCTS_PROD_STATUS_BIX
PROD_LIST_PRICE	NUMBER	not null
PROD_MIN_PRICE	NUMBER	not null
PROD_TOTAL	VARCHAR2	not null
PROD_TOTAL_ID	NUMBER	not null
PROD_SRC_ID	NUMBER	null
PROD_EFF_FROM	DATE	null
PROD_EFF_TO	DATE	null
PROD_VALID	VARCHAR2	null

Detail Table	Column	Referencing Column
SH.COSTS	PROD_ID	PROD_ID
SH.SALES	PROD_ID	PROD_ID