How can we configure Saturday Delivery  for UPS in DCS?

Resolving The Problem

Saturday Delivery is a special service.
Special services information are downloaded from the Order Download (ORDD). A record type ORDNAM is used to download Special service requirements for an order. The details are downloaded into a table Ord_Rel_Name_Value.
They can also be associated to a shipper has been created in Yantra , using 02013 screen
The records for all special services have Common_Code_Type as 100 and different values for the "VALUE" field in the COMMON_CODES Table. or you can check it in function 09280.

The following special services are supported in DCS Version 6.2.

Code Values for Special Services Table
Special Service Name Common_Code_Type Common_Code_Value Description
Saturday Delivery 100 101 SATDELI
Delivery Confirmation100 102 DELCONF
Cash on Delivery 100 103 COD
Declared Value Insurance100 104 DECLVAL
Verbal Confirmation 100 105 VRBLCONF
Online Call Tag 100 106 ONLCALLTAG
Contract Print Return Label100 107 CONPRLBL
Signature Required 100 108 SIGNREQD
Ship Notification 100 109 SHPNTFY
Hold for Pickup 100 110 HLDFRPCKUP
Adult Signature Required100 111 ADLTSGNRQD
Hazardous material 100 NA
Hundred Weight 100 NA
Saturday Pickup 100 NA

Any special services (such as Saturday Delivery or Signature Required) must be set up in the MNF_CARR_SPL_SRVC table. There are SQL scripts provided with the release that will set up the special services for UPS and FedEx. If you need to set up your own special services, the following describes what should be in the table:
Whse
Spl_srvc_group: Used in the MNF_CARRIER table. Any carrier with this spl_srvc_group will use these special services
Spl_srvc_id: Unique ID from this special service.
Charge_type: Type of charge that should be used when calculating the freight charge. Possible values are:
1 = flat charge
2 = % on weight
3 = % on declared value
Charge_value: For charge type 1, this is the value that will be added to the freight charge if this special service is selected
Base_exempt_value: For charge type 2, the base value is the shipment weight for which no charge is applied for the special service. The charge is applied if the weight exceeds the baseweight. For charge type 3, the base value is the declared value of shipment for which no charge is applied for the special service. The charge is applied if the declared value exceeds the base value
Spl_srvc_type: Type of special service. Possible values:
01 = Surcharge: Special service is added automatically to charges if it applies.
02 = Normal: Special service will show up on carton scan screen for selection.
Select_by_default: For special service types 02, should this special service show up on the screen as selected by default?

Insert statement for the mnf_carr_spl_srvc table for UPSN and sat delivery

Insert into mnf_carr_spl_srvc
(WHSE, SPL_SRVC_GROUP, SPL_SRVC_ID, SPL_SRVC_REF, CHARGE_TYPE, CHARGE_VALUE, BASE_EXEMPT_VALUE, SPL_SRVC_TYPE, SELECT_BY_DEFAULT, DEACTIVATE_FLAG, REFERENCE_FIELD1, REFERENCE_FIELD2, REFERENCE_FIELD3, REFERENCE_FIELD4, REFERENCE_FIELD5, REFERENCE_FLAG1, REFERENCE_FLAG2, REFERENCE_FLAG3, REFERENCE_FLAG4, REFERENCE_FLAG5, CREATE_TIME_STAMP, MODIFY_TIME_STAMP, USERID, MOD_PROGRAM_ID)
Values
('FGI27', 'UPSN ', '101 ', '10 ',
'04 ', '0.25 ', '1 ', '02 ', 'N',
'N', '30', '30', '30', '30',
'30', '1', '1', '1', '1',
'1', sysdate, sysdate, 'SQLPLUS', 'SQLPLUS '
)