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.
Sender ISA Value -> F0111.REM1
N104 (N1*ST) -> F0111.MLNM
‘Z’ -> F0111.TYC
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.
F47011.SHAN -> F0111.AN8
'Z’ -> F0111.TYC
F0111.MLNM -> N104 (N1*ST)
By: Sean Hoppe on