Total unshipped order packages
SQL query for Starshipit
Get the total number of unshipped order packages.
SELECT COUNT(*) FROM unshipped_orderpackages
Starshipit data model
Unshipped Orders
View 41 columns
DtpBoolean
PltBoolean
TypeString
ItemsString
StatusString
CarrierString
ArchivedBoolean
CurrencyString
Order_idInteger
PackagesString
PlatformString
MetadatasString
ReferenceString
Order_dateDate-time
Carrier_nameString
Order_numberString
Add_insuranceBoolean
Create_returnBoolean
Declared_valueNumber
Dangerous_goodsBoolean
Insurance_valueNumber
Manifest_numberInteger
Destination_cityString
Destination_nameString
Destination_emailString
Destination_phoneString
Destination_stateString
Address_validationString
Destination_streetString
Destination_suburbString
Signature_requiredBoolean
Destination_companyString
Destination_countryString
Carrier_service_codeString
Destination_buildingString
Sender_details_emailString
Sender_details_phoneString
Destination_post_codeString
Sender_details_companyString
Sender_details_countryString
Destination_delivery_instructionsString
Unshipped Orderitems
View 13 columns
ValueNumber
WidthNumber
HeightNumber
LengthNumber
WeightNumber
Item_idInteger
Order_idInteger
QuantityInteger
DescriptionString
Tariff_codeString
Stock_on_handInteger
Quantity_to_shipInteger
Country_of_originString
Unshipped Orderpackages
View 9 columns
NameString
WidthNumber
HeightNumber
LengthNumber
WeightNumber
Order_idInteger
Package_idInteger
Packaging_typeString
Tracking_numberString
Shipped Orders
Shipped Orderitems
Shipped Orderpackages
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed