SeanHoppe.com > CLEO Tips > CLEO JDE Tips 4 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: Sean Hoppe on
