In the coming months, some key fields will be removed from several child tables of the book table as enhancements are made to the database architecture. These changes will affect the way tables are joined together - specifically which fields they should now be joined on. The following is a list of affected tables and the new join logic.
BookSplit
InvNum, Location, and InvoiceDate will be removed from the BookSplit table, so any of those fields (including table joins) in the data source should be changed.
| Do Not Use | Replace With |
| Booksplit.invnum | Book.invnum |
| Booksplit.location | Book.location |
| Booksplit.invoicedate | Book.invdate |
|
| |
| Proper join: Book.bookguid = booksplit.bookguid | |
BookLi
InvNum, Location, InvoiceDate, and CUSTID will be removed from the BookLi table, so any use of those fields (including table joins) in the data source should be changed. Additionally, any join of the Grower table to BookLi should be changed to join the Grower table to BookSplit on BookSplit.CUSTID = Grower.GROWID
| Do Not Use | Replace With |
| BookLi.InvNum | Book.invnum |
| BookLi.Location | Book.location |
| BookLi.InvoiceDate | Book.invdate |
| BookLi.CUSTID | BookSplit.CUSID |
|
| |
|
Proper joins:
Book.bookguid = booksplit.bookguid BookSplit.booksplitguid = BookLi.booksplitguid | |
BookAnal
InvNum, Location, and InvoiceDate will be removed from the BookAnal table, so any use of those fields (including table joins) in the data source should be changed.
| Do Not Use | Replace With |
| BookAnal.InvNum | Book.invnum |
| BookAnal.Location | Book.location |
| BookAnal.InvoiceDate | Book.invdate |
|
| |
| Proper joins: Book.bookguid = BookAnal.bookguid | |
BookPlan
BookNumber, BookLocation, and BookDate will be removed from the BookPlan table, so any use of those fields (including table joins) in the data source should be changed.
| Do Not Use | Replace With |
| BookPlan.BookNumber | Book.invnum |
| BookPlan.BookLocation | Book.location |
| BookPlan.BookDate | Book.invdate |
|
| |
| Proper joins: Book.bookguid = BookPlan.bookguid | |
InvBooks
TicketNumber, TicketLocation, TicketDate, TicketCustId, and TicketLineItem will be removed from the InvBooks table, so any use of those fields (including table joins) in the data source should be changed.
| Do Not Use | Replace With |
| InvBooks.TicketNumber | Book.invnum |
| InvBooks.TicketLocation | Book.location |
| InvBooks.TicketDate | Book.invdate |
| InvBooks.TicketCustId | BookSplit.CUSTID |
| InvBooks.TicketLineItem | BookLi.LINEITEM |
|
| |
| Proper joins:
BookLi.bookliguid = InvBooks.bookli.guid Bookli.booksplitguid = booksplit.booksplitguid Book.bookguid = booksplit.bookguid | |
SeedOrderDt
Bookinvnum, BookLocation, and BookInvDate will be removed from the InvBooks table, so any use of those fields (including table joins) in the data source should be changed.
| Do Not Use | Replace With |
| SeedOrderDt.Bookinvnum | Book.invnum |
| SeedOrderDt.BookLocation | Book.location |
| BookInvDate | Book.invdate |
|
| |
| Proper joins: BookLi.bookliguid = SeedOrderDt.bookliguid Bookli.booksplitguid = booksplit.booksplitguid Booksplit.bookguid = book.bookguid | |
