Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Contractors are basically who takes up the works which is awarded by the State or a ULB for a set period. For Example Construction of New Roads/Bridges, Maintenance of Parks etc.

Data Table

*Sr. No

*Name

*Contractor Code

*Permanent Address

Correspondence Address

*Registration No.

*Contact Person

Email ID

*Mobile No.

PAN No.

*GST/TIN No.

*GST registered State/UT

Bank Name

Bank Account No.

IFSC Code

*Status (Active/Inactive)

1

Rakesh

RAK00123

#141/25 2nd Cross koramangala Bangalore

#62 5th main road

ITPL Bangalore

NIL

Rakesh

Rakesh@gmail.com

98XXXXXX45

AFRXXXX64N

NIL

NIL

ICICI

000XXXX1234

ICICI0XXXX97

Active

2

ABC Constructions

ABC00143

#1/1 8th Main JP Nagar Bangalore

NIL

Z12345KA2020PTC097654

Mahesh

contact@abcconstruction.com

987XXXXXX65

PNBXXXX78U

22AAAAA0000A1Z5

45GGGGG0000A1X6

HDFC

987XXXXX64

HDFC0XXXX51

Active

...

  • Sr No: Defines the serial no of the line item.

  • Name: The register Name of the Company/Firm Name or a Individual Person Name, this will help the user to easily identify the contract assigned and also while generating the bills.

  • Contractor Code: A unique code that identifies the contractor of the works.

  • Permanent Address: Company/Firm permanent address or a Individual Person permanent address, this will help the user to send the hard copy document to the contractor. Example, A signed hard copy of the contract.

  • Correspondence Address: Alternative address of a Company/Firm or a Individual Person Alternative address

  • Registration No: Company/Firm registered number, it’s a unique number assigned by the Registrar of Companies. The registration number is made up of an alphanumeric code that is 21 digits long

  • Contact Person: Details of a contact person of a individual or a Company/Firm. THis will help the user to contact a person in case of any information required.

  • Email ID: Company/Firm email Id or a individual person email Id, with the email Id the contractor can receive the notification related to works and payments.

  • Mobile No: Company/Firm Mobile number or a individual person mobile number, the contractor can receive a SMS alerts after the bills are processed.

  • PAN No: Company/Firm registered PAN number or a individual person PAN number

  • GST/TIN No: Company/Firm registered GST/TIN number is a Tax Identification Number which is a unique 15-digit number.

  • GST registered State/UT: The company/Firm has a multiple business with the state or union territory a separate registered GST number is a Tax Identification Number which is a unique 15-digit number.

  • Bank Name: Company/Firm 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/Firm Bank Account number or a individual person Bank Account number. With the bank account number the bill payment can be made to the correct account, also while doing the RTGS fund transfer the amount can be transferred to the respective firms or individual account.

  • IFSC Code: The Bank IFSC code pertaining to the bank Account of the Company/Firm or a Individual person holding a bank account, the IFSC code will be a validation check for the bank account provided by the contractor and useful for the user while doing a bill payment via RTGS.

  • Status: Active/inactive status to be mentioned for the individual contractor

...

  • Identify all the “Contractor” details which exists at State and ULB Level.Collect all the information .

  • Download both the attached template and to updated all the details as per the above information in the empty template provided. The sample data template can be used as a reference to fill in the data.

  • Read through all the information above before updating the template and feed into the respective columns accordingly.

...

  • 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 AFRXXXX37P).

  • The IFSC code should consists of 11 digit alphanumeric (Example ICICI0XXXX97).

  • Length of the fields should be as below:

    • Name : 50 characters

    • Contractor Code : 50 characters

    • Correspondence address /Permanent address : 250 characters

    • Contact Person : 100 characters

    • Mobile No : 12 characters

    • GST/TIN No : 15 characters alphanumeric

Attachments

  • Refer to “Contracts Tab” in the uploaded template.

  • For sample data reference, refer to the uploaded “sample date” file.

View file
nameSample Data Template - Contractor.xlsx
View file
nameTemplate Sample Data - Contractor.xlsx