Introduction
A supplier is a person or business that provides a product or service to another entity. The role of a supplier in a business is to provide high-quality products.
A supplier may also be refereed as a vendor who supplies required materials or a product to the State or ULB for the works which need to be executed. (Example: materials for street light, cable wires for street light etc)
Data Table
Sr. No | *Name | *Permanent Address | Correspondence Address | *Supplier Code | Contact Person | *Email ID | *Mobile No. | PAN No. | GST No. | Bank Name | Bank Account No. | IFSC Code |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ABC Supplies | #5 6th main cross opp to ICICI bank Punjab | NIL | ABC134 | Ramesh | abcsupplies@gmail.com | 98XXXXXX21 | APRFN9561B | 22AAAAA0000A1Z5 | ICICI | 2XXXX1234XX4 | ICICI00XXXX7 |
2 | Suresh Traders | 10 main road Punjab | #62 5th main road ITPL Punjab | MB0099 | Rakesh | sureshtraders@xyz.com | 98XXXXXXX95 | ARIZG9874C | 22BBBBA0000A1Z5 | HDFC | 98XXXXX5X4 | HDFC00XXX51 |
Procedure
Data Definition
Sr No: Defines the serial no of the line item.
Name: Company Name or a Individual Person Name
Permanent Address: Company permanent address or a Individual Person permanent address
Correspondence Address: Alternative address of a Company or a Individual Person Alternative address
Supplier Code: A unique code that identifies the supplier of the goods
Contact Person: Details of a contact person of a individual or a Company.
Email ID: Company email Id or a individual person email Id
Mobile No: Company Mobile number or a individual person mobile number
PAN No: Company registered PAN number or a individual person PAN number
GST/TIN No: Company registered GST/TIN number is a Tax Identification Number is a unique 15-digit number.
Bank Name: Company Bank Name in which they hold the account or a individual person Bank account name which he/she holds the account
Bank Account No: Company Bank Account number or a individual person Bank Account number.
IFSC Code: The Bank IFSC code pertaining to the bank Account of the Company or a Individual person holding a bank account
Steps to fill data
Identify all the “Contractor” details which exists at State and ULB Level.
Collect all the information and feed into the respective columns accordingly.
Validations
All the fields with * sign are mandatory to be filled in. Without this information, the system configurations cannot be executed.
The Email ID should be valid Id, email Id should contain the Company/Firm name or a individual person name before the “@” and the “XXXXX.com” after the “@” (Example ABCltd@xeror.com).
The Phone number should be valid and must contain 10 digit number.
The PAN number should consists of 10 digit alphanumeric (Example AFRPN1237P).
The IFSC code should consists of 11 digit alphanumeric (Example ICICI0000297).
Attachments
Refer to “Suppliers Tab” in the uploaded template.
For sample data reference, refer to the uploaded “sample date” file.