Are barcodes stored? List of all tables in SQL?

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.

Reply to
Jonathan Smith
Loading thread data ...

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

Reply to
Greg Williams
**********

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

Or are the barcodes generated on the fly?

Thanks.

Reply to
Jeff

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 C> Are the barcodes for all the ILCs stored? If so, on what table?

Reply to
Glenn Adams [MVP - Retail Mgmt]

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.