Import Invoice Entries by Database Trigger

[Adrian Hodson]

Hello,
I am using Partkeepr for inventory and Gnucash on the same Mysql server
instance. 

I plan for customers to sign off on an initial invoice from Gnucash.
A Partkeepr Materials List ID will be identical to the Gnucash Invoice
number.

I would like to create a database trigger  on Partkeeper that inserts
Materials entries (quantity, price, etc) into the Entries table in
Gnucash using the invoice number (pre-created in Gnucash). 

I see the entries in the Gnucash Entries table have guid,date and
date_entered fields as not null. Followed by invoice related fields
i_acct ... i_discount_denom ... , followed by billing related fields
and finally order_guid. 

Could this mechanism work from Gnucash point of view? 

If so,  I would like to know how to obtain a new instance of guid for
the records that I insert. Also Which of the Entries table fields are
foreign keys?


Such a mechanism would be of general benefit to anyone using an
external inventory system.

Best wishes