24015548263535
24015139263485
 
 BD Canteen Meal Booking System
CREATE TABLE [material_pi_master_merch](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[serial_no] [nvarchar](50) NULL,
	[pi_no] [nvarchar](50) NULL,
	[pi_type] [nvarchar](100) NULL,
	[pi_date] [date] NULL,
	[demand_date] [date] NULL,
	[season] [nvarchar](150) NULL,
	[customer] [nvarchar](100) NULL,
	[requested_by] [nvarchar](150) NULL,
	[requested_date] [nvarchar](50) NULL,
	[confirmed_by] [nvarchar](150) NULL,
	[confirmed_id] [int] NULL,
	[confirmed_date] [nvarchar](50) NULL,
	[certified_by] [nvarchar](100) NULL,
	[certified_id] [int] NULL,
	[certified_date] [nvarchar](50) NULL,
	[approved_by] [nvarchar](150) NULL,
	[approved_id] [int] NULL,
	[approved_date] [nvarchar](50) NULL,
	[received_by] [nvarchar](100) NULL,
	[received_id] [int] NULL,
	[received_date] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[create_date] [date] NULL,
	[user_id] [int] NULL,
	[user_name] [varchar](50) NULL,
	[create_datetime] [varchar](50) NULL,
	[update_datetime] [varchar](50) NULL,
	[department_id] [int] NULL
);





CREATE TABLE [material_pi_details_merch](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[serial_no] [nvarchar](20) NULL,
	[pi_id] [bigint] NULL,
	[pi_no] [nvarchar](100) NULL,
	[material_code] [nvarchar](100) NULL,
	[material_name] [nvarchar](250) NULL,
	[required_qty] [int] NULL,
	[bd_stock] [nvarchar](100) NULL,
	[purchased_qty] [nvarchar](100) NULL,
	[unit_name] [nvarchar](100) NULL,
	[unit_price] [nvarchar](20) NULL,
	[total_price] [nvarchar](20) NULL,
	[file_no] [nvarchar](100) NULL,
	[style_no] [nvarchar](100) NULL,
	[color_code] [nvarchar](100) NULL,
	[remarks] [nvarchar](250) NULL,
	[status] [nvarchar](50) NULL,
	[create_date] [date] NULL,
	[user_id] [int] NULL,
	[user_name] [varchar](50) NULL,
	[create_datetime] [varchar](50) NULL,
	[update_datetime] [varchar](50) NULL,
	[reason] [nvarchar](150) NULL,
	[resposible_dept] [nvarchar](50) NULL,
);
	




CREATE TABLE [dbo].[material_requisition_info_merch](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[requisition_no] [varchar](50) NOT NULL,
	[department_id] [int] NULL,
	[demand_date] [date] NULL,
	[material_type] [varchar](100) NULL,
	[customer] [nvarchar](100) NULL,
 	[file_no] [nvarchar](100) NOT NULL,
	[style_no] [nvarchar](100) NOT NULL,
	[color_code] [nvarchar](100) NOT NULL,
	[color_name] [nvarchar](100) NOT NULL,
	[bag_qty] [int] NULL,
 	[material_code] [nvarchar](100) NOT NULL,
	[material_name] [nvarchar](300) NOT NULL,
	[consumption_rate] [float] NULL,
	[mrequest_qty] [float] NOT NULL,
	[missue_qty] [float] NULL,
	[mreceive_qty] [float] NULL,
	[creator_id] [int] NULL,
	[creator_name] [varchar](50) NULL,
	[created_date] [date] NULL,
	[approved_by] [int] NULL,
	[approved_name] [varchar](50) NULL,
	[approved_date] [nvarchar](25) NULL,
	[received_name] [varchar](50) NULL,
	[received_date] [nvarchar](25) NULL,
	[issue_date] [date] NULL,
	[requisition_status] [int] NOT NULL,
	[diff_notes] [nvarchar](1000) NULL,
	[create_datetime] [varchar](50) NULL,
	[update_datetime] [varchar](50) NULL,
	[alter_item_code] [nvarchar](50) NULL,
	[unit_name] [nvarchar](50) NULL,
	[bmi_no] [nvarchar](150) NULL,
	[material_group] [nvarchar](50) NULL,
	[req_type] [int] NOT NULL,
	[reason_type] [int] NULL,
	[approved_by2] [nvarchar](100) NULL,
	[approved_by2_date] [nvarchar](20) NULL,
	[completed_date] [nvarchar](50) NULL,
	[approved_by2_name] [nvarchar](100) NULL,
 	[delivery_date] [nvarchar](20) NULL,
	[checked_by] [int] NULL,
	[checked_by_name] [nvarchar](100) NULL,
	[checked_date] [nvarchar](25) NULL,
	[remarks] [nvarchar](250) NULL,
 	[reject_note] [nvarchar](250) NULL,
	[UPRICE] [float] NULL,
	[CURRENCY] [nvarchar](30) NULL,
	[completed_by] [nvarchar](50) NULL,
	[received_by_pro] [nvarchar](50) NULL,
	[received_pro_date] [nvarchar](20) NULL
	 
    );
	
BWSO1182


Successful Completion and Delivery of [Project Name]

Dear Moyen & Parves vai,
Good Afternoon,


We are pleased to inform you of the successful completion and delivery of the PO Discount System development project. This project is part of OA it will help eliminate your manual work process. 

Application Name: PO Discount System

Major key function: 
1.	Purchase team easily can manage supplier discount amount,
2.	After approved PO no need to return purchaser can add discount amount
3.	Every year easily can get the data how much amount save compare with PO amount.
 
We are confident that these enhancements will contribute significantly to increased efficiency, reduced manual workload, and improved overall productivity

The PO Discount System is now ready for implementation, and we kindly request Purchase department to review the final deliverables. Should you have any questions, concerns, or require further clarification, please do not hesitate to reach out to me directly. 

We appreciate your ongoing support and look forward to the successful implementation of the project.

How to Access the Office Automation Application:
Your department have already access permission.

Training Sessions:
To ensure a smooth transition and to help you make the most of the new features, we will be conducting training sessions on [mention dates and times]. Attendance is highly encouraged
