Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Egg Configuration

Egg Size Types

  • Go to System, Settings (Ribbon Bar), System Types Tab, Select Egg Size Types from Drop down.These need to be set up exactly as they are in the report so we get the correct values back.  Run the following script against the user database to set up the egg size types used:


update userbusinesstype
set sortorder = 20.00
where objectid = 77

update userbusinesstype
set BusinessTypeCode = 'Bs', BusinessTypeName = 'Bs', IsUserMod = 1, SortOrder = 7
where BusinessTypeID = 310

update userbusinesstype
set BusinessTypeCode = 'CRACKS', BusinessTypeName = 'CRACKS', IsUserMod = 1, SortOrder = 8
where BusinessTypeID = 311

update userbusinesstype
set BusinessTypeCode = 'REJECTS', BusinessTypeName = 'REJECTS', IsUserMod = 1, SortOrder = 9
where BusinessTypeID = 314

update userbusinesstype
set BusinessTypeCode = 'JUMBO', BusinessTypeName = 'JUMBO', IsUserMod = 1, SortOrder = 1
where BusinessTypeID = 293
update userbusinesstype
set BusinessTypeCode = 'X-LARGE', BusinessTypeName = 'X-LARGE', IsUserMod = 1, SortOrder = 2
where BusinessTypeID = 294
update userbusinesstype
set BusinessTypeCode = 'LARGE', BusinessTypeName = 'LARGE', IsUserMod = 1, SortOrder = 3
where BusinessTypeID = 295
update userbusinesstype
set BusinessTypeCode = 'MEDIUM', BusinessTypeName = 'MEDIUM', IsUserMod = 1, SortOrder = 4
where BusinessTypeID = 296
update userbusinesstype
set BusinessTypeCode = 'SMALL', BusinessTypeName = 'SMALL', IsUserMod = 1, SortOrder = 5
where BusinessTypeID = 297
update userbusinesstype
set BusinessTypeCode = 'PEEWEE', BusinessTypeName = 'PEEWEE', IsUserMod = 1, SortOrder = 6
where BusinessTypeID = 298



Egg Size Matrix Configuration

...