| Name | Description | Type | Additional Information |
|---|---|---|---|
| ProductLineItem |
The Number Associated With the Order of Products on the Blend Ticket |
integer |
Required Must be filled out and numeric |
| BlendTicketLineItemGuid |
Used in the PUT of a blend ticket to allow the changing of a product on a line item for an unloaded ticket - will be null unless the database is new enough to support this property |
globally unique identifier | |
| ProductGUID |
The Globally Unique Identifier That Represents the Product on the Blend Ticket |
string |
Max length: 36 |
| DepartmentID |
The Agvance ID of the Department That the Product is Listed Under |
string |
Max length: 6 |
| ProductID |
The Agvance ID of the Product Unique to the Department |
string |
Max length: 10 |
| ProductName |
The Full Name of the Product |
string |
Max length: 50 |
| RatePerUnitAmount |
The Amount of Product Applied per Unit Measured in RatingUOM |
decimal number |
Must be numeric |
| RatingUOM |
The Corresponding Unit of Measure to the RatePerUnitAmount |
string |
Max length: 10 |
| TotalRatingAmount |
The Total Amount of Product Measured by the RatingUOM |
decimal number |
Must be numeric |
| MixedAmount |
The Total Amount of Product Mixed Measured by the MixingUOM |
decimal number |
Must be numeric |
| MixingUOM |
The Corresponding Unit of Measure to the MixedAmount |
string |
Max length: 10 |
| MixingScale |
The Mixing Scale of the Product's Department |
integer |
Must be numeric |
| ISAnalysisItem |
Indicates whether or not the product is set to analysis. |
boolean |
Must be 0, 1, True, or False |
| InventoryAmount |
The Product Quanity in Inventory Units |
decimal number |
Must be numeric |
| InventoryUOM |
The Corresponding Unit of Measure to the InventoryAmount |
string |
Max length: 10 |
| ListPrice |
The List Price of the Product |
decimal number |
Must be numeric |
| PricingUOM |
The Corresponding Unit of Measure to the Pricing |
string |
Max length: 10 |
| CropCode |
The Name of the Crop Listed on the Product |
string |
Max length: 15 |
| Container |
A Container Text Entry for the Product |
string |
Max length: 15 |
| LotNumber |
The Lot Number Assigned to the Product |
string |
Max length: 30 |
| ComPrefix |
Custom Comment for the Product |
string |
Max length: 10 |
| TechnologyLicenseNumber |
Unique Identifier for the Product Assigned by the Manufacturer |
string |
Max length: 30 |
| ExcludeFromMixFile |
Indicates whether or not the product is excluded from the Blender file. |
boolean |
Must be 0, 1, True, or False |
| ShipFromLocationID |
The Location to Ship the Product From |
string |
Max length: 6 |
| AgSyncExcludeProduct |
Indicates whether or not the product is excuded in AgSync. |
boolean |
Must be 0, 1, True, or False |
| AgSyncHotLoaded |
Indicates whether or not the product is mixed in the field in AgSync. |
boolean |
Must be 0, 1, True, or False |
| TotalPoundsInTheMix |
The Total Weight in Pounds of Fertilizer Material in the Blend. |
decimal number |
Must be numeric |
| UpdateAgvanceBasedOn_Rate_Mix_Inventory_Pounds |
Indicates which value to use to update. Valid entries are: 'Rating', 'Total', 'Mixing', 'Inventory', and 'Pounds' |
string | |
| Density |
The Density of the Product to Use in Formulation |
decimal number |
Must be numeric |
| ISLiquidStateOfMatter |
Indicates whether or not the product is a liquid. |
boolean |
Must be 0, 1, True, or False |
| PoundsPerRatingUnit |
The Weight in Pounds per One Rating Unit |
decimal number |
Must be numeric |
| RateToBlendRatio |
The Number of Rating Units in One Blending Unit |
decimal number |
Must be numeric |
| BlendToInventoryRatio |
The Number of Blending Units in One Inventory Unit |
decimal number |
Must be numeric |
| InventoryToPricingRatio |
The Number of Inventory Units in One Pricing Unit |
decimal number |
Must be numeric |
| PoundsPerInventoryUnit |
The Number of Pounds in One Inventory Unit |
decimal number |
Must be numeric |
| SpecificGravity |
The Specific Gravity of the Product |
decimal number |
Must be numeric |
| ISFeeItem |
Indicates whether or not the Product is marked as a fee item. |
boolean |
Must be 0, 1, True, or False |
| MixGroup |
The number indicating which group of products the product is blended with. |
integer |
Must be numeric |
| ShipFromDepartmentID |
The Department Id of the Product in the Ship From Location. Required if the Product Id is not unique in the Ship From Location. |
string |
Max length: 6 Must not contain a space or a tic (') |
| BlendProductCustomerPriceOverrides |
The List of Properties and Values of Customer Price Overrides on the Product |
Collection of clsAPIBlendProductCustomerPriceOverrides |