Product Modeling
Entity | Attribute | DataType | Description |
Categories | Id | Number | Id of MenuItem Category |
| Name | Text | Name of Category Name |
| TenantId | Number | TenantId given by DinePlan team |
| IsDeleted | Boolean |
|
| DeleterUserId | Number | Name of User who last deleted the Category |
| Deletion Time | DateTime | Date and Time when the Category is Deleted |
| LastModificationTime | DateTime | Date and Time when the Category is Modified |
| LastModifierUserId | Number | Name of User who last modified the Category Names |
| Creation Time | DateTime | Date and Time when the Category is Created |
| CreatorUserId | Number | UserId who created the Categories |
| Code | Number |
|
| Oid | Number |
|
MenuItems | Id | Number | Id of MenuItem |
| Name | Text | Name of MenuItem |
| BarCode | Number | BarCode of MenuItem |
| AliasCode | Number | AliasCode of MenuItem |
| AliasName | Text | AliasName of MenuItem |
| ItemDescription | Text | ItemDescription of MenuItem |
| ForceQuantity | Boolean | Whether the products need to ask Quantity or Not |
| ForceChangePrice | Boolean | Whether the products need to ask Price or Not |
| CategoryId | Number | Id of MenuItem Category |
| TenantId | Number | TenantId given by DinePlan team |
| IsDeleted | Boolean |
|
| DeleterUserId | Number | Name of User who deleted the MenuItem |
| Deletion Time | DateTime | Date and Time when the MenuItem is Deleted |
| LastModification Time | DateTime | Date and Time when the MenuItem is Modified |
| LastModifierUserId | Number | Name of User who last modified the MenuItem Names |
| Creation Time | DateTime | Date and Time when the MenuItem is Created |
| CreatorUserId | Number | UserId who created the MenuItems |
| Product Type | Number | Product Type of MenuItems |
| Tag | Text |
|
| Transaction TypeId | Number |
|
| Locations | Text |
|
| Files | Text |
|
| Group | Boolean |
|
| Oid | Number |
|
| DownloadImage |
|
|
| Uom | Text |
|
| RestrictPromotion | Boolean | Where the MenuItem need Promotion or not |
| No Tax | Boolean | Where the MenuItem have Tax or not |
| NonLocations | Text |
|
MenuItemPortions | Id | Number | Id of MenuItemPortions |
| Name | Text | Name of MenuItemPortions |
| MenuItemId | Number | Id of MenuItem |
| Multiplier | Number |
|
| Price | Number | Price of MenuItemPortions |
| Creation Time | DateTime | Date and Time when the MenuItemPortion is Created |
| CreatorUserId | Number | UserId who created the MenuItemPortions |
| IsDeleted | Boolean |
|
| DeleterUserId | Number |
|
| Deletion Time | DateTime |
|
| LastModificationTime | DateTime | Date and Time when the MenuItemPortion is Modified |
| LastModifierUserId | Number |
|
OrderTagGroups | Id | Number |
|
| Name | Text |
|
| MaxSelectedItems | Number | Select Maximum Quantity of OrderTags |
| MinSelectedItems | Number | Select Minimum Quantity of OrderTags |
| SortOrder | Number | SortOrder of OrderTags |
| AddTagPriceToOrderPrice | Boolean | Add Price for the OrderTags |
| SaveFree Tags | Boolean | SaveFree Tags save the Free Tagging |
| Free Tagging | Boolean | Can enter the custom Free Tags |
| TaxFree | Boolean | Where the OrderTag have Tax or not |
| TenantId | Number | TenantId given by DinePlan team |
| IsDeleted | Boolean |
|
| DeleterUserId | Number | Name of User who last deleted the OrderTagGroups |
| Deletion Time | DateTime | Date and Time when the OrderTagGroup is Deleted |
| LastModification Time | DateTime | Date and Time when the OrderTagGroup is Modified |
| LastModifierUserId | Number | Name of User who last modified the OrderTagGroups |
| Creation Time | DateTime | Date and Time when the OrderTagGroup is Created |
| CreatorUserId | Number | UserId who created the OrderTagGroups |
| Prefix | Text | Can add the Prefix for the OrderTagGroups. |
| Locations | Text | Name of the Location the OrderTagGroup belogs to |
| Group | Boolean |
|
| Oid | Number |
|
| NonLocations | Text |
|
OrderTags | Id | Number | Id of OrderTags |
| Name | Text | Name of OrderTags |
| SortOrder | Number |
|
| Price | Number | Price of OrderTag |
| OrderTagGroupId | Number | Id of OrderTagGroup |
| MenuItemId | Number | Id of MenuItem |
| Creation Time | DateTime | Date and Time when the OrderTag is Created |
| CreatorUserId | Number | UserId who created the OrderTags |
| MaxQuantity | Number |
|
| AlternateName | Text | AlternateName of OrderTags |
OrderTagMaps | Id | Number | Id of OrderTagMaps |
| OrderTagGroupId | Number | Id of OrderTagGroup |
| CategoryId | Number | Id of Category |
| MenuItemId | Number | Id of MenuItem |
| Creation Time | DateTime | Date and Time when the OrderTagMap is Created |
| CreatorUserId | Number | UserId who created the OrderTagMaps |
ProductComboes | Id | Number | Id of ProductComboes |
| MenuItemId | Number | Id of MenuItem |
| AddPriceToOrderPrice | Boolean | Add the price for the Combo Items |
| Creation Time | DateTime | Date and Time when the ProductComboes is Created |
| CreatorUserId | Number | UserId who created the ProductComboes |
| Name | Text | Name of ProductComboes |
ProductComboGroups | Id | Number | Id of ProductComboGroups |
| Name | Text | Name of ProductComboGroups |
| SortOrder | Number |
|
| Minimum | Number |
|
| ProductComboId | Number | Id of ProductCombo |
| Creation Time | DateTime | Date and Time when the ProductComboGroup is Created |
| CreatorUserId | Number | UserId who created the ProductComboGroups |
| Maximum | Number |
|
ProductComboItems | Id | Number | Id of ProductComboItems |
| Name | Text | Name of ProductComboItems |
| ProductComboGroupId | Number | Id of ProductComboGroup |
| MenuItemId | Number | Id of MenuItem |
| AutoSelect | Boolean | Its Auto select the ComboItems |
| Price | Number | Price of ProductComboItems |
| SortOrder | Number |
|
| Creation Time | DateTime | Date and Time when the ProductComboItems is Created |
| CreatorUserId | Number | UserId who created the ProductComboItems |
| Count | Number |
|
| AddSeperately | Boolean |
|