Journal Line DFF with Customer Account number and Supplier Number

Summary:

Journal Line DFF with Customer Account number and Supplier Number

Content (required):

Business would like to query/select Customer/Supplier number in DFF for passing provisional entries in Journal directly. I created DFF with Hz_parties table but this table don't have Supplier Number/Customer Account Number. If I want to query these two numbers and both are in different tables.

DFF screenshot & Journal Line page screenshot attached. I am not sure how to link both table columns in single column

select * from HZ_PARTIES where party_name='Dell'

select * from poz_suppliers_v  where party_id=300000080226079

Suppier number column is Segment1