NameDescriptionTypeAdditional Information
UniqueId

The unique number to identify the blend product set. This number is unique within an Agvance database.

integer
SetDescription

The unique name of a blend product set within the Agvance database.

string

Required

Max length: 15

SetTypeEnum

The product set type enumeration.

BlendSetTypeEnum

Required

Range: inclusive between 0 and 4

SetTypeAsString

The ReadOnly string representation of the SetTypeEnum property. Valid entries are Dry, Liquid, Suspension, Feed, and Other

string
WaterRatePerAcre

If the water percentage is not used, this optional Rate/Acre settings may be used to indicate the default amount of water to include. This must be included in the product details as well as in the Key Inventory Item to be used.

string

Max length: 6

Must be numeric

ClayRatePerAcre

If the clay percentage is not used, this optional Rate/Acre settings may be used to indicate the default amount of clay to include. This must be included in the product details as well as in the Key Inventory Item to be used.

string

Max length: 6

Must be numeric

MinimumGalPerAcre

Applicable only to liquid and suspension blend sets, the program adds enough water to meet this minimum if the calculated Gallons/Acre falls below this figure during the formulation process. If filled out, when a Blend Ticket is created, on the Products tab the water product is added in an amount so the blend meets this minimum setting.

string

Max length: 8

Must be numeric

WaterPercent

This optional setting causes water to be added in as a percentage of the total product. If using this percentage, the Water Rate/Acre must be zero or blank. To utilize this item, it must be included in the product details making up the Product Set and in the Key Inventory Item.

string

Max length: 6

Must be numeric

ClayPercent

This optional setting causes clay to be added in as a percentage of the total product. If using this percentage, the Clay Rate/Acre must be zero or blank. To utilize this item, it must be included in the product details making up the Product Set and in the Key Inventory Item.

string

Max length: 6

Must be numeric

AllowNToRunOver

Allow Nitrogen to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowPToRunOver

Allow Phosphorus to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowKToRunOver

Allow Potassium to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowSToRunOver

Allow Sulfur to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowUdToRunOver

Allow User Defined to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowCaToRunOver

Allow Calcium to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowMgToRunOver

Allow Magnesium to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowZnToRunOver

Allow Zinc to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowFeToRunOver

Allow Iron to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowMnToRunOver

Allow Manganese to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowCuToRunOver

Allow Copper to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowBToRunOver

Allow Boron to overfill an analysis request.

boolean

Must be 0, 1, True, or False

PercentWaterToPreload

If set, the percentage of water is listed first on the Blend Ticket regardless of its blend order.

decimal number
BaseGradeDepartmentID

The ID of the department in which the Base Grade product resides.

string

Max length: 6

BaseGradeProductID

The ID of the Base Grade product

string

Max length: 10

BaseGradeProductGuid

The globally unique identifier for the Base Grade product

globally unique identifier

(Hexadecimal 8-4-4-4-12)

BaseGradeProductName

The name of the Base Grade product

string

Max length: 50

PercentBaseGradeToPreload

If set, the percentage of the Base Grade product is listed first on the Blend Ticket regardless of its blend order.

decimal number
ClayKeyInventroyDepartmentID

The ID of the department in which the Clay Key Inventory product resides.

string

Max length: 6

ClayKeyInventroyProductID

The ID of the Clay Key Inventory product.

string

Max length: 10

ClayProductGuid

The globally unique identifier for the Clay Key Inventory product

globally unique identifier

(Hexadecimal 8-4-4-4-12)

ClayProductName

The name of the Clay Key Inventory product

string

Max length: 50

DryFillerKeyInventroyDepartmentID

The ID of the department in which the Dry Filler Key Inventory product resides.

string

Max length: 6

DryFillerKeyInventroyProductID

The ID of the Dry Filler Key Inventory product.

string

Max length: 10

FillerProductGuid

The globally unique identifier for the Dry Filler Key Inventory product

globally unique identifier

(Hexadecimal 8-4-4-4-12)

FillerProductName

The name of the Dry Filler Key Inventory product

