Articles
Database Query (Database) - New Query Added (19067)
A new query entity 'Customer Service Activity History' has been added to the Database Query tool. The image below captures the display fields the new query includes. Pathway: Database > Database Query ...
Database Query (Database) - Updates to Revenue Query (19517)
The following fields have been added to the Revenue query in Database Query: Start Date End Date Service ID Account Class Name Pathway: Database > Database Query ...
Database Query (Database) - Colums Updated to 'Work Order Label' Query (19630)
In the Work Order Label Query , the Equipment Type Name and Material Type Name columns have been updated to display their corresponding values. Pathway: Database > Database Query ...
Database Query (Database) - Updates to Date Filter in 'Franchise Fees Posted to AR 'Query (19816)
The Date filter in the Franchise Fees Posted to AR query has been enhanced to include additional operator options for more flexible date filtering. Pathway: Database > Database Query > Franchise Fees Posted to AR (entity) ...
Database Query (Database) - Updates to Accounts and Sites Query (19907, 19908)
The following fields have been added to the Accounts and Sites query: Account Credit Limit Site Bill To Selection Fax Number Site Broker Account Broker Broker Name Pathway: Database > Database Query > Accounts and Sites [entity]...
Database Query (Database) - Updates to 'Service Change History' Query (19910)
The following fields have been added to the Service Change History query: LOB ID and LOB Name Equipment Type ID and Equipment Type Name Lost to Competitor ID and Lost to Competitor Name ...
Database Query (Database) - Updates to 'Site Contract Status' Query (19906)
The following fields have been added to the Site Contract Status query: Contract Effective Date Rate Guarantee Months Annual Increase Limit ...
Database Query (Database) - Updates to 'AR History' Query (18765, 19986)
The following updates have been applied to the AR History query: Addition of a Payment Type field Addition of account address field Fix to the AR Type filter Pathway: Database > Database Query ...
Database Query (Database) - Fields Added to 'Daily Route Productivity' Query (19985)
Truck State has been added as a field option to the Daily Route Productivity query. ...
Database Query (Database) - Fields Added to the Active Services Query (19984)
Reason Code has been added as an option to the Active Services query. Pathway: Database > Database Query ...
Database Query (Database) - Fields Added to Work Orders Query (19979)
Site Service ID has been added as a field option to the Active Services and Work Orders queries. Pathway: Database > Database Query ...