| Name | Description | Type | Additional Information |
|---|---|---|---|
| SalesOrderLineItemGUID |
The globally unique identifier that represents this Sales Order LineItem record |
globally unique identifier |
Required (Hexadecimal 8-4-4-4-12) |
| LineItem |
A counter used to keep the product records in the same order that they were added |
integer |
Required |
| DeptId |
The Agvance ID for the Department in which the Product resides |
string |
Required Max length: 6 |
| ProdId |
The Agvance ID for the Product |
string |
Required Max length: 10 |
| ProductGuid |
The Agvance globally unique identifier for the Product |
globally unique identifier |
Required (Hexadecimal 8-4-4-4-12) |
| ProductDescription |
The description of the Product either from the Product setup in Agvance or an override entered by the user when adding or editing the Sales Order |
string |
Required Max length: 50 |
| Quantity |
The quanity of the Product. This is the total amount for the Sales Order, not for each customer |
decimal number |
Required |
| QuantityUnits |
The unit of measure of the product's quantity |
string |
Required Max length: 4 |
| Price |
The selling price per unit of the product for the customer on this split |
decimal number |
Required |
| PriceUnits |
The unit of measure of the product's price. |
string |
Required Max length: 4 |
| QuantityToPricingRatio |
The ratio used to calculate the extension of a products selling price. Quantity * Price / QuantityToPricingRatio = ExtendedDollars (round to 2 decimal places). That result * SplitPercent / 100 = Customer's Share (rounded to 2 decimal places) of the cost of this line to them. |
decimal number |
Required |
| PriceLevel |
The product price level indication of what level the price was selected from. A price can be different from this setting without setting this to Quote. The original default from Agvance is from the customer pricing level for the department of this product. |
EnumPriceLevel |
Required |
| PriceLevelDescription |
A convenience property giving the full description of the price level from the department of the product for the PriceLevel enumeration |
string |
Max length: 25 |
| SplitNum |
An indication of what split override was used for the SplitPercent |
integer |
Required |
| SplitPercent |
The percentage that the current split is responsible for on the current product |
decimal number |
Required |
| LotNumber |
The lot number for the current product |
string |
Max length: 30 |
| CropCode |
The Agvance ID for the Crop on this product |
string |
Max length: 50 |
| CropCodeGuid |
The Agvance globally unique identifier for the Crop on this product |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| AllocationNumber |
The Agvance ID for the Sales Allocation Number for this line item |
integer | |
| ProdIdAlternate |
Alternate ID for the product |
string |
Max length: 40 |