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
ATTACHMENTFileName
ATTACHPATHFilePath
CATKEYNot mapped
INSPKEYPrimary key of the existing inspection that the attachment is associated with. This must match the INSPKEY column for an inspection in the SRCESCTV table.
INSPNOID of the new inspection that the attachment is associated with. This must match the INSPNO column for an inspection in the NEWSCTV table.