1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Drag to adjust the number of frozen columns
Table
Portal
Columns In the Table
Data Type
Description
orders_shipments
VC
id
Integer
Unique number assigned to every line in the table
orders_shipments
VC
_created_on
timestamp with time zone
Date the record was created in the database
orders_shipments
VC
_last_updated_on
timestamp with time zone
Date the record was last updated in the database
orders_shipments
VC
_revision
Integer
Number of times the record has changed
orders_shipments
VC
shipment_id_arn
Character Varying
The shipment's Amazon Reference Number (ARN)
orders_shipments
VC
asn
Character Varying
Amazon Shipping Notification (ASN) that vendors send to Amazon prior to shipping
orders_shipments
VC
creation_date
timestamp with time zone
Date the shipment was created.
orders_shipments
VC
status
Character Varying
Shipment status
orders_shipments
VC
date_or_detail
Character Varying
Information regarding the next status (detail) and/or expected ETA (date) of the next step in the shipment process.
orders_shipments
VC
alert
Character Varying
Flag to indicate if there is an issue with the shipment.
orders_shipments
VC
pos
Character Varying
PO number
orders_shipments
VC
stacked_pallets
Integer
Number of stacked pallets in shipment
orders_shipments
VC
unstacked_pallets
Integer
Number of unstacked pallets in shipment
orders_shipments
VC
cartons
Integer
Number of cartons in shipment
orders_shipments
VC
carrier_scac
Character Varying
Standard Carrier Alpha Code (SCAC)
orders_shipments
VC
carrier_name
Character Varying
The name of the carrier used (e.g. Old Dominion)
orders_shipments
VC
mode
Character Varying
Referrs to how the shipment was shipped (i.e. small parcel, less than truckload, truckload etc.)
orders_shipments
VC
ship_from
Character Varying
Address where the shipment is being shipped from.
orders_shipments
VC
ship_to
Character Varying
Amazon Fulfillment Center(s) where the shipment is being shipped to..
orders_shipments
VC
reference_id
Character Varying
Bill of Lading (BOL) Number
orders_shipments
VC
_partneruuid
Character Varying
Partner Unique ID
21 records

Alert

Lorem ipsum
Okay
View larger version
Download CSV