string

Max length: 50

WaterKeyInventroyDepartmentID

The ID of the department in which the Water Key Inventory product resides.

string

Max length: 6

WaterKeyInventroyProductID

The ID of the Water Key Inventory product.

string

Max length: 10

WaterProductGuid

The globally unique identifier for the Water Key Inventory product

globally unique identifier

(Hexadecimal 8-4-4-4-12)

WaterProductName

The name of the Water Key Inventory product

string

Max length: 50

BlenderCapacity

The default for the blender used to mix the product (may also be used as the capacity for the spreader). The capacity has an effect on the number of batches required for the mix. The capacity may be overridden when creating a blend or field plan.

string

Max length: 10

Must be numeric

SuspensionBlendTargetPercent

This is the total analysis % (sum of the nutrients’ percent concentration) that the guaranteed analysis cannot exceed when formulating a Suspension blend. If the percentage is higher than this number, a prompt appears for the blend operator to decide if water is to be added to the blend until the total of the nutrients’ guaranteed analysis is at or below this setting. The default value is 38.

decimal number
PhosphatePercentLimit

This upper limit setting for the P2O5 Guaranteed Analysis adds water to the blend until this blend’s P2O5 guarantee is at the upper limit entered here. This is used by companies when the amount of a product should be limited, such as Acid, to keep the fertilizer mixture from getting too hot. A setting of ‘999’ deactivates this checking.

decimal number
SaltOutSystemEnum

The setting that indicates which calculations are used to calculate the Salt Out Temperature enumeration

BlendSetSaltOutSystemEnum

Range: inclusive between -5 and 5

SaltOutSystemAsString

The ReadOnly string representation of the SaltOutSystemEnum property. Valid entries are None, No Poly UAN, 55% Poly UAN, 70% Poly UAN, No Poly Urea, 55% Poly Urea, No Poly UAN by Equations, 55% Poly UAN by Equations, 70% Poly UAN by Equations, No Poly Urea by Equations, or 55% Poly Urea by Equations

string
PercentChlorineWarning

The percentage at which a warning is displayed after formulating a blend. If set to zero, the warning is disabled.

decimal number
BlenderCapacityUnitsEnum

The Blender Capacity enumeration

BlendSetBlenderCapacityEnum

Range: inclusive between 0 and 2

BlenderCapacityUnitsAsString

The ReadOnly string representation of the BlenderCapacityUnitsEnum property. Valid entries are Lbs, GalCuFt, or Kg

string
EqualOrPartialEnum

Batch Defaults Enumeration

BlendSetBatchDefaultEnum

Range: inclusive between 0 and 1

EqualOrPartialAsString

The ReadOnly string representation of the EqualOrPartialEnum property. Valid entries are Equal or Partial

string
FormulateToAGivenSaltOutTemperature

This setting allows the program to verify the salt out temperature during formulation and make adjustments if needed. This is only available for ‘Suspension’ type Product Sets and when the SaltOutSystem is greater than 0. Note: If formulating To a given salt out temp, Then Set the SuspensionBlendTargetPercent To 9999.

boolean

Must be 0, 1, True, or False

FormulationMaximumSaltOutTemperature

The maximum salt out temperature used for a ‘Suspension’ type Blend Product Set. The SaltOutSystem must be greater than 0.

string

Max length: 10

Must be numeric

LocationID

The location for this Product Set. Only the Product Sets created for the location assigned to a Blend Ticket are available for selection when the Blend Ticket is created. When an existing Blend Ticket is edited, product sets from all locations are available to use as needed.

string

Max length: 6

LocationGuid

The globally unique identifier for the Blend Product Set Location

globally unique identifier

(Hexadecimal 8-4-4-4-12)

LocationName

The name of the Blend Product Set Location

string

Max length: 50

AutomatedBlenderTypeEnum

The Automated Blender Type enumeration for this blend product set.

BlendSetAutomatedBlenderTypeEnum

Range: inclusive between 0 and 15

AutomatedBlenderTypeAsString

The ReadOnly string representation of the AutomatedBlenderTypeEnum property. Valid entries are None, SSI Standard XML, SSI Standard Ascii, SSI/Ranco Automation, Kahler, Junge Liquid, Junge Dry, Murray Remote, Murray Liquid Extended 2, Murray Dry Extended 2, Murray Liquid Extended, Murray Dry Extended, Murray Liquid (Win), Murray Dry (Win), and Repete SABRE NXT

string
AutomatedBlenderDataStoragePath

The network path used when creating automated blender interface files.

string

Max length: 100

RancoBlenderSettingsPrinted

Enable the Ranco RPM settings to be printed on the Blend batch ticket.

boolean

Must be 0, 1, True, or False

RancoMaximumCapacity

The maximum downflow capacity of the Ranco blender in Lbs/Min.

string

Max length: 6

Must be numeric

RancoMaximumDialSetting

The maximum dial setting for the Ranco control panel. Typically this is set to 999.

string

Max length: 6

Must be numeric

PercentBoronWarning

The percentage at which a warning is displayed after formulating a blend. If set to zero, the warning is disabled.

decimal number
SuppressBatchSheetLoadCheckboxes

The setting that indicates if the boxes to mark for orders requiring multiple batches are suppressed when printing the Blend Ticket.

boolean

Must be 0, 1, True, or False

AutomatedBlenderProductAttributeToUse

The Product Attribute to use as the product id in the automated blender interface files. This allows the same product to have multiple blend factors for different blending systems.

string

Max length: 50

Inactive

Indicates the Blend Product Set is inactive. Setting Product Set inactive prevents it from being available in the list of Blend Product Sets on the General tab of the Blend Ticket window.

boolean

Must be 0, 1, True, or False

AutomatedBlenderShippedFromLocationCode

A special code that is used for some automated blender interfaces that indicate a shipped from location different from the Agvance Ship From Location ID.

string

Max length: 20

AutomatedBlenderAlternateCompletionFileExtension

The alternate extension to search for when getting the completed files back from an automated blender other than the standard that the program was coded for.

string

Max length: 5

AutomatedBlenderUseBlendFactorForProductID

An automated blender interface setting to override the Product ID value in the file that is created with the blend factor of that product.

boolean

Must be 0, 1, True, or False

AutomatedBlenderFromRemoteDataStoragePath

For selected automated blenders, a secondary network path that is where the completed files are read from.

string

Max length: 100

AutomatedBlenderExpirationDate

For selected automated blenders, a default setting for the expiration date of the blend ticket.

date
VisibleToDispatchOnly

A Blend Product Set that is “Dispatcher Only” is not visible to blend operators when adding or editing a Blend Ticket unless the dispatcher has saved the Blend Ticket with one of these product sets assigned to it.

boolean

Must be 0, 1, True, or False

ShipFromLocationID

This setting relates to the Dispatch module only. Specifying a Ship From Location on the product set allows the Dispatcher to be more in control of products available when selecting product sets in Dispatch to create automated blender files. This is available regardless of the selections in Accounting for the Ship From Location or Sell From DeptID preferences. Setting a location on a job through one of the viewing buttons (Ship From or Sell From) has the original product set associated with the blend, as well as any other blend product sets from other locations which match that location, available in the Blend Product Set drop down list.

string

Max length: 6

ShipFromLocationGuid

The globally unique identifier for the Ship From location

globally unique identifier

(Hexadecimal 8-4-4-4-12)

ShipFromLocationName

The name of the Ship From location

string

Max length: 50

AutomatedBlenderImportRoundToScale

A setting that indicates that for Automated Blender Files, if the final product amounts should be rounded based on the scale settings from Agvance.

boolean

Must be 0, 1, True, or False

ProductSetGUID

The Globally Unique Identifier of this product set

globally unique identifier
ProductDetails

The list of products to use in the formulation.

Collection of ClsBlndSetD

Maximum of 50 allowed

AddOns

The list of products to be included in the formulation result.

Collection of ClsBlndSetAddOns