CData Python Connector for Amazon Marketplace

Build 25.0.9454

DirectFulfillmentOrders

Returns a list of purchase orders created during the time frame that you specify.

Columns

Name Type References Description
PurchaseOrderNumber [KEY] String The purchase order number for this order. Formatting Notes: alpha-numeric code.
BillToPartyAddressLine1 String First line of the address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyAddressLine2 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyAddressLine3 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyAttention String The attention name of the person at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyCity String The city where the person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
BillToPartyCounty String The county where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyDistrict String The district where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyId String Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details.
BillToPartyName String The name of the person, business or institution at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyPhone String The phone number of the person, business or institution located at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
BillToPartyStateOrRegion String The state or region where person, business or institution is located.
BillToPartyTaxRegAddressLine1 String First line of the address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegAddressLine2 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegAddressLine3 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegAttention String The attention name of the person at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegCity String The city where the person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
BillToPartyTaxRegCounty String The county where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegDistrict String The district where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegMessages String Tax registration message that can be used for additional tax related details.
BillToPartyTaxRegName String The name of the person, business or institution at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegNumber String Tax registration number for the party. For example, VAT ID.
BillToPartyTaxRegPhone String The phone number of the person, business or institution located at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
BillToPartyTaxRegPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
BillToPartyTaxRegStateOrRegion String The state or region where person, business or institution is located.
BillToPartyTaxRegType String Tax registration type for the entity.
CustomerMessage String Message to customer for order status.
CustomerOrderNum String The customer order number.
IsGift Bool When true, the order contain a gift. Include the gift message and gift wrap information.
IsPriority Bool When true, this is a priority shipment.
IsScheduledDelivery Bool When true, this order is part of a scheduled delivery program.
IsSlipRequired Bool When true, a packing slip is required to be sent to the customer.
OrderDate Datetime The date the order was placed.
OrderStatus String Current status of the order.
OrderItems String A JSON aggregate containing the line items included in this purchase order.
OrderTaxDetails String The tax details for the order.
PromisedDate Datetime Delivery date promised to the Amazon customer.
RequiredDate Datetime Time by which the vendor is required to ship the order.
SellingPartyAddressLine1 String First line of the address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyAddressLine2 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyAddressLine3 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyAttention String The attention name of the person at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyCity String The city where the person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
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. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyDistrict String The district where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyId String Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details.
SellingPartyName String The name of the person, business or institution at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyPhone String The phone number of the person, business or institution located at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
SellingPartyPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
SellingPartyStateOrRegion String The state or region where person, business or institution is located.
SellingPartyTaxRegMessages String Tax registration message that can be used for additional tax related details.
SellingPartyTaxRegNumber String Tax registration number for the party. For example, VAT ID.
SellingPartyTaxRegType String Tax registration type for the entity.
ShipFromId String The vendor warehouse identifier for the fulfillment warehouse. If not specified, the result will contain orders for all warehouses.
ShipMethod String Ship method to be used for shipping the order. Amazon defines ship method codes indicating the shipping carrier and shipment service level.
ShippingPartyAddressLine1 String First line of the address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyAddressLine2 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyAddressLine3 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyAttention String The attention name of the person at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyCity String The city where the person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
ShippingPartyCounty String The county where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyDistrict String The district where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyName String The name of the person, business or institution at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyPhone String The phone number of the person, business or institution located at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
ShippingPartyStateOrRegion String The state or region where person, business or institution is located.
ShippingPartyTaxRegAddressLine1 String First line of the address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegAddressLine2 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegAddressLine3 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegAttention String The attention name of the person at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegCity String The city where the person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
ShippingPartyTaxRegCounty String The county where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegDistrict String The district where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegMessages String Tax registration message that can be used for additional tax related details.
ShippingPartyTaxRegName String The name of the person, business or institution at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegNumber String Tax registration number for the party. For example, VAT ID.
ShippingPartyTaxRegPhone String The phone number of the person, business or institution located at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShippingPartyTaxRegPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
ShippingPartyTaxRegStateOrRegion String The state or region where person, business or institution is located.
ShippingPartyTaxRegType String Tax registration type for the entity.
ShipToAddressLine1 String First line of the address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToAddressLine2 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToAddressLine3 String Additional address information, if required. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToAttention String The attention name of the person at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToCity String The city where the person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToCountryCode String The two digit country code. In ISO 3166-1 alpha-2 format.
ShipToCounty String The county where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToDistrict String The district where person, business or institution is located. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToName String The name of the person, business or institution at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToPhone String The phone number of the person, business or institution located at that address. For Amazon label only vendors, this field will have the value `xxxxx` within the object `shipToParty`.
ShipToPostalCode String The postal code of that address. It conatins a series of letters or digits or both, sometimes including spaces or punctuation.
ShipToStateOrRegion String The state or region where person, business or institution is located.

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