Attachment of Additional Objects to Data Records (NoteID)

You can attach additional objects to a data record—for instance, attach a text note or an uploaded file or multiple uploaded files to a data record.

You turn on or off support for data record attachments for each particular table individually. To turn on support for data record attachments, add a NoteID column that stores the global data record identifier to the table and declare the corresponding field in the data access class. For more information on uploading files through an MYOB Acumatica form, see To Display an Attached Image on the Form. See below for the parameters of the global identifier column and the attribute that should be added to the corresponding DAC field.

Table 1. The Global Data Record Identifier Column (NoteID)
Database Column	Data Type (SQL Server)	Data Type (MySQL)	Type Attribute on the Data Field
Global data record identifier (named `NoteID`)	`uniqueidentifier`; not null	`CHAR(36)`	`[PXNote]`

Note: If you have added the NoteID column to a custom table, we recommend to create a unique index for this table with the CompanyID and NoteID columns. Both columns are required to achieve a unique index because when a snapshot is taken the NoteID values stay the same as they were in the tenant where the snapshot is taken.