cieTrade.net API
The cieTrade provides a basic REST API that (currently) includes 2 commonly used datasets: One for "worksheets" and one for worksheet "shipping details". Arguments can be given via URL parameters if called from a browser. UserID and UserPwd parameters are mandatory all others are optional. Data is returned as a JSON datatable. After 6 failed login attempts login will be blocked for 24 hours.
WORKSHEETS
Worksheets in cieTrade are logistical events that includes brokerage transactions (buy/sell), Inventory (purchases) or receipts and inventory sales. This dataset provides details for the overall "load" such as worksheet or invoice number, receiver, supplier, total sales, purchases, expenses etc.
Dataset Attributes
| BuysellNo | ||
| TradeType | ||
| ShippingDate |
||
| Status | ||
| PostDate | ||
| Customer | ||
| ShipToLocation | ||
| Supplier | ||
| ShipFromLocation |
||
| FreightCarrier | ||
| ReleaseNumber | ||
| PickupNumber | ||
| Sales | ||
| Chargebacks | ||
| TotalSale | ||
| Purchases | ||
| Expenses | ||
| TotalCosts | ||
| SalesAdj | ||
| PurchaseAdj | ||
| GrossProfit | ||
| SalesTaxAmnt | ||
| SalesCurrency | ||
| ExchangeRate | ||
| PurchaseFxRate | ||
| FxInvoiceAmount | ||
| FxSalesTaxAmt | ||
| PurchaseCurrency | ||
WORKSHEET DETAILS
Worksheet details are the product or grade details associated with a given received/brokered load or shipment. This data set includes attributes such as product/grade name, quantity, price, extension, product attributes, sales/purchase cost, as well as allocated expenses.
Dataset Attributes
| Buysellno |
||
| Detailid |
||
| Department |
||
| TradeType |
||
| Status |
||
| ShippingDt |
||
| InvoiceDt |
||
| SoOrderDt |
||
| PoOrderDt |
||
| Customer |
||
| CustomerAddress |
||
| ShipFromID |
||
| RelNo |
||
| ContainerNo |
||
| Supplier |
||
| SupplierAddress |
||
| ShipTo |
||
| PickupNo |
||
| BookingNo |
||
| SoDestPort |
||
| PoDestPort |
||
| ETA |
||
| ProductCat |
||
| ProductGrp |
||
| Description |
||
| Specifications |
||
| InvoiceDesc |
||
| Units | ||
| UnitType | ||
| WksWeightLBS |
||
| SWeight |
||
| SWeightUOM |
||
| PWeight |
||
| PWeightUOM | ||
| SWeightLBS |
||
| WksSales |
||
| WksChgBack |
||
| WksExp |
||
| WksPurchases |
||
| WksSAdj |
||
| WksPAdj |
||
| Factor |
||
| SPO |
||
| SCurrencyCd |
||
| SPrice |
||
| SPriceUOM |
||
| SAmount |
||
| PO |
||
| PCurrencyCd |
||
| PPrice |
||
| PPriceUOM |
||
| PAmount |
||
| ChargeBacks |
||
| FreightExp |
||
| Expenses |
||
| SAdjs |
||
| PAdjs |
||
| Interest |
||
| BankFees |
||
| Discount |
||
| Margin |
||
| TotalSale |
||
| TotalCost |
||
| GrossProfit |
||
| NetProfit |
||
| Sell-Rep |
||
| Buy-Rep |
||
| IsAgency |
||
| IsNegSales |
||
| TranSrc |
||
| UserDefined1 |
||
| UserDefined2 |
||
| UserDefined3 |
||
| OwnerName |
||
| POShippingTerms |
||
| POShipVia |
||
| POPaymentTerms |
||
| SOShippingTerms |
||
| SOShipVia |
||
| SOPaymentTerms |
||
| CustID |
||
| SupplierID |
||
| EquipNo |
||
| GrossWt |
||
| TareWt |
||
If you have additional questions, please contact the Support Team via email to support@cietrade.net.