Versions Compared

Key

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

Introduction

Once the Trade Categories are defined, the next task is to define :

  • “Trade Types”.

  • Map “Trade Category” & “Types”

    -

    • Define Trade Types

    • Map Trade Category to listed Trade Types

    The Trade Type can be defined as the next (2nd) level classification of the Trade. There can be multiple trade types and can vary depending on ULB to ULB, state to statethe list may vary from one State/ULB to another.

    Data Table

    Sr.No.

    *Trade Category Code

    *Trade Type Code

    *Trade Type Name (English)

    Trade Type Name (Local Language)

    1

    TC1

    TRADE_TYPE_MEDICAL

    Hospital

    अस्पताल

    2

    TC2

    TRADE_TYPE_HOTEL

    Hotels

    होटल

    Note: Data given in the above table is a sample The table above contains sample Trade Type data.

    Procedure

    Data Definition

    Sr. No.

    Column Name

    Data Type

    Data Size

    Mandatory

    Description

    1

    Trade Category Code

    Reference

     64

    Yes

    The Code assigned to the Trade Category. Eg: TC1 For Goods, TC2 for Services.

    2

    Trade Type Code

    Alphanumeric

    64

    Yes

    The Code assigned to the Trade Type. Eg: TRADE_TYPE_MEDICAL is assigned to Hospitals

    3

    Trade Type Name (English)

    Text

    256 

    Yes

    Name of the Trade Type in English. Eg: Goods, Services etc.

    4

    Trade Type Name (Hindi)

    Text

    256 

    Yes

    Name of the Trade Type in Local Language (as decided). Eg: Service is described as “सर्विस” in Hindi.

    How to fill data

    Steps to create Trade Type master data table

    1. Download the data template attached to this page.

    2. Get a good understanding of all the headers in Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.In case of any doubt, please .

    3. Please reach out to the person who has shared this template with you to discuss and clear your doubts.

    4. Identify the “Trade Types” that exists at a ULB/ State level.

    5. Collect the above information and feed it below the “Trade Type Name” column accordingly. The Description of Trade Type Name must be provided as per the language specified in the respective column.

    6. Add the “Trade Type Code” respectively against the identified trade categories(s).

    7. Fill in the appropriate Trade Category Code from “Trade Category” master for the respective trade type accordingly. The predefined format of the Trade Category Code only must be used from Trade Category Master Sheet and not any random code.

    8. The respective mapping between Trade Categories & Trade Types is defined by columns “ Trade Category Code” & “Trade Type Code”Select the relevant Trade Category Code from the available drop-down list of Trade Category. This will map the listed Trade Type to the corresponding Trade Category.

    9. Enter a unique Trade Type Code to identify the type of trade.

    10. Enter a Trade Type Name (English).

    11. Enter the Trade Type Name (Hindi).

    Checklist

    The checklist is contains a set of activities to be performed one once the data is filled into a template to ensure data type, size, and format of data is as per the expectationentry requirements are met. These activities have been divided into 2 groups as given below.

    Common Checklist

    This checklist covers all the activities which are common across the entities.

    Sr. No.

    Checklist Parameter

    Example

    1

    Make sure that each and every point in this reference list has been taken care of.

    Checklist

    Entity Specific Checklist

    This checklist covers the activities which are specific to the entity.

    Sr. No.

    Checklist Parameter

    Example

    1

    The format of the Trade Category Type Code defined should be alphanumeric and unique.

    TC1 : Goods

    TC2: ServicesTRADE_TYPE_MEDICAL

    TRADE_TYPE_HOTELS

    2

    Trade Type Name (In in either Languageslanguage) should not contain any special characters.

    Hospital: [Allowed]

    #Hospital! : [Not allowed]

    Attachments

    Configurable Data Template -Trade License Type

    (Refer to “Trade Type” tab in the attached file).


    View file
    nameConfiguration Data Template- Trade Master.xlsx

    Sample Configurable Data- Trade License Type


    View file
    nameSample Configuration Data Template- Trade Master (Filled).xlsx