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) |