...
Key Header:
ORDER_ID|ORDER_NUMBER|PLACED_DTTM|ITEM_QUANTITY|ORDER_SOURCE|ORDER_STATUS|FULFILLMENT_STATUS|CANCLLED_DTTM|CANCELLED_REASON|TOTAL_WEIGHT_VALUE|TOTAL_WEIGHT_UNITS|SHIPPING_LINE_SOURCE|SHIPPING_LINE_CODE|SHIPPING_LINE_SERVICE|SHIPCOST_VALUE|SHIPCOST_CURRENCY|BUYER_ADDRESS_ADDRESS_1|BUYER_ADDRESS_ADDRESS_2|BUYER_ADDRESS_CITY|BUYER_ADDRESS_PROVINCE|BUYER_ADDRESS_PROVINCE_CODE|BUYER_ADDRESS_COUNTRY|BUYER_ADDRESS_COUNTRY_CODE|BUYER_ADDRESS_ZIPCODE|LINE_ITEMS_SKUSKUS|LINE_ITEMS_QUANTITY|LINE_ITEMS_REQUIRES_SHIPPING|LINE_ITEMS_IMAGE_URL|LINE_ITEMS_ROUTING_URL|PREDICTION_EXPECTED_SHIPMENT_DTTM|PREDICTION_PROMISED_DELIVERY_DTTMSample Data:
5544645|S824514|2023-08-05T00:00:00-05:00|4|Amazon|OPEN|FILLED|||3|LBS|Fenix Shipping|Priority|Priority Mail|10|USD||P.O. Box 8050||Christiansted|Virgin Islands|VI|United States|US|00823|910544U^911441U^111319^101102|1^1^2^1|TRUE^TRUE^TRUE^FALSE|||2023-08-12T00:00:00-05:00|2023-08-12T00:00:00-05:00
...
Key Header:
SHIPMENT_ID|ORDER_NUMBER|SHIPMENT_DTTM|TRACKING_NUMBER|CARRIER_NAME|CARRIER_SERVICE|ITEM_QUANTITY(`)|LABELCOST_VALUE(`)|LABELCOST_CURRENCY|SHIPMENT_STATUS(`)|SHIPPER_ADDRESS_1|SHIPPER_CITY|SHIPPER_ADDRESS_PROVINCE|SHIPPER_ADDRESS.PROVINCE_CODE|SHIPPER_COUNTRY|SHIPPER_ADDRESS.COUNTRY_CODE|SHIPPER_ZIPCODESKUS|QUANTITIES _ZIPCODE|LINE_ITEMS_SKU|LINE_ITEMS_QUANTITYSample Data:
XGDYS1737S|S824514|2022-12-12T00:00:00-05:00|99981773237887|USPS|Priority Mail|2|10|USD|SHIPMENT_CONFIRMED|2000 Walnut Ave|Fremont|California|CA|United States|US|94538|911441U^111319|1^1
...