Skip to Content
0
Former Member
Nov 17, 2011 at 06:15 AM

How to find out the common fields

371 Views

Hi all

I want to pull out data from the following tables

OPCH,PCH1,OCRD,OVPM

Vendor Name OPCH

GL Date PCH1

Bill No PCH1

Bill Date PCH1

Due Date PCH1

Bill Amount OPCH

TDS PCH1

Advance Adjusted OPCH

Total Due OPCH

Amount Paid OVPM

Mode of payment OCRD

Cheque/EFT No OVPM

How do i know which are the common fields ?

Regards

Farheen