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.
|STRID||VARCHAR(38)||The code of the transaction to which the item belongs.|
|INTCODE||INT||A unique number of the item within the transaction.|
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)|