Does Acumatica have a generic table that contains:
I would add custom entries to this table, as an alternative to creating a new table to store simple values that can be retrieved based on a user-defined key.
Thank you,
Randy
Best answer by aaghaei
View original
+8
It is what the Amenities & Attributes (CS205000) feature does in Acumatica. You define the AttributeID, Desc, and Type and Available Values for it and then use it in the Attribute Tab of the other Master Records Screens. Please note in order to use them in some master records, you might need to assign the Attributes to the entity class and then use them in the entity itself. For example, if you want to use an Attribute for Inventory Items (Stock and Non-Stock Items) you will need to assign the attributes to Inventory Item Class and then select the value for Inventory Item.
+8
Here is how data stored
The Attribute Types (i.e Color, Size … ) are stored in “CSAttribute”
The Attribute Values (i.e {Black, Red, ...}, {Large, Medium, ...} are stored in “CSAttributeDetail”)
The assigned values to records (i.e This Inventory Item selected Color or Size) are stored in “CSAnswers” and linked using Entity.NoteID = CSAnswers.RefNoteID
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
