Difference between revisions of "SH.SALES TRANSACTIONS EXT (table)"

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
 
 
 
 
|-
 
|-
Line 22: Line 22:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 29: Line 28:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 36: Line 34:
 
| DATE(7)
 
| DATE(7)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 43: Line 40:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 57: Line 52:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 64: Line 58:
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 71: Line 64:
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 78: Line 70:
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
 
|}
 
|}

Revision as of 08:29, 11 February 2010

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