Free Text field in Item record stored in which database table?
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
We could make use of Pick and Scan to update Free Text field in Item records if we can run an Access report on this field. However, this field is not stored in ITEM table. Which table stores Item record Free Text field?
The "Free Text" data is in the MFHD_ITEM table:
Name Null? Type
--------- ----- -------------
The general guideline is that human-readable public info about items is in the MFHD_ITEM table (except barcodes, which are in ITEM_BARCODE), while generally internal/staff data about items is in the ITEM table (number of pieces, whether it's on Reserve, spine label, and lots of circulation-related info).
- Article last edited: 10-Apr-2022