| Name | Description | Type | Additional information |
|---|---|---|---|
| ID |
Sequential ID |
integer |
None. |
| DepartmentID | integer |
None. |
|
| SubDepartmentID | integer |
None. |
|
| MinorDepartmentID | integer |
None. |
|
| Name | string |
String length: inclusive between 0 and 60 |
|
| Code | string |
String length: inclusive between 0 and 20 |
|
| DepartmentCode | string |
String length: inclusive between 0 and 20 |
|
| SubDepartmentCode | string |
String length: inclusive between 0 and 20 |
|
| MinorDepartmentCode | string |
String length: inclusive between 0 and 20 |
|
| Updated | date |
None. |
|
| SalesMode | SalesMode |
None. |
|
| GSTPercent | integer |
None. |
|
| CostGSTPercent | integer |
None. |
|
| EarnLoyaltyPoints | boolean |
None. |
|
| QuantityOverride | boolean |
None. |
|
| QuantityRequired | boolean |
None. |
|
| AllowDiscounts | boolean |
None. |
|
| DiscountDiscounts | boolean |
None. |
|
| ItemRecalled | boolean |
None. |
|
| NoRefund | boolean |
None. |
|
| Active | boolean |
None. |
|
| AllowMarkdown | boolean |
None. |
|
| DefaultGP | decimal number |
None. |
|
| LabelShelfDefault | integer |
None. |
|
| LabelTalkerDefault | integer |
None. |
|
| LabelSmall | boolean |
None. |
|
| Tags | string |
None. |
|
| UnitMeasureKind | integer |
None. |
|
| FuelItem | boolean |
None. |
|
| TrackSerial | boolean |
None. |
|
| WarrantyPeriod | integer |
None. |
|
| CostCalcMethod | CostCalcMethod |
None. |
|
| ProviderName | string |
None. |
|
| OverrideHostMargin | boolean |
None. |
|
| KeepDescription |
when false, changes to HostDescription should flow to receipt Name. (OverrideHostDescription) |
boolean |
None. |
| MSCCommodity | string |
None. |
|
| AllowAutoOrder | boolean |
None. |
|
| ExcludeFromWebUpdate | boolean |
None. |
|
| WebPriceBasedOn | boolean |
None. |
|
| LabelFormat | string |
None. |
|
| SendToScale | boolean |
None. |
|
| LabelPageLayoutG_UID | Collection of byte |
None. |
|
| LabelPageLayoutGuid | globally unique identifier |
None. |
|
| MinimumAge |
Only a default on the Department table |
integer |
Relation. This field may not always be loaded or used for updates. |
| CountryOfOrigin | string |
Relation. This field may not always be loaded or used for updates. |
|
| ServiceFeeID |
Only a default on the Department table |
integer |
None. |
| EftCode |
Only a default on the Department and SubDepartment table |
integer |
None. |
| DefaultPrinter |
Only a default on the Department and SubDepartment table |
string |
String length: inclusive between 0 and 60 |
| DefaultPrinterGroup |
Only a default on the Department and SubDepartment table |
string |
String length: inclusive between 0 and 60 |
| BuyingLimit |
Buying Limit for Department. Below are possible values NULL=Dept/SubDept Limit will be used 0=Unlimited - Regardless of Dept/SubDept limits +ve integer |
integer |
None. |
| BuyingLimitIndependent |
This indicates if buying limit is independent from other limits like Product/PriceGroup. If yes, limit does not count towards other limits like Product/PriceGroup limit. For example, if toilet paper has BuyingLimit=1 and Grocery Dept has BuyingLimit=2 - if true, transaction may have 1xTP and 2xGrocery - if false, 1xTP and 1xGrocery |
boolean |
None. |
| BuyingLimitType |
It indicates whether limit applies to category or item |
BuyingLimitType |
None. |
| IncludeInDistinctLimit |
It indicates whether this limit includes in distinct store level limit |
boolean |
None. |
| DefaultsEmpty | boolean |
None. |
|
| MSCCat | MSCCategory |
Relation. This field may not always be loaded or used for updates. |
|
| MSCCom | MSCCommodity |
Relation. This field may not always be loaded or used for updates. |
|
| MSCDep | MSCDepartment |
Relation. This field may not always be loaded or used for updates. |
|
| MSCSubCom | MSCSubCommodity |
Relation. This field may not always be loaded or used for updates. |