咨询库存项目屏幕属性标签存储属性值的DAC/表及GI访问方法

Hey there! Let's walk through exactly what you need to access those attribute values in a Generic Inquiry (GI) for the Stock Items screen's Attributes tab.

Key DACs & Corresponding Database Tables #

The attribute values for Stock Items (and most Acumatica entities) are stored in these core objects:

• CSAnswers DAC (database table: CSAnswers): This is the primary table holding the actual attribute values (answers) linked to your inventory items. Each row maps an attribute to a specific stock item via the RefNoteID field.
• CSAttribute DAC (database table: CSAttributes): Stores the definition of each attribute (like its name, type, and settings). Use this if you want to pull attribute names instead of just their IDs in your GI.
• CSAttributeDetail DAC (database table: CSAttributeDetails): For dropdown/multi-select attributes, this table holds predefined option values and their descriptions. Use it to display user-friendly text instead of raw code values.
• InventoryItem DAC (database table: InventoryItem): The base DAC for stock items, which you'll use to link to attribute values via its NoteID field.

Setting Up the Generic Inquiry #

Follow these steps to build a GI that pulls inventory item attributes:

1. Add DACs to your GI: Include InventoryItem, CSAnswers, and optionally CSAttribute and CSAttributeDetail.
2. Configure Joins:
   • Link InventoryItem.NoteID to CSAnswers.RefNoteID (this connects each stock item to its attribute values).
   • If using CSAttribute, link CSAnswers.AttributeID to CSAttribute.AttributeID to get attribute names.
   • For dropdown attributes, link CSAnswers.AttributeID to CSAttributeDetail.AttributeID and CSAnswers.Value to CSAttributeDetail.Value to retrieve option descriptions.
3. Select Fields: Pick the fields you need, for example:
   • InventoryItem.InventoryCD (Stock Item ID)
   • CSAttribute.Descr (Attribute Name)
   • CSAnswers.Value (Raw Attribute Value)
   • CSAttributeDetail.Description (Friendly Dropdown Option Text)
4. Add Filters (optional but recommended):
   • Add a filter for CSAnswers.EntityType equals InventoryItem to ensure you only pull attributes related to stock items.
   • Add filters on InventoryItem fields to narrow down to specific stock items if needed.
5. Test & Adjust: Run the GI to verify you're seeing the correct attribute values, and tweak joins/fields as necessary based on your attribute types (text, dropdown, etc.).

A quick tip: If you're having trouble seeing the data, double-check that the joins are correctly set up using NoteID/RefNoteID—this is the critical link between stock items and their attributes.

内容的提问来源于stack exchange，提问作者Jerry Welliver