iisCART™ Documentation

 

iisCART DataBase Structure

Tables Fields Field Type:
Items ID
ItemID (primary key)
ItemName
ItemDescription
ItemPrice
ItemWeight
Custom1
Custom2
Custom3
Custom4
Custom5
autonumber
Text
Text
Text
Currency
Number
Text
Text
Text
Text
Text
Orders ID
SessionID
Name
Company
Address1
Address2
Address3
City
StateProvince
ZipPostal
Country
Phone
Email
BillingSameAsShipping
ShipName
ShipCompany
ShipAddress1
ShipAddress2
ShipAddress3
ShipCity
ShipStateProvince
ShipZipPostal
ShipCountry
ShipPhone
ShipEmail
Resident
CountryResident
Tax
Shipping
OrderTotal
CCType
CCNumber
CCMonth
CCYear
CCName
OrderDate
ShippingType
AutoNumber
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Yes/No
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Yes/No
Yes/No
Currency
Currency
Currency
Text
Text
Text
Text
Number
Number
Text
Date/Time
Text
Order Items ID
OrderID
ItemID
Quantity
Property1
Property2
Property3
Property4
Property5
AutoNumber
Number
Text
Number
Text
Text
Text
Text
Text
 
Description / Comments:
iisCART requires a backend structure identical to this as is looks for specific field names.   There is backend flexibility however as a DSN is used rather than connecting directly to the DB.

 

© Corporate Web Solutions 1998, 1999.