IntelliTrack Check In/Out - Manual (Page 17)

Table of Contents
xvii
CHAPTER 21: CE Data Searching .....................................................375
Overview.................................................................................................................. 376
Searching for Sites............................................................................................ 376
Searching for Locations.................................................................................... 378
Searching for Items........................................................................................... 380
Searching for Inventory By Location ............................................................... 382
Searching by Site and Location................................................................. 383
Searching by Site and Item Number.......................................................... 385
Search by Site and Lot............................................................................... 387
Searching by Site and Expiration Date...................................................... 388
Searching by Quantity ...................................................................................... 390
Searching for Departments ............................................................................... 391
Searching for Customers................................................................................... 391
Searching for Transactions ............................................................................... 392
APPENDIX A: Data Structure ............................................................397
Data Tables............................................................................................................... 398
Site ........................................................................................................................... 398
Inventory Table ........................................................................................................ 398
Inventory by Location Table.................................................................................... 400
Bin Location Table................................................................................................... 402
tblCheck Table ......................................................................................................... 402
Field Types............................................................................................................... 403
APPENDIX B: Database Maintenance ...............................................405
Verifying Database Connection ............................................................................... 406
IntelliTrack Database........................................................................................ 406
SQL Server Logon Information........................................................................ 406
SQL Server 2008 Login Strong Password Requirements ......................... 406
Testing the Database Connection via the UDL File ......................................... 407
Database Connection Test Example.......................................................... 409
Connecting to the Database with SQL Server Management Studio..................411
Changing the Application Database Connection.............................................. 413
Changing the Database Connection in Check In-Out, Fixed Assets,
Inventory, or Stockroom............................................................................ 413
Changing the Database Connection in Package Track.............................. 415
Changing the Database Connection in WMS or ISRP .............................. 417
Database Backup and Restore.................................................................................. 418
Database Maintenance ...................................................................................... 419
2283.book Page xvii Thursday, July 7, 2011 2:29 PM