Task #18365
Updated by Redmine Admin 3 months ago
# Deployment Checklist for Air Import Delivery Order Functionality (Master and House) ## SQL Server (Production) * [x] Create stored procedure `SP_GetCompanyDetailsByID` on SQL Server production environment. --- ## Oracle Database (Production) ### Tables * [x] Create table `MASTER_DELIVERY_ORDER`. * [x] Create table `HOUSE_DELIVERY_ORDER`. ### Sequences * [x] Create sequence `MASTER_DO_SEQ`. * [x] Create sequence `SEQ_MDO_REF`. * [x] Create sequence `HOUSE_DO_SEQ`. * [x] Create sequence `SEQ_HDO_REF`. ### Triggers * [x] Create trigger `TRIG_MASTER_DO_ID`. * [x] Create trigger `MDO_DATE_TRIG`. * [x] Create trigger `TRIG_HOUSE_DO_ID`. * [x] Create trigger `HDO_DATE_TRIG`. ### Package * [x] Create PKG_DELIVERY_ORDER package. --- ## Configuration Updates ### SERVICE_CONFIG Table (Oracle Schema `CCS_COMMON`) * [x] Insert SMTP configuration in `SERVICE_CONFIG` table. * [x] Confirm values: * ID: `2` * SERVICE_NAME: `EMAIL_SERVICE` * MODULE: `CCS` * KEY: `SMTP_ADDRESS` * VALUE: `smtp01.maccs.oci.ldn.com` * [x] [ ] Provide application package to IT * [x] Update Company Name & Address on MaccsPortal