Billing Sheet Charges

The Billing Sheet Charges API "ListBillingSheetCharges" returns a list of individual customer charges and corresponding vendor / provider expenses as a JSON data table. The available parameters define the returned dataset. Each row defines one individual bill sheet charge and matching expense item with some associated header data from the related Billing Sheet record that it is connected to.

Request Example

https://api.cietrade.net/ListBillingSheetCharges?UserID=Example@gmail.com&UserPwd=1234&DateFrom=6/1/2024&DateTo=7/2/2024&DateType=Invoice&Account=daktest234&Location=new location&Dept=AMI Trading&Status=OPEN&Vendor=84699&Equipment=""&ServiceType=""

Query Parameters

UserID	cieTrade.net User Name.	Required
UserPwd	cieTrade.net User Password.	Required
Account	Target Account. Use exact company name as defined or use Account ID or blank for all accounts	Optional
Location	Target Account-Location or blank for all locations	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 Invoice or Transaction. Controls whether the date filter is based off Invoice Date or Transaction Date if not provided, it will default to Invoice 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
Status	Status filter. Accepted values: ‘Open’, ‘Completed’, ‘Approved’, ‘Posted’, ‘Not Approved’, ‘Cancelled’ This parameter is Optional, no default value if not provided.	Optional
Vendor	Target vendor of billing sheet detail item/charge, include exact company name as listed in cieTrade. Can also pass the Vendor’s account ID form cieTrade if known.	Optional
Equipment	Target equipment type of billing sheet detail item/charge. Include exact name of equipment.	Optional
ServiceType	Target Service Type of billing sheet detail item/charge. Accepted values: ‘Manual’, ’On Call’, ’Recurring’ If not provided returns all values.	Optional

Response Example

{
        "invoice_no": "512535",
        "group_invoice_no": "",
        "account_name": "TARGET",
        "location_name": "#1001 STAMFORD STORE",
        "billing_reference": "",
        "department": "ALLEGHENY",
        "owner": "cieTrade Admin",
        "status": "OPEN",
        "transaction_date": "2024-06-13",
        "hauler_name": "BLACK TRUCKS",
        "hauler_ID": "1010",
        "service_GLAcct": "90002",
        "service_description": "FUEL SURCHARGE",
        "equipment_name": "",
        "site_ref": "",
        "eq_number": "",
        "weight": 0.00000,
        "WeightUOM": "",
        "pono": "",
        "jobno": "0",
        "charge_amount": "0.00",
        "cost_per": "",
        "price": "5.00",
        "price_per": "",
        "sales_amount": "15.00",
        "margin": -5.00000,
        "billing_address1": "21 Broad St",
        "billing_address2": "21 Broad St",
        "billing_city": "Stamford",
        "billing_region": "CO",
        "billing_postal_code": "06901",
        "BillingUDF1": ""
	"ServiceID": 804
        "grade": "OCC # 11"
    }

Note: The ServiceID attribute is the unique identifier of the Service Record that is connected to the Billing Sheet Detail.