Friday, August 21, 2009

WMS Database Design (Addressing structure)-2.part


The addressing is done by scanning the barcode codes on the containers. This process should be very simple and very fast. Container to container movement should be done by scanning only two barcodes: the barcode of container to be emptied and the barcode of the container to which goods from first container to be moved. The barcode codes should be unique and should have a merchandise in them. To distinguish between merchandise, address locations and containers from each other a barcoding rule is to be applied. I used first digit of barcodes to distinguish the types of containers and the length of barcodes to distinguish merchandise from address locations.
For example: when container barcode is scanned and first digit is letter "B", system recognizes it as a box container, if it was letter "R" it recognizes the location of row, if it was the letter "P" it recognizes the pallet number and so on. If container number is scanned, system searches if this address exists, if it exists it searches if the merchandise in this container is allocated for picking, if merchendise for picking is allocated, it searches if it is collected and scanned, if it is collected end scanned, program allows the user to scan the next barcode otherwise it prints error message and error description onto the screen. All this control mechanism takes no longer than 1 second in Access databese. The next barcode could be a merchandise barcode or container barcode. If the second barcode is another location address, system puts all the merchandise from the first container to second container. If second barcode is merchandise barcode system waits for the third barcode to be scanned and third barcode should be a final destination barcode. When third barcode is scanned, system puts merchandise scanned second from the container scanned first into the container scanned third. Program also choses whether the location is primary address or secondary address.

No comments: