Back to list of main tables
| Field number | Field Name | Description | Type | Length | Index |
| 7 | application_date | The date of application | Date | | |
| 8 | application_number | A unique number assigned to track the application | Long Integer | | |
| 9 | approval_date | The date the application was approved (blank if never approved) | Date | | |
| 17 | category1_ID | ID of the category record related to this record | Alpha | | |
| 18 | category2_ID | ID of the category2 record related to this record | Alpha | | |
| 19 | category3 | Free-form text field for another category of the user's choice | Text | | |
| 20 | category4 | Free-form text field for another category of the user's choice | Text | | |
| 16 | comment | User-entered free text | Text | | |
| 13 | created_by | The ID of the user who created the record | Alpha | | |
| 1 | ID | The unique ID of the record | Alpha | | Y |
| 15 | is_currently_registered | True if currently registered (automatically turned off by mSupply on registration expiry) | Boolean | | |
| 2 | Item_ID | The ID of the item associated with this record | Long Integer | | Y |
| 4 | Manufacturer_ID | The ID of the Manufacturer associated with this record | Long Integer | | Y |
| 11 | modified_date | The date the record was last modified | Date | | |
| 12 | modified_time | The time the record was last modified | Time | | |
| 6 | pack_size | The pack sizes for this item | Text | | |
| 10 | registration_expiry_date | The date the registration expires | Date | | |
| 14 | registration_number | The unique number (or code) given to the registration | Text | | Y |
| 3 | Supplier_ID | The ID of the Supplier associated with this record | Long Integer | | Y |
| 5 | trade_name | The name the item is being registered under | Alpha | | Y |
| Field number | Field Name | Description | Type | Length | Index |
| 2 | Description | The category name | Alpha | | |
| 1 | ID | The unique ID of the category | Alpha | | Y |
| Field number | Field Name | Description | Type | Length | Index |
| 2 | Description | The category name | Alpha | | |
| 1 | ID | The unique ID of the category | Alpha | | Y |