The triggers for DataType as Table are as follows:
- Import::OnAfterInsertRecord() for Import only: This trigger is typically used when the data is being imported into Temporary tables. This is where we would put the C/AL code to build and insert records for the permanent database tables.
- Import::OnBeforeModifyRecord(), for Import only: When AutoSave is Yes, this is used to update the imported data before saving it.
- Import::OnAfterModifyRecord(), for Import only: When AutoSave is No, this is used to update the data after updating.
- Export::OnPreXMLItem(), for Export only: This trigger is typically used for setting filters and initializing before finding and processing the first database record.
- Export::OnAfterGetRecord(), for Export only: This trigger allows access to the data after the record is retrieved from the NAV database. This trigger is typically used to allow manipulation of table fields being exported.
- Import::OnAfterInitRecord(), for Import only: This trigger is typically used to check whether or not a record should be processed further or to manipulate the data.
- Import::OnBeforeInsertRecord(), for Import only: This is another place where we can manipulate data before it is inserted into the target table. This trigger is executed after the OnAfterInitRecord() trigger.