API - 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 0 -> No 1 -> Yes |
|
| ForceChangePrice | Boolean | Whether the products need to ask Price or Not 0 -> No 1 -> Yes |
|
| 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 1 -> MenuItem 2 -> Combo |
|
| 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 0 -> Promotion 1 -> RestrictPromotion |
|
| No Tax | Boolean | Where the MenuItem have Tax or not 0 -> 1 -> |
|
| 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 0 -> 1 -> |
|
| 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. (Less,More,No,etc) |
|
| 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 |