Introduction
Once the Trade Categories are defined, the next task is to define :
“Trade Types”.
Map “Trade Category” & “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 state.
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 data.
Procedure
Sr. No. | Column Name | Data Type | Data Size | Mandatory | Description |
|---|---|---|---|---|---|
1 | Trade Category Code | Alphameric | 64 | Yes | The Code assigned to the Trade Category. Eg: TC1 For Goods, TC2 for Services. |
2 | Trade Type Code | Text | 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
Download the data template attached to this page.
Get a good understanding of all the headers in 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 reach out to the person who has shared this template with you to discuss and clear your doubts.
Identify the “Trade Types” that exists at a ULB/ State level.
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.
Add the “Trade Type Code” respectively against the identified trade categories(s).
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.
The respective mapping between Trade Categories & Trade Types is defined by columns “ Trade Category Code” & “Trade Type Code”.
Checklist
The checklist is a set of activities to be performed one the data is filled into a template to ensure data type, size, and format of data is as per the expectation. 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. |
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 Code defined should be alphanumeric and unique. | TC1 : Goods TC2: Services |
2 | The format of the Trade Type Code defined should be text and unique. | TRADE_TYPE_MEDICAL |
3 | Trade Type Name (In either Languages) should not contain any special characters. | Hospital: [Allowed] #Hospital! : [Not allowed] |
Attachments
Refer to “Trade Type Tab” in the uploaded template. This sheet consists of a blank template for filling in the data.
2. Refer to “Trade Type Tab” in the uploaded template, for filled-in sample data. This sheet consists of sample data for reference.