{"id":1802,"date":"2024-02-02T09:10:45","date_gmt":"2024-02-02T09:10:45","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=1802"},"modified":"2024-12-02T05:50:52","modified_gmt":"2024-12-02T05:50:52","slug":"acumatica-attributes-in-dac-code","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/02\/02\/acumatica-attributes-in-dac-code\/","title":{"rendered":"Acumatica Attributes in DAC Code"},"content":{"rendered":"\n

Acumatica <\/a>provides a powerful framework for creating and customizing data structures through the use of Data Access Classes (DACs). One of the key features that contribute to the flexibility and extensibility of Acumatica data structures is the use of attributes.<\/p>\n\n\n\n

In this blog post, we will dive into the world of Acumatica attributes used in DAC code, exploring their significance and types. Let’s see how attributes enhance the definition and behavior of DAC fields.<\/p>\n\n\n\n

Attributes:<\/strong><\/p>\n\n\n\n

Attributes in Acumatica<\/a> are metadata tags applied to DAC fields, providing additional information about how the field should be treated or presented. They impact various aspects, including user interface rendering, validation rules, and database interactions.<\/p>\n\n\n\n

Commonly Used Attributes<\/strong><\/p>\n\n\n\n

1. PXDBString<\/strong><\/p>\n\n\n\n

The `PXDBString` attribute defines a string field in the database. It allows you to specify the maximum length, whether the field is a key, and whether it should be stored as Unicode.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

 [PXDBString(30, IsUnicode = true, InputMask = “”)] [PXUIField(DisplayName = “Customer ID”)]<\/p>\n\n\n\n

2. PXDefault<\/strong><\/p>\n\n\n\n

The `PXDefault` attribute sets the default value for a field. This is useful for fields that should have a predefined value when a new record is created.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

[PXDefault(“NEW”)]<\/p>\n\n\n\n

[PXDBString(2, IsFixed = true)]<\/p>\n\n\n\n

[PXUIField(DisplayName = “Status”)]<\/p>\n\n\n\n

3. PXUIField<\/strong><\/p>\n\n\n\n

The `PXUIField` attribute controls the appearance and behavior of fields in the user interface, including labels, visibility, and enabled\/disabled states.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

[PXUIField(DisplayName = “Customer Name”, Visibility = PXUIVisibility.SelectorVisible)]<\/p>\n\n\n\n

[PXDBString(60, IsUnicode = true)]<\/p>\n\n\n\n

4. PXSelector<\/strong><\/p>\n\n\n\n

The `PXSelector` attribute associates a field with a selector control, providing a list of values for the user to choose from.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

[PXSelector(typeof(Search<InventoryItem.inventoryID>))]<\/p>\n\n\n\n

[PXDBInt]<\/p>\n\n\n\n

[PXUIField(DisplayName = “Inventory ID”)]<\/p>\n\n\n\n

 Advanced Attributes<\/strong><\/p>\n\n\n\n