SH.SALES TRANSACTIONS EXT (table)

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

wikibot

Table SH.SALES_TRANSACTIONS_EXT


Column Data Type Nullable Default PK Index
PROD_ID NUMBER null
CUST_ID NUMBER null
TIME_ID DATE(7) null
CHANNEL_ID NUMBER null
PROMO_ID NUMBER null
QUANTITY_SOLD NUMBER null
AMOUNT_SOLD NUMBER(10, 2) null
UNIT_COST NUMBER(10, 2) null
UNIT_PRICE NUMBER(10, 2) null