Document Type in Outgoing Payment

[Former Member]

Hi All,

I would like to know which table stores the information about the document type selected in Outgoing Payment.

Thanks,

Joseph

[Former Member]

Hi,

Check the table OVPM

Try this...

select distinct(DocType) from OVPM

Regards,

Priya

[Former Member]

Hi,

Every Header Table have ObjType field this field is used to find out the document Type.

Regards

jambulingam.P

[Former Member]

Hi Joseph,

It is calculated based on selection of the document saved in VPM1 depending on the document type either OPCH or ORPC.

You need a case statement to get the same.

Thanks,

Gordon

[jitin_chawla]

Hi,

Check this :

select distinct Invtype from VPM2

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Jitin and Gordon,

Thank you for your feedback.

Please let me know which table stores the information for Customer reference and Invoice date.

Thanks,

Joseph

[Former Member]

Hi,

Check this...

select docdate as 'Invoice date',numatcard as 'Customer reference' from OINV

[Former Member]

Hi P,

I meant on outgoing payment. Not on Invoice Sorry if my question was not clear..

Thanks,

Joseph

[Former Member]

VPM2 table saved Invoice Key so that all required info by you are actually still in OPCH table but linked by the key.