System Specification Document for Warehouse Management System

In business computing, we understand that we need to capture and translate the business requirements into technical specifications in assist and understand what and how the proposed system is going to be designed.  Due to different solution for the different industries, the contents in a system specification document will vary but it should capture all the required information for the solution design.

For our warehouse management system we identify the following information to be captured into the system specification document:

  1. System Architecture – A description of the network and hardware design for the solution.
  2. System Design – A description of the system flow and integration with internal and external systems that includes communication protocols, formats and frequency.
  3. System Process Flows – A collection of all the system process flows showing all the key points of system interaction and integration with internal and external systems.
  4. Data Dictionary – Shows all the tables, primary and foreign key constraints, fields’ values, stored procedures and triggers that provides its propose and usage.
  5. Message Mapping – A description of the mapping requirements between the message and the system.
  6. Message Management – A description of the message execution and error handling within the system, includes staging tables, validation rules and error handling.
  7. Screen Design and Execution – a description of the screen layout, field validation, database mapping/computation formula for each field and action upon clicking.
  8. RF (Radio Frequency) Design Flow – a description of the RF flow and explanation of the logic including exception handling on each RF screen.
  9. Reports – a description of all the reports required (operational and planning).  The details should include descriptions of all online reports, purpose/usage, intended audience, parameters and corresponding validations on screen, data extration source and logic, report format/layout and report export requirements.

1 Response to “System Specification Document for Warehouse Management System”

  1. November 13, 2009 at 3:15 am

    I have been reading your posts lately, just want to say thanks for all informative stuff i have found here, helped me learn alot lately.

    Much Regards, Mark

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

October 2009
« Sep   Nov »


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 464 other followers


%d bloggers like this: