SH.COSTS (table)

From dbscript Online Help
Revision as of 21:01, 24 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table SH.COSTS


Column Data Type Nullable Default PK Index
PROD_ID NUMBER not null COSTS_PROD_BIX
TIME_ID DATE(7) not null COSTS_TIME_BIX
PROMO_ID NUMBER not null
CHANNEL_ID NUMBER not null
UNIT_COST NUMBER(10, 2) not null
UNIT_PRICE NUMBER(10, 2) not null


Relation Column Referenced Column
SH.CHANNELS CHANNEL_ID CHANNEL_ID
SH.PRODUCTS PROD_ID PROD_ID
SH.PROMOTIONS PROMO_ID PROMO_ID
SH.TIMES TIME_ID TIME_ID