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.![]() |
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) |