| A. |
COMPANY CODE
Must be passed to program as a parm, used as key to freight table. |
| B. |
FOB CODE (must be passed to program as a parm, used as key to freight table) |
| C. |
ALT CODE 1:
The purpose of this code is to provide a duplicate FOB code; e.g.., if P1C is used on the sales order, and that code is not found in the table (column B), then an ALTERNATE code lookup will be done to column C. |
| D. |
ALT CODE 2:
The purpose of this code is to provide a duplicate FOB code; e.g., if P1C is used on the sales order, and that code is not found in the table (column B), then an ALTERNATE code lookup will be done to column C. |
| E. |
RATE CODE:
|
Code
|
Description |
|
F
|
Flat Rate charge – BASED on total dollar amount of order |
|
Q
|
Flat Rate charge – BASED on total quantity amount of order |
|
P
|
Flat Rate charge – BASED on a percentage of amount of order (column O) |
|
V
|
Actual Varsity charge |
|
W
|
Flat Rate charge – BASED on weight of total order (pounds) |
|
V
|
Calculate VARSITY regular charges. After the freight charges are calculated, the amount is compared to the amount in column J. If the amount is greater than the freight calculated, then the amount in column J will replace the calculated freight amount (MINIMUM charges). |
|
|
|
|
| F. |
CUSTOMER TYPE
Passed as a parm to the program, and used as a key to freight table. |
| G. |
FROM (range)
Compared to either the QUANTITY or DOLLAR amount, lower limit. |
| H. |
TO (range)
Compared to either the QUANTITY or DOLLAR amount, upper limit. |
| I. |
Actual FREIGHT amount charged
Should always be ZERO if rate type is “V” or “P”. |
| J. |
ADD CODE 1:
The purpose of this code is to allow ADDITIONAL CHARGES to be applied when necessary. If this code is passed to the RATE CALCULATION program, then whatever amount is in column K will be added to the freight charges. |
| K. |
The purpose of this field is to apply additional charges based on column K. The amount in this column will be added to the total freight charges if column K is non-blank. |
| L. |
ADD CODE 2:
The purpose of this code is to allow ADDITIONAL CHARGES to be applied when necessary. This code is NOT passed to the RATE CALCULATION program. If this code in not blank, then additional charges will always be applied. The following codes indicate HOW the charge is calculated. Either the ADDITIONAL CHARGES 2 amount (column N) is applied, or, ADDITIONAL PERCENTAGE OF CHARGES is applied (column O), depending on which one is zero. It is possible for BOTH additional amount AND additional percentage to apply.
|
Code
|
Description |
|
P
|
The additional amount in column N is multiplied times the quantity ordered and applied to the total freight amount as additional charges. |
|
F
|
The additional amount in column N is added to the total amount of freight. Additional charges could also be applied based on a PERCENTAGE of the total order, if a percentage is entered into column O. |
|
| M. |
ADDITIONAL CHARGES – 2
The purpose of this field is to apply additional charges to the freight charges calculated. The application will be based on specific RATE CODES; i.e., rate code P will charge whatever is in column N times the quantity purchase. If column K is an F, then the amount in column N will be added to the total freight charges. |
| O. |
ADDITIONAL CHARGES - PERCENTAGE |
|
The purpose of this field is to apply additional charges based on the TOTAL CHARGE amount. This may be in addition to ADDITIONAL CHARGES –2 (column L). Or, if the RATE TYPE in column E is a P, then the percentage is column O is used in calculating the TOTAL freight charges. |
| P. |
COUNTRY CODE
If COUNTRY CODE is passed to this program (country code from sales order entry), then the code is used to lookup a cross reference code found in UDC table, that will correspond to a code in column P, and used to chain to the FREIGHT TABLE. The UDC table will be a duplicate of the country code table, and contain a 2 character code that can be found in this column. |
