SRCEATTACH table
Used to import new attachments for inspection records. The attachment records are added to the SMNATTCHMTSRVINSP table (
Hansen.AssetManagement.Sewer.SMNServiceInspectionAttachment object).
See Attachment import.
This table shows the property of the SMNServiceInspectionAttachment object that each column in the SRCEATTACH table maps to.
| Access DB column | IPS property |
|---|---|
| ATTACHMENT | FileName |
| ATTACHPATH | FilePath |
| CATKEY | Not mapped |
| INSPKEY | Primary key of the existing inspection that the attachment is associated with. This must match the INSPKEY column for an inspection in the SRCESCTV table. |
| INSPNO | ID of the new inspection that the attachment is associated with. This must match the INSPNO column for an inspection in the NEWSCTV table. |