iisCART2000™ Documentation

 

iisCART2000 DataBase Structure

Table: Fields: Field Type:
Items ID autonumber
  ItemID (primary key) Text
  ItemName Text
  ItemDescription Text
  ItemPrice Currency
  ItemWeight Number
  Custom1 Text
  Custom2 Text
  Custom3 Text
  Custom4 Text
  Custom5 Text
  Custom6 Text
  Custom7 Text
  Custom8 Text
  Imagepath Text
  Adjust Number
  AdjustRate Text
  Tax Number
  TaxRate Text
  CategoryNo Number
Table: Fields: Field Type:
Customers CustomerID AutoNumber
  Name Text
  Company Text
  Address1 Text
  Address2 Text
  City Text
  StateProvince Text
  ZipPostal Text
  Country Text
  Phone Text
  Fax Text
  Email Text
  Custom1 Text
  Custom2 Text
  Custom3 Text
  Custom4 Text
  Custom5 Text
  Custom6 Text
  Custom7 Text
  Custom8 Text
  BillingSameAsShipping Yes/No
  ShipName Text
  ShipCompany Text
  ShipAddress1 Text
  ShipAddress2 Text
  ShipCity Text
  ShipStateProvince Text
  ShipZipPostal Text
  ShipCountry Text
  ShipPhone Text
  ShipFax Text
  ShipEmail Text
  ShipCustom1 Text
  ShipCustom2 Text
  ShipCustom3 Text
  ShipCustom4 Text
  ShipCustom5 Text
  ShipCustom6 Text
  ShipCustom7 Text
  ShipCustom8 Text
  Resident Yes/No
  CountryResident Yes/No
  Password Text
Table: Fields: Field Type:
Orders ID AutoNumber
  CustomerID Number
  SessionID Number
  Comments Text
  ShipComments Text
  Tax Currency
  Shipping Currency
  OrderTotal Currency
  CCType Text
  CCNumber Text
  CCMonth Number
  CCYear Number
  CCName Text
  OrderDate Date/Time
  ShippingType Text
  PaymentType Text
  Processed Yes/No
  CCAuthCode Text
Table: Fields: Field Type:
OrderItems id AutoNumber
  OrderID Number
  ItemID Text
  Quantity Number
  Property1 Text
  Property2 Text
  Property3 Text
  Property4 Text
  Property5 Text
  Property6 Text
  Property7 Text
  Property8 Text
Table: Fields: Field Type:
OrderItemsEx id AutoNumber
  OrderID Number
  ItemID Text
  Quantity Number
  Property1 Text
  Property2 Text
  Property3 Text
  Property4 Text
  Property5 Text
  Property6 Text
  Property7 Text
  Property8 Text
  ItemName Text
  ItemDescription Text
  ItemPrice Currency
  ItemWeight Number
  Custom1 Text
  Custom2 Text
  Custom3 Text
  Custom4 Text
  Custom5 Text
  Custom6 Text
  Custom7 Text
  Custom8 Text
  ImagePath Text
  CategoryNo Number
  Adjust Number
  AdjustRate Text
  Tax Number
  TaxRate Text
Table: Fields: Field Type:
Category CategoryID AutoNumber
  CategoryName Text
 
Table: Fields: Field Type:
Cart CartID AutoNumber
  CartDate Date / Time
  CartData Memo
 
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.  iisCART has been specifically tested with MS Access and MS SQL server backends.

You are free to add additional fields to the database if you wish, just don't change existing fields.


 

Corporate Web Solutions 1998, 1999, 2000, 2001.