| Name | Description | Type | Additional Information |
|---|---|---|---|
| DeliveryTicketGUID |
Globally Unique Identifier for the ticket record |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| TicketNumber |
Ticket number of the delivery ticket – the combination of TicketNumber, Location ID, and TicketDate makes the ticket unique |
integer |
Required If auto numbering is turned on send 0. Otherwise, send the delivery ticket number. Must be filled out and numeric Range: inclusive between 0 and 2147483647 |
| LocationID |
ID of the location of the ticket |
string |
Required Max length: 6 |
| TicketDate |
Date of the ticket |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| GrowerID |
Agvance customer ID of the field |
string |
Max length: 6 |
| FieldID |
Agvance ID of the field |
string |
Max length: 8 |
| FieldGUID |
Globally Unique Identifier of the field |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| FieldDescription |
Description of the field |
string |
Max length: 30 |
| Comments |
User entered comment |
string |
Max length: 80 |
| InvoicedTF |
Status indicating if the ticket is invoiced |
boolean |
Must be 0, 1, True, or False |
| VoidedTF |
Status indicating if the ticket is voided |
boolean |
Must be 0, 1, True, or False |
| MiniBulkTF |
Indicates whether the ticket is for an order that is considered a Mini Bulk ticket |
boolean |
Must be 0, 1, True, or False |
| TicketType |
Delivery status of the delivery ticket - Pickup or Delivered |
string |
Required Max length: 10 Valid options: Delivered or Pickup. |
| ShipVia |
Mode of transportation for the ticket |
string |
Max length: 25 |
| County |
County the product on the ticket is being shipped to |
string |
Max length: 60 |
| Territory |
Territory identifier if the ship to location is in Canada |
string |
Max length: 15 |
| ShipTo |
Selected ship to address of the customer to identify where the product on the ticket is being shipped to |
string |
Max length: 50 |
| AdditionalComments |
Additional user entered comments for this ticket |
string |
Max length: 240 |
| ControlNumber |
User entered alternative identifier of the ticket |
string |
Max length: 10 |
| SalesmanID |
ID of the salesperson associated with the ticket |
string |
Max length: 15 |
| CustomAppliedTF |
Indicates whether the products on the ticket will be custom applied or not - True = customer applied, False = not customer applied |
boolean |
Must be 0, 1, True, or False |
| LoadedTF |
Indicates if the ticket has affected inventory balances yet or not - True = loaded so inventory quantities have been affected, False = not loaded so inventory quantities have not been affected yet |
boolean |
Must be 0, 1, True, or False |
| CustomerPONumber |
Customer’s purchase order reference number tied to the ticket |
string |
Max length: 20 |
| CropID |
ID of the crop the products on the ticket are being used for |
string |
Max length: 15 |
| FederalPermit |
Federal permit for restricted products on the ticket |
string |
Max length: 60 |
| OnHoldTF |
Indicates if the ticket is ready to be invoiced - True = not ready to be invoiced, False = ready to be invoiced |
boolean |
Must be 0, 1, True, or False |
| Acres |
Number of acres the product was applied to |
decimal number | |
| AuthorizedAgent |
Selected authorized agent from the customer's contact list - as returned from the Post Customerlist method of the API |
string |
Max length: 50 |
| RePackedTF |
Indicates if products on the ticket are being repackaged by the retailer |
boolean |
Must be 0, 1, True, or False |
| UnitType |
Type of unit used for the application on the additional information tab - T for Tons, H for Hect, M for Tonne, F for 1000 SQFT, A for Acres |
string |
Max length: 1 Valid options: T for Tons, H for Hect, M for Tonne, F for 1000 SQFT, A for Acres. |
| ADJobStatus |
Dispatch Job Status |
string |
Max length: 10 |
| Dropship | boolean |
Must be 0, 1, True, or False |
|
| PrintMethod |
Type of Print Method for Roll Up |
string |
Max length: 10 Valid options: '' or 'Detail' (1) for No Roll Up, 'RollBoth' (2) for Roll Up Prices and Product Names, 'RollPrce' (3) for Roll Up Prices Only, 'RollBothIT' (4) for Roll Up Prices and Product Names (Include Tax), 'RollPrceIT' (5) for Roll Up Prices Only (Include Tax), 'RollPrceSQ' (6) for Roll Up Prices Only, Supress Quantities, 'RollPSQIT' (7) for Roll Up Prices Only, Supress Quantities (Include Tax). |
| ADPriority |
Dispatch priority of the ticket |
integer |
Range: inclusive between 0 and 5 |
| LoadedDate |
Date the ticket was marked as loaded to affect inventory |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| ADDateRequested |
Dispatch date requested |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| ADTimeRequested |
Dispatch time requested |
string |
Data type: DateTime Must be valid time format |
| LockedByUserID |
User ID of the person currently editing the ticket |
string |
Max length: 3 |
| LockedByUserFirstName |
First name of the person currently editing the ticket |
string |
Max length: 20 |
| LockedByUserLastName |
Last name of the person currently editing the ticket |
string |
Max length: 25 |
| AssignedToUserID |
User ID of the person the ticket is assigned to |
string |
Max length: 3 |
| UserFirstName |
First name of the person that entered the ticket |
string |
Max length: 20 |
| UserLastName |
Last name of the person that entered the ticket |
string |
Max length: 25 |
| UserAssignedFirstName |
First name of the person the ticket is assigned to |
string |
Max length: 20 |
| UserAssignedLastName |
Last name of the person the ticket is assigned to |
string |
Max length: 25 |
| LocationName |
Name of the location associated with the ticket |
string |
Max length: 50 |
| UniqueKey |
Unique number within an Agvance database to identify the ticket |
integer |
Send in zero (0) if new. Do not modify existing value. |
| LastModifiedUTC |
The last modified date of the delivery ticket in UTC format |
date | |
| FreightVendorGuid |
Globally Unique Identifier for the freight vendor |
globally unique identifier |
(Hexadecimal 8-4-4-4-12) |
| FreightCalculationMethod |
Calculation method for the freight amount. Valid options: Unit for Estimated $/Unit, Total for Estimated Total $. |
string |
Max length: 20 |
| FreightAmount |
Cost of freight |
decimal number |
Max of 4 decimal places |
| TicketSplit |
List of customers on the ticket and what percentage is assigned to them |
Collection of clsDelSplit |
List cannot be empty |
| TicketDetail |
List of products on the ticket |
Collection of clsDelLI |
List cannot be empty |
| TicketApplicator |
List of applicators and vehicles on the ticket |
Collection of clsDelAppl |
JSON list name must be TicketApplicator. |
| TicketStatePermits |
List of state permits for the first split customer on the ticket |
Collection of clsDelPermit | |
| TicketPosOverrides |
List of PosOverrides |
Collection of ClsPosOverrides |