Post Reply 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ChequeNo in Multiple Tables
02-08-2018, 10:05 AM (This post was last modified: 02-08-2018 10:10 AM by VortecCPI.)
Post: #1
ChequeNo in Multiple Tables
Not really a problem except in the sense of DB normalization...

I see we have added ChequeNo to other Trans tables when we already have that field in GLTrans table. I changed my code to write check numbers to the GL Trans table during Payments because I was unaware of this new development.

Am I correct in assuming these new ChequeNo fields are added because our payment check numbers are from one contiguous incrementing set while receipt check numbers could be just about anything, including identical numbers from different customers?

Just a little curious...
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 

Messages In This Thread
ChequeNo in Multiple Tables - VortecCPI - 02-08-2018 10:05 AM
RE: ChequeNo in Multiple Tables - falkoner - 02-08-2018, 08:54 PM

Forum Jump:

User(s) browsing this thread: 1 Guest(s)