Invoice_to_org_id
I know that the value Invoice_to_org_id (in the oe order headers all table)corresponds to the correct Bill to value for the customer master in the front end. I am trying to connect this column to the correct address/customer back in AR or the customer files. Does anyone know where the connection is between customer master and the order header file? I tried the etrm but it wasn't very helpful. Thanks.
select invoice_to_org_id
from oe_order_headers_all
In the above simple statement I would also try to bring in the corresponding address from the customer files but I dont know the connection here.
0