...
These are the results of the enabled triggers script query, assuming all nine triggers are enabled. Note that the Entity name does not display in the query results.
| Entity | TriggerTable Name | Table Trigger Name | Disabled |
|---|---|---|---|
| Job | JC00102 | JC00102_D_CDCJC00102 | 0 |
JC00102_IU_CDCJC00102 | 0 | ||
| Job Cost Code | JC00701 | JC00701_D_CDCJC00701 | 0 |
JC00701_IU_CDCJC00701 | 0 | ||
| GP Customer | RM00101 | RM00101_D_CDCRM00101 | 0 |
RM00101_IU_CDCRM00101 | 0 | ||
| Technician | SV00115 | SV00115_D_CDCSV00115 | 0 |
SV00115_IU_CDCSV00115 | 0 | ||
Service Option | sv00196 | sv00196_D_CDCsv00196 | 0 |
sv00196_IU_CDC | sv00196 | 0 | |
Location | SV00200 | SV00200_D_CDCSV00200 | 0 |
SV00200_IU_CDCSV00200 | 0 | ||
| Service Call | SV00300 | SV00300_D_CDCSV00300 | 0 |
SV00300_I_CDCSV00300 | 0 | ||
SV00300_U_CDCSV00300 | 0 | ||
| Appointment | SV00301 | SV00301_D_CDCSV00301 | 0 |
SV00301_I_CDCSV00301 | 0 | ||
SV00301_U_CDCSV00301 | 0 | ||
| Equipment | SV00400 | SV00400_D_CDCSV00400 | 0 |
SV00400_IU_CDC | SV00400 | 0 |
Disabled Triggers Script
...
These are the query results at the GP database level from the disabled triggers script. Note that the Entity name does not display in the query results.
| Entity | TriggerTable Name | Table Trigger Name | Disabled |
|---|---|---|---|
| Call Source | SVCALSRC | SVCALLSRC_D_CDCSVCALSRC | 1 |
| SVCALLSRC_IU_CDCSVVALSRC | 1 | ||
| GP Company | SY01500 | SY01500_D_CDCSY01500 | 1 |
| SY01500_IU_CDCSY01500 | 1 |
Company Database Level
These are the query results at the Company database level from the disabled triggers script, assuming the default nine triggers have been enabled. Note that the Entity name does not display in the query results.
| Entity | TriggerTable Name | Table Trigger Name | Disabled | |
|---|---|---|---|---|
| GP GL Account | GL00100 | GL00100_D_CDCGL00100 | 1 | |
GL00100_IU_CDC | GL00100 | 1 | ||
Job User Defined | JC00107 | JC00107_D_CDC | JC00107 | 1 |
JC00107_IU_CDCJC00107 | 1 | |||
| Estimate Revision | JC00201 | JC00201_D_CDCJC00201 | 1 | |
JC00201_IU_CDCJC00201 | 1 | |||
| Forecast Revision | JC00401 | JC00401_D_CDCJC00401 | 1 | |
JC00401_IU_CDCJC00401 | 1 | |||
| Job Cost Note | JC00501 | JC00501_D_CDCJC00501 | 1 | |
JC00501_IU_CDC | JC00501 | 1 | ||
| Job Bill Code | JC00601 | JC00601_D_CDCJC00601 | 1 | |
JC00601_IU_CDCJC00601 | 1 | |||
| Job Revenue Code | JC00610 | JC00610_D_CDCJC00610 | 1 | |
JC00610_IU_CDC | JC00610 | 1 | ||
| Employee Union Code Master | JC00801 | JC00801_D_CDCJC00801 | 1 | |
JC00801_IU_CDCJC00801 | 1 | |||
Change Order | JC01001 | JC01001_D_CDCJC01001 | 1 | |
JC01001_IU_CDCJC01001 | 1 | |||
| Change Order Cost Code | JC01002 | JC01002_D_CDCJC01002 | 1 | |
JC01002_IU_CDC | JC01002 | 1 | ||
| Job Change Order Revenue Code | JC01004 | JC01004_D_CDCJC01004 | 1 | |
JC01004_IU_CDCJC01004 | 1 | |||
| Job Vendor | JC01501 | JC01501_D_CDCJC01501 | 1 | |
JC01501_IU_CDC | JC01501 | 1 | ||
| Job Vendor Date | JC01504 | JC01504_D_CDCJC01504 | 1 | |
JC01504_IU_CDCJC01504 | 1 | |||
| Job Project | JC01701 | JC01701_D_CDCJC01701 | 1 | |
JC01701_IU_CDCJC01701 | 1 | |||
| Rate Class | JC01801 | JC01801_D_CDCJC01801 | 1 | |
JC01801_IU_CDCJC01801 | 1 | |||
| Job Lien Waiver | JC20705 | JC20705_D_CDCJC20705 | 1 | |
JC20705_IU_CDCJC20705 | 1 | |||
| Fed Class | JC40106 | JC40106_D_CDC | JC40106 | 1 |
JC40106_IU_CDCJC40106 | 1 | |||
| Union Code | JC40201 | JC40201_D_CDCJC40201 | 1 | |
JC40201_IU_CDCJC40201 | 1 | |||
| Cost Element | JC40209 | JC40209_IU_CDCJC40209 | 1 | |
| Resource Extension | K2A_ResourceExtension | K2A_ResourceExtension_D_CDCK2A_ResourceExtension | 1 | |
K2A_ResourceExtension_IU_CDC | K2A_ResourceExtension | 1 | ||
| GP Purchase Order | POP10100 | POP10100_D_CDCPOP10100 | 1 | |
POP10100_IU_CDC | POP10100 | 1 | ||
| GP Purchase Order Detail | POP10110 | POP10110_D_CDC | POP10110 | 1 |
POP10110_IU_CDCPOP10110 | 1 | |||
| GP Address | RM00102 | RM00102_D_CDCRM00102 | 1 | |
RM00102_IU_CDCRM00102 | 1 | |||
| GP Salesperson | RM00301 | RM00301_D_CDCRM00301 | 1 | |
RM00301_IU_CDCRM00301 | 1 | |||
| Installation By | SV_00415 | SV_00415_D_CDC | SV_00415 | 1 |
SV_00415_IU_CDCSV_00415 | 1 | |||
| Time Zone | SV00045 | SV00045_D_CDCSV00045 | 1 | |
SV00045_IU_CDC | SV00045 | 1 | ||
| Division | SV00077 | SV00077_D_CDCSV00077 | 1 | |
SV00077_IU_CDCSV00077 | 1 | |||
| Note | SV000805 | SV000805_D_CDCSV000805 | 1 | |
SV000805_IU_CDCSV000805 | 1 | |||
| Customer | SV00100 | SV00100_D_CDCSV00100 | 1 | |
SV00100_IU_CDCSV00100 | 1 | |||
| Technician Vehicle | SV00113 | SV00113_D_CDCSV00113 | 1 | |
SV00113_IU_CDCSV00113 | 1 | |||
| Technician Branch | SV00114 | SV00114_D_CDCSV00114 | 1 | |
SV00114_IU_CDCSV00114 | 1 | |||
| Technician Skill Set | SV00155 | SV00155_D_CDC | SV00155 | 1 |
SV00155_IU_CDCSV00155 | 1 | |||
| Sublocation | SV00201 | SV00201_D_CDCSV00201 | 1 | |
SV00201_IU_CDCSV00201 | 1 | |||
| Problem Type | SV00310 | SV00310_D_CDCSV00310 | 1 | |
SV00310_IU_CDCSV00310 | 1 | |||
| Call Type | SV00320 | SV00320_D_CDCSV00320 | 1 | |
SV00320_IU_CDCSV00320 | 1 | |||
| Appointment Status | SV00325 | SV00325_D_CDC | SV00325 | 1 |
SV00325_IU_CDCSV00325 | 1 | |||
| Technician Activity | sv00326 | sv00326_D_CDC | sv00326 | 1 |
sv00326_IU_CDC | sv00326 | 1 | ||
| User Define 1 | SV00330 | SV00330_D_CDCSV00330 | 1 | |
SV00330_IU_CDCSV00330 | 1 | |||
| User Define 2 | SV00331 | SV00331_D_CDCSV00331 | 1 | |
SV00331_IU_CDCSV00331 | 1 | |||
| Contract Equipment | SV00403 | SV00403_D_CDC | SV00403 | 1 |
SV00403_IU_CDCSV00403 | 1 | |||
| Equipment Type | SV00405 | SV00405_D_CDCSV00405 | 1 | |
SV00405_IU_CDC | SV00405 | 1 | ||
| Manufacturer | SV00410 | SV00410_D_CDC | SV00410 | 1 |
SV00410_IU_CDCSV00410 | 1 | |||
| Model Number | SV00411 | SV00411_D_CDCSV00411 | 1 | |
SV00411_IU_CDCSV00411 | 1 | |||
| Extended Warranty Type | SV00420 | SV00420_D_CDCSV00420 | 1 | |
SV00420_IU_CDCSV00420 | 1 | |||
| Meter Reading | SV00430 | sv00430_D_CDC | SV00430 | 1 |
sv00430_IU_CDCSV00430 | 1 | |||
| Contract | SV00500 | SV00500_D_CDCSV00500 | 1 | |
SV00500_IU_CDC | SV00500 | 1 | ||
| Task Code | SV00560 | SV00560_D_CDC | SV00560 | 1 |
SV00560_IU_CDC | SV00560 | 1 | ||
| Skill Level | SV00572 | SV00572_D_CDCSV00572 | 1 | |
SV00572_IU_CDCSV00572 | 1 | |||
| Invoice History | SV00701 | SV00701_D_CDCSV00701 | 1 | |
SV00701_IU_CDCSV00701 | 1 | |||
| Service Cost Code | SV00735 | SV00735_IU_CDCSV00735 | 1 | |
| Building | SV01200 | SV01200_D_CDCSV01200 | 1 | |
SV01200_IU_CDCSV01200 | 1 | |||
| Refrigerant Type | SV40180 | SV40180_D_CDC | SV40180 | 1 |
SV40180_IU_CDCSV40180 | 1 | |||
| Refrigerant Code | SV40182 | SV40182_D_CDCSV40182 | 1 | |
SV40182_IU_CDCSV40182 | 1 | |||
| Refrigerant Leak | SV40184 | SV40184_D_CDCSV40184 | 1 | |
SV40184_IU_CDCSV40184 | 1 | |||
| GP Internet Address | SY01200 | SY01200_D_CDCSY01200 | 1 | |
SY01200_IU_CDCSY01200 | 1 | |||
| GP Employee | UPR00100 | UPR00100_D_CDCUPR00100 | 1 | |
UPR00100_IU_CDCUPR00100 | 1 | |||
| GP Employee Tax Info | UPR00300 | UPR00300_D_CDC | UPR00300 | 1 |
UPR00300_IU_CDCUPR00300 | 1 | |||
| GP Employee Pay Code | UPR00400 | UPR00400_D_CDCUPR00400 | 1 | |
UPR00400_IU_CDCUPR00400 | 1 | |||
| GP Employee State Tax | UPR00700 | UPR00700_D_CDCUPR00700 | 1 | |
UPR00700_IU_CDCUPR00700 | 1 | |||
| GP Department | UPR40300 | UPR40300_D_CDCUPR40300 | 1 | |
UPR40300_IU_CDCUPR40300 | 1 | |||
| GP Position | UPR40301 | UPR40301_D_CDC | UPR40301 | 1 |
UPR40301_IU_CDCUPR40301 | 1 | |||
| GP Pay Code | UPR40600 | UPR40600_D_CDCUPR40600 | 1 | |
UPR40600_IU_CDC | UPR40600 | 1 | ||
| GP Workers Comp | UPR40700 | UPR40700_D_CDC | UPR40700 | 1 |
UPR40700_IU_CDCUPR40700 | 1 | |||
| GP Payroll State | UPR41100 | UPR41100_D_CDCUPR41100 | 1 | |
UPR41100_IU_CDCUPR41100 | 1 | |||
| Purchase Order Detail | WS10101 | WS10101_D_CDCWS10101 | 1 | |
WS10101_IU_CDCWS10101 | 1 | |||
| TimeTrack Option | WS40000 | WS40000_D_CDC | WS40000 | 1 |
WS40000_IU_CDCWS40000 | 1 | |||
| TimeTrack Registered User | WS41001 | WS41001_D_CDCWS41001 | 1 | |
WS41001_IU_CDC | WS41001 | 1 | ||
| Attachment | WSDOCS | WSDOCS_D_CDC | WSDOCS | 1 |
WSDOCS_IU_CDCWSDOCS | 1 |