SH.CHANNELS (table)

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

wikibot

Table SH.CHANNELS


Column Data Type Nullable Default PK Index
CHANNEL_ID NUMBER not null CHANNELS_PK
CHANNEL_DESC VARCHAR2(20) not null
CHANNEL_CLASS VARCHAR2(20) not null
CHANNEL_CLASS_ID NUMBER not null
CHANNEL_TOTAL VARCHAR2(13) not null
CHANNEL_TOTAL_ID NUMBER not null


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