| Name | Description | Type | Additional information |
|---|---|---|---|
| PluG_UID |
Product identifier |
Collection of byte |
None. |
| PluGuid |
Product identifier guid |
globally unique identifier |
None. |
| SupplierIdentifier |
Supplier identifier |
Collection of byte |
None. |
| SupplierIdentifierGuid |
Supplier identifier guid |
globally unique identifier |
None. |
| CartonQuantity | integer |
None. |
|
| CartonQuantityChanged | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| ProductSize | string |
String length: inclusive between 0 and 12 |
|
| CigarettesPerSleeve | integer |
None. |
|
| RandomWeight | boolean |
Deprecated. |
|
| PiecesPerUnit | integer |
None. |
|
| AveragePackSize |
When ordering packs used to determine pricing values |
integer |
None. |
| EffectiveDate | date |
Data type: Date |
|
| PricedByWeight |
If true, sold by weight |
boolean |
None. |
| LandedUnitCostEx |
Complete carton cost, including all fees and excluding GST |
integer |
None. |
| LandedUnitCostInc |
Complete carton cost, including GST and all fees |
integer |
None. |
| LandedCartonCostInc |
Complete carton cost, including GST and all fees |
integer |
None. |
| LandedCartonCostEx |
Complete carton cost, including all fees and excluding GST |
integer |
None. |
| StandardCost |
The Carton-only portion of the landed cost |
integer |
None. |
| DeliveryFee | integer |
Deprecated. |
|
| DeliveryFeeBasis | FeeBasis |
Deprecated. |
|
| PickAndPackFee | integer |
Deprecated. |
|
| PickAndPackFeeBasis | FeeBasis |
Deprecated. |
|
| FinanceFee | integer |
Deprecated. |
|
| FinanceFeeBasis | FeeBasis |
Deprecated. |
|
| 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. |
| RebateExclude |
Rebate exclude flag |
boolean |
None. |
| 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. |
| PreferredSupplier |
Set, or unset supplier as the preferred supplier on save. If null, ignores |
boolean |
Relation. This field may not always be loaded or used for updates. |
| PreferredRebateSupplier |
Set, or unset supplier as the preferred rebate supplier on save. If null, ignores |
boolean |
Relation. This field may not always be loaded or used for updates. |
| SupplierName | string |
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. |
|
| Active | 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. |
|
| CostGstPercent | integer |
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. |
|
| Freight | decimal number |
Relation. This field may not always be loaded or used for updates. |
|
| FreightType | FreightFeeType |
Relation. This field may not always be loaded or used for updates. |
|
| Product | Product |
Relation. This field may not always be loaded or used for updates. |
|
| Supplier | Supplier |
Relation. This field may not always be loaded or used for updates. |
|
| ServiceFee | ServiceFee |
Relation. This field may not always be loaded or used for updates. |
|
| IsPrimaryHost | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| HostVendor | integer |
Relation. This field may not always be loaded or used for updates. |