Home > Technical > Table Definitions > SHOPPINGDTL
When a user is buying something from the home shopping website, the system keeps track of the items they have bought in a shopping cart. The header record for the transaction is stored in SHOPPINGHDR while this table contains the items within the transaction.
| Column | Type | Description |
| STRID | VARCHAR(38) | The code of the transaction to which the item belongs. |
| INTCODE | INT | A unique number of the item within the transaction. |
| LINTITEMNUMBER | INT | The number
of the item being purchased.
ITEM.lintItemNumber
|
| STRDESCRIPTION | VARCHAR(100) | Description of the item. |
| DBLQUANTITY | DECIMAL(19,4) | The quantity being purchased. |
| CURSELLPRICE | DECIMAL(19,4) | The sell price of the item. |
Primary Key: STRID + INTCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |