NameDescriptionTypeAdditional Information
UniqueKey

The unique number to identify the product record so it cannot be duplicated.

 integer

Required

Send In zero (0) If New. Do Not modify existing value.
DepartmentID

Department ID of the product.

 string

Required

Max length: 6
DepartmentName

Department name of the product.

 string

Max length: 30
ProductID

ID of the product.

 string

Required

Max length: 10

Must not contain a space or a tic (')
Manufacturer

Manufacturer of the product.

 string

Max length: 50
ProductName

Name (description) of the product.

 string

Required

Max length: 50
EPANumber

EPA number assigned to 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 counted in inventory.

 string

Required

Max length: 4
AmountOnHand

Inventoried amount of the product.

 string

Max length: 16
ReorderLevel

The amount of the product in inventory that adds the product to the reorder list.

 decimal number

Must be numeric
UnitWeight

Number of pounds per inventory unit.

 string

Max length: 10
PackageSize

Number of inventory units per package units.

 string

Max length: 10

Must be filled out and numeric

Range: inclusive between 0.00000001 and 9999999999
PackageUnits

Unit of measure in which the product will be packaged.

 string

Required

Max length: 4
CrossRef1

Used on some reports and exports/imports.

 string

Max length: 40
CrossRef2

Used on some reports and exports/imports.

 string

Max length: 40
CrossRef3

Used on some reports and exports/imports.

 string

Max length: 40
CrossRef4

Used on some reports and exports/imports.

 string

Max length: 40
BarCodeID

UPC code/barcode for the product.

 string

Max length: 20
ReplacementCost

One of 4 available replacement cost inputs for the product. The others are in the PricesAdd section.

 string

Max length: 10
DryOrLiquid

Consistency of the product.

 string

Max length: 1

Valid options: D for Solid (dry), L for Liquid.
ActiveIngredient

Active ingredient in the product.

 string

Max length: 50
Consignment

Indicates a product that will be invoiced by the vendor as it is sold, rather than upon delivery.

 boolean

Must be 0, 1, True, or False
EDIReportable

Used by a specific type of data export in Agvance.

 boolean

Must be 0, 1, True, or False
Inactive

Removes the product from selection lists. Cannot be used if the product has a non-zero amount on hand.

 boolean

Must be 0, 1, True, or False
InvoiceLineItemComment

Accompanies each line on an invoice on which the product is selected.

 string

Max length: 1000
TechnologyGroup

The technology group of the product.

 string

Max length: 30
CommodityRef

Type of commodity the product is tied to. Examples are corn, beans, and wheat.

 string

Max length: 6
ManufacturerPartNumber

Part 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
SeedYear

Associated with seed products.

 integer

Must be numeric
Crop

Crop associated with the product. Must match an existing crop in the data.

 string

Max length: 15
IsBioTech

Associated with seed products.

 boolean

Must be 0, 1, True, or False
Variety

Associated with seed products.

 string

Max length: 80
Kind

Associated with seed products.

 string

Max length: 80
Origin

Associated with seed products.

 string

Max length: 80
TestDate

Associated with seed products.

 string

Data type: DateTime
PurityPercent

Associated with seed products.

 decimal number

Must be numeric
InertPercent

Associated with seed products.

 decimal number

Must be numeric
WeedPercent

Associated with seed products.

 decimal number

Must be numeric
GermPercent

Associated with seed products.

 decimal number

Must be numeric
HardPercent

Associated with seed products.

 decimal number

Must be numeric
Trait

Associated with seed products.

 string

Max length: 80
BrandName

Associated with seed products.

 string

Max length: 40
IsInsectResistantMaterial

Associated with seed products.

 boolean

Must be 0, 1, True, or False
NeedsFieldCoordinates

Associated with seed products.

 boolean

Must be 0, 1, True, or False
ProcessorCode

Associated with seed products.

 string

Max length: 20
TreatmentCode

Associated with seed products.

 string

Max length: 255
SeedSize

Associated with seed products.

 string

Max length: 20
OrderQuantityMultiple

Associated with seed products.

 decimal number

Must be numeric
GTIN

Global Trade Identification Number

 string

Max length: 20
SSIGlobalID

SSI Global Identification number.

 integer
MPSGuid

Used in Agvance Mapping.

 string
MPSProductCategoryKey

Used in Agvance Mapping.

 string
MPSCode

Used in Agvance Mapping.

 string

Max length: 50
MPSDescription

Used in Agvance Mapping.

 string

Max length: 100
MPSProductForm

Used in Agvance Mapping.

 integer
OnHold

Prevents product from being used on transactions.

 boolean

Must be 0, 1, True, or False
MPSMinSetPoint

Used in Agvance Mapping.

 decimal number
MPSMaxSetPoint

Used in Agvance Mapping.

 decimal number
MPSSwitchSetPoint

Used in Agvance Mapping.

 decimal number
MPSOutOfFieldRate

Used in Agvance Mapping.

 decimal number
MPSRoundRecMethodInt

Used in Agvance Mapping.

 integer
MPSRoundRecValue

Used in Agvance Mapping.

 decimal number
MapXRefGUID

Used in Agvance Mapping.

 string
DepartmentScale

Formulation scale used for this product's department.

 integer
IsAnalysis

Indicates whether or not the product is used in formulation analysis.

 boolean
ContainerRequiredOnPOS

Indicates whether or not the product requires a container when used on a Point Of Sale transaction.

 boolean

Must be 0, 1, True, or False
LastModifiedUTC

The last modified date of the product in UTC format

 date
Accounts

A list of product accounting information.

 Collection of clsProductAccounts

List cannot be empty
Prices

A list of product pricing information.

 Collection of clsProductPrices

List cannot be empty
Classifications

A list of product classifications.

 Collection of clsProductClassifications

List cannot be empty
Attributes

A list of product attributes.

 Collection of clsProductAttributes

List cannot be empty
Safety

A list of product safety information.

 Collection of clsProductSafety

List cannot be empty
Blends

A list of product blending information.

 Collection of clsProductBlends

List cannot be empty
CASNumbers

A list of Chemical Abstracts Service information.

 Collection of clsProductCASNumbers

List cannot be empty
Ingredients

A list of product ingredient information.

 Collection of clsProductIngredients

List cannot be empty
Lots

A list of product lot information.

 Collection of clsProductLots

List cannot be empty
LotAttributes

A list of product lot attribute information

 Collection of clsProductLotAttributes

List cannot be empty
StateRestrictions

A list of product state restriction information.

 Collection of clsProductStateRestrictions

List cannot be empty
StorageCodes

A list of product storage code information.

 Collection of clsProductStorageCodes

List cannot be empty
BarCodes

A list of product bar code information.

 Collection of clsProductBarCodes

List cannot be empty
ExtraCharges

A list of product extra charges information.

 Collection of clsProductExtraCharges

List cannot be empty
StatesWhereProductIsRestrictedFromDistribution

A list of product state restriction available for distribution information.

 Collection of clsProductStateRestrictAvailForDist

List cannot be empty
deleteYN

Used to determine if the record should be deleted. Must be used with UniqueKey. Only used with PUT.

 boolean

Must be 0, 1, True, or False