Home > Technical > Table Definitions > SHOPPINGHDR

SHOPPINGHDR

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. This table contains a header for the shopping cart while the items are stored in SHOPPINGDTL.

Column Type Description
STRID VARCHAR(38) A unique id assigned to the transaction.
DTMCREATED DATETIME The date the transaction was created.
STRSTATUS VARCHAR(10) Currently set to 'NEW'.
STRNAME VARCHAR(100) Name of customer
STRADDR1 VARCHAR(50) Address line 1 of customer
STRADDR2 VARCHAR(50) Address line 2 of customer
STRCITY VARCHAR(50) City of customer
STRSTATE VARCHAR(20) State of customer
STRPOSTCODE VARCHAR(20) Postcode of customer
STRCOUNTRY VARCHAR(50) Country of customer
STRPHONE VARCHAR(20) Phone number of customer
STRFAX VARCHAR(20) Fax number of customer
STRMOBILE VARCHAR(20) Mobile number of customer
STREMAIL VARCHAR(100) Email address of customer
STRDELIVERYNAME VARCHAR(100) Delivery name
STRDELIVERYADDR1 VARCHAR(50) Delivery address line 1
STRDELIVERYADDR2 VARCHAR(50) Delivery address line 2
STRDELIVERYCITY VARCHAR(50) Delivery city
STRDELIVERYSTATE VARCHAR(20) Delivery state
STRDELIVERYPOSTCODE VARCHAR(20) Delivery postcode
STRDELIVERYCOUNTRY VARCHAR(50) Delivery country
MEMDELIVERYCOMMENT TEXT Delivery comment
STRCUSTOMERCARD VARCHAR(38) The card number of the customer (if they have one)
INTORDERCODE BIGINT The code of the customer order that was created from this basket.
 

Primary Key: STRID

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)