Audit Fields
For data access class (DAC) fields used for record or state audit, you should specify the corresponding type attribute in their declaration. The following table lists these attributes and their descriptions:
| Attribute | Description |
|---|---|
| PXDBLastChangeDateTime | Maps a DAC field to the database column and automatically sets the field's value to the date and time of the last modification to the data record. |
| PXDBCreatedByID | Maps a DAC field to a database column and automatically sets the field's value to the ID of the user who created the data record. |
| PXDBCreatedByScreenID | Maps a DAC field to a database column and automatically sets the field's value to the string ID of the application screen from which the data record was created. |
| PXDBCreatedDateTime | Maps a DAC field to a database column and automatically sets the field's value to the date and time of the data record's creation. |
| PXDBLastModifiedByID | Maps a DAC field to a database column and automatically sets the field's value to the ID of the user who last modified the data record. |
| PXDBLastModifiedByScreenID | Maps a DAC field to a database column and automatically sets the field's value to the ID of the application screen on which the data record was last modified. |
| PXDBLastModifiedDateTime | Maps a DAC field to a database column and automatically sets the field's value to the date and time of the last modification to the data record. |
| PXDBStateChangedByID | Maps a DAC field to the database column and automatically sets the field's value to the ID of the user who invoked the last workflow transition for the data record. |
| PXDBStateChangedByScreenID | Maps a DAC field to the database column and automatically sets the field's value to the ID of the application screen on which the data record's last workflow transition occurs. |
| PXDBStateChangedDateTime | Maps a DAC field to the database column and automatically sets the field's value to the date and time (in UTC) of the last workflow transition of the data record. |
The MYOB Acumatica Framework binds DAC fields declared with these attributes to their corresponding columns and automatically assigns the field values.