Inward outward product
Download as DOCX, PDF
1 like906 views
The document describes four modules used by an Agricultural Produce Market Committee (APMC) to track produce coming into and leaving the market. The Gate Pass module tracks details of farmers and crops entering. The Auction module records crop sales from farmers to buyers. The Weight Register module records actual crop weights and generates bills. The Out Gate Pass module tracks crops leaving with buyers and helps ensure proper clearance.
Inward outward product
- 1. Inward - Outward Product Gate Pass : APMC can identify the how many no of farmer, crops come in APMC. Farmer come in APMC and generate gate pass in that they give the detail about residential, crops and agent for reference. This module is use by employee of APMC that is on gate. Repots: No. of farmer come in APMC. How many crops are come? How many types crops are come? gate_id int (auto increment) (primary key) farmer_nm varchar(20) agent_nm varchar(20) village varchar(20) crop_type varchar(10) vehicle_no varchar(10) Date varchar(10) quantity int incharge_empid varchar(10) Created By: Nikunj Antala Page 1 of 4
- 2. Auction : APMC can identify the how many crops is come sell by farmer and who is purchase so that APMC can collect the charge. This used by APMC employee that is on auction platform. Repots: APMC can identify the how many crops are sell by farmer. How many crops are purchase by buyer, what rate, who agent, and what quantity they purchase. id int (auto increment) date varchar(10) gate_id int (foreign key of gate_pass) farmer_nm varchar(20) crop_nm varchar(10) village varchar(10) agent_nm varchar(20) buyer_nm varchar(20) quantity int rate float remark varchar(50) Created By: Nikunj Antala Page 2 of 4
- 3. Weight register : In that APMC can recognize the crops actual weight. Also can have detail about farmer, agent, buyer, rate. This detail fill by APMC employee and given the copy to farmer, agent and buyer. Using that report we can generate the bill. Repots: Generate bill. Id Int (auto increment) Weightier_nm Varchar(20) Bill_no Int Village Varchar(10) Farmer_nm Varchar(20) Agent Varchar(20) Buyer_nm Varchar(20) Quantity Int Weight Float Crops Varchar(20) Created By: Nikunj Antala Page 3 of 4
- 4. Out Gate Pass : Using that report buyer can take report for crops. So that buyer can transfer crops outside APMC. Any buyer can leave without out gate pass so APMC can give penalty for buyer. Repots: APMC can identify buyer how many crops are transfer from APMC. Also they can see the buyer can buy crops but currently on APMC. id int (auto increment) buyer_nm varchar(20) crops varchar(10) weight float rate float total float Created By: Nikunj Antala Page 4 of 4