URL: https://api.kometsales.com/api/purchase.order.list  

Method: GET

Content-Type: URL Parameters 

Input parameters:

authenticationToken (required)(string:50):

Komet Sales security token.

date (required if number is not sent)(date): the vendor ship date of the order. (format

Vendor Ship Date.

Date format: YYYY-MM-DD).

futureInventoryAvailableFrom (optional)(date): the date

Date when the product will be available from. (format YYYY-MM-DD). The .

The specified date range must not exceed 4 days.

Date format: YYYY-MM-DD 

futureInventoryAvailableTo (optional)(date): the date

Date when the product will beavailable to. (format stops being available.

Date format: YYYY-MM-DD). The DD 

The specified date range must not exceed 4 days.

vendor (optional)(string:50): vendor

Vendor name or code.

vendorId(optional)(integer:10): vendor

Komet Sales internal Vendor ID.

This parameter is used to search purchase orders from only one vendor.

You can obtain get this value from the vendor.list API method.

customerId(optional)(integer:20): customer

Komet Sales internal Customer ID.

You can obtain get this value from the customer.list API method.

customerPONumber (optional)(string:20): The PO # of the customer

Customer PO Number.

product (optional)(string:100): product

Product description.

number (optionalrequired if date is not sent)(string:10): purchase

Purchase order number. You may  

You can send a set of numbers separated by commas. 

origin (optional)(string:4): origin code (

Origin code. For example: MIA, MDE, and BOG, etc).

prebook(optional)(string:10):prebooknumber

Prebook number.

locationIdawbId (optional)(integer:10): location Komet Sales internal ID. You can obtain this value from the location.list API method.status )

AWB ID of the order.

If you use this parameter, or inboundTruckId, you don’t need to send any other parameters aside from the authenticationToken.

inboundTruckId (optional)(string:20): it's used if you want to see only some orders with a specific status. integer)

Inbound Truck ID.

If you use this parameter, or awbId, you don’t need to send any other parameters aside from the authenticationToken.

locationId (optional)(integer:10)

Komet Sales internal Location ID.

You can obtain this value from the location.list API method.

status (optional)(string:20)

Prebook status.

Valid values: Confirmed by Farm, Approved, Pending Approval, Cancelled.

If this filter is not set, the system will return all the purchases ordersevery Purchase Order, including those that are have the Pending Approval status.

statusLine (optional)(string:20): the status of the line.

Product line status.

Valid values: Pending, Confirmed, Cancelled, Partial Confirm, Shipped. 

purchaseOrderItemIds (optional)(string:200):

A set of purchase order item Purchase Order Item IDs separated by commas.

This is very useful for the Vendor Availability integration. 

includeVendorAvailabilityDetails (optional)(boolean:true/false): By default )

Include Vendor Availability information.

Valid values: True | False

Default it's false. If this value is true, the response will include the details of the vendor availability information but you will have to apply the number filter and only one number is allowed at a time. updatedAsOf(optional) (datetime) (date format  

updatedAsOf (optional)(datetime)

When provided the system will only return orders that have been updated as of the date/time that is specified.

Date format: YYYY-MM-DDhh:mm:ss

Time must be in the GMT time zone. 

excludeDetails(optional): When provided it will force the method to only return orders that have been updated as of the date/time that is specified. Time must be in the GMT time zone. 

excludeDetails(optional)(integer:1): specify 1 if you want the list only the header of the orders and exclude the details. Default = 0.  

(integer:1)

If the result should include only headers and exclude details.

Valid values: 0 = Include details | 1 = Exclude details

Default is 0.

status (integer:1): transaction

Transaction status. 1 for success or 0 for failure.

Valid values: 1 = Success | 0 = Failure

message (string:500): description of the status of the transaction

Transaction status description.

purchaseOrders: array of purchase orders (array)

An array containing Purchase Orders.

id (integer:20):

Komet Sales internal purchase order Purchase Order ID.

number (integer:10): purchase order

Purchase Order number.

origin carrierName (string:4): origin 200)

Purchase Order carrier name.

carrierId (integer:20)

Purchase Order Carrier ID.

networkCodeId (integer)

Purchase Order Carrier’s Komet Network Code.

origin (string:4)

Origin code.

vendorId (integer:20): vendor

Komet Sales internal Vendor ID.

vendorName (string:200): vendor

Vendor name.

shipDate (date): order ship

Purchase Order shipping date. (date

Date format: YYYY-MM-DD).

status (string:1): status code (

Status code.

Valid values: CF = Confirmed by Farm , | A = Approved , | PA = Pending Approval , | CA = Cancelled).

locationId (integer:20): location

Komet Sales internal Location ID.

locationName (string:200): location

Location name.

