Home Page link  

What is DetailID field in TransactionEntry table?

  
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
What is DetailID field in TransactionEntry table? Alex 04-26-2006
Posted by Alex on April 26, 2006, 4:41 pm
Please log in for more thread options
 Hi all,

I am importing our old sales history into RMS and have a question on
the DetailID field in the TransactionEntry table. In the sample
database, most items are 0, some are 13, some 115. What does this field
mean? Am I safe to import using 0 for all of my items?

Thanks in advance!


Posted by Wendy on April 26, 2006, 5:52 pm
Please log in for more thread options
 The DetailID is the SerialID of a voucher. To be thorough, once you've
imported items into the Serial table (gift cards/vouchers that have already
been sold) you can transfer the Serial ID into the Detail ID of the actual
transaction entry of that Gift Certificate (voucher) purchase.

Hope this helps.


> Hi all,
>
> I am importing our old sales history into RMS and have a question on
> the DetailID field in the TransactionEntry table. In the sample
> database, most items are 0, some are 13, some 115. What does this field
> mean? Am I safe to import using 0 for all of my items?
>
> Thanks in advance!
>



Posted by Alex on April 26, 2006, 6:02 pm
Please log in for more thread options
That is exactly what I was looking for. Thank you.


Similar ThreadsPosted
Synchronize new field in table TransactionEntry January 25, 2007, 3:41 pm
Fields in TransactionEntry table June 26, 2008, 9:39 pm
Adding additional field to RMS table June 14, 2005, 2:20 pm
batch table: status field July 8, 2008, 10:12 pm
How to know if a sale its enabled or desabled... (what table field October 6, 2006, 6:35 pm
How to know if a sale its enabled or desabled... (what table field October 6, 2006, 6:36 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
Changing a TransactionEntry Qty using QSRules December 13, 2005, 11: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