| Name | Description | Type | Additional information |
|---|---|---|---|
| Identifier | Collection of byte |
None. |
|
| IdentifierGuid | globally unique identifier |
None. |
|
| HeaderIdentifier | Collection of byte |
None. |
|
| HeaderIdentifierGuid | globally unique identifier |
None. |
|
| PLUG_UID | Collection of byte |
None. |
|
| PluGuid | globally unique identifier |
None. |
|
| PageNo | integer |
None. |
|
| LineNo | integer |
None. |
|
| ItemOrdered | string |
None. |
|
| ItemShipped | string |
None. |
|
| Apn | string |
None. |
|
| Barcode | string |
None. |
|
| ProdStatus | ProductStatus |
None. |
|
| DateAvailable | date |
None. |
|
| Commodity | string |
String length: inclusive between 0 and 10 |
|
| Supplier | string |
None. |
|
| ItemDesc | string |
None. |
|
| ItemType | ProductType |
None. |
|
| InvestmentBuyInd | character |
None. |
|
| OrderType | string |
None. |
|
| CartonQty | integer |
None. |
|
| CartonQuantitySpecified |
Whether the host specified the carton qty |
boolean |
None. |
| SoldByWeight | boolean |
None. |
|
| OrderByWeight | boolean |
None. |
|
| UnitsOrdered | integer |
None. |
|
| UnitsSupplied | integer |
None. |
|
| UnitsReceived | integer |
None. |
|
| WeightOrdered | integer |
None. |
|
| WeightShipped | integer |
None. |
|
| WeightReceived | integer |
None. |
|
| UnitSpecified |
Whether host specified unit type, used to improve product matching results |
UnitSpecified |
None. |
| WholesalePrice | integer |
None. |
|
| ExtWholesalePrice | integer |
None. |
|
| NormalPrice | integer |
None. |
|
| RetailPrice | integer |
None. |
|
| PricingUnit | string |
None. |
|
| ClaimFlag | character |
None. |
|
| GstRate | integer |
None. |
|
| GstAmount | integer |
None. |
|
| ExtGstAmount | integer |
None. |
|
| DeliWeight | integer |
None. |
|
| MarginAmount | integer |
None. |
|
| ExtMarginAmount | integer |
None. |
|
| CostAmount | integer |
None. |
|
| OrderedCostAmount | integer |
None. |
|
| ExtCostAmount | integer |
None. |
|
| CostIncSpecified |
Whether the host specified the costs inclusive of tax |
boolean |
None. |
| FreightAmount | integer |
None. |
|
| FreightGstAmount | integer |
None. |
|
| ExtFreightAmount | integer |
None. |
|
| ExtFreightGstAmount | integer |
None. |
|
| CostDecimals | integer |
None. |
|
| WetRate | integer |
None. |
|
| ContainerDeposit | integer |
None. |
|
| BasePrice | integer |
None. |
|
| WetValue | integer |
None. |
|
| DeliveryFee | integer |
None. |
|
| CasePrice | integer |
None. |
|
| WholesaleExt | integer |
None. |
|
| WetExt | integer |
None. |
|
| TotalLitres | integer |
None. |
|
| Tun | string |
None. |
|
| ApplyDetails | boolean |
None. |
|
| ApplySell | boolean |
None. |
|
| ApplyCost | boolean |
None. |
|
| ApplyOr | boolean |
None. |
|
| ApplyQty | boolean |
None. |
|
| ItemNumber | string |
None. |
|
| DirectNumber | string |
None. |
|
| ItemSize | string |
None. |
|
| CostGst | integer |
None. |
|
| SellGst | integer |
None. |
|
| CostOr | integer |
None. |
|
| SellOr | integer |
None. |
|
| MarginOr | integer |
None. |
|
| GrossProfit | decimal number |
None. |
|
| Sell | integer |
None. |
|
| CartonCost | integer |
None. |
|
| CurrentCost | integer |
None. |
|
| CostID | character |
None. |
|
| CostStart | date |
None. |
|
| CostEnd | date |
None. |
|
| CreatedFromUnknownScan | boolean |
None. |
|
| OrderGuid | Collection of byte |
None. |
|
| OrderIdentifierGuid |
The order that the invoice order details are sourced from |
globally unique identifier |
None. |
| Processed |
This line has been processed for inventory and costs as per header settings |
boolean |
None. |
| Received |
This line is locked for changes |
boolean |
None. |
| Inventoried |
This line has been processed for inventory |
boolean |
None. |
| FromElectronicInvoice |
Added from processing an electronic invoice allowing that |
boolean |
None. |
| AllowDelete |
Line can be removed from invoice |
boolean |
None. |
| Updated | date |
None. |
|
| InvoiceNo | string |
Relation. This field may not always be loaded or used for updates. |
|
| HasInventory | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| ExistingCost |
The current cost of the product |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| ExistingSell |
The current sell of the product |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| FutureCost |
The future cost after completed, null if not last cost. Has not summarised to include discounts |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| FutureSell |
The future sell after completed, based on cost margin updates, null if no change will be attempted |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| NextSell |
Next sell price, from a price change campaign |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| NextSellCampaignName |
Next sell campaign name |
string |
Relation. This field may not always be loaded or used for updates. |
| NextSellCampaignDescription |
Next sell campaign description |
string |
Relation. This field may not always be loaded or used for updates. |
| UnknownScan |
Generated by InvoiceService.LocateProduct, and will generate a new Product record on save |
InvoiceUnknownScan |
Relation. This field may not always be loaded or used for updates. |
| ProductActive |
Product active status |
boolean |
Relation. This field may not always be loaded or used for updates. |
| ProductSalesMode |
Product sales mode |
SalesMode |
Relation. This field may not always be loaded or used for updates. |
| ProductGSTPercent |
Product sales GST Percent |
integer |
Relation. This field may not always be loaded or used for updates. |
| ProductCostCalcMethod | CostCalcMethod |
Relation. This field may not always be loaded or used for updates. |
|
| ProductAlwaysApplyMargin | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| ProductMarginRanged | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| ProductMargin | decimal number |
Relation. This field may not always be loaded or used for updates. |
|
| ProductMinimumMargin | decimal number |
Relation. This field may not always be loaded or used for updates. |
|
| ProductMaximumMargin | decimal number |
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. |
|
| PriceGroupName | string |
Relation. This field may not always be loaded or used for updates. |
|
| PriceGroupCode | string |
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. |
|
| IncrementCount |
Flag that indicates on update the received values instead of setting |
boolean |
Relation. This field may not always be loaded or used for updates. |
| MinimumQuantity | integer |
Relation. This field may not always be loaded or used for updates. |
|
| RandomWeight | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| SalesMode | integer |
Relation. This field may not always be loaded or used for updates. |
|
| Cartons | integer |
Relation. This field may not always be loaded or used for updates. |
|
| Weight | integer |
Relation. This field may not always be loaded or used for updates. |
|
| Units | integer |
Relation. This field may not always be loaded or used for updates. |
|
| AutoOrderStatus | integer |
Relation. This field may not always be loaded or used for updates. |
|
| InvoiceDetailReceive |
Credit note populated. True if images are attached to invoice detail |
boolean |
Relation. This field may not always be loaded or used for updates. |