| Name | Description | Type | Additional information |
|---|---|---|---|
| ID | integer |
None. |
|
| Name | string |
Required String length: inclusive between 0 and 60 |
|
| Code | string |
Required String length: inclusive between 0 and 20 |
|
| SortOrder | integer |
None. |
|
| IsLiquor | boolean |
Deprecated. Use only IsTobacco field. |
|
| IsTobacco | boolean |
None. |
|
| ExcludeTalker | boolean |
None. |
|
| ExternalSales | boolean |
None. |
|
| SaleGLCode | string |
String length: inclusive between 0 and 50 |
|
| COGSGLCode | string |
String length: inclusive between 0 and 50 |
|
| AccountingCategoryID | integer |
None. |
|
| MaximumMarkdownPercentage |
Maximum markdown amount for products with in this department, i.e. This percent each time |
decimal number |
None. |
| AccountingOnly |
Excludes department from reporting |
boolean |
None. |
| GenerateExternalID | integer |
None. |
|
| UseNonReportableTaxCode |
When set to true, the MyOB accounting integration will use the non reportable tax code when exporting sales for this department. |
boolean |
None. |
| MinPLU | integer |
None. |
|
| MaxPLU | integer |
None. |
|
| ScaleLocation |
Default Location for new Scale PLUs in this Department, can be overridden at Product level |
ScaleLocation |
Relation. This field may not always be loaded or used for updates. |
| SubDepartments | Collection of SubDepartment |
Relation. This field may not always be loaded or used for updates. |
|
| Stores | Collection of integer |
Relation. This field may not always be loaded or used for updates. |
|
| InvestmentBuyOverride |
Store size configuration has been overridden for this department |
boolean |
Relation. This field may not always be loaded or used for updates. |
| 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. |