RMS Store OPS Database question

Mar 22, 2006 2 Replies
J

Can anyone point me to something explaing the meanings of everything in the database? Specifically I am looking for what the various Type ID (in the Daily Sales Table) refer to.



Thanks in advance,


---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.



formatting link
<de29f8-f51c-4acb-aa1e-da506998ead7&dg=microsoft.public.pos


Vote
Twitter Facebook LinkedIn
E

Jason,

Type:

A number indicating which group this daily sales total belongs to. 1 Supplier; 2 = Category; 3 = Department; 4 = Register; 5 = Cashier; 6 = Sales Rep; 7 = Tax.

TypeID:

Identifies the applicable category, department... this total belongs to; when type = 2 for category, TypeID correlates to the ID field of the category table.

- Evan Culver New West Technologies

formatting link
<de29f8-f51c-4acb-aa1e-da506998ead7&dg=microsoft.public.pos

Vote
Twitter Facebook LinkedIn
J

Evan,

Thanks very much.

"Evan Culver" wrote:

formatting link
<de29f8-f51c-4acb-aa1e-da506998ead7&dg=microsoft.public.pos >

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required