| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| projid | integer |
None. |
|
| subject | string |
None. |
|
| sow | string |
None. |
|
| dos | date |
None. |
|
| status | string |
None. |
|
| seq | integer |
None. |
|
| tno | string |
None. |
|
| parentid | integer |
None. |
|
| companyid | integer |
None. |
|
| customerid | integer |
None. |
|
| isbilled | boolean |
None. |
|
| category | string |
None. |
|
| requestedby | string |
None. |
|
| orderref | string |
None. |
|
| responsetime | decimal number |
None. |
|
| scheduleddate | date |
None. |
|
| scheduledtime | time interval |
None. |
|
| feedback | string |
None. |
|
| rating | decimal number |
None. |
|
| duedate | date |
None. |
|
| createby | string |
None. |
|
| createdate | date |
None. |
|
| updateby | string |
None. |
|
| priority | string |
None. |
|
| signfile | string |
None. |
|
| assignto | string |
None. |
|
| siteid | integer |
None. |
|
| contractid | integer |
None. |
|
| customervisibility | boolean |
None. |
|
| poc | string |
None. |
|
| phone | string |
None. |
|
| low | string |
None. |
|
| directions | string |
None. |
|
| receivedvia | string |
None. |
|
| approvedby | string |
None. |
|
| devices | string |
None. |
|
| string |
None. |
||
| subcategory | string |
None. |
|
| watchlist | string |
None. |
|
| publicid | string |
None. |
|
| internalstatus | string |
None. |
|
| notifycustomers | boolean |
None. |
|
| tpcode | string |
None. |
|
| billactuals | integer |
None. |
|
| servicenotes | string |
None. |
|
| siteother | string |
None. |
|
| lat | string |
None. |
|
| lng | string |
None. |
|
| techrecommendation | string |
None. |
|
| workcompleted | boolean |
None. |
|
| estimatedhrs | decimal number |
None. |
|
| contractno | string |
None. |
|
| is_checklist_mandetory | boolean |
None. |
|
| customer_notice | string |
None. |
|
| fullday | boolean |
None. |
|
| duetime | time interval |
None. |
|
| tags | string |
None. |
|
| finish_date | date |
None. |
|
| finish_time | time interval |
None. |
|
| techvisibility | boolean |
None. |
|
| color | string |
None. |
|
| textcolor | string |
None. |
|
| subcat_default_line | boolean |
None. |
|
| customer_notified | boolean |
None. |
|
| categoryid | integer |
None. |
|
| subcategoryid | integer |
None. |
|
| deletedate | date |
None. |
|
| updatedate | date |
None. |
|
| deleteby | string |
None. |
|
| multi_day | boolean |
None. |
|
| exclude_public_holidays | boolean |
None. |
|
| week_days_only | boolean |
None. |
|
| estimatedhrs_perday_pertech | decimal number |
None. |
|
| contract_recurrence_id | integer |
None. |
|
| mergefrom | integer |
None. |
|
| authorizedby | string |
None. |
|
| authorizationnotes | string |
None. |
|
| contract_billing_id | integer |
None. |
|
| salesrep | string |
None. |
|
| tpid | string |
None. |
|
| print_template | string |
None. |
|
| t_contract_billing | t_contract_billing |
None. |
|
| t_contract_recurrence | t_contract_recurrence |
None. |
|
| t_customersites | t_customersites |
None. |
|
| t_ers | Collection of t_ers |
None. |
|
| t_estimate_hdr | Collection of t_estimate_hdr |
None. |
|
| t_projects | t_projects |
None. |
|
| t_servicecategory | t_servicecategory |
None. |
|
| t_servicecategory1 | t_servicecategory |
None. |
|
| t_ticket_schedule | Collection of t_ticket_schedule |
None. |
|
| t_ticketcards | Collection of t_ticketcards |
None. |
|
| t_ticketchecklist | Collection of t_ticketchecklist |
None. |
|
| t_ticketchecklistgeneric | Collection of t_ticketchecklistgeneric |
None. |
|
| t_ticketitems | Collection of t_ticketitems |
None. |
|
| t_ticketlog | Collection of t_ticketlog |
None. |
|
| t_ticketlogfiles | Collection of t_ticketlogfiles |
None. |
|
| t_orders | Collection of t_orders |
None. |
|
| t_customers | t_customers |
None. |
|
| t_invhdr | Collection of t_invhdr |
None. |
|
| t_pihdr | Collection of t_pihdr |
None. |
|
| t_pohdr | Collection of t_pohdr |
None. |
|
| t_expenses | Collection of t_expenses |
None. |