Триггеры

"localhost:/firebird/data/ILICHEVSK2.FDB"

Триггеры

Триггер	Таблица	Тип	Порядок	Описание
BLACKLIST_SETID	BLACKLIST	BEFORE INSERT	0
CLASS_SetID	CLASS	BEFORE INSERT	0
CLIENTFIELDS_SETID	CLIENTFIELDS	BEFORE INSERT	0
CLIENTS_CHECK_ENTERPRISE	CLIENTS	AFTER INSERT OR UPDATE	0
CLIENTS_SetFullName	CLIENTS	BEFORE INSERT OR UPDATE	0
CLIENTS_SetID	CLIENTS	BEFORE INSERT	0
CLIENTTYPES_SETID	CLIENTTYPES	BEFORE INSERT	0
CONTRACTCOSTS_BD0	CONTRACTCOSTS	BEFORE DELETE	0
CONTRACTCOSTS_SetID	CONTRACTCOSTS	BEFORE INSERT	0
CONTRACTS_SetID	CONTRACTS	BEFORE INSERT	0
CORNFIELDS_SETID	CORNFIELDS	BEFORE INSERT	0
CROPPARAMS_SetID	CROPPARAMS	BEFORE INSERT	0
CROPSORT_SetID	CROPSORT	BEFORE INSERT	0
CROPTYPES_SetID	CROPTYPES	BEFORE INSERT	0
CROP_SetID	CROP	BEFORE INSERT	0
DEVIATION_CHANGESTATE	DEVIATION	BEFORE UPDATE	0
DEVIATION_SETDATE	DEVIATION	BEFORE INSERT	0	Установка даты возникновения отклонения
EXPORTACTITEMPREDS_BIU0	EXPORTACTITEMPREDS	BEFORE INSERT OR UPDATE	0
EXPORTACTITEMS_SETID	EXPORTACTITEMS	BEFORE INSERT	0
EXPORTACTITEMS_SETTESTWEIGHT	EXPORTACTITEMS	BEFORE INSERT OR UPDATE	100
EXPORTACTS_DELETE_EAI	EXPORTACTS	BEFORE DELETE	0
EXPORTACTS_SETID	EXPORTACTS	BEFORE INSERT	0
FORMSETUP_BI	FORMSETUP	BEFORE INSERT	0
GRADEBASIS_SetID	GRADEBASIS	BEFORE INSERT	0
GRADEBASIS_SetState	GRADEBASIS	BEFORE INSERT OR UPDATE	10
GRADERESULTS_SetID	GRADERESULTS	BEFORE INSERT	0
ILT$INVOICESUPDATE	INVOICES	AFTER UPDATE	1000
ILT$ITDELETE	IT	AFTER DELETE	1000
ILT$ITINSERT	IT	AFTER INSERT	1000
ILT$ITUPDATE	IT	AFTER UPDATE	1000
ILT$TABLEOPERATION_BI0	ILT$TABLEOPERATION	BEFORE INSERT	0
INVOICEREGISTERS_SETID	INVOICEREGISTERS	BEFORE INSERT	0
INVOICES_COPYSTORAGEMOVE	INVOICES	AFTER UPDATE	0
INVOICES_SetID	INVOICES	BEFORE INSERT	0
ITTRANSPORT_COPYSTORAGEMOVE	ITTRANSPORT	BEFORE UPDATE	0
ITTRANSPORT_SET_BUH_QUALITY	ITTRANSPORT	AFTER INSERT OR UPDATE	0
IT_CHECK_DELETE	IT	BEFORE DELETE	0
IT_COPYSTORAGEMOVE	IT	AFTER INSERT OR UPDATE	0
IT_CheckPeriod	IT	BEFORE INSERT OR UPDATE OR DELETE	0
IT_DELETE_ITTRANSPORT	IT	AFTER DELETE	0
IT_SETID	IT	BEFORE INSERT	0	Установка ID
IT_SETLABQUALITYID	IT	BEFORE INSERT OR UPDATE	0
IT_SETPARTYID	IT	BEFORE INSERT OR UPDATE	100	Установка ID партии операции
IT_SETQUALITYONSILAGE	IT	BEFORE INSERT OR UPDATE	0
IT_SETRRWREGDATE	IT	BEFORE INSERT OR UPDATE	0
IT_SETSTORINGID	IT	BEFORE INSERT OR UPDATE	0
IT_SETWEIGHTNUMBER	IT	BEFORE INSERT OR UPDATE	0
IT_SET_BUH_QUALITY	IT	BEFORE INSERT OR UPDATE	0
IT_SetOwnerAndProvider	IT	AFTER INSERT OR UPDATE	0
IT_SetRRWRegister	IT	BEFORE INSERT OR UPDATE	0
IT_SetSamplerTimeForRRW	IT	BEFORE INSERT OR UPDATE	10
IT_SetSilageUserID	IT	BEFORE INSERT OR UPDATE	0
IT_SetWeight	IT	BEFORE INSERT OR UPDATE	100	Установка зачетного веса (для автоприхода только начальная)
IT_SetWeightTimes	IT	BEFORE INSERT OR UPDATE	0
IT_Set_Weight_In_Silage	IT	AFTER INSERT OR UPDATE	0	Занесение/уборка веса силоса при приходе/расходе
JOBS_SetID	JOBS	BEFORE INSERT	0
OBJECTS_SetID	OBJECTS	BEFORE INSERT	0
OBJRELATIONS_SetID	OBJRELATIONS	BEFORE INSERT	0
OPERATIONS_SetID	OPERATION	BEFORE INSERT	0
ORDERLOADLOSSES_SETID	ORDERLOADLOSSES	BEFORE INSERT	0
ORDERLOAD_POSTEVENT	ORDERLOAD	AFTER UPDATE	0
PACKS_SetID	PACKS	BEFORE INSERT	0
PARTIES_SetID	PARTIES	BEFORE INSERT	0
QUALITYHUMIDITY_BI	QUALITYHUMIDITY	BEFORE INSERT	0
QUALITYTYPES_SetID	QUALITYTYPES	BEFORE INSERT	0
QUALITYTYPEVALUES_SetID	QUALITYTYPEVALUES	BEFORE INSERT	0
QUALITY_SET_CLASSID	QUALITY	BEFORE INSERT OR UPDATE	0
QUALITY_SET_CROPCLASSID	QUALITY	BEFORE INSERT OR UPDATE	0
QUALITY_SetID	QUALITY	BEFORE INSERT	0
QUALITY_SetUser	QUALITY	BEFORE INSERT OR UPDATE	0
RDB$PROCEDURES_BI0	RDB$PROCEDURES	BEFORE INSERT	0
RECIPESILAGES_SetSortIndex	RECIPESILAGES	BEFORE INSERT	0
RECIPES_SetID	RECIPES	BEFORE INSERT	0
REGIONS_SetID	REGIONS	BEFORE INSERT	0
REPORTFIELD_BI	REPORTFIELD	BEFORE INSERT	0
REPORTJOBS_SET_ID	REPORTJOBS	BEFORE INSERT	0
REPORTS_SET_REPORT_ID	REPORTS	BEFORE INSERT	0
ROUTECHEMA_SetID	ROUTECHEMA	BEFORE INSERT	0
ROUTEORDER_SetID	ROUTEORDER	BEFORE INSERT	0
ROUTEORDER_SetUUserID	ROUTEORDER	BEFORE INSERT	0
ROUTESILAGECHEMA_SetID	ROUTESILAGECHEMA	BEFORE INSERT	0
RouteSCh_InsertSQ	ROUTESILAGECHEMA	AFTER INSERT	0
RouteSilChema_CalcsWeight	ROUTESILAGECHEMA	BEFORE DELETE	0
SEPARATORS_SetID	SEPARATORS	BEFORE INSERT	0
SERTIFICATES_BI	SERTIFICATES	BEFORE INSERT	0
SERVICES_SetID	SERVICES	BEFORE INSERT	0
SESSIONS_SET_ID	SESSIONS	BEFORE INSERT	0
SETORDERLOADID	ORDERLOAD	BEFORE INSERT	0
SETORDERLOADITEMID	ORDERLOADITEMS	BEFORE INSERT	0
SET_DATALOCKID	DATALOCKS	BEFORE INSERT	0
SET_PERIODID	PERIODS	BEFORE INSERT	0
SHIPBUNKERS_SETID	SHIPBUNKERS	BEFORE INSERT	0
SHIPS_SETID	SHIPS	BEFORE INSERT	0
SIEVES_SetID	SIEVES	BEFORE INSERT	0
SILAGEPACKSQUALITY_ID	SILAGEPACKSQUALITY	BEFORE INSERT	0
SILAGEPACKS_CalcQuality	SILAGEPACKS	BEFORE UPDATE	0
SILAGEPACKS_EraseComment	SILAGEPACKS	BEFORE UPDATE	0
SILAGEPACKS_SetID	SILAGEPACKS	BEFORE INSERT	0
SILAGEPACKS_SetWeight	SILAGEPACKS	BEFORE UPDATE	1
SILAGESTATES_SetID	SILAGESTATES	BEFORE INSERT	0
SILAGE_CalcSilagePacksWeight	SILAGE	AFTER UPDATE	2
SILAGE_SETINVENTORYID	SILAGE	BEFORE UPDATE	0
SILAGE_SetID	SILAGE	BEFORE INSERT	0
SILAGE_UpdateSilageGroupWeight	SILAGE	AFTER UPDATE	1
STATIONS_SET_FULLNAME_ON_NULL	STATIONS	BEFORE INSERT OR UPDATE	0
STATIONS_SetID	STATIONS	BEFORE INSERT	0
STORAGELOSSES_SETID	STORAGELOSSES	BEFORE INSERT	0
STORAGELOSSETS_SETID	STORAGELOSSETS	BEFORE INSERT	0
STORAGETICKETS_SETID	STORAGETICKETS	BEFORE INSERT	0
STORAGETYPE_SetID	STORAGETYPE	BEFORE INSERT	0
STORAGE_SetID	STORAGE	BEFORE INSERT	0
STORINGRELATION_SET_ID	STORINGRELATION	BEFORE INSERT	0
STORING_SetID	STORING	BEFORE INSERT	0
SUBCLASS_SetID	SUBCLASS	BEFORE INSERT	0
Set_Weight_GRADEOUTS	GRADEOUTS	BEFORE INSERT	0
TRANSPORTPLANS_SETID	TRANSPORTPLANS	BEFORE INSERT	0
TRANSPORTTYPE_SetID	TRANSPORTTYPE	BEFORE INSERT	0
TWEIGHTES_SetID	WEIGHTES	BEFORE INSERT	0
USERJOB_SetID	USERSJOB	BEFORE INSERT	0
USERS_SetID	USERS	BEFORE INSERT	0
USERS_UPPERLOGIN	USERS	BEFORE INSERT OR UPDATE	0
UWACTS_SetID	UWACTS	BEFORE INSERT	0
UWORDERS_ClearActInIT	UWORDERS	AFTER UPDATE	0
UWORDERS_SetID	UWORDERS	BEFORE INSERT	0
UWOUTACTS_SETITQUALITY	UWOUTACTS	AFTER UPDATE	0	Пересчет качества в IT при подработке
UWTYPES_SetID	UWTYPES	BEFORE INSERT	0
WASTEACTS_SETID	WASTEACTS	BEFORE INSERT	0
WEIGHTOUT_SetID	WEIGHTOUT	BEFORE INSERT	0
WEIGHTOUT_SetOneWeight	WEIGHTOUT	BEFORE INSERT	0
WHEIGHTOUTITEMS_SETID	WHEIGHTOUTITEMS	BEFORE INSERT	0