Home Page link  

How to know if a sale its enabled or desabled... (what table field

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
How to know if a sale its enabled or desabled... (what table field Aldo 10-06-2006
Posted by Aldo on October 6, 2006, 6:35 pm
Please log in for more thread options
 Hi, i have some useful RMS views at SQL Server level, the thing is that i
cant find the field with specify if enabled or disabled a sale, i use
SalePrice, StartSaleDate, and EndSaleDate, but no the enabled or disabled
sale... which one is this?

thanks in advance...

Aldo

Posted by Jeff on October 6, 2006, 8:20 pm
Please log in for more thread options
 : quoted-printable

Aldo,=20

You need to look at the SaleType column/field.

0 =3D not on sale
1 =3D onsale for a period
2 =3D on sale per schedule

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

Hi, i have some useful RMS views at SQL Server level, the thing is =
that i=20
cant find the field with specify if enabled or disabled a sale, i use=20
SalePrice, StartSaleDate, and EndSaleDate, but no the enabled or =
disabled=20
sale... which one is this?

thanks in advance...

Aldo
------=_NextPart_000_03A4_01C6E96B.B62C0AF0
Content-Type: text/html;
        charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Aldo, </FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>You need to look at the SaleType=20
column/field.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>0 =3D not on sale</FONT></DIV>
<DIV><FONT color=3D#008000>1 =3D onsale for a period</FONT></DIV>
<DIV><FONT color=3D#008000>2 =3D on sale per schedule</FONT></DIV>
<DIV><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.&nbsp; If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.&nbsp; Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Aldo" &lt;<A=20
=
.com</A>&gt;=20
wrote in message <A=20
=
EEB13-5F1B-43F7-93AB-37DE21879C66@microsoft.com</A>...</DIV>Hi,=20
i have some useful RMS views at SQL Server level, the thing is that i =
<BR>cant=20
find the field with specify if enabled or disabled a sale, i use=20
<BR>SalePrice, StartSaleDate, and EndSaleDate, but no the enabled or =
disabled=20
<BR>sale... which one is this?<BR><BR>thanks in=20
advance...<BR><BR>Aldo</BLOCKQUOTE></BODY></HTML>

------=
Posted by Aldo on October 9, 2006, 1:49 pm
Please log in for more thread options
Thanks!!!!!




"Jeff" wrote:

> Aldo,
>
> You need to look at the SaleType column/field.
>
> 0 = not on sale
> 1 = onsale for a period
> 2 = on sale per schedule
>
> --
> *
> Get Secure! - www.microsoft.com/security
>
> You must be using Outlook Express or some other type of newsgroup reader to
> see and download the file attachment. If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
>
> **********
>
> Hi, i have some useful RMS views at SQL Server level, the thing is that i
> cant find the field with specify if enabled or disabled a sale, i use
> SalePrice, StartSaleDate, and EndSaleDate, but no the enabled or disabled
> sale... which one is this?
>
> thanks in advance..

Similar ThreadsPosted
How to know if a sale its enabled or desabled... (what table field October 6, 2006, 6:36 pm
Adding additional field to RMS table June 14, 2005, 2:20 pm
What is DetailID field in TransactionEntry table? April 26, 2006, 4:41 pm
Synchronize new field in table TransactionEntry January 25, 2007, 3:41 pm
batch table: status field July 8, 2008, 10:12 pm
Item.content field in RMS Items table August 15, 2007, 3:02 pm
Store Operations POS Item Table Field Suggestion July 15, 2005, 7:38 am
Remote Desktop or web-enabled inventory December 9, 2005, 6:23 pm
RE: Update Retail Management System to be Unicode enabled August 27, 2008, 3:57 am
Make the reorder number field be a copy and past field March 21, 2006, 11:55 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap