NameDescriptionTypeAdditional Information
SalesOrderGUID

The globally unique identifier that represents this Sales Order

globally unique identifier

Required

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

OrderNum

A document number counter that is used to represent this Sales Order. Used on the printout and displayed for selection of the Sales Order throughout Agvance. Populate this value and leave SalesOrderGUID = GUID.Empty {00000000-0000-0000-0000-000000000000} to use this value to find the Sales Order in Agvance to update

integer

Range: inclusive between 0 and 2147483647

OrderDate

The date the Sales Order was created

string

Required

Data type: DateTime

Format must be MM/dd/yyyy

BillComment

The billing comment of the Sales Order

string

Max length: 80

EstDelDate

Estimated date of product delivery to the customer

string

Required

Data type: DateTime

Format must be MM/dd/yyyy

PickupOrDeliver

The type of Sales Order. Indicates the purpose of what will be done with the products on this order

EnumPickupOrDeliver

Required

Status

The customer approved status of the Sales Order

EnumStatus

Required

ShipVia

Method of shipment

string

Max length: 25

ShipTo

The destination address of the Sales Order

string

Max length: 50

County

The Agvance ID of the County of the destination address for the Sales Order

string

Max length: 60

Territory

A sales tool that can be used to group Sales Orders

string

Max length: 15

ControlNum

A value that may be used to reference an internal control number (such as hand ticket numbers) associated with the Sales Order

string

Max length: 10

SalespersonId

The Agvance ID of the Salesperson associated with this Sales Order

string

Max length: 15

CropId

The Agvance ID of the Crop associated with the Sales Order. If set, will be the value used on the Sales Order

string

Max length: 15

CropGuid

The Agvance globally unique identifier for the Crop associated with the Sales Order

globally unique identifier

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

CustPo

Customer provided purchase order number

string

Max length: 20

AuthAgent

Authorized Agent - the person associated with this customer who is authorized to make decisions or pickup products

string

Max length: 50

AaRelatedHow

How the Authorized Agent is related to the customer

string

Max length: 20

AaAddr1

Authorized Agent Address 1

string

Max length: 50

AaAddr2

Authorized Agent Address 2

string

Max length: 50

AaCity

Authorized Agent City

string

Max length: 50

AaState

Authorized Agent State

string

Max length: 2

AaZip

Authorized Agent Zipcode

string

Max length: 10

CustomApplied

Indicates if this Sales Order is to be applied by the dealer

boolean

Must be 0, 1, True, or False

AddComments

A large text field that holds additional notes or comments about this Sales Order

string

Max length: 240

Acres

Indicates the number of Acres, Hectares, Tons, Metric Tonnes, or 1000 SqFt based on the UnitType

decimal number
UnitType

The type of unit that was used to identify the Acres value entered

EnumUnitType

Required

FedPermit

One of the federal permits of a customer associated with this Sales Order

string

Max length: 60

FedPermitExpDate

The expiration date of the FedPermit of this Sales Order at the time it was created.

string

Data type: DateTime

Format must be MM/dd/yyyy

DiscOpt

The Agvance ID of the Payment Term associated with this Sales Order

string

Max length: 15

OfferExpiresDate

The date that the Sales Order is no longer valid; Works in conjunction with the Status of "Offered"

string

Data type: DateTime

Format must be MM/dd/yyyy

PaymentDate

The date that the payment is received for this Sales Order

string

Data type: DateTime

Format must be MM/dd/yyyy

CheckNumber

The check number for the payment received

string

Max length: 10

StartDate

The date that transfers to the Booking Start Date

string

Data type: DateTime

Format must be MM/dd/yyyy

ExpirationDate

The date that transfers to the Booking Expiration Date

string

Data type: DateTime

Format must be MM/dd/yyyy

Splits

List of customers to whom the order is being sent. The purpose on the Edit is to hold the LineItem collection of products. If supplied each customer must already exist on the Sales Order as identified by the SalesOrderSplitGUID.

Collection of ClsSalesOrderSplitUpdate

Maximum of 8 allowed

Applications

List of applicator / vehicle records for the Sales Order. If records are supplied without the SalesOrderApplicationGUID populated, those new records will be added to the Sales Order. Any existing Application records will not be modified unless the SalesOrderApplicationGUID is provided. To remove an Application record, set the DeleteLine property to true and supply the SalesOrderApplicationGUID

Collection of ClsSalesOrderApplicationUpdate
Discounts

List of Sales Order Discounts applied to the Sales Order. If records are supplied without the SalesOrderDiscountGUID populated, those new records will be added to the Sales Order. Any existing Discount records will not be modified unless the SalesOrderDiscountGUID is provided. To remove a Discount record, set the DeleteLine property to true and supply the SalesOrderDiscountGUID

Collection of ClsSalesOrderDiscountUpdate