CData Python Connector for Amazon Marketplace

Build 25.0.9454

VendorOrderStatus

Returns purchase order statuses based on the filters that you specify.

Columns

Name Type References Description
PurchaseOrderNumber [KEY] String Provides purchase order status for the specified purchase order number.
ItemSequenceNumber [KEY] String Numbering of the item on the purchase order. The first item will be 1, the second 2, and so on.
PurchaseOrderStatus String Buyer has received all of the items in the purchase order.
PurchaseOrderDate String The date the purchase order was placed. Must be in ISO-8601 date/time format.
BuyerProductIdentifier String Buyer's Standard Identification Number (ASIN) of an item.
CurrencyCode String Three digit currency code in ISO 4217 format for the listed price. String of length 3.
Amount String Acknowledged quantity for the listed price. This value should not be zero.
VendorProductIdentifier String The vendor selected product identification of the item.
OrderedQuantityAmount Decimal Acknowledged quantity. This value should not be zero.
OrderedQuantityUnitMeasure String Unit of measure for the acknowledged quantity.
OrderedQuantityUnitSize Int The case size, in the event that we ordered using cases.
ItemReceiveStatus String Receive status of the line item.
ItemReceiveAmount Decimal Acknowledged quantity. This value should not be zero.
ItemReceiveUnitMeasure String Unit of measure for the acknowledged quantity.
ItemReceiveUnitSize Int The case size, in the event that we ordered using cases.
ItemReceiveDate Datetime The date when the purchase order was last received. Must be in ISO-8601 date/time format.
ItemConfirmationStatus String Confirmation status of line item.
ItemConfirmationAmount Decimal Acknowledged quantity. This value should not be zero.
ItemConfirmationUnitMeasure String Unit of measure for the acknowledged quantity.
ItemConfirmationUnitSize Int The case size, in the event that we ordered using cases.
ItemRejectionAmount Decimal Acknowledged quantity. This value should not be zero.
ItemRejectionUnitMeasure String Unit of measure for the acknowledged quantity.
ItemRejectionUnitSize Int The case size, in the event that we ordered using cases.
SellingPartyId String Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details.
SellingPartyTaxRegistrationNumber String Tax registration number for the entity. For example, VAT ID.
SellingPartyTaxRegistrationType String Tax registration type for the entity.
SellingPartyPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
SellingPartyAddressLine1 String First line of the address.
SellingPartyAddressLine2 String Additional address information, if required.
SellingPartyAddressLine3 String Additional address information, if required.
SellingPartyCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
SellingPartyCounty String The county where person, business or institution is located.
SellingPartyCity String The city where the person, business or institution is located.
SellingPartyDistrict String The district where person, business or institution is located.
SellingPartyName String The name of the person, business or institution at that address.
SellingPartyStateOrRegion String The state or region where person, business or institution is located.
SellingPartyPhone String The phone number of the person, business or institution located at that address.
ShipToPartyId String Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details.
ShipToPartyTaxRegistrationNumber String Tax registration number for the entity. For example, VAT ID.
ShipToPartyTaxRegistrationType String Tax registration type for the entity.
ShipToPartyPostalCode String The postal code of that address. It contains a series of letters or digits or both, sometimes including spaces or punctuation.
ShipToPartyAddressLine1 String First line of the address.
ShipToPartyAddressLine2 String Additional address information, if required.
ShipToPartyAddressLine3 String Additional address information, if required.
ShipToPartyCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
ShipToPartyCounty String The county where person, business or institution is located.
ShipToPartyCity String The city where the person, business or institution is located.
ShipToPartyDistrict String The district where person, business or institution is located.
ShipToPartyName String The name of the person, business or institution at that address.
ShipToPartyStateOrRegion String The state or region where person, business or institution is located.
ShipToPartyPhone String The phone number of the person, business or institution located at that address.
LastUpdatedDate Datetime The date when the purchase order was last updated. Must be in ISO-8601 date/time format.
OrderedQuantityDetails String Details of item quantity ordered.
AcknowledgementStatusDetails String Details of item quantity ordered.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454