Introduction
Once the Trade Categories are defined, the next task is to define :
“Trade 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. |
Steps to create Trade Type master data table
Download the data template attached to this page.
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 .
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”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.
Enter a unique Trade Type Code to identify the type of trade.
Enter a Trade Type Name (English).
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. |
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] |