Difference between revisions of "SH.PRODUCTS (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.PRODUCTS |- |} {| border="1" cellpadding="5" cellspacing="0" style="borde...)
(No difference)

Revision as of 18:06, 2 May 2009

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