OrderShipmentsCData JDBC Driver for BigCommerce 2019J - Build 19.0.7354
Returns shipments and their corresponding orders.
Table Specific Information
To insert a new Order Shipment, at least one Shipment Item is required to be attached to the INSERT query. For this reason, you can first populate a temporary ShipmentItems table with the desired items for the shipment you are about to create, and later using this table as a value for the LinkedProducts Pseudo-Columns during insertion:
INSERT INTO ShipmentItems#TEMP (Id,Quantity) Values (2519,1); INSERT INTO OrderShipments (OrderId,OrderAddressId,LinkedProducts) VALUES (1106,1007,ShipmentItems#TEMP);
Numeric ID of this shipment within this order.
Numeric ID of the associated order.
Creation date for the shipment.
Tracking number of the shipment.
Enum of the BigCommerce shipping-carrier integration/module.
Comments the shipper wishes to add.
ID of this shipping address.
Pseudo column fields are used to enable the user to INSERT Fields that are non-readable but required during creation of new records.
Column for the aggregate table name holding order products.