ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?
Summary:
Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID columns from the Oracle table ZMM_notes within Receivables - Transactions Real Time? Ultimately, I am looking to add the notes_txt column to an existing otbi report with various other subjects areas - Payables Invoices - Transactions Real Time, Payables Invoices - Installments Real Time, Supplier - Supplier Real Time.
In order to perform the join on the AP_INVOICES_ALL table on the invoice id, it is required to have the SOURCE_OBJECT_CODE = 'Standard_AP_Invoice', and the SOURCE_OBJECT_UID = invoice_id.
Tagged:
0