Adding columns to item table

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

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Adding columns to item table tfitts 10-30-2008  Re: Adding columns to item table Galen Meyer 10-30-2008  Re: Adding columns to item table antonio 10-31-2008  Re: Adding columns to item table convoluted 10-31-2008  Re: Adding columns to item table Mickie 11-03-2008  Re: Adding columns to item table antonio 11-03-2008
Posted by tfitts on October 30, 2008, 1:37 am Please log in for more thread options Are there any incompatibility issues I would need to worry about in adding additional columns to tables in the database? I'm already using most of the available fields in the item table and I would like a place to store each items ASIN assigned from amazon. I don't need to be able to read or write this in either the POS or the Manager, I just need to be able to access it through SQL queries. Posted by Galen Meyer on October 30, 2008, 4:46 pm Please log in for more thread options I would like to know the same thing. Has anybody done that without problems? > Are there any incompatibility issues I would need to worry about in > adding additional columns to tables in the database? I'm already > using most of the available fields in the item table and I would like > a place to store each items ASIN assigned from amazon. I don't need > to be able to read or write this in either the POS or the Manager, I > just need to be able to access it through SQL queries. Posted by antonio on October 31, 2008, 8:55 am Please log in for more thread options On Oct 30, 6:37=A0am, tfi...@gmail.com wrote: > Are there any incompatibility issues I would need to worry about in > adding additional columns to tables in the database? =A0I'm already > using most of the available fields in the item table and I would like > a place to store each items ASIN assigned from amazon. =A0I don't need > to be able to read or write this in either the POS or the Manager, I > just need to be able to access it through SQL queries. you can add a custom columns in Item table with this statement ALTER TABLE [Item] ADD [ColumnName] NVARCHAR([size]) DEFAULT('') NOT NULL it's important a DEFAULT value, otherwise the Manager and the HQ Client can't create new items on database.... in addition, you must add the field on offline databases and hq databases (or viceversa) because the sync. procedures get all fields antonio Posted by convoluted on October 31, 2008, 9:35 am Please log in for more thread options Thanks for posting a reply Antonio - having said that, would it make more sense to create a separate table then join it to the item table ( kind of like the alias table), since the only purpose is to access the ASIN via queries? May need to consider also that future versions of the software may have an issue with that added column. Thanks again for sharing your knowledge "antonio" wrote: > On Oct 30, 6:37 am, tfi...@gmail.com wrote: > > Are there any incompatibility issues I would need to worry about in > > adding additional columns to tables in the database? I'm already > > using most of the available fields in the item table and I would like > > a place to store each items ASIN assigned from amazon. I don't need > > to be able to read or write this in either the POS or the Manager, I > > just need to be able to access it through SQL queries. > > > you can add a custom columns in Item table with this statement > > ALTER TABLE [Item] > ADD [ColumnName] NVARCHAR([size]) DEFAULT('') NOT NULL > > it's important a DEFAULT value, otherwise the Manager and the HQ > Client can't create new items on database.... > in addition, you must add the field on offline databases and hq > databases (or viceversa) because the sync. procedures > get all fields > > antonio > Posted by Mickie on November 3, 2008, 12:50 pm Please log in for more thread options I agree. A separate table with the ILC and ASIN as the 2 fields would work for you. You could query out your combined table and import it into Amazon's item lister program. convoluted wrote: > Thanks for posting a reply Antonio - having said that, would it make more > sense to create a separate table then join it to the item table ( kind of > like the alias table), since the only purpose is to access the ASIN via > queries? May need to consider also that future versions of the software may > have an issue with that added column. Thanks again for sharing your knowledge > > "antonio" wrote: > >> On Oct 30, 6:37 am, tfi...@gmail.com wrote: >>> Are there any incompatibility issues I would need to worry about in >>> adding additional columns to tables in the database? I'm already >>> using most of the available fields in the item table and I would like >>> a place to store each items ASIN assigned from amazon. I don't need >>> to be able to read or write this in either the POS or the Manager, I >>> just need to be able to access it through SQL queries. >> >> you can add a custom columns in Item table with this statement >> >> ALTER TABLE [Item] >> ADD [ColumnName] NVARCHAR([size]) DEFAULT('') NOT NULL >> >> it's important a DEFAULT value, otherwise the Manager and the HQ >> Client can't create new items on database.... >> in addition, you must add the field on offline databases and hq >> databases (or viceversa) because the sync. procedures >> get all fields >> >> antonio >> Similar Threads Posted Adding columns to the Item (all) window September 15, 2009, 12:47 pm Adding columns to Inventory Transfer Out Order November 30, 2006, 4:04 pm RMS generated PO's need to be upgraded to allow adding columns fo. January 17, 2007, 12:44 pm Adding/removing columns in POS 2009 lists July 8, 2009, 10:48 am Adding fields to a table March 27, 2008, 10:21 am Adding additional field to RMS table June 14, 2005, 2:20 pm SupplierList Table doesn't get filled up autom. when adding an ite October 10, 2005, 3:02 pm costumize item(all) form columns August 15, 2007, 4:46 am unable to default Item tax when adding an item from PO screen. April 20, 2007, 2:02 pm Updating Item Table February 20, 2006, 2:02 pm