Updates the shipping details for a purchase order.

Procedure Specific Information

Updates the shipping details for a purchase order. The purchase order Id is required. All other fields are optional and only the supplied fields will be updated. The procedure is executed as below:

EXEC UpdatePurchaseOrderShippingDetails PurchaseOrderId = 'po-123', TrackingNumber = '1Z999AA10123456784', ShippingCarrier = 'fedex'

EXEC UpdatePurchaseOrderShippingDetails PurchaseOrderId = 'po-123', PaymentStatus = 'paid', PaymentTerms = 'net_30', CurrencyCode = 'USD'

Input

Name	Type	Description
PurchaseOrderId	String	The Id of the purchase order.
OrderDate	Datetime	The order date and time.
ExpectedDeliveryDate	Datetime	The expected delivery date and time.
PaymentTerms	String	The payment terms. The allowed values are none, cash_on_delivery, payment_on_receipt, payment_in_advance, net_7, net_15, net_30, net_45, net_60.
PaymentStatus	String	The payment status. The allowed values are none, unpaid, partially_paid, paid, refunded, credit_issued, other.
CurrencyCode	String	The currency code.
ShippingCarrier	String	The shipping carrier.
TrackingNumber	String	The tracking number.
ReferenceNumber	String	The reference number.
NoteToSupplier	String	A note to the supplier.

Result Set Columns

Name	Type	Description
Status	String	The status of the operation.
PurchaseOrderId	String	The Id of the purchase order.
OrderNumber	String	The order number of the purchase order.
SupplierId	String	The Id of the supplier.
OrderStatus	String	The current status of the purchase order.
OrderDate	Datetime	The order date and time.
ExpectedDeliveryDate	Datetime	The expected delivery date and time.
CreateDate	Datetime	The date the purchase order was created.
ModifyDate	Datetime	The date the purchase order was last modified.
PaymentTerms	String	The payment terms of the purchase order.
PaymentStatus	String	The payment status of the purchase order.
CurrencyCode	String	The currency code used for the purchase order.
ShippingCarrier	String	The shipping carrier for the purchase order.
TrackingNumber	String	The tracking number for the shipment.
ReferenceNumber	String	The reference number of the purchase order.
WarehouseId	String	The Id of the warehouse associated with the purchase order.
NoteToSupplier	String	A note to the supplier.
Products	String	A JSON array of products included in the purchase order.