SyteLine – Handling new Table Schema in SyteLine 9

When upgrading to SyteLine 9, one major change has been made to the tables: A new column for the sitecontext has been added as an additional column to some base tables like coitem  and item . Infor has added the column on a table with the same name and the suffix _mst. In order for an easy upgrade for all theses table a view was added with the origin known name. Thus item_mst  was added as a table and item  as a view.

SL 9 Table Changes
Original from the Infor SyteLine resource 1 linked at the bottom

To use the newly introduced views, you have to set a TSQL global variable with the sitename. It will be applied as a filter on the view. – Or you can directly use the _mst table and filter for the corresponding sitename in the new column yourself.

There are two solutions to query the new views, which will be shown below:


 

Resources:

  1. Coding and Schema Changes Made in SyteLine 9.00 for Multiple Sites per Database
  2. http://www.sytelinemaster.com/sql/sql-query-syteline-9/

Tags

Categories

Meta

Peter Merkert Written by:

Be First to Comment

Leave a Reply