To Create a Custom Column in an Existing Table

Because you can need a new column in an existing database table only for a bound data field, the MYOB Acumatica Customization Platform automatically creates a custom column when you create a custom bound data field by using the New Field wizard.

To add a custom field as a new column that will be appended to the original table of MYOB Acumatica, perform the following actions:
  1. Open the Create New Field dialog box for the data access class by using the Data Class Editor or by using the Screen Editor.
  2. In the dialog box, specify the custom field parameters and select DBTableColumn in the Storage Type box to make the system append the column to the original table in the database.
  3. Click OK to add the field to the data access class.
The New Field wizard includes an XML declaration of the new field in the DAC item for the modified data access class. If the DAC item for the modified data access class is absent in the customization project, the wizard creates the appropriate item. Also, the wizard creates a Table item with a description of the custom column to be created in the database table for the custom field.

After you publish the customization project at least once, the database schema is changed. Changes to the database schema aren't deleted when you unpublish the project or delete the DAC and Table items and publish the project once more. You have to remove the changes manually.