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.
Database Column | Data Type (SQL Server) | Data Type (MySQL) | Type Attribute on the Data Field |
---|---|---|---|
Global data record identifier (named NoteID ) |
|
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.