For most tables, when I create a user defined field (UDF), the history table automatically gets the same field added and the data gets copied into the history table automatically.
It looks like AR_InvoiceHistoryDetail may be getting records from both AR_InvoiceDetail and SO_InvoiceDetail.
Do I have to add my UDFs to both AR_InvoiceDetail and SO_InvoiceDetail?
So far, I only have them in AR_InvoiceDetail and this appears to be insufficient. I will probably get the columns if I added them to SO_InvoiceDetail, but would the data copy over from AR_InvoiceDetail data entry? or would the data just get copied from SO_InvoiceDetail?