| Name | Description | Type | Additional information |
|---|---|---|---|
| G_UId |
Product GUID data |
Collection of byte |
None. |
| Guid |
Product GUID |
globally unique identifier |
None. |
| Active | boolean |
None. |
|
| DoNotRange |
Store Product will be removed once stock has depleted |
boolean |
None. |
| DoNotOrder |
Product is not to be ordered (Purchase orders) |
boolean |
None. |
| Hidden |
This item is not yet approved for usage by users |
boolean |
None. |
| Deleted |
Soft deletion flag |
boolean |
None. |
| PLU |
Scale PLU |
integer |
None. |
| APN |
Barcode, EAN, etc. |
string |
None. |
| ItemNumber | string |
None. |
|
| SalesMode | integer |
None. |
|
| OrderPacked | integer |
None. |
|
| Name | string |
None. |
|
| SecondDescription | string |
None. |
|
| Text1 |
Scale text |
string |
Data type: MultilineText |
| Text2 |
Scale Ingredients (Named Text2 for reasons unknown) |
string |
None. |
| ImageName | string |
None. |
|
| Expiry | integer |
None. |
|
| Tare | integer |
None. |
|
| HasModifiers | integer |
None. |
|
| MPL | integer |
None. |
|
| NotForSale | integer |
None. |
|
| IsManufactured | boolean |
None. |
|
| IsIngredient | boolean |
None. |
|
| IsModifier | boolean |
None. |
|
| PackQty | integer |
None. |
|
| PriceOverride | PriceOverride |
None. |
|
| FixedWeight | integer |
None. |
|
| ProductGrade | string |
None. |
|
| ComplianceIndicatorType |
Compliance indicator type |
string |
None. |
| ComplianceIndicator | string |
None. |
|
| WarehouseDirectIndicator | string |
None. |
|
| UnitMeasure |
Label UOM |
decimal number |
None. |
| UnitMeasureKind |
Label UOM Kind |
UnitMeasureKind |
None. |
| CoolCode | CoolCode |
None. |
|
| PercentContent | decimal number |
None. |
|
| AllowZeroPrice | boolean |
None. |
|
| PriceRequired | boolean |
None. |
|
| SendToScale |
When true, this product is to be sent to foreign scales via GaP ToScale.exe |
boolean |
None. |
| PosTare |
POS Tare |
integer |
None. |
| BestOrExpire | BestOrExpire |
None. |
|
| NonScaleWeigh | boolean |
None. |
|
| Cost |
This is the normal cost based on cost calc method |
integer |
None. |
| CostCalcMethod |
The Method used to determine how cost is retrieved from PluCostTable, overrides subdept, and dept options |
CostCalcMethod |
None. |
| AsEnteredCost |
This is the normal cost as entered |
integer |
None. |
| WeightedAvgCost |
This is the normal weighted avg cost |
integer |
None. |
| LastCost |
This is the normal last cost |
integer |
None. |
| CostDecimals | integer |
None. |
|
| CostGSTPercent | integer |
None. |
|
| CurrentCost | integer |
None. |
|
| CurrentCostDecimals | integer |
None. |
|
| CartonCost |
PLU Ordering LandedCartonCostInc |
integer |
None. |
| Price |
Sell price |
integer |
None. |
| GSTPercent | integer |
None. |
|
| CurrentPrice |
Current register price |
integer |
None. |
| Break1 | integer |
None. |
|
| Price1 | integer |
None. |
|
| Break2 | integer |
None. |
|
| Price2 | integer |
None. |
|
| Break3 | integer |
None. |
|
| Price3 | integer |
None. |
|
| FuelItem | boolean |
None. |
|
| RRP | integer |
None. |
|
| AltPriceMode | AltPriceMode |
None. |
|
| AlwaysApplyMargin |
Apply target margins for cost changes that are not from a host |
boolean |
None. |
| Margin |
Target Margin % GP |
decimal number |
None. |
| MarginRanged |
Target margin is a ranged setting |
boolean |
None. |
| MinimumMargin |
Target Margin min GP% |
decimal number |
None. |
| MaximumMargin |
Target Margin max GP% |
decimal number |
None. |
| GrossProfit | decimal number |
None. |
|
| ExternalID | string |
None. |
|
| PriceGroupG_UID | Collection of byte |
None. |
|
| PriceGroupGuid | globally unique identifier |
None. |
|
| PriceGroupName | string |
None. |
|
| SupplierIdentifier |
Current supplier ID set by the host |
Collection of byte |
None. |
| SupplierIdentifierGuid | globally unique identifier |
None. |
|
| PreferredSupplier |
Preferred Supplier |
string |
None. |
| DirectNumber |
Direct Number of Preferred Supplier |
string |
None. |
| DeptCode | string |
None. |
|
| SubDeptCode | string |
None. |
|
| MinorDeptCode | string |
None. |
|
| LesserDeptCode | string |
None. |
|
| DeptName | string |
None. |
|
| SubDeptName | string |
None. |
|
| MinorDeptName | string |
None. |
|
| LesserDeptName | string |
None. |
|
| AltDescription |
eCommerce Description |
string |
None. |
| AltDeptCode | string |
None. |
|
| AltSubDeptCode | string |
None. |
|
| AltMinorDeptCode | string |
None. |
|
| AltLesserDeptCode | string |
None. |
|
| CartonQuantity | integer |
None. |
|
| BaseUnits | integer |
None. |
|
| AWS |
Average weekly sales |
decimal number |
None. |
| SOH |
Current stock on hand |
integer |
None. |
| SOO |
Current stock on order |
integer |
None. |
| InventoryAccuracy | integer |
None. |
|
| IsNormalPriceChangesCampaign |
Store IsNormalPriceChangesCampaign This will indicate whether normal price changes is campaign for store product |
boolean |
None. |
| LastManualUpdate | date |
None. |
|
| LastManualUpdatedByUser | string |
None. |
|
| Activated | date |
None. |
|
| LastOrdered |
Last Ordered local |
date |
None. |
| LastCountedDate | date |
None. |
|
| LastSold | date |
None. |
|
| StoreID |
Store ID this Product applies at |
integer |
None. |
| MasterID |
For Store Products, this is set to its Master (a Product row where StoreID=0 or null) GUID |
globally unique identifier |
None. |
| MasterPluG_UID | Collection of byte |
None. |
|
| Bins |
Shelf location Bins |
Collection of Bin |
Relation. This field may not always be loaded or used for updates. |
| Barcodes |
Product barcodes |
Collection of PluApn |
Relation. This field may not always be loaded or used for updates. |