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

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.SALES_TRANSACTIONS_EXT
 
| SH.SALES_TRANSACTIONS_EXT
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| PROD_ID
 
| PROD_ID
 
| NUMBER
 
| NUMBER
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CUST_ID
 
| CUST_ID
 
| NUMBER
 
| NUMBER
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| TIME_ID
 
| TIME_ID
 
| DATE(7)
 
| DATE(7)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CHANNEL_ID
 
| CHANNEL_ID
 
| NUMBER
 
| NUMBER
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PROMO_ID
 
| PROMO_ID
 
| NUMBER
 
| NUMBER
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| QUANTITY_SOLD
 
| QUANTITY_SOLD
 
| NUMBER
 
| NUMBER
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| AMOUNT_SOLD
 
| AMOUNT_SOLD
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| UNIT_COST
 
| UNIT_COST
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| UNIT_PRICE
 
| UNIT_PRICE
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)

Latest revision as of 06:16, 24 June 2010

wikibot[edit]

Table SH.SALES_TRANSACTIONS_EXT

Columns[edit]

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