SH.SALES TRANSACTIONS EXT (table)

From dbscript Online Help

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
Personal tools
dbscript.help
dbscript.web