custom fields in line items for invoice and sales order

custom fields in line items for invoice and sales order

Hi
I would like to be able to add information to line items.  For instance, by default, line items are made up of

  1. Item #
  2. Description
  3. Quantity
  4. Rate
and then the totals calculation.  Custom fields in invoices/SOs are applied to the entire invoice, and are not  associated with line items.  For example:

  1. Item #
  2. Description
  3. { Characteristic 1...n }
  4. Quantity
  5. Rate
where Characteristics is a custom field set that can be populated in the usual way: manually or via integration.  Can this be done today?  Can I write a script to get this done?
THanks
Mike