The system table list offered during checkout should be dependent upon whether the bundle is a small carrier shipment (UPS/FEDEX) or a large carrier shipment (LTL/COMMON CARRIER). Filter the list returned to the UI accordingly.
Modify LDLIB RPC$SYSTEMTABLEITEM_GETBYFILTER:
If TIER.CD = "VIA", add the following to the SELECT statement:
- If SHIP.FOB = "CPU", return only CPU ship via
- If CRITERIA = "LTL", select VIA system items with field 1 = "CC"
- If CRITERIA is not LTL, select VIA with field 1 # "CC" *** 5/21/14 - this has been changed to: select VIA with field 1 # "" and with F1 # "CC" so that we don't get the few with null field 1, including Freight Collect and Ship w/another order. We have added "PO" to field 1 of POST OFFICE so that this will be selected.
UI Side:
- Must pass CRITERIA based on FOB Code based on LTL.FLAG for the bundle (if LTL.FLAG = 1, set CRITERIA = "LTL")
- Must pass the bundle's FOB Code in SHIP.FOB.
Per John 5/19:
We could set up a numeric flag for CRITERIA.
0 or “” means all carriers
1 means Common Carriers
2 means small package carriers.