| Name | Description | Type | Additional Information |
|---|---|---|---|
| DepartmentID |
Existing department ID into which the new product will be saved. |
string |
Required Max length: 6 |
| ProductID |
User assigned ID of the product. |
string |
Required Max length: 10 Must not contain a space or a tic (') |
| Manufacturer |
Manufacturer of the product; must match an existing manufacturer in the database. |
string |
Max length: 50 |
| ProductName |
User assigned Name (description) of the product. |
string |
Max length: 50 |
| EPANumber |
EPA number of the product. |
string |
Max length: 40 |
| FederallyRestricted |
Restricted by federal regulations. |
boolean | |
| PotentiallyHazardous |
Works with the HazMat document printing capabilities of Agvance. |
boolean | |
| ReorderLevel |
The user entered amount of the product to be reordered. |
decimal number | |
| UnitWeight |
Number of pounds per inventory unit. |
decimal number | |
| PackageSize |
Number of inventory units per package unit. |
string |
Max length: 10 Must be numeric |
| CrossRef1 |
User defined cross reference value. |
string |
Max length: 40 |
| CrossRef2 |
User defined cross reference value. |
string |
Max length: 40 |
| CrossRef3 |
User defined cross reference value. |
string |
Max length: 40 |
| CrossRef4 |
User defined cross reference value. |
string |
Max length: 40 |
| BarCodeID |
UPC code/barcode for the product. |
string |
Max length: 20 |
| DryOrLiquid |
State of Matter of the product (D or L). |
string |
Max length: 1 |
| ActiveIngredient |
Primary Active ingredient in the product. |
string |
Max length: 50 |
| Consignment |
Indicates a product that will be invoiced by the vendor as it is resold, rather than upon delivery. |
boolean | |
| EDIReportable |
Flag indicating whether the sales for this product get reported back to the manufacturer. |
boolean | |
| TechnologyGroup |
Seed technology classification - Must match an existing technology group record in the data. |
string |
Max length: 30 |
| CommodityRef |
Type of commodity to tie the product to. Examples are corn, beans, and wheat. Must be a valid commodity in the data. |
string |
Max length: 6 |
| ManufacturerPartNumber |
Part/Product ID number assigned by the manufacturer. |
string |
Max length: 30 |
| AlternateProductID |
Used as an alternative to the product ID on some reports. |
string |
Max length: 40 Must not contain invalid characters |
| GTIN |
Global Trade Identification Number. |
string |
Max length: 20 |
| OnHold |
Flag to prevent the product from being used on Agvance transactions. |
boolean | |
| ClassificationsAdd |
List of Product Classifications |
Collection of clsProductClassificationsAdd | |
| AttributesAdd |
List of Product Attributes |
Collection of clsProductAttributesAdd | |
| ShippingName |
The legal DOT shipping description. |
string |
Max length: 500 |
| NationalMotorCarrierClass |
The National Motor Carrier classification name. |
string |
Max length: 180 |
| ReentryIntervalHours |
Hours until reentry is allowed where this product has been applied. |
string |
Max length: 8 Must be numeric |
| HazardClass |
DOT hazard class. |
string |
Max length: 10 |
| PackingGroup |
DOT packaging group. |
string |
Max length: 6 |
| SafetyComments1 |
PPE required for early entry workers. |
string |
Max length: 500 |
| SafetyComments2 |
PPE required for handlers. |
string |
Max length: 500 |
| SafetyComments3 |
PPE required for workers. |
string |
Max length: 500 |
| PLACARD |
One or more placards required on the vehicle when transporting this product. |
string |
Max length: 50 |
| UNNAID |
The United Nations / North America Identification Number. |
string |
Max length: 10 |
| PostedWarning |
Indicates that a posted warning must be placed at the entrance to the field after this product is applied. |
boolean |
Must be 0, 1, True, or False |
| OralWarning |
Indicates that an oral warning must be given after this product is applied. |
boolean |
Must be 0, 1, True, or False |
| PackageSizeIsBulk |
Indicates for DOT placard calculation that the package size is considered bulk. |
boolean |
Must be 0, 1, True, or False |
| ShippingManifestPkgQtyIsAlways1 |
Indicates for DOT placard calculation that the package quantity is always 1. |
boolean |
Must be 0, 1, True, or False |
| DOTWarningNote |
Warning information from the Department of Transportation. |
string | |
| Threshold |
Indicates to HazMat printing functions when documentation is required and how to print the data on the HazMat document. |
decimal number | |
| GHS |
Indicates when printing safety data sheets, to print the Globally Harmonized System document for this product. |
boolean |
Must be 0, 1, True, or False |
| ProductDensity |
Pounds of product per cubic foot for solid (dry) products and pounds of product per gallon for liquid products. |
string |
Max length: 10 Must be numeric |
| RecommendedRatePerAcre |
Recommended number of rate per acre units of the product to be applied per acre. |
string |
Max length: 10 Must be numeric |
| RateToBlendingRatio |
Number of rate per acre units in one blending unit. |
string |
Max length: 10 Must be numeric |
| BlendToInventoryRatio |
Number of blending units in one inventory unit. |
string |
Max length: 10 Must be numeric |
| BlenderFactor |
Blender-specific data. |
string |
Max length: 10 |
| PercentSolidMaterial |
Percent of the product that is ccomprised of solid (dry) material. |
string |
Max length: 10 Must be numeric |
| PercentWater |
Percent of the product that is comprised of water. |
string |
Max length: 10 Must be numeric |
| PercentClay |
Percent of the product that is comprised of clay. |
string |
Max length: 10 Must be numeric |
| SpecificGravity |
Specific Gravity of product. |
decimal number | |
| ProfitMargin |
Used if inventory department is set as a profit margin department. Determines pricing for the product based on the cost. |
decimal number |