questions about barcode

Dear all I want to know more about barcode in POS system. Is the barcode only contain a unique code of the products? What does the unique code like?(give me a example please) Is the barcode used as a primary key of products' table? If yes, what type and length of the barcode field should i use in the database?

Thanks~~

Reply to
DG Cell
Loading thread data ...

Hi,

YES

It can be a EAN 13, EAN8 , CODE128 or any unique identifier that pertains to the item

Yes. But in RMS is refer as Itemlookupcode in ITEM table.

NVARCHAR 25

I hope my answers suits your question and in some point I hope it helps you understand some of your questions.

"DG Cell" wrote:

Reply to
GregDxb

thanks GregDxb! by the way,where can I find a sample POS system database structure, I want to know what data will be stored in a POS system.

"GregDxb" ¦b¶l¥ó news: snipped-for-privacy@microsoft.com ¤¤¼¶¼g...

Reply to
DG Cell

Hi About barcodes I think the answers are clear ad correct. What about database. If you own one , you can user EMS SQL Server manager software to see what's going on in your database... you can download the 30 day trial version from

formatting link
site. Install it , run and it's not hard to understand what to do in it, it's quite simple and very effective program ... Hope, this can help you .

Reply to
Ashot

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.