THE FOLLOWING INFORMATION IS SUPPLIED FOR INFORMATION PURPOSES ONLY. USERS SHOULD NOT PERFORM THESE PROCEDURES AND THEY SHOULD ONLY BE PERFORMED BY QUALIFIED SERVICELEDGER PERSONNEL. ANY ATTEMPT TO USE THIS INFORMATION WITHOUT SERVICELEDGER'S KNOWLEDGE MAY COMPROMISE THE INTEGRITY OF YOUR DATA.
Common Search Commands
select * from ticket where ticket_id = 'xxxx' - search the ticket table to find a specific ticket for modification
select * from entry where entry_id = "xxxx' - search the entry table to find a specific entry for modification
select * from ticket_item where ticket_id = 'xxxx' - search the work order invoice charges for a specific ticket.
select * from client_quote where client_quote_id = 'xxxx' - search the quote table to find a specific quote
select * from client_quote_item where client_quote_id = 'xxxx' - search a specific quote for items associated with quote.
COMMON TABLE AND ENTRY ID'S
company_user / company_user_id
resource / resource_id
client / client_id
client_location / location_id
client_quote / client_quote_id
ticket / ticket_id (common - ticket_item, entry, ticket_equipment)
equipment / equipment_id
item / item_id
invoice / invoice_id (common - invoice_item)
agreement / agreement_id
task / task_id (common task_item)
project / project_id
purchase_order / purchase_order_id (common purchase_order_item)
bill / bill_id (common bill_item / bill_id)
payment / payment_id