SH.SALES TRANSACTIONS EXT (table)
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 |
