Source Lookup SQL

This is an SQL function that you can create to pull in source values and their destination values that are already defined in an ERP database table.

Example: In Oracle the source value for PAYMENT _TERMS as well as the destination values can be obtained from the Oracle AP_TERMS_TL database table.

Adding source lookup SQL

Editing source lookup SQL

Deleting source lookup SQL