Hi
Basically..
For all customers, the below logic is applied.
Below $200 = $58
$200 - $299 = $48
$300 and above = FOC
However, for certain Customers, minimum order must be $150 for FOC otherwise the charges will be $ 48, but then user can remove it manually.
for certain Customers will be determined by Industry Code 1. There can be more than 1 Industry Code 1 for academics, thus I believe we need to maintain table to capture the Industry Code 1 that can enjoy such privilege.
pls can some one guide how to mainatin in the tables and fulfill this req.
Thanks