›> ›> Using Who’s Who (F0111) for Inbound/Outbound EDI

Using Who’s Who (F0111) for Inbound/Outbound EDI

16th August 2016

The JDE best practice to determine the ship-to address book number is utilizing JDE’s F0111 table. This table is commonly referred to as the Who’s Who table.

By leveraging the Who’s who table we are able to tie each JDE address book number to a unique customer location ID across the board. By using fields such as TYC (type code), REM1 (Remark Field), and MLNM (Mailing Name) we can use a common theme across all EDI customers.

Below is an example of an Inbound 850 (Purchase Order) where we are trying to determine the SHAN.

Inbound 850:
Input
Sender ISA Value -> F0111.REM1
N104 (N1*ST) -> F0111.MLNM
‘Z’ -> F0111.TYC

Output
F0111.AN8 -> F47011.SHAN andF47012.SHAN

Below is an example of an Outbound 810 (Invoice ) where we are trying to determine the trading partner’s ship-to location ID.


Outbound 810:
Input
F47011.SHAN ->  F0111.AN8
'Z’ -> F0111.TYC

Output
F0111.MLNM -> N104 (N1*ST)


By: on