[ic] A few Interchange queries

[Kai and Sally Berberich]

Hi,

I am in the process of finding out more about Interchange, and after having
played with the demo store for a while I have a couple of queries.

A) Is it possible to build some automation into the order numbering system ?
What I mean by this is that the in the demo store, the order number appears
to be a simple iterator of whatever number code is entered. I want to set
the order number up so that it is a combination of date AND iterator ie at
the start of each day, the order number is set to the current date plus the
number 1 eg the first order today would be "20030120-1" - then this number
is incremented throughout the day until it is reset the next morning eg
20030121-1 tomorrow morning. Is this possible and if so - how can it be
done.

B) The demo system has a number of lookup tables that bear no relevance to
my business eg the freight/shipping lookup tables. Is it possible to remove
or alter these tables and/or create new ones ? Or is the existing table
structure set in stone ?
 
Thanks in advance for your assistance with these queries and I look forward
to your responses.

Regards
Kai Berberich