Introduction
common.dimPartCategories
| Column Name | Description | Type | Is Unique |
|---|---|---|---|
| CategoryID | The primary key for Category Table | int | Yes |
| Name | Category Name | nvarchar(320) | Yes |
| BomCode | The category by which bill of material is identified | nvarchar(320) | Yes |
| Import ID | NA/to be deleted | int | ? |
| Description | Category Description | nvarchar(320) | Yes |
| Modified By | Who modified the record | nvarchar(320) | No |
| Modified Date Time | Date and time when the record was modified | Date | No |
| Quotation Order | The order by which the category occurs on a quotation | int | Yes |
| Is Deleted | Is the category deleted or not | bool | No |
| IsAssembly | Is the component for Assembly | bool | No |
| IsMade | Is the component made | bool | No |
| IsPurchased | Is the component purchased | bool | No |
| IsMachined | Is the component machined | bool | No |
| IsModifiedPurchased | Is the component Modified purchased | bool | No |
| IsFabricated | Is the component fabricated | bool | No |
| IsElectricalPanel | Is the component an electrical panel | bool | No |
| IsElectricalField | Is the component an electrical field | bool | No |
| IsOem | Is the component an OEM(original equipment manufacturer) | bool | No |
| IsRawMaterial | Is the component a raw material | bool | No |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article