Portal
1
SC
2
SC
3
SC
4
SC
5
SC
6
SC
7
SC
8
SC
9
SC
10
SC
11
SC
12
SC
13
SC
14
SC
15
SC
16
SC
17
SC
18
SC
19
SC
20
SC
21
SC
22
SC
23
SC
24
SC
25
SC
26
SC
27
SC
28
SC
29
SC
30
SC
31
SC
32
SC
33
SC
34
SC
35
SC
36
SC
Drag to adjust the number of frozen columns
Table
Columns In the Table
Data Type
Description
order_fulfillment
id
Integer
Unique number assigned to every line in the table
order_fulfillment
_created_on
timestamp with time zone
Date the record was created
order_fulfillment
_last_updated_on
timestamp with time zone
Date the record was last updated
order_fulfillment
_revision
Integer
Number of times the record has changed
order_fulfillment
_partneruuid
Character Varying
Partner Unique Identifier
order_fulfillment
purchase_date
timestamp with time zone
Date the purchase was made
order_fulfillment
last_updated_date
timestamp with time zone
Date the purchase order was last updated
order_fulfillment
amazon_order_id
character varying
Amazon's assigned ID for the order
order_fulfillment
merchant_order_id
character varying
A unique identifier optionally supplied for the order by the seller
order_fulfillment
order_status
Character Varying
Shows whether the order is running, paused, ended, etc.
order_fulfillment
sales_status
character varying
The status of the sale
order_fulfillment
fulfillment_channel
Character Varying
Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
order_fulfillment
ship_service_level
character varying
A value describing the type of fulfillment service that the buyer expects the seller to use (for example, standard versus expedited)
order_fulfillment
city
character varying
Destination city
order_fulfillment
state
character varying
Destination state, region or province
order_fulfillment
postal_code
character varying
Destination zip code
order_fulfillment
country
character varying
Destination country
order_fulfillment
is_business_order
boolean
Is ordered by a business.
order_fulfillment
asin
character varying
Unique identifier assigned by Amazon to a product
order_fulfillment
currency
Character Varying
Currency used for the purchase
order_fulfillment
principal_price
double precision
The principal price for the order
order_fulfillment
shipping_price
double precision
The cost of shipping for the order
order_fulfillment
tax_price
double precision
The sales tax for the oder
order_fulfillment
shipping_tax
double precision
The sales tax for the shipping
order_fulfillment
gift_wrap
double precision
The gift wrap cost
order_fulfillment
gift_wrap_tax
double precision
The sales tax for the gift wrap
order_fulfillment
promotion_ids
character varying
The ID for the promotion
order_fulfillment
price_designation
character varying
Deprecated by Amazon
order_fulfillment
ship_promotion_discount
double precision
Promotion discount applied to shipping
order_fulfillment
item_promotion_discount
double precision
Total of all promotion discounts applied to the order item
order_fulfillment
sku
Character Varying
Seller's product identifier
order_fulfillment
item_status
character varying
The status of the item(s) in the order
order_fulfillment
product_name
character varying
The short title for the product, displayed on the detail web page.
order_fulfillment
quantity
double precision
The number of product units ordered
order_fulfillment
order_channel
character varying
The sub channel through which a sale was made for CBA/WBA orders
order_fulfillment
purchase_order_number
character varying
The number for the purchase order
36 records

Alert

Lorem ipsum
Okay
View larger version
Download CSV