Description |
Background:
* To prevent duplication of data entry we need a check on duplicate BOLs
* Many BOL#s can duplicate over the years due to vendors only using 6 digit BOL#.
* Expand to only give error on Duplicates when BOL# is for the Same Vendor and Same Date
Requirements:
* During Post Check BOL # to be unique by Vendor and Date
** Fail if the BOL# is found on another Transport Load for the Same Vendor and Same Date.
** Possible Scenarios:
*** Pass = No Duplicate Error
*** Fail = Duplicate is Found
|BOL#|Vendor|Date|Pass/Fail|
|Match|Match|Match|Fail|
|Match|Match|Different|Pass|
|Match|Different|Match|Pass|
|Match|Different|Different|Pass|
|Different|Match|Match|Pass|
|Different|Match|Different|Pass|
|Different|Different|Match|Pass|
|Different|Different|Different|Pass|
|