Recently, when modifying the form of a purchase order, we found that the place where the form of the purchase order inserted data into the database could not be found, and there were too many programs. We also need to find other methods when generating database data based on the item value on the order interface, one is to add your own interpolation processing program on the on-insert trigger, which does not affect the insertion of normal order data, however, when the on-insert operation is performed, the related association IDS (such as header_id and line_id) on the interface do not have data, and sometimes they do not meet the requirements. They can only write triggers on the table, of course, it is not recommended to write a trigger on a table. I don't know if anyone has a better solution to this requirement.
Note: After a row is recorded and the corresponding allocation row is recorded, when the cursor falls on the next row, the insert trigger on the allocation row will trigger
Question about the Po Standard Form