Are barcodes stored? List of all tables in SQL?

Posted by Jonathan Smith on October 13, 2006, 1:07 pm

Please log in for more thread options

Are the barcodes for all the ILCs stored? If so, on what table?

Is there a way to get a list of all the tables in the database?

Or are the barcodes generated on the fly?

Thanks.

Posted by Greg Williams on October 13, 2006, 2:25 pm

Please log in for more thread options

The ILC is usually the barcode number. Alias can also be used.

Barcode type is stored in the item table. It is only needed if you are
printing barcodes

> Are the barcodes for all the ILCs stored? If so, on what table?

> Is there a way to get a list of all the tables in the database?

> Or are the barcodes generated on the fly?

> Thanks.

Posted by Jeff on October 13, 2006, 3:06 pm

Please log in for more thread options

: quoted-printable

Jonathan,

1. A barcode type is stored in the Item table. Item.BarCodeFormat

2. Database schema - http://tinyurl.com/nao8m

Must have access to CustomerSource

3. On the fly

--=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

**********

Are the barcodes for all the ILCs stored? If so, on what table?

Is there a way to get a list of all the tables in the database?

Or are the barcodes generated on the fly?

Thanks.
------=_NextPart_000_03A8_01C6EEBF.F2F207B0
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>Jonathan,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>1. A barcode type is stored in the Item=20
table.  Item.BarCodeFormat</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>2. Database schema - <A=20
href=3D"http://tinyurl.com/nao8m">http://tinyurl.com/nao8m</A></FONT></DI=
V>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Must have access to =
CustomerSource</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>3. On the fly</FONT></DIV>
<DIV><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </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>"Jonathan Smith" <<A=20
=
cussions.microsoft.com</A>>=20
wrote in message <A=20
=
82ADD-B3F7-4F9C-BAF8-0532B2787068@microsoft.com</A>...</DIV>Are=20
the barcodes for all the ILCs stored? If so, on what table?<BR><BR>Is =
there a=20
way to get a list of all the tables in the database?<BR><BR>Or are the =

barcodes generated on the =
fly?<BR><BR><BR>Thanks.</BLOCKQUOTE></BODY></HTML>

------=

Posted by Glenn Adams [MVP - Retail Mgmt on October 13, 2006, 3:10 pm

Please log in for more thread options

think of a barcode as a Font. that series of lines just represents a
string - ItemLookupCode in the case of RMS.
They are generated on the fly (by the printer or driver) when they are
printed and they are decoded on the fly (by the scanner) when they are
read. In both cases, RMS only knows the string that is send to the
printer or received from the scanner.

--List User Tables in a database
select Name from sysobjects where type = 'U'

--List Columns for a Table
select sc.name, st.name,
case st.name when 'nvarchar' then sc.length/2 else sc.length end as length,
case sc.isnullable when 1 then 'NULL' else 'NOT NULL' end as nullable
from sysobjects so
inner join syscolumns sc on so.id = sc.id
inner join systypes st on sc.xusertype = st.xusertype
where so.name = 'customer'

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

Jonathan Smith wrote:

> Are the barcodes for all the ILCs stored? If so, on what table?

> Is there a way to get a list of all the tables in the database?

> Or are the barcodes generated on the fly?

> Thanks.