Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
SH SALES_TRANSACTIONS_EXT (table)
Print
RSS
Modified on 2011/08/27 12:11
by
wikibot
Categorized as
Uncategorized
Production (schema)
Production Product (table)
Production WorkOrder (table)
Purchasing PurchaseOrderDetail (table)
Sales SalesOrderDetail (table)
dbo Name (type)
Production (schema)
Production ProductInventory (table)
Production WorkOrderRouting (table)
dbo Name (type)
Production (schema)
Production ProductModelProductDescriptionCulture (table)
public category_node (table)
(8)
»
IX ORDERS_QUEUETABLE (table)
»
OE PURCHASEORDERS (table)
»
SH SALES_TRANSACTIONS_EXT (table)
[X]
»
public categories (table)
»
Production Culture (table)
»
Production Location (table)
»
IX AQ$_ORDERS_QUEUETABLE_G (table)
»
Production TransactionHistory (table)
»
IX ORDERS_QUEUETABLE (table)
»
OE PURCHASEORDERS (table)
»
SH SALES_TRANSACTIONS_EXT (table)
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.