In this application there is also a feature to create a list of categories to simplify the recording of groups of goods. That will be recorded in this application is
- Code the group of goods / goods group . Serial number in order to avoid the mess of data .
- Name of categories / groups of goods. Name to each group of goods .
In MS SQL Sever we also have to create a table to enter data categories with the column fields as follows:
Field Name
|
Data type
|
Explaination
|
GrpCd (PK)
|
Varchar(10)
|
Code of grouping
|
GrpNm
|
Varchar(50)
|
Name of grouping
|
Info
|
Char(1)
|
New data
notification
|
Status
|
Char(1)
|
Status of data sent
|