1. Home
  2. Point-Of-Sale Software
  3. RMS Store OPS Database question

RMS Store OPS Database question

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

Reply to
Jason
Loading thread data ...

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

Reply to
Evan Culver

Evan,

Thanks very much.

"Evan Culver" wrote:

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

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.