Deliver to usage in POI (EDI)
Hello,
I receive orders from client by EDI in ECOD format and it works ok.
But client sends additionally information about end-customer (who will receive the goods at the end).
This information should go to Oracle order and this is the problem I will describe.
Client sends this information in tag:
<UltimateCustomer>
<ILN>XXXX</ILN>
</UltimateCustomer>
This ILN is not equal Buyer ILN (bill to EDI location in Oracle) or DeliveryPoint ILN (ship to EDI location in Oracle).
I've heard that for these situations we should use deliver to usage in Oracle.
I can imagine that I create many 'DELIVER TO' sites for this client in Oracle, I put EDI locations for them and I can create some sql like: