Home > Technical > Table Definitions > 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) |