| Name | Description | Type | Additional Information |
|---|---|---|---|
| UniqueKey |
The unique number to identify the product record - cannot be duplicated. |
integer |
Required Send In zero (0) If New. Do Not modify existing value. |
| 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 |
Required Max length: 50 |
| EPANumber |
EPA number of the product. |
string |
Max length: 40 |
| FederallyRestricted |
Restricted by federal regulations. |
boolean |
Must be 0, 1, True, or False |
| PotentiallyHazardous |
Works with the HazMat document printing capabilities of Agvance. |
boolean |
Must be 0, 1, True, or False |
| InventoryUnits |
Unit of measure in which the product will be tracked in inventory. |
string |
Required Max length: 4 |
| ReorderLevel |
The user entered amount of the product to be reordered. |
decimal number |
Must be numeric |
| UnitWeight |
Number of pounds per inventory unit. |
decimal number | |
| PackageSize |
Number of inventory units per package unit. |
string |
Max length: 10 Must be filled out and numeric |
| PackageUnits |
Unit of measure in which the product will be packaged. |
string |
Required Max length: 4 |
| 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 |
| ReplacementCost |
One of four available replacement cost inputs for the product. The others are in the ClsProductPricesAdd section. |
decimal number | |
| DryOrLiquid |
State of Matter of the product (D or L). |
string |
Max length: 1 Valid options: D for Solid (dry), L for Liquid. |
| 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 |
Must be 0, 1, True, or False |
| EDIReportable |
Flag indicating whether the sales for this product get reported back to the manufacturer. |
boolean |
Must be 0, 1, True, or False |
| Inactive |
Removes the product from selection lists. Cannot be set to true if the product has a non-zero amount on hand. |
boolean |
Must be 0, 1, True, or False |
| InvoiceLineItemComment |
User comment - Accompanies each line on an invoice on which the product is selected. |
string |
Max length: 1000 |
| 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 |
| Crop |
Crop associated with the product. Must match an existing crop in the data. |
string |
Max length: 15 |
| Variety |
Manufacturer's Seed Variety name. |
string |
Max length: 80 |
| Trait |
Names of the Seed traits for the Variety. |
string |
Max length: 80 |
| BrandName |
Seed brand. |
string |
Max length: 40 |
| IsInsectResistantMaterial |
Insect Resistant Material. |
boolean |
Must be 0, 1, True, or False |
| NeedsFieldCoordinates |
Planting locations of the seed need to be reported to the manufacturer. |
boolean |
Must be 0, 1, True, or False |
| TreatmentCode |
If seed is treated, what treatment code was used. |
string |
Max length: 255 |
| SeedSize |
Seed size (small rounds, medium rounds, medium flats, large rounds, etc). |
string |
Max length: 20 |
| GTIN |
Global Trade Identification Number. |
string |
Max length: 20 |
| SSIGlobalID |
SSI Global ID |
integer | |
| OnHold |
Flag to prevent the product from being used on Agvance transactions. |
boolean |
Must be 0, 1, True, or False |
| AccountsAdd |
Sales Taxable and GLAccounts specific for this Product |
Collection of clsProductAccountsAdd |
JSON list name must be AccountsAdd. |
| PricesAdd |
The Price Information of the Product |
Collection of clsProductPricesAdd |
JSON list name must be PricesAdd. List cannot be empty |
| ClassificationsAdd |
List of Product Classifications |
Collection of clsProductClassificationsAdd |
JSON list name must be ClassificationsAdd. |
| AttributesAdd |
List of Product Attributes |
Collection of clsProductAttributesAdd |
JSON list name must be AttributesAdd. |
| SafetyAdd |
The Safety Information of the Product |
Collection of clsProductSafetyAdd |
JSON list name must be SafetyAdd. |
| BlendsAdd |
The Blend Information of the Product |
Collection of clsProductBlendsAdd |
JSON list name must be BlendsAdd. |
| CASNumbersAdd |
The List of CAS Numbers for the Product |
Collection of clsProductCASNumbersAdd |
JSON list name must be CASNumbersAdd. Maximum of 20 allowed |