Skip to main content
Solved

Acumatica Table to Store Key/Value pairs for Generic/Custom Use

  • 22 December 2022
  • 4 replies
  • 109 views

Forum|alt.badge.img

Does Acumatica have a generic table that contains:

  • A Key - a String
  • A Value - also a String, with an expanded value for the key, to be used in any way that is appropriate
  • A value type - optional, identifies the value has a format of String, Decimal, Date, etc

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

@rdennisj57

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.

 

 

View original
Did this topic help you find an answer to your question?

aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • December 27, 2022

@rdennisj57

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.

 

 


Forum|alt.badge.img
  • Jr Varsity II
  • January 18, 2023

@aaghaei   Thank you for the suggestion. I have reviewed this table and the associated graph (CS205000). I can see how this would be used to define the properties of an ‘Attribute’, but where is actual value of the attribute? For example, there is an existing Attribute in the table, ‘COMPSIZE’, for Number of Employees. What is the value for COMPSIZE, and where is that value stored? 


Forum|alt.badge.img
  • Jr Varsity II
  • January 18, 2023

@aaghaei  A follow-up to my last question. I JUST re-read your suggestion, and now I see the Attribute values are stored with the associated Master Records. My original request is for a stand-alone set of attributes (or properties) that are independent of any other master records. I can see a table, CSAttributeKvExt, that appears to have columns very similar to what I am looking for. I don’t see a DAC related to this table. Do you know how it is used?


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • January 18, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings