Re: Where to store the reason for canceling some quantity of Order Item

[Bilgin Ibryam]

Jacopo, thanks for the suggestions.

As you said using OrderHeaderNote is a bit hacky solution, but extending
OrderHeaderNote enity the way you suggested would allow us adding order
notes per order item. May be I can extend it later.

I think using "OrderItemChange" entity is a better way to go.
Do you mean something like this:

    <entity entity-name="OrderItemChange"
            package-name="org.ofbiz.order.order"
            never-cache="true"
            title="Order Item Change Entity">
      <field name="orderItemChangeId" type="id-ne"></field>
      <field name="orderItemChangeTypeId" type="id-ne"></field>      
      <field name="orderId" type="id-ne"></field>
      <field name="orderItemSeqId" type="id-ne"></field>
      <field name="reasonEnumId" type="id"></field>
      <field name="comments" type="comment"></field>      
      <prim-key field="orderItemChangeId"/>
      <relation type="one" fk-name="ORDER_ITCH_TYPE"
rel-entity-name="OrderItemChangeType">
        <key-map field-name="orderItemChangeTypeId"/>
      </relation>       
      <relation type="one-nofk" rel-entity-name="OrderHeader">
        <key-map field-name="orderId"/>
      </relation>
      <relation type="one" fk-name="ORDER_ITCH_OITM"
rel-entity-name="OrderItem">
        <key-map field-name="orderId"/>
        <key-map field-name="orderItemSeqId"/>
      </relation>
      <relation type="one" fk-name="ORDER_ITCH_REAS" title="Reason"
rel-entity-name="Enumeration">
          <key-map field-name="reasonEnumId" rel-field-name="enumId"/>
      </relation>
    </entity>
    <entity entity-name="OrderItemChangeType"
            package-name="org.ofbiz.order.order"
            title="Order Item Change Type Entity">
      <field name="orderItemChangeTypeId" type="id-ne"></field>
      <field name="hasTable" type="indicator"></field>
      <field name="description" type="description"></field>
      <prim-key field="orderItemChangeTypeId"/>
    </entity>

What do you think about these entities? Should I commit them? Any other
solutions?

Thanks in advance
Bilgin