RMS HQ data dictionary

Hello, Bill-

I've been looking for the same information for a couple of months now, but I'm not sure where to find it. To me a "data dictionary" is more than just a list of tables, columns, and their types. I think there is some semantics that an automatic tool cannot generate. For example, there is a POType field in PurchaseOrder table. As it turns out, inventory transfers (both in and out) create records in PurchaseOrder table with a special value in POType. I don't think that kind of information is obviously clear just by looking at the names of tables and columns.

Zare Agazaryan Kana Systems, Inc. NETWORK SOLUTIONS, RETAIL SYSTEMS

Alternatively, is anyone aware of a tool in SQL Server Enterprise Manager or Query Analyser that will create a data dictionary? Right now I'm just generating a lot of SQL scripts and editing them by hand into an easy-to-read format.

Bill Yater The Worth Collection, Ltd.

Bill,

Microsoft Visio Enterprise edition, among others, is capable of generating Entity Relationship Diagrams and Database Model Diagrams through reverse engineering of a SQL Server database. If you have specific questions on the semantic meaning of the enumerated values (such as Status and Type fields), post your questions here.

- Evan Culver New West Technologies

Bill Yater wrote:

Zare,

PurchaseOrder.POType is enumerated as:

Local = 0 HQ = 1 Local Receive = 2 Local Issue = 3 HQ Receive = 4 HQ Issue = 5

- Evan Culver New West Technologies

Zare wrote:

The DailySales table:

What does the Type field and TypeID field correspond to? What sort of Type is it referring to? Is the TypeID a foreign key, and if so, what table does this relate to?

Also, I'm not sure what gets written to this table. I'll have a transaction with four line items, and I only see information for two of the items. I can't predict what will be written here.

We are planning on writing our own integration between RMS and AspDotNetStorefront, and trying to do a manual analysis of the RMS tables to determine what information they contain. I'm sure this will not be the only question I have about their tables and the metadata.

Bill

"Evan Culver" wrote:

Bill,

DailySales.Type

1 = Supplier 2 = Category 3 = Department 4 = Register 5 = Cashier 6 = Sales Rep 7 = Tax

DailySales.TypeID

TypeID relates the record back to a table specified in the Type column. If Type=1, and TypeID, this would reference the record in the Supplier table where ID.

- Evan Culver New West Technologies

Bill Yater wrote:

.. 0 Supplier 1 Department 2 Category 3 Register 4 Cashier 5 Sales Representative

antonio

TransactionType, used in the Journal table, NonTenderTransaction table.

I already figured out that type 1 is a sales transaction or return, and the reference ID in that case is the transaction ID (entries in the Journal table). I'm guessing that type 19 is a blind closeout, and type 17 is a z-report (these last two are in the NonTenderTransaction table).

Bill Yater

"Evan Culver" wrote: