Billing Sheets
A Billing Sheet is a specialized transaction form (page) in cieTrade.net, typically used with the waste brokerage business workflow model to capture all of the customer service charges and related hauler expenses associated with a specific monthly billing for waste services. The ListBillingSheets API returns a list of Billing Sheet "header records" with fields such as Invoice number, invoice date, customer, service location, hauler or vendor, billing period and other details as a JSON data table. Each row in the result set is an instance of an individual Billing sheet for one customer, location and hauler over a specified period. The details of a specific billing sheet can be produced from the ListBillingSheetCharges API.
Request Example
https://api.cietrade.net/ListBillingSheets?UserID=ExampleUser@gmail.com&UserPwd=123ABC&DateFrom=5/21/2024&DateTo=6/12/2024&SearchType=Invoice&Account=TargetAccount&Location=TargetLocation&Dept=DeptID&Status=Status&Vendor=VendorName
Query Parameters (Filters)
| UserID | cieTrade.net User Name. | Required | |
| UserPwd | cieTrade.net User Password. | Required | |
| Account | Target Account. Use exact company name as defined, the Account ID or blank value for all accounts. | Optional | |
| Location | Target Dispatch Job Location or blank value for all locations of the specified Account parameter (above). Cannot have a value without an Account parameter. | Optional | |
| DateFrom | Start of date range. Optional, if not provided, it will default to 30 days from today's date. | Optional | |
| DateTo | End of date range. Optional, if not provided, it will default to Todays Date. | Optional | |
| DateType | Inquiry date type either "Schedule" or "Dispatch". Sets whether the date filter is based off Scheduled Date or Dispatch Job create Date. if not provided, it will default to schedule Date | Optional | |
| Dept | Department Filter Example: “00” as it is stored in cieTrade, or Department Short Name. This parameter is Optional, no default value if not provided. | Optional | |
| Vendor | Hauler or vendor servicing account. Pass the exact company name as listed in cieTrade or the vendor’s account ID. Blank value defaults to all. | Optional | |
| Status | Status filter. Accepted values: ‘Open’, ‘Completed’, ‘Approved’, ‘Posted’, ‘Not Approved’, ‘Cancelled’ A blank value will default to all statuses. | Optional |
Response Example
{
"invoice_no": "512535",
"group_invoice_no": "",
"account_name": "TARGET",
"location_name": "#1001 STAMFORD STORE",
"department": "ALLEGHENY",
"hauler": "BLACK TRUCKS",
"status": "OPEN",
"billing_reference": "",
"invoice_date": "2024-06-13",
"posting_date": null,
"due_date": "2024-06-28",
"sales": "165.00",
"cost": "105.00",
"profit": "60.00",
"weight": "0.000",
"total_qtyuom": "L",
"owner": "cieTrade Admin",
"transaction_date": "2024-05-01",
"billing_address1": "TARGET",
"billing_address2": "21 Broad St",
"billing_city": "Stamford",
"billing_region": "CO",
"billing_postal_code": "06901",
"BillingUDF1": "",
"account_id": "43686",
"notes": ""
}