Docstoc

AMC

Document Sample
AMC Powered By Docstoc
					Product Master Extended fields

Serial Number        varchar(50)
Batch NO             varchar(50
Manu date            varchar(51
exp date             varchar(52
warrant from         varchar(53
warrant to.          varchar(54
AMC FROM             varchar(55
amc TO               varchar(56
barcode              varchar(57



product master
opst
mt
Customer Name                                                      AMC Date
Address                                                            AMC Expiry Date
AMC Type
Service Freqency

Sr. No                                              Product Name Serial Number       Rate Amount




List of Parts that would be replaced free of cost
Sr. No                                              Product Name




List of Services that would be covered Under AMC
Sr. No                                           Service Description




Terms and condition
Service Code Auto generated
Service desc
Sr. NO
date
Customer Name
Complaint Number
Complaint Detail
AMC Status
Complaint Type             new installation/in warranty custimer/not in warranty customer/ne requirement
Complaint Handed Over to
Complaint Registered By
Call date
Engineer Attendee
Spares Required if any
If not in AMC call charges
Amount
Narration
Sr. NO
date
Customer Name
Complaint Number
Complaint Detail
AMC Status
Complaint Type
Complaint Handed Over to
Complaint Registered By
Call date
Engineer Attendee
Spares Required if any
If not in AMC call charges
Amount
Narration
Call Status
Complaint Remark
Future Comment or parts replacement due
Machine Status
Serial Number
Product Outward/Inward (2 more transactions)(update grn n dispatch table)

Product Code Serial Number Location warrantyperiod AMC from AMC to Service Comprehensive
     10000001  1122233213     1001
     10000001  1122233214     1001
     10000001  1122233021     1001
     10000001  1122233211     1001
     10000002  1122231212     1222
     10000003  1122133212     1222
     10000004  1122233111     1222
     10000005  1111233111     1222
BatchNo location
Product Code
Serial Number
Location
warrantyperiod
AMC from
AMC to
Service
Comprehensive
BatchNo
location
Incase of dispatch the details wold be picked up stock ledger of inward cloumns only.
Product Inward

Product Code Serial Number Location warrantyperiod AMC from AMC to Service Comprehensive
     10000001  1122233213       1001
     10000001  1122233214       1001
     10000001  1122233021       1001
     10000001  1122233211       1001
     10000002  1122231212       1222
     10000003  1122133212       1222
     10000004  1122233111       1222
     10000005  1111233111       1222
location

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:8/28/2012
language:Unknown
pages:11