| Name | Description | Type | Additional information |
|---|---|---|---|
| PluG_UID |
Product identifier |
Collection of byte |
None. |
| PluGuid |
Product identifier guid |
globally unique identifier |
None. |
| SupplierIdentifier | Collection of byte |
None. |
|
| SupplierIdentifierGuid |
Supplier identifier guid |
globally unique identifier |
None. |
| CartonQuantity | integer |
None. |
|
| ProductSize | string |
None. |
|
| CigarettesPerSleeve | integer |
None. |
|
| RandomWeight | boolean |
Deprecated. |
|
| PiecesPerUnit | integer |
None. |
|
| AveragePackSize |
When ordering packs used to determine pricing values |
integer |
None. |
| EffectiveDate | date |
None. |
|
| PricedByWeight |
If true, sold by weight |
boolean |
None. |
| LandedUnitCostEx | integer |
None. |
|
| LandedUnitCostInc | integer |
None. |
|
| LandedCartonCostEx |
The Carton Cost total, excluding GST |
integer |
None. |
| LandedCartonCostInc |
The Carton Cost total, including GST |
integer |
None. |
| StandardCost |
The Carton-only portion of the landed cost |
integer |
None. |
| DeliveryFee | integer |
None. |
|
| DeliveryFeeBasis | string |
None. |
|
| PickAndPackFee | integer |
None. |
|
| PickAndPackFeeBasis | string |
None. |
|
| FinanceFee | integer |
None. |
|
| FinanceFeeBasis | string |
None. |
|
| CartonLength | integer |
None. |
|
| CartonWidth | integer |
None. |
|
| CartonHeight | integer |
None. |
|
| PalletLayerQuantity | integer |
None. |
|
| PalletLayers | integer |
None. |
|
| ItemCode | string |
None. |
|
| InvoiceCode | string |
None. |
|
| InvoiceDesc | string |
None. |
|
| OrderDirect | boolean |
None. |
|
| UseCost | boolean |
None. |
|
| MinimumQuantity |
Order at least this many units each time the product is ordered - as determined by the host |
integer |
None. |
| HostType |
Host Type (0 if it's not created by host) |
integer |
None. |
| FromHost |
FromHost (0->false, 1->true) |
integer |
None. |
| MinimumReorder |
Minimum number of units to order if any are ordered - As set by the user, not the host |
integer |
None. |
| MaximumReorder |
Maximum number of units to order |
integer |
None. |
| OrderMultiple | decimal number |
None. |
|
| SellMultiple | decimal number |
None. |
|
| BaseMultiple | decimal number |
None. |
|
| HostStandardCost | integer |
None. |
|
| HostTotalCost | integer |
None. |
|
| HostRetail | integer |
None. |
|
| HostLandedUnitCostEx | integer |
None. |
|
| HostLandedUnitCostInc | integer |
None. |
|
| HostDesc |
These columns are also in the Plu table They were added here for supporting multiple hosts |
string |
None. |
| DirectIndicator | string |
None. |
|
| AvailableToOrder | boolean |
None. |
|
| HostRangeIndicator | string |
None. |
|
| HostProductType | string |
None. |
|
| HostProductGrade | string |
None. |
|
| HostProductGroup | string |
None. |
|
| HostSlowMoving | boolean |
None. |
|
| HostGeneralMerchandise | boolean |
None. |
|
| HostPillar | string |
None. |
|
| HostLastUpdated | date |
None. |
|
| Rebate |
Rebate override value |
decimal number |
None. |
| RebateType | integer |
None. |
|
| RebateExclude |
Rebate exclude flag |
boolean |
None. |
| CreatedFromInvoice |
Flag to indicate whether Product is created from Invoice and still unapproved |
boolean |
Relation. This field may not always be loaded or used for updates. |
| InvoiceCodes | Collection of ProductInvoicingDetail |
Relation. This field may not always be loaded or used for updates. |
|
| StoreIDs |
Store IDs of store products for ordering detail to be also saved against |
Collection of integer |
Relation. This field may not always be loaded or used for updates. |
| ProductName | string |
Relation. This field may not always be loaded or used for updates. |
|
| APN | string |
Relation. This field may not always be loaded or used for updates. |
|
| PLU | integer |
Relation. This field may not always be loaded or used for updates. |
|
| StockOnHand | decimal number |
Relation. This field may not always be loaded or used for updates. |
|
| StockOnOrder | decimal number |
Relation. This field may not always be loaded or used for updates. |
|
| BaseUnits | integer |
Relation. This field may not always be loaded or used for updates. |
|
| InventoryAccuracy | integer |
Relation. This field may not always be loaded or used for updates. |
|
| SalesMode | SalesMode |
Relation. This field may not always be loaded or used for updates. |
|
| OrderPacked | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| Price | integer |
Relation. This field may not always be loaded or used for updates. |
|
| GSTPercent | integer |
Relation. This field may not always be loaded or used for updates. |
|
| FuelItem | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| CostDecimals | integer |
Relation. This field may not always be loaded or used for updates. |
|
| CostGSTPercent | integer |
Relation. This field may not always be loaded or used for updates. |
|
| DeptCode | string |
Relation. This field may not always be loaded or used for updates. |
|
| SubDeptCode | string |
Relation. This field may not always be loaded or used for updates. |
|
| MinorDeptCode | string |
Relation. This field may not always be loaded or used for updates. |
|
| LesserDeptCode | string |
Relation. This field may not always be loaded or used for updates. |
|
| DeptName | string |
Relation. This field may not always be loaded or used for updates. |
|
| SubDeptName | string |
Relation. This field may not always be loaded or used for updates. |
|
| MinorDeptName | string |
Relation. This field may not always be loaded or used for updates. |
|
| LesserDeptName | string |
Relation. This field may not always be loaded or used for updates. |
|
| MasterPLUG_UID | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| MasterID | globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
|
| PriceGroupG_UID | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| PriceGroupGuid | globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
|
| ParentPluG_UID | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| ParentPluGuid | globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
|
| PriceGroupName | string |
Relation. This field may not always be loaded or used for updates. |
|
| PriceGroupCode | integer |
Relation. This field may not always be loaded or used for updates. |
|
| Active | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| PreferredSupplier |
This product has the supplier as preferred supplier |
boolean |
Relation. This field may not always be loaded or used for updates. |
| RebateSupplier |
This product has the supplier as preferred rebate supplier |
boolean |
Relation. This field may not always be loaded or used for updates. |