| Name | Description | Type | Additional 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 |
integer |
Required |
| OrderDate |
The date the Sales Order was created |
date |
Required |
| FieldOwnerId |
The Agvance ID for the owner (Customer) of the Field associated with the Sales Order |
string |
Max length: 6 |
| FieldOwnerGuid |
The Agvance globally unique identifier for the owner (Customer) of the Field associated with the Sales Order |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| FieldOwnerFirstName |
The first name of the field owner for the field associated with this Sales Order |
string |
Max length: 20 |
| FieldOwnerLastName |
The last name of the field owner for the field associated with this Sales Order |
string |
Max length: 50 |
| FieldOwnerName |
A convenience property joining the first and last names together for the field owner |
string |
Max length: 71 |
| FieldId |
The Agvance ID for the Field associated with the Sales Order |
string |
Max length: 8 |
| FieldGuid |
The Agvance globally unique identifier for the Field associated with the Sales Order |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| FieldDescription |
The expanded description of the Field associated with the Sales Order |
string |
Max length: 30 |
| BillComment |
The billing comment of the Sales Order |
string |
Max length: 80 |
| EstDelDate |
Estimated date of product delivery to the customer |
date |
Required |
| PickupOrDeliver |
The type of Sales Order. Indicates the purpose of what will be done with the products on this order |
EnumPickupOrDeliver |
Required |
| PickupOrDeliverAsString |
A convenience property displaying the string value for the PickupOrDeliver enumeration. |
string |
Required |
| Status |
The customer approved status of the Sales Order |
EnumStatus |
Required |
| StatusAsString |
A convenience property displaying the string value for the Status enumeration. |
string |
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 |
| SalespersonFirstName |
The first name of the Salesperson associated with this Sales Order |
string |
Max length: 30 |
| SalespersonLastName |
The last name of the Salesperson associated with this Sales Order |
string |
Max length: 30 |
| SalespersonName |
A convenience property joining the first and last names together for the Salesperson |
string |
Max length: 61 |
| CropId |
The Agvance ID of the Crop associated with 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 |
Required |
| 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 |
| UnitTypeAsString |
A convenience property displaying the string value for the UnitType enumeration |
string |
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. |
date | |
| DiscOpt |
The Agvance ID of the Payment Term associated with this Sales Order |
string |
Max length: 15 |
| PaymentTermDescription |
The description of the Payment Term set in the DiscOpt property |
string |
Max length: 20 |
| ProcessedYn |
A property indicating that the Sales Order has already be transferred to another transaction in Agvance |
boolean |
Required |
| Location |
The Agvance ID for the Location of this Sales Order |
string |
Required Max length: 6 |
| LocationGuid |
The Agvance globally unique identifier for the Location of this Sales Order |
globally unique identifier |
Required (Hexadecimal 8-4-4-4-12) |
| LocationName |
The Agvance Location Name tied to the Location/LocationGuid properties of the Sales Order |
string |
Required Max length: 50 |
| OfferExpiresDate |
The date that the Sales Order is no longer valid; Works in conjunction with the Status of "Offered" |
date | |
| PaymentDate |
The date that the payment is received for this Sales Order |
date | |
| CheckNumber |
The check number for the payment received |
string |
Max length: 10 |
| StartDate |
The date that transfers to the Booking Start Date |
date | |
| ExpirationDate |
The date that transfers to the Booking Expiration Date |
date | |
| AddedByUserId |
The Agvance ID of the User who created the Sales Order |
string |
Max length: 3 |
| AddedByUserGuid |
The Agvance globally unique identifier of the User who created the Sales Order |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| AddedByUserFirstName |
The first name of the User that created the Sales Order |
string |
Max length: 20 |
| AddedByUserLastName |
The last name of the User that created the Sales Order |
string |
Max length: 25 |
| AddedByUserName |
A convenience property joining the first and last names together for the added by user |
string |
Max length: 46 |
| LastEditedUserId |
The Agvance ID of the last User to edit the Sales Order |
string |
Max length: 3 |
| LastEditedUserGuid |
The Agvance globally unique identifier of the last User to edit the Sales Order |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| LastEditedUserFirstName |
The first name of the User that last edited the Sales Order |
string |
Max length: 20 |
| LastEditedUserLastName |
The last name of the User that last edited the Sales Order |
string |
Max length: 25 |
| LastEditedUserName |
A convenience property joining the first and last names together for the last edited user |
string |
Max length: 46 |
| ContractFormat |
The Booking Contract that is selected when the Sales Order is created. If provided it must already exist. Default is empty string |
string | |
| Splits |
List of customers to whom the order is being sent |
Collection of ClsSalesOrderSplit |
Required |
| Applications |
List of applicator / vehicle records for the Sales Order |
Collection of ClsSalesOrderApplication | |
| Discounts |
List of Sales Order Discounts applied to the Sales Order |
Collection of ClsSalesOrderDiscount |