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)