Task #18365
Updated by Redmine Admin 6 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`
* [ ] Provide application package to IT
* [ ] Update Company Name & Address on MaccsPortal