totalCost (decimal:10,3): total

Total cost of the order.

comments (string:500): special

Special instructions or comments.

totalBoxes (integer:10): number

Number of boxes.

updatedOn (datetime): last

Last time when the order was updated. (date format YYYY

Date format: YYYY-MM-DD'T'hh:mm:ss). Time will be ss 

Time is in the GMT time zone.

createdOn (datetime):date

Date when the order was created. (

Date format: YYYY-MM-DD'T'hh:mm:ss).

details : array of purchase orders details(array)

Purchase Order details.

poItemId (integer:20): PO item internal

Komet Sales internal Purchase Order Item ID.

prebookItemId (integer:20):

Prebook item internal ID.

prebook(integer:10):prebook

Prebook number.

prebookTruckDate(date):prebook truck date. (date format

Prebook Truck Date.

Date format: YYYY-MM-DD).

carrierId(integer:20): carrier Komet Sales internal

Prebook Carrier ID.

carrierName(string:200): carrier name

Prebook Carrier Name.

standingOrder(string:10): standing

Standing order number.

orderType(string:1)

Order type.

Valid values: P for prebook, S for standing Order, D for double.= Prebook | S = Standing Order | D = Double

customerId(integer:20): customer Komet Sales internal ID.

customerName(string:200): customer name.

customerCode (string:50): Customer code.

shipName (string:200): Ship To name. 

shipCity (string:200): ship city name.  

subtotalCost(decimal:10,2)

Purchase Order total cost plus additional charges.

shipState (string:200): ship state name. 

shipAddress (string:200): ship address. 

shipZipCode (string:10): ship zip code.  

shipCountry (string:200): ship

Ship country name.  

productId (integer:20) product Komet Sales internal ID.

productDescription(string:200): product description.

recipes: array (array) of the products included within the recipe:

productDescription(string:200): item description.

stems(integer: 3): the number of stems.

laborAndMaterials: array of the labor and materials included within the recipe:

productDescription(string:200): product description.

quantity(integer: 3): the number of units.

totalBoxes(integer:10): number of boxes.

quantityConfirmed(integer:10): number of boxes confirmed by the vendor. 

boxType(string:3): box type code. (HB, QB, EB, etc).

bunches (integer:10): number of bunches per box.

stemsBunch(integer:10): stems per bunch.

unitCost(decimal:10,3): unit flower cost.

units (integer:10): units per box.

unitType(string:5): stem or bunch.

totalFbe(decimal:10,2)

Total Full Box Equivalent (FBE) of every box in the Purchase Order.

totalUnits(integer:10):total of units.

totalCost(decimal:10,3): total cost.unitPrice

totalAdditionalCharges (decimal:10,3): 2)

Total additional charges.

unitPrice(decimal:10,3): unit flower price. This field is only available if the token type is Company Token. 

totalPrice(decimal:10,3): total price. This field is only available if the token type is Company Token. 

markCode(string:20): special mark code or slot number.

customField1 (string:50): additional field #1.

notes (string:200): general notes for each line.

notesForVendor (string:200): notes for the vendor associated to the prebook item.

lineItemStatus(string:1): vendor status code of the product line. P for Pending, C for Confirmed, CA for Cancelled, PC for Partial Confirm, S for Shipped.

breakdowns: array of breakdowns

productId (integer:20): product Komet Sales internal ID.

productDescription(string:200): product description.

stemsBunch(integer:10): stems per bunch.

bunches (integer:10): number of bunches.

cost (decimal:10,3): unit flower cost.

boxes: array of boxes

boxCode(string:20): box code number.

lotNumber(integer:10): box string)

Box lot number.

position (string:5): physical position of the box.

statusId(integer:10): status Komet Sales internal ID.

statusName(string:20): status name (Farm Shipped, Received Warehouse, Shipped Warehouse)

customFields: array of custom fields of the line, only if they exist.

name and value of the custom field (string:20).

vendorAvailabilityDetails: details of the vendor availability items associated to this line of the order. 

productDescription(string:200): product description.

availableFrom(date): date when the product was available from the vendor. (date format YYYY-MM-DD).

postHarvest (string:20): post harvest. 

unitType(string:20): unit type. Stem or Bunch. 

unitsAllocated(integer:10): number of units allocated to this line of the order. 

downgraded (boolean): true if the product was downgraded.

originalProductDescription(string:200):

product where the item was downgraded from. 

upc: details of the upc information added to the product. 

number (string: 50): UPC number. 

checkDigit(integer: 2): UPC check digit. 

pullDate(string: 20): UPC Pull date

price (string:20): UPC unit price. 

description (string:200): Product description for the UPC. 

instructions (string:200):

Additional UPC instructions for the UPC.