SH.SALES TRANSACTIONS EXT (table)

From dbscript Online Help
Revision as of 06:16, 24 June 2010 by Bot (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table SH.SALES_TRANSACTIONS_EXT

Columns

Column Data Type Nullable Default Description